Difference between revisions of "Template:Event List"

From A3! Wiki
m
Line 50: Line 50:
 
<!--'''Event Scout:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events#",Scout.name_en,"|",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|}}}" |order by=Cards.number|format=ul|default=}}<br>-->
 
<!--'''Event Scout:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events#",Scout.name_en,"|",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|}}}" |order by=Cards.number|format=ul|default=}}<br>-->
 
'''Event Scout:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events#",Scout.name_en,"|",Scout.name_en,"]]")|where=Scout.event HOLDS "{{{name_en|}}}" }}
 
'''Event Scout:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events#",Scout.name_en,"|",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=CardFiles.icon1,Cards.rarity = Rarity,Cards.character = Character,Cards.cardname = Card Name|where=Scout.event HOLDS "{{{name_en|}}}" |format=gallery|mode=nolines|image width=50px|show bytes=0|show filename=0|default=}}<br>
+
{{#cargo_query:tables= Scout,Cards,CardFiles|join on=Cards.cardset = Scout.name_en, Cards.number = CardFiles.number|fields=CardFiles.icon1,Cards.rarity = Rarity,Cards.character = Character,Cards.cardname = Card Name|where=Scout.event HOLDS "{{{name_en|}}}" |format=gallery|mode=nolines|image width=60px|show bytes=0|show filename=0|alt field="Card Name"|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=N/A}}<br>
 
'''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=N/A}}<br>
 
'''Previous Event:''' {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}-1}}<br>
 
'''Previous Event:''' {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}-1}}<br>

Revision as of 08:57, 13 January 2018

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