Difference between revisions of "Template:Character Cards Table"
From A3! Wiki
Fimbulvetr (talk | contribs) (Created page with "<noinclude> {{#cargo_query:tables=Cards,CardFiles,Card_Stats |join on=Cards.number=CardFiles.number, Card_Stats.number=Cards.number |fields=Cards.number=No., IF( Cards.prebl...") |
Fimbulvetr (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | < | + | <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 | ||
| Line 8: | Line 8: | ||
|limit=500 | |limit=500 | ||
}} | }} | ||
| − | </ | + | </includeonly> |
