Card List: Difference between revisions
From A3! Wiki
mNo edit summary |
Fimbulvetr (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
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). | 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). | ||
{{#cargo_query:tables=Cards, | {{#cargo_query:tables=Cards,Card_Data,Card_Stats | ||
|join on=Cards.number=Card_Files.number, | |join on=Cards.number=Card_Files.number, Card_Data.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:',REPLACE(Card_Files.icon2, "/", "-"),'|35px]]'), CONCAT(CONCAT('[[File:',REPLACE(Card_Files.icon1, "/", "-"),'|35px]]'), ' ', CONCAT('[[File:',REPLACE(Card_Files.icon2, "/", "-"),'|35px]]')))=Icon, CONCAT('[[Cards/',Cards.chara,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, | |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:',REPLACE(Card_Files.icon2, "/", "-"),'|35px]]'), CONCAT(CONCAT('[[File:',REPLACE(Card_Files.icon1, "/", "-"),'|35px]]'), ' ', CONCAT('[[File:',REPLACE(Card_Files.icon2, "/", "-"),'|35px]]')))=Icon, CONCAT('[[Cards/',Cards.chara,'/', Cards.cardname,'|', Cards.cardname, ']]')=Card Name, Card_Data.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=1000 | |limit=1000 | ||
}} | }} | ||
Revision as of 06:19, 2 August 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 "Card_Files" is not in list of table names or aliases.
