Template:Event: Difference between revisions
From A3! Wiki
| Line 9: | Line 9: | ||
{{#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}} | {{#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:''' {{#ifeq: {{#cargo_query:tables=Cards,Card_Files|join on=Cards.number = Card_Files.number|fields=Card_Files.icon1|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=Card_Files.icon1|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| | '''Title Achievements:''' {{#ifeq: {{#cargo_query:tables=Event,Titles|join on=Event.name_en = Titles.event|fields=CONCAT('[[',title,'.png|180px]]')|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|33px]] ',title)|where=Titles.event ="{{{name_en|}}}"|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> | ||
