Difference between revisions of "Template:Character Cards Table"
From A3! Wiki
Fimbulvetr (talk | contribs) m |
Fimbulvetr (talk | contribs) |
||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly> | ||
| − | {{#cargo_query:tables=Cards, | + | {{#cargo_query:tables=Cards,Card_Files,Card_Stats |
| − | |join on=Cards.number= | + | |join on=Cards.number=Card_Files.number, Card_Stats.number=Cards.number |
| − | |fields=Cards.number=No., IF( Cards.prebloomed LIKE 'Yes' OR Cards.prebloomed LIKE 'yes' OR Cards.prebloomed like 'true' OR Cards.prebloomed = '1', CONCAT('[[File:', | + | |fields=Cards.number=No., IF( Cards.prebloomed LIKE 'Yes' OR Cards.prebloomed LIKE 'yes' OR Cards.prebloomed like 'true' OR Cards.prebloomed = '1', CONCAT('[[File:',Card_Files.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',Card_Files.icon1,'|35px]]'), ' ', CONCAT('[[File:',Card_Files.icon2,'|35px]]')))=Icon, CONCAT('[[Cards/',Cards.chara,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Stats.cardname_jp = Card Name (JP), CONCAT('[[', Cards.chara,']]')=Character, Cards.attribute=Attribute, Cards.rarity=Rarity, Cards.troupe=Troupe, Cards.cardset=Cardset |
|where=Cards.chara LIKE '{{SUBPAGENAME}}' | |where=Cards.chara LIKE '{{SUBPAGENAME}}' | ||
|format=dynamic table | |format=dynamic table | ||
