Difference between revisions of "User:Fimbulvetr/Sandbox 3"

From A3! Wiki
 
Line 1: Line 1:
 
==Link Skill==
 
==Link Skill==
{| class="wikitable a3table sortable"
 
|-
 
! Link Skill
 
! Characters
 
! Description
 
! Bonus
 
|- style="height: 3em;"
 
|}
 
 
 
 
{{#cargo_query:
 
{{#cargo_query:
 
tables=Link_Skill
 
tables=Link_Skill
|fields=linkname=Link Skill,CONCAT(chara1, IFNULL(CONCAT(', ',chara2), ''), IFNULL(CONCAT(', ',chara3, ''), ''), IFNULL(CONCAT(', ',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(attribute,' ',bonus,'% Up') = Bonus
|where="Tsuzuru Minagi" IN(chara1,chara2,chara3,chara4) OR troupe="Spring"
+
|where="{{PAGENAME}}" IN(chara1,chara2,chara3,chara4) OR troupe="Spring"
 
|format=table
 
|format=table
 
|order by=bonus="Co" DESC,bonus="Ac" DESC,bonus="Sr" DESC
 
|order by=bonus="Co" DESC,bonus="Ac" DESC,bonus="Sr" DESC
|limit=10
 
 
}}
 
}}

Latest revision as of 12:20, 19 December 2017

Link Skill[edit]

Link Skill Characters Description Bonus
Spring Troupe A theatre unit specialising in traditional fairytales and fantasy plays. Sr 60% Up