|
|
| (2 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(troupeorder)=count|order by=count ASC|more results text=|no html|limit=1}}}}" style="font-size: 1.4rem"|[[Character Hub|Main 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
| |
| |where=troupe="Winter" AND maincast=1
| |
| |more results text=
| |
| |no html
| |
| |format=template
| |
| |template=Navbox Link}}
| |
| |}
| |
Link Skill
Identifier must not contain quote, dot or null characters
