Difference between revisions of "Template:Scout List"
From A3! Wiki
m ((test) added "|no html" parameter to all 3 {{{type|}}}s for card preview (trying to fix taichi's SuitColle SR having it's "R&D" being read as code -w-)) |
(Tag: Undo) |
||
| Line 43: | Line 43: | ||
{{#switch: {{{type|}}} | combined = <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.number,Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{scout1|}}}" OR Scout.name_en="{{{scout2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes}} | {{#switch: {{{type|}}} | combined = <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.number,Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{scout1|}}}" OR Scout.name_en="{{{scout2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes}} | ||
</ul> | </ul> | ||
| − | {{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption, CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{scout1|}}}" OR Scout.name_en="{{{scout2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show dimensions=0|show filename=0|caption field=caption|link field=link|default=' ' | + | {{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption, CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{scout1|}}}" OR Scout.name_en="{{{scout2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show dimensions=0|show filename=0|caption field=caption|link field=link|default=' '}} |
| scoutextra = <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{scout1|}}}" OR Cards.chara="{{{chara1|}}}" AND Cards.cardname="{{{cardname1|}}}" OR Cards.chara="{{{chara2|}}}" AND Cards.cardname="{{{cardname2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes|default=}} | | scoutextra = <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{scout1|}}}" OR Cards.chara="{{{chara1|}}}" AND Cards.cardname="{{{cardname1|}}}" OR Cards.chara="{{{chara2|}}}" AND Cards.cardname="{{{cardname2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes|default=}} | ||
</ul> | </ul> | ||
| − | {{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption,CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{scout1|}}}" OR Cards.chara="{{{chara1|}}}" AND Cards.cardname="{{{cardname1|}}}" OR Cards.chara="{{{chara2|}}}" AND Cards.cardname="{{{cardname2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show filename=0|show dimensions=0|caption field=caption|link field=link|default= | + | {{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption,CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{scout1|}}}" OR Cards.chara="{{{chara1|}}}" AND Cards.cardname="{{{cardname1|}}}" OR Cards.chara="{{{chara2|}}}" AND Cards.cardname="{{{cardname2|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show filename=0|show dimensions=0|caption field=caption|link field=link|default=}} |
| − | | #default = <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{name_en|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes|default= | + | | #default = <ul>{{#cargo_query:tables=Scout,Cards|join on=Scout.name_en = Cards.cardset|fields=Cards.rarity,Cards.cardname,Cards.chara|where=Scout.name_en="{{{name_en|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=template|template=Scout/Cards|named args=yes|default=}} |
</ul> | </ul> | ||
{{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption,CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{name_en|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show filename=0|show dimensions=0|caption field=caption|link field=link|default=}} }}</div>{{clear}}</includeonly> | {{#cargo_query:tables=Scout,Cards,Card_Files|join on=Scout.name_en = Cards.cardset, Cards.number = Card_Files.number|fields=Cards.rarity,Cards.chara,Card_Files.image1,CONCAT(Cards.rarity,' [[',Cards.chara,']]')=caption,CONCAT('Cards/',Cards.chara,'/',Cards.cardname)=link|where=Scout.name_en="{{{name_en|}}}"|order by=Cards.rarity DESC, Cards.number ASC|format=gallery|mode=nolines|show bytes=0|show filename=0|show dimensions=0|caption field=caption|link field=link|default=}} }}</div>{{clear}}</includeonly> | ||
Latest revision as of 19:23, 3 April 2021
This template defines the table "Scout". View table.
{{Scout List
|number=
|name_jp=
|name_en=
|start=DD/M/YYYY 00:00
|end=DD/M/YYYY 00:00
|troupe=ssr_chara_name (eg. sakuya) OR bday_troupe_name (eg. spring)
|event=
|tiny=Event 1 (/) Event 2
|banner2= 2nd banner file name (eg. APRIL BIRTHDAY SP 2021 Part 2)
|note=
}}
