Difference between revisions of "Template:Event List"
From A3! Wiki
Fimbulvetr (talk | contribs) |
Fimbulvetr (talk | contribs) |
||
| Line 42: | Line 42: | ||
| {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}-1}} || '''{{{type|}}} Event'''{{#if: {{{troupe|}}} | <br />{{{troupe|}}} Troupe}} || {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}+1|format=text|default=}} | | {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}-1}} || '''{{{type|}}} Event'''{{#if: {{{troupe|}}} | <br />{{{troupe|}}} Troupe}} || {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}+1|format=text|default=}} | ||
|}--> | |}--> | ||
| − | |||
| − | |||
[[File:{{{banner|}}}|right|600px]] | [[File:{{{banner|}}}|right|600px]] | ||
{{{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|}}}|}} | {{{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|}}}|}} | ||
| − | + | '''Event Period:''' {{#time: F j, Y H:i | {{{start}}} }} JST to {{#time: F j, Y H:i | {{{end}}} }} JST<br> | |
| − | {{#if: {{{theme|}}} | *'''Theme Song:''' [[Music/{{{theme|}}}|{{{theme|}}}]] }} | + | {{#if: {{{theme|}}} | *'''Theme Song:''' [[Music/{{{theme|}}}|{{{theme|}}}]]<br> }} |
| − | '''Event Scout:''' {{#cargo_query:tables= Scout|fields=Scout.name_en|where=Scout.event HOLDS "{{{name_en|}}}" }} {{#cargo_query:tables= Scout,Cards,CardFiles|join on=Cards.cardset = Scout.name_en, Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity,Cards.character = Character,Cards.cardname = Card Name|where=Scout.event HOLDS "{{{name_en|}}}" |format=ul|default=}} | + | '''Event Scout:''' {{#cargo_query:tables= Scout|fields=Scout.name_en|where=Scout.event HOLDS "{{{name_en|}}}" }} {{#cargo_query:tables= Scout,Cards,CardFiles|join on=Cards.cardset = Scout.name_en, Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity,Cards.character = Character,Cards.cardname = Card Name|where=Scout.event HOLDS "{{{name_en|}}}" |format=ul|default=}}<br> |
| − | '''Event Cards:''' {{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity, Cards.character = Character,Cards.cardname = Card Name|where=Cards.cardset="{{{name_en}}}"|order by=Cards.number|format=ul|default=}} | + | '''Event Cards:''' {{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT("[[File:",CardFiles.icon1,"|33px]]"),Cards.rarity = Rarity, Cards.character = Character,Cards.cardname = Card Name|where=Cards.cardset="{{{name_en}}}"|order by=Cards.number|format=ul|default=}} |
</includeonly> | </includeonly> | ||
Revision as of 07:29, 6 December 2017
This template defines the table "Event". View table.
