Difference between revisions of "Template:Link Skill/Table"
From A3! Wiki
Fimbulvetr (talk | contribs) |
Fimbulvetr (talk | contribs) |
||
| Line 5: | Line 5: | ||
description=Description, | description=Description, | ||
CONCAT(CASE WHEN attribute = "Co" THEN CONCAT('[[File:Comedy.png|20px|link=|Comedy]] Co ', bonus, '% Up') WHEN attribute = "Ac" THEN CONCAT('[[File:Action.png|20px|link=|Action]] Ac ', bonus, '% Up') ELSE CONCAT('[[File:Serious.png|20px|link=|Serious]] Sr ', bonus, '% Up') END) = Bonus | CONCAT(CASE WHEN attribute = "Co" THEN CONCAT('[[File:Comedy.png|20px|link=|Comedy]] Co ', bonus, '% Up') WHEN attribute = "Ac" THEN CONCAT('[[File:Action.png|20px|link=|Action]] Ac ', bonus, '% Up') ELSE CONCAT('[[File:Serious.png|20px|link=|Serious]] Sr ', bonus, '% Up') END) = Bonus | ||
| − | |where="{{PAGENAME}}" IN(chara1,chara2,chara3,chara4) OR troupe="{{Character to Troupe|character={{PAGENAME}} }}" | + | |where="{{Character to Troupe|characterfirst2={{PAGENAME}} }}" IN(chara1,chara2,chara3,chara4) OR troupe="{{Character to Troupe|character={{PAGENAME}} }}" |
|format=table | |format=table | ||
|order by=bonus LIKE "%Co" DESC,bonus LIKE "%Ac" DESC,bonus LIKE "%Sr" DESC | |order by=bonus LIKE "%Co" DESC,bonus LIKE "%Ac" DESC,bonus LIKE "%Sr" DESC | ||
}} | }} | ||
</includeonly> | </includeonly> | ||
