Card List: Difference between revisions

From A3! Wiki
Fimbulvetr (talk | contribs)
Display Japanese card names
Fimbulvetr (talk | contribs)
No edit summary
Line 3: Line 3:
{{#cargo_query:tables=Cards,CardFiles,Card_Stats
{{#cargo_query:tables=Cards,CardFiles,Card_Stats
  |join on=Cards.number=CardFiles.number, Card_Stats.number=Cards.number
  |join on=Cards.number=CardFiles.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:',CardFiles.icon2,'|35px]]'), CONCAT(CONCAT('[[File:',CardFiles.icon1,'|35px]]'), ' ', CONCAT('[[File:',CardFiles.icon2,'|35px]]')))=Icon, CONCAT('[[Cards/',Cards.character,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Stats.cardname_jp = Card Name (JP), 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('[[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
  |format=dynamic table
  |format=dynamic table
  |rows per page=50
  |rows per page=50
  |limit=500
  |limit=500
}}
}}

Revision as of 13:44, 6 February 2018

All the cards in the game currently are listed below. You can use the search box to search for a particular keyword or character. By default, these are sorted by number (ordered by when the cards appeared in the game and then by troupe and character order).

Error: Table CardFiles not found.