Difference between revisions of "Template:Featured Cards"
Fimbulvetr (talk | contribs) (Created page with "<noinclude> {{#tag:gallery| {{#cargo_query: tables=Cards,Card_Files |join on=Cards.number = Card_Files.number |fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara)...") |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | < | + | <includeonly>{{#cargo_query: |
| − | |||
| − | {{#cargo_query: | ||
tables=Cards,Card_Files | tables=Cards,Card_Files | ||
|join on=Cards.number = Card_Files.number | |join on=Cards.number = Card_Files.number | ||
| − | |fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link | + | |fields=IFNULL(Card_Files.icon1,Card_Files.icon2), CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link |
| − | |where=Cards.cardset="{{{ | + | |where=Cards.cardset="{{{1}}}" |
|order by=Cards.rarity DESC | |order by=Cards.rarity DESC | ||
|format=template | |format=template | ||
| − | |template= | + | |template=Featured Cards/Line}}</includeonly> |
| − | + | <noinclude> | |
| − | | | + | {{Featured Cards|Dazzling Rose Mansion}} |
| − | }} | ||
</noinclude> | </noinclude> | ||
Latest revision as of 18:03, 27 April 2020
(Elegant Nénuphar) Azuma Yukishiro Action SSR++ Icon Bloomed.png | (Elegant Nénuphar) Azuma Yukishiro Action SSR++ Icon Bloomed.png|SSR++ Azuma Yukishiro|link=Cards/Azuma Yukishiro/Elegant Nénuphar|alt=SSR++ Azuma Yukishiro
(Smiling Fleurir) Tsumugi Tsukioka Comedy SSR Icon Unbloomed.png | (Smiling Fleurir) Tsumugi Tsukioka Comedy SSR Icon Unbloomed.png|SSR Tsumugi Tsukioka|link=Cards/Tsumugi Tsukioka/Smiling Fleurir|alt=SSR Tsumugi Tsukioka
(Warm Jardinage) Kazunari Miyoshi Serious SR Icon Unbloomed.png | (Warm Jardinage) Kazunari Miyoshi Serious SR Icon Unbloomed.png|SR Kazunari Miyoshi|link=Cards/Kazunari Miyoshi/Warm Jardinage|alt=SR Kazunari Miyoshi
(Noble Adult) Homare Arisugawa Action R Icon Unbloomed.png | (Noble Adult) Homare Arisugawa Action R Icon Unbloomed.png|R Homare Arisugawa|link=Cards/Homare Arisugawa/Noble Adult|alt=R Homare Arisugawa
