|
|
| Line 26: |
Line 26: |
| | |attribute={{{attribute|}}} | | |attribute={{{attribute|}}} |
| | |bonus={{{bonus|}}} | | |bonus={{{bonus|}}} |
| − | }}
| |
| − | {{#cargo_query:
| |
| − | tables=Link_Skill
| |
| − | |fields=linkname=Link Skill,IF(troupe IS NOT NULL, CONCAT(troupe, ' ', 'Troupe'), CONCAT(CONCAT('[[',chara1,']]'), IFNULL(CONCAT('<br>[[',chara2,']]'), ''), IFNULL(CONCAT('<br>[[',chara3, ']]'), ''), IFNULL(CONCAT('<br>[[',chara4,']]'), ''))) = Characters,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
| |
| − | |where="{{PAGENAME}}" IN(chara1,chara2,chara3,chara4) OR troupe="{{Character to Troupe|character={{PAGENAME}} }}"
| |
| − | |format=table
| |
| − | |order by=bonus LIKE "%Co" DESC,bonus LIKE "%Ac" DESC,bonus LIKE "%Sr" DESC
| |
| | }} | | }} |
| | </includeonly> | | </includeonly> |
Revision as of 09:51, 21 December 2017
This template defines the table "Link_Skill". View table.
