Difference between revisions of "Template:Event"

From A3! Wiki
m (Event Information)
m (Event Information)
Line 6: Line 6:
 
'''Event Type:''' [[{{{type|}}} Events|{{{type|}}} Event]]<br>
 
'''Event Type:''' [[{{{type|}}} Events|{{{type|}}} Event]]<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:''' [[{{{theme|}}}]]<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:''' [[{{{theme|}}}]]<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",CASE WHEN Scout.number < 44 THEN "/2017" WHEN Scout.number < 93 THEN "/2018" ELSE "" END,"#",Scout.name_en,"|",Scout.name_en,"]]")|where=Scout.event HOLDS "{{{name_en|}}}" }}
 
{{#cargo_query:tables=Scout,Cards,Card_Files|join on=Cards.cardset = Scout.name_en, Cards.number = Card_Files.number|fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link|where=Scout.event HOLDS "{{{name_en|}}}" |format=gallery|mode=nolines|image width=100px|show bytes=0|show filename=0|alt field=Caption|caption field=Caption|link field=Page Link|default=|order by=Cards.number}}
 
{{#cargo_query:tables=Scout,Cards,Card_Files|join on=Cards.cardset = Scout.name_en, Cards.number = Card_Files.number|fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link|where=Scout.event HOLDS "{{{name_en|}}}" |format=gallery|mode=nolines|image width=100px|show bytes=0|show filename=0|alt field=Caption|caption field=Caption|link field=Page Link|default=|order by=Cards.number}}
 
'''Event Cards:''' {{#ifeq: {{#cargo_query:tables=Cards,Card_Files|join on=Cards.number = Card_Files.number|fields=Card_Files.icon1|where=Cards.cardset="{{{name_en|}}}"|default=N/A}} | N/A | N/A | {{#tag:gallery|{{Featured Cards|{{{name_en}}}}}|mode=nolines|widths=100px}} }}<br>
 
'''Event Cards:''' {{#ifeq: {{#cargo_query:tables=Cards,Card_Files|join on=Cards.number = Card_Files.number|fields=Card_Files.icon1|where=Cards.cardset="{{{name_en|}}}"|default=N/A}} | N/A | N/A | {{#tag:gallery|{{Featured Cards|{{{name_en}}}}}|mode=nolines|widths=100px}} }}<br>

Revision as of 17:50, 28 December 2018