User:Fimbulvetr/Sandbox 3: Difference between revisions

From A3! Wiki
Fimbulvetr (talk | contribs)
No edit summary
Fimbulvetr (talk | contribs)
No edit summary
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
{| cellpadding="10" style="text-align:center; background-color: #eee; margin: auto;" class="navboxtable"
==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="font-size: 1.6rem"|[[Character Hub|Characters]]
{{#cargo_query:
|-style="line-height:30px"
tables=Link_Skill
|<div style="float:left">[[File:Spring troupe.png|30px]]</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=firstname
|format=table
|order by=troupeorder ASC
|order by=bonus="Co" DESC,bonus="Ac" DESC,bonus="Sr" DESC
|where=troupe="Spring" AND maincast=1
}}
|more results text=
|no html
|format=template
|template=Navbox Link}}
|-style="line-height:30px"
|<div style="float:left">[[File:Summer troupe.png|30px]]</div> '''Summer'''
{{#cargo_query:tables=Characters
|fields=firstname
|order by=troupeorder ASC
|where=troupe="Summer" AND maincast=1
|more results text=
|no html
|format=template
|template=Navbox Link}}
|-style="line-height:30px"
|<div style="float:left">[[File:Autumn troupe.png|30px]]</div> '''Autumn'''
{{#cargo_query:tables=Characters
|fields=firstname
|order by=troupeorder ASC
|where=troupe="Autumn" AND maincast=1
|more results text=
|no html
|format=template
|template=Navbox Link}}
|-style="line-height:30px"
|<div style="float:left">[[File:Winter troupe.png|30px]]</div> '''Winter'''
{{#cargo_query:tables=Characters
|fields=firstname
|order by=troupeorder ASC
|where=troupe="Winter" AND maincast=1
|more results text=
|no html
|format=template
|template=Navbox Link}}
|}

Latest revision as of 12:20, 19 December 2017

Link Skill

Identifier must not contain quote, dot or null characters