Difference between revisions of "Template:Link Skill"

Revision as of 03:17, 21 December 2017

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

No results

@@ Line 26: / Line 26: @@
 |attribute={{{attribute|}}}
 |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(attribute,' ',bonus,'% Up') = 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
 }}
 </includeonly>