Difference between revisions of "Template:Event List"
From A3! Wiki
Fimbulvetr (talk | contribs) |
Fimbulvetr (talk | contribs) |
||
| Line 49: | Line 49: | ||
'''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#",Scout.name_en,"|",Scout.name_en,"]]")|where=Scout.event HOLDS "{{{name_en|}}}" }} | ||
| − | {{#cargo_query:tables=Scout,Cards, | + | {{#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:''' {{#cargo_query:tables=Cards, | + | '''Event Cards:''' {{#cargo_query:tables=Cards,Card_Files|join on=Cards.number = Card_Files.number|fields=Card_Files.icon1, CONCAT(Cards.rarity, ' ', Cards.chara) = Caption, CONCAT('Cards/', Cards.chara, '/', Cards.cardname) = Page Link|where=Cards.cardset="{{{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=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> | ||
'''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,"]]")|where=number={{{number|}}}+1|default=N/A}}<br> | ||
Revision as of 01:07, 22 February 2018
This template defines the table "Event". View table.
