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

From A3! Wiki
 
(29 intermediate revisions by the same user not shown)
Line 1: Line 1:
{| cellpadding="10" style="text-align:center; background-color: #fff; margin: auto;"
+
==Link Skill==
! colspan="{{#expr: 1 + {{#cargo_query:tables=Characters|fields=COUNT(troupe)=count|group by=troupe|order by=count DESC|more results text=|no html|limit=1}}}}" style="background-color:#aaa;"|[[Characters]]
+
{{#cargo_query:
|-
+
tables=Link_Skill
|<div style="float:left;padding-right:5px;">WEY</div> '''Spring:'''
+
|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
{{#cargo_query:tables=Characters
+
|where="{{PAGENAME}}" IN(chara1,chara2,chara3,chara4) OR troupe="Spring"
|fields=name_en
+
|format=table
|order by=name_en ASC
+
|order by=bonus="Co" DESC,bonus="Ac" DESC,bonus="Sr" DESC
|where=troupe="Spring"
+
}}
|more results text=
 
|no html}}
 
|-
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Summer:'''
 
{{#cargo_query:tables=Characters
 
|fields=name_en
 
|order by=name_en ASC
 
|where=troupe="Summer"
 
|more results text=
 
|no html}}
 
|-
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Autumn:'''
 
{{#cargo_query:tables=Characters
 
|fields=name_en
 
|order by=name_en ASC
 
|where=troupe="Autumn"
 
|more results text=
 
|no html}}
 
|-
 
|<div style="float:left;padding-right:5px;">WEY</div> '''Winter:'''
 
{{#cargo_query:tables=Characters
 
|fields=name_en
 
|order by=name_en ASC
 
|where=troupe="Winter"
 
|more results text=
 
|no html}}
 
|}
 

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