Template:EN Event: Difference between revisions
From A3! Wiki
No edit summary |
m cargo_query: Add field alias, in preparation for Cargo extension upgrade |
||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly> | ||
{{#ifeq: {{{type|}}} | Rerelease | [[File:Revival Events EN event banner.png|right|500px]] |[[File:{{Replace|{{{name_enserver|}}}}} EN event banner.png|right|500px]]}} | {{#ifeq: {{{type|}}} | Rerelease | [[File:Revival Events EN event banner.png|right|500px]] |[[File:{{Replace|{{{name_enserver|}}}}} EN event banner.png|right|500px]]}} | ||
=Event Information= | =Event Information= | ||
{{Notice|This is the event page for the event in the English server. The JP event page is [[{{{name_en|}}}]].}} | |||
'''{{{name_enserver|}}}''' is event number {{{number}}} in the English A3! server. {{#if: {{{extra|}}}|{{{extra|}}}|}} | '''{{{name_enserver|}}}''' is event number {{{number}}} in the English A3! server. {{#if: {{{extra|}}}|{{{extra|}}}|}} | ||
'''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:''' {{#if: {{{start|}}} | {{#switch: {{{timezone|}}} | ||
'''Event | |PST to PST|PST to PDT = {{#time: F j, Y H:i | {{{start}}} }} PST | ||
|PDT to PDT|PDT to PST = {{#time: F j, Y H:i | {{{start}}} }} PDT | |||
}} |TBA}}{{#if: {{{end|}}} | {{#switch: {{{timezone|}}} | |||
|PST to PST|PDT to PST = to {{#time: F j, Y H:i | {{{end}}} }} PST | |||
|PST to PDT|PDT to PDT = to {{#time: F j, Y H:i | {{{end}}} }} PDT | |||
}} | to TBA}}<br> {{#if: {{{theme2|}}} | '''Theme Songs:''' [[{{{theme|}}}]], [[{{{theme2|}}}]]<br> | {{#if: {{{theme|}}} | '''Theme Song:''' [[{{{theme|}}}]]<br>|}} }} | |||
'''Event Tryout:''' {{#cargo_query:tables=EN_Tryout|fields=CONCAT("[[EN Tryout List","#",EN_Tryout.name_enserver,"|",EN_Tryout.name_enserver,"]]")=Name|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)=Icon|where=Cards.cardset="{{{name_en|}}}"|default=N/A}} | N/A | N/A | {{#tag:gallery|{{Featured Cards|{{{name_en}}}}}|mode=nolines|widths=100px}} }}<br> | ||
'''Title Achievements:''' {{#ifeq: {{#cargo_query:tables=Event,Titles|join on=Event.name_en = Titles.event|fields=CONCAT('[[',title,'.png]]')|where=Titles.event ="{{{name_en|}}}"|default=N/A}} | N/A | N/A | {{#cargo_query:tables=Event,Titles|join on=Event.name_en = Titles.event|fields=CONCAT('[[File:',title,'.png|180px]] ',title)|where=Titles.event ="{{{name_en|}}}"|default=N/A}} }}<br> | '''Title Achievements:''' {{#ifeq: {{#cargo_query:tables=Event,Titles|join on=Event.name_en = Titles.event|fields=CONCAT('[[',title,'.png]]')=TitleImage|where=Titles.event ="{{{name_en|}}}"|default=N/A}} | N/A | N/A | {{#cargo_query:tables=Event,Titles|join on=Event.name_en = Titles.event|fields=CONCAT('[[File:',title,'.png|180px]] ',title)=TitleImage|where=Titles.event ="{{{name_en|}}}"|default=N/A}} }}<br> | ||
'''Previous Event:''' {{#cargo_query:tables=EN_Event|fields=CONCAT("[[",name_enserver,"]]")|where=number={{{number|}}}-1}}<br> | '''Previous Event:''' {{#cargo_query:tables=EN_Event|fields=CONCAT("[[",name_enserver,"]]")=Name|where=number={{{number|}}}-1}}<br> | ||
'''Next Event:''' {{#cargo_query:tables=EN_Event|fields=CONCAT("[[",name_enserver,"]]")|where=number={{{number|}}}+1|default=N/A}}<br> | '''Next Event:''' {{#cargo_query:tables=EN_Event|fields=CONCAT("[[",name_enserver,"]]")=Name|where=number={{{number|}}}+1|default=N/A}}<br> | ||
[[Category:EN Events]] [[Category:{{{type|}}} EN Events]] {{#switch: {{{type|}}} | Troupe = [[Category: {{{troupe|}}} EN Events]] | }} | [[Category:EN Events]] [[Category:{{{type|}}} EN Events]] {{#switch: {{{type|}}} | Troupe = [[Category: {{{troupe|}}} EN Events]] | }} | ||
{{clear}} | {{clear}} | ||
</includeonly> | </includeonly> | ||
