Difference between revisions of "Template:Event Info"

From A3! Wiki
(Created page with "<includeonly>Category: Events [[Category: {{{troupe|}}} Events]] {| class="wikitable a3table" style="text-align: center;" |- ! Previous !! {{{number|}}}<br />{{{name_en|}}...")
 
m
Line 1: Line 1:
 
<includeonly>[[Category: Events]]
 
<includeonly>[[Category: Events]]
[[Category: {{{troupe|}}} Events]]
+
{{#ifeq: {{{type|}}} | Troupe | [[Category: {{{troupe|}}} Events]] | Seasonal | [[Category: Seasonal Events]] | Etude | [[Category: Etude Events]] | Support | [[Category: Support Events]]}}
{| class="wikitable a3table" style="text-align: center;"
+
{| class="wikitable a3table" style="text-align: center; margin: auto;"
 
|-
 
|-
 
! Previous !! {{{number|}}}<br />{{{name_en|}}} !! Next
 
! Previous !! {{{number|}}}<br />{{{name_en|}}} !! Next
 
|-
 
|-
| {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}-1}} || [[{{{banner|}}}|600px]] || {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}+1|format=text}}
+
| {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"|<]]")|where=number={{{number|}}}-1}} || {{#cargo_query:tables=Event|fields=CONCAT("[[File:",banner,"|600px]]")|where=number={{{number|}}}|format=text}} || {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"|>]]")|where=number={{{number|}}}+1|format=text}}
 
|-
 
|-
| {{{previous|}}} || '''{{{type|}}} Event:''' {{{name_jp}}}<br />{{#if: {{{troupe|}}} | {{{troupe|}}} Troupe}} || {{{next|}}}
+
| {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}-1}} || '''{{{type|}}} Event:''' {{{name_jp}}}<br />{{#if: {{{troupe|}}} | {{{troupe|}}} Troupe}} || {{#cargo_query:tables=Event|fields=CONCAT("[[",name_en,"]]")|where=number={{{number|}}}+1|format=text}}
 
|}
 
|}
  
Line 16: Line 16:
 
{{#if: {{{name_jp|}}} | '''Name (Japanese):''' {{{name_jp}}} (''{{{name_ro|}}}'') }}
 
{{#if: {{{name_jp|}}} | '''Name (Japanese):''' {{{name_jp}}} (''{{{name_ro|}}}'') }}
 
'''Event Period:''' {{#time: F j, Y H:i | {{{start}}} }} JST to {{#time: F j, Y H:i | {{{end}}} }} JST
 
'''Event Period:''' {{#time: F j, Y H:i | {{{start}}} }} JST to {{#time: F j, Y H:i | {{{end}}} }} JST
{{#if: {{{theme|}}} | '''Theme Song:''' {{{theme|}}} }}
+
{{#if: {{{theme|}}} | '''Theme Song:''' [[Music/{{{theme|}}}|{{{theme|}}}]] }}
'''Event Scout:''' {{#cargo_query:tables= Scout,Cards,CardFiles|join on=Cards.cardset = Scout.name_en, Cards.number = CardFiles.number|fields=Scout.name_en,Cards.rarity,Cards.character,Cards.cardname,CardFiles.icon1|where=Scout.event HOLDS "{{{name_en|}}}" }}
+
'''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}}
'''Event Cards:''' {{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=Cards.rarity, Cards.character, CardFiles.icon1|where=Cards.cardset="{{{name_en}}}"|order by=Cards.number|format=}}
+
'''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}}
 
</poem>
 
</poem>
  
Line 36: Line 36:
 
|troupe=Autumn
 
|troupe=Autumn
 
|theme=BUZAMA
 
|theme=BUZAMA
|banner=File:Alice event banner.png
 
 
}}
 
}}
 
<noinclude>
 
<noinclude>

Revision as of 05:01, 5 December 2017

Previous 12
Midsummer SparkleMemory
Next
<
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT CONCAT("600px") FROM `mw_cargo__Event` WHERE number=12 ORDER BY CONCAT("600px") LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'banner' in 'SELECT' (localhost)

|| >
Walk with me, talk with me! Troupe Event: 任侠伝・流れ者銀二
Autumn Troupe
Tag Match: Halloween '17

Event Info

Name (English): Midsummer SparkleMemory, alt. "test", lit. "lit test"
Name (Japanese): 任侠伝・流れ者銀二 (Ninkyōden・Nagare-sha Ginji)
Event Period: September 19, 2017 16:00 JST to September 28, 2017 13:59 JST
Theme Song: BUZAMA

Event Scout: A night in summer
Error: Table CardFiles not found.

Event Cards:
Error: Table CardFiles not found.