Difference between revisions of "Template:Event List"

Revision as of 17:51, 28 December 2018

This template defines the table "Event". View table.

@@ Line 34: / Line 34: @@
 <div class="eventinfo"><ul><li>'''Event Period:''' {{#if: {{{start|}}} | {{#time: F j, Y H:i | {{{start}}}}} JST |TBA}}{{#if: {{{end|}}} | &nbsp;to {{#time: F j, Y H:i | {{{end}}}}} JST |}}</li>
 {{#if: {{{countdown|}}} | <li>'''Countdown:''' {{{countdown}}}</li> | }}
-<li>'''Related Scouting:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events#",Scout.name_en,"|",Scout.name_en,"]]")|where=Scout.event HOLDS "{{{name_en|}}}"}}</li>
+<li>'''Related Scouting:''' {{#cargo_query:tables= Scout|fields=CONCAT("[[Scouting Events",CASE WHEN Scout.number < 44 THEN "/2017" WHEN Scout.number < 93 THEN "/2018" ELSE "" END,"#",Scout.name_en,"|",Scout.name_en,"]]")|where=Scout.event HOLDS "{{{name_en|}}}"}}</li>
 <li>'''Featured:''' {{#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}} }}
 </li></ul></div>
 <div class="eventbanner">[[File:{{Replace|{{{name_en|}}}}} event banner.png|frameless|link={{{name_en}}}|{{{name_en}}}]]</div></div>
 </includeonly>