Template:EN Event: Difference between revisions

From A3! Wiki
Yukari25mbcms (talk | contribs)
No edit summary
Yukari25mbcms (talk | contribs)
No edit summary
Line 7: Line 7:
'''Event Type:''' [[{{{type|}}} Events|{{{type|}}} Event]]<br>
'''Event Type:''' [[{{{type|}}} Events|{{{type|}}} Event]]<br>
'''Event Period:''' {{{start}}} to {{{end}}}<br> {{#if: {{{theme|}}} | '''Theme Song:''' [[{{{theme|}}}]]<br>|}}
'''Event Period:''' {{{start}}} to {{{end}}}<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 Tryout:''' {{#cargo_query:tables=EN_Tryout|fields=CONCAT("[[EN Tryout List","#",EN_Tryout.name_enserver,"|",EN_Tryout.name_enserver,"]]")|where=EN_Tryout.event HOLDS "{{{name_enserver|}}}" }}
{{#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 dimensions=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 dimensions=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=IFNULL(Card_Files.icon1,Card_Files.icon2)|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=IFNULL(Card_Files.icon1,Card_Files.icon2)|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 14:04, 29 July 2020