Difference between revisions of "Template:Event"

From A3! Wiki
m (_i forgot i changed this template too_ (mission abort mission abo-))
m (cargo_query: Add field alias and update string literal quotes, in preparation for Cargo extension upgrade)
 
(6 intermediate revisions by 2 users not shown)
Line 3: Line 3:
  
 
=Event Information=
 
=Event Information=
'''{{{name_en|}}}'''{{#if: {{{name_alt|}}} | , alt. "{{{name_alt|}}}" }}{{#if: {{{name_lit|}}} | , lit. "{{{name_lit|}}}" }} {{#if: {{{name_jp|}}} |({{{name_jp}}} ''{{{name_ro|}}}'')|}} is event number {{{number}}} in A3! overall. {{#if: {{{extra|}}}|{{{extra|}}}|}}
+
<b>{{{name_en|}}}</b>{{#if: {{{name_alt|}}} | , alt. '{{{name_alt|}}}' }}{{#if: {{{name_lit|}}} | , lit. '{{{name_lit|}}}' }} {{#if: {{{name_jp|}}} |({{{name_jp}}} <i>{{{name_ro|}}}</i>)|}} is event number {{{number}}} in A3! overall. {{#if: {{{extra|}}}|{{{extra|}}}|}}
  
 
'''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: {{{theme2|}}} | '''Theme Songs:''' [[{{{theme|}}}]], [[{{{theme2|}}}]]<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','#',Scout.name_en,'|',Scout.name_en,']]')=Name|where=Scout.event HOLDS '{{{name_en|}}}'|order by=Scout.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}}
+
{{#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>
'''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|}}}"|order by=Titles.number ASC|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|}}}'|order by=Titles.number ASC|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,']]')=Name|where=number={{{number|}}}-1}}<br>
'''Next Event:''' {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}+1|default=N/A}}<br>
+
'''Next Event:''' {{#cargo_query:tables=Event|fields=CONCAT('[[',name_en,']]')=Name|where=number={{{number|}}}+1|default=N/A}}<br>
 
[[Category:Events]] [[Category:{{{type|}}} Events]] {{#switch: {{{type|}}} | Troupe = [[Category: {{{troupe|}}} Events]] | }}
 
[[Category:Events]] [[Category:{{{type|}}} Events]] {{#switch: {{{type|}}} | Troupe = [[Category: {{{troupe|}}} Events]] | }}
 
{{clear}}
 
{{clear}}
 
</includeonly>
 
</includeonly>

Latest revision as of 02:25, 31 December 2024