Card List: Difference between revisions

From A3! Wiki
Fimbulvetr (talk | contribs)
No edit summary
mNo edit summary
Line 3: Line 3:
{{#cargo_query:tables=Cards,CardFiles
{{#cargo_query:tables=Cards,CardFiles
  |join on=Cards.number=CardFiles.number
  |join on=Cards.number=CardFiles.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:',CardFiles.icon1,'|35px]]'), CONCAT(CONCAT('[[File:',CardFiles.icon1,'|35px]]'), ' ', CONCAT('[[File:',CardFiles.icon2,'|35px]]')))=Icon, CONCAT('[[Card/',Cards.character,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, CONCAT('[[', Cards.character,']]')=Character, Cards.attribute=Attribute, Cards.rarity=Rarity, Cards.troupe=Troupe, Cards.cardset=Cardset
  |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:',CardFiles.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',CardFiles.icon1,'|35px]]'), ' ', CONCAT('[[File:',CardFiles.icon2,'|35px]]')))=Icon, CONCAT('[[Card/',Cards.character,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, CONCAT('[[', Cards.character,']]')=Character, Cards.attribute=Attribute, Cards.rarity=Rarity, Cards.troupe=Troupe, Cards.cardset=Cardset
  |format=dynamic table
  |format=dynamic table
  |rows per page=30
  |rows per page=30
  |limit=500
  |limit=500
}}
}}

Revision as of 18:59, 16 December 2017

To see card images, transparent renders and raws, please go to Card Files.

Error: Table CardFiles not found.