Difference between revisions of "Template:Link Skill"

Revision as of 09:43, 21 December 2017

This template defines the table "Link_Skill". View table.

No results

@@ Line 29: / Line 29: @@
 {{#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(attribute,' ',bonus,'% Up') = Bonus
+|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="Co" DESC,bonus="Ac" DESC,bonus="Sr" DESC
+|order by=bonus LIKE "%Co" DESC,bonus LIKE "%Ac" DESC,bonus LIKE "%Sr" DESC
 }}
 </includeonly>