Difference between revisions of "Template:Event List"

From A3! Wiki
m
Line 47: Line 47:
 
'''Event Period:''' {{#time: F j, Y H:i | {{{start}}} }} JST to {{#time: F j, Y H:i | {{{end}}} }} JST<br>
 
'''Event Period:''' {{#time: F j, Y H:i | {{{start}}} }} JST to {{#time: F j, Y H:i | {{{end}}} }} JST<br>
 
{{#if: {{{theme|}}} | *'''Theme Song:''' [[Music/{{{theme|}}}|{{{theme|}}}]]<br> }}
 
{{#if: {{{theme|}}} | *'''Theme Song:''' [[Music/{{{theme|}}}|{{{theme|}}}]]<br> }}
'''Event Scout:''' {{#cargo_query:tables= Scout|fields=Scout.name_en|where=Scout.event HOLDS "{{{name_en|}}}" }} {{#cargo_query:tables= Scout,Cards,CardFiles|join on=Cards.cardset = Scout.name_en, Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity,Cards.character = Character,Cards.cardname = Card Name|where=Scout.event HOLDS "{{{name_en|}}}" |format=ul|default=}}<br>
+
'''Event Scout:''' {{#cargo_query:tables= Scout|fields=Scout.name_en|where=Scout.event HOLDS "{{{name_en|}}}" }} {{#cargo_query:tables= Scout,Cards,CardFiles|join on=Cards.cardset = Scout.name_en, Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity,Cards.character = Character,Cards.cardname = Card Name|where=Scout.event HOLDS "{{{name_en|}}}" |format=ul|default=}}
 
'''Event Cards:''' {{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity, Cards.character = Character,Cards.cardname = Card Name|where=Cards.cardset="{{{name_en}}}"|order by=Cards.number|format=ul|default=}}
 
'''Event Cards:''' {{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity, Cards.character = Character,Cards.cardname = Card Name|where=Cards.cardset="{{{name_en}}}"|order by=Cards.number|format=ul|default=}}
 
</includeonly>
 
</includeonly>

Revision as of 07:30, 6 December 2017

This template defines the table "Event". View table.