Difference between revisions of "User:AsahiKaen/Sandbox3"
From A3! Wiki
m (and the changes are live !! yatta~) |
|||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | {{#cargo_query: tables= | + | '''Test for auto EN home modules (like the JP ones) + auto rerelease event banners?''' |
− | | | + | <br>''Last updated Wednesday, 31 Mar 2021'' |
− | |fields= | + | |
− | |where= | + | ==FROM CURRENT MAIN PAGE== |
− | | | + | <tab name="JP Server"> |
− | | | + | <div class="flex-container" style="width: 100%; margin: auto;"> |
− | |limit= | + | {{Home/Module|type=Event|troupe={{#if: {{#cargo_query:tables=Event|fields=troupe = troupe|where=|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=Event|fields=troupe = troupe|where=|order by=number DESC|limit=1|more results text=|no html}} | mankai}}|name={{#cargo_query:tables=Event|fields=name_en = name|where=|order by=number DESC|limit=1|more results text=|no html}}|startdate={{#cargo_query:tables=Event|fields=start = startdate|where=|order by=number DESC|limit=1|more results text=|no html}}|enddate={{#cargo_query:tables=Event|fields=end = enddate|where=|order by=number DESC|limit=1|more results text=|no html}}|banner= |
− | }} | + | {{#switch: {{#cargo_query:tables=Event|fields=type|where=|order by=number DESC|limit=1|more results text=|no html}} | Rerelease = 2018-12 event banner.png}} }} |
+ | |||
+ | {{Home/Module|type=Limited Scout|troupe={{#if: {{#cargo_query:tables=Scout|fields=troupe = troupe|where=name_en NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=Scout|fields=troupe = troupe|where=name_en NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | mankai}}|name={{#cargo_query:tables=Scout|fields=name_en = name|where=name_en NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|startdate={{#cargo_query:tables=Scout|fields=start = startdate|where=name_en NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|enddate={{#cargo_query:tables=Scout|fields=end = enddate|where=name_en NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|banner=}} | ||
+ | |||
+ | {{Home/Module|type=Premium Scout|troupe={{#if: {{#cargo_query:tables=Scout|fields=troupe = troupe|where=name_en LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=Scout|fields=troupe = troupe|where=name_en LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | mankai}}|name={{#cargo_query:tables=Scout|fields=name_en = name|where=name_en LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|startdate={{#cargo_query:tables=Scout|fields=start = startdate|where=name_en LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|enddate={{#cargo_query:tables=Scout|fields=end = enddate|where=name_en LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|banner=}} | ||
+ | </div> | ||
+ | </tab> | ||
+ | |||
+ | <tab name="EN Server"> | ||
+ | <div class="flex-container" style="width: 100%; margin: auto;"> | ||
+ | {{Home/Module|type=EN Event|troupe={{#if: {{#cargo_query:tables=EN_Event|fields=troupe = troupe|where=|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=EN_Event|fields=troupe = troupe|where=|order by=number DESC|limit=1|more results text=|no html}} | mankai}}|enname={{#cargo_query:tables=EN_Event|fields=name_enserver = enname|where=|order by=number DESC|limit=1|more results text=|no html}}|startdate={{#cargo_query:tables=EN_Event|fields=start = startdate|where=|order by=number DESC|limit=1|more results text=|no html}}|enddate={{#cargo_query:tables=EN_Event|fields=end = enddate|where=|order by=number DESC|limit=1|more results text=|no html}}|timezone={{#cargo_query:tables=EN_Event|fields=timezone = timezone|where=|order by=number DESC|limit=1|more results text=|no html}}|banner={{#switch: {{#cargo_query:tables=EN_Event|fields=type|where=|order by=number DESC|limit=1|more results text=|no html}} | Rerelease = Revival Events EN event banner.png}} }} | ||
+ | |||
+ | {{Home/Module|type=EN Tryout|troupe={{#if: {{#cargo_query:tables=EN_Tryout|fields=troupe = troupe|where=name_enserver NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=EN_Tryout|fields=troupe = troupe|where=name_enserver NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | mankai}}|enname={{#cargo_query:tables=EN_Tryout|fields=name_enserver = enname|where=name_enserver NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|startdate={{#cargo_query:tables=EN_Tryout|fields=start = startdate|where=name_enserver NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|enddate={{#cargo_query:tables=EN_Tryout|fields=end = enddate|where=name_enserver NOT LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|timezone={{#cargo_query:tables=EN_Event|fields=timezone = timezone|where=|order by=number DESC|limit=1|more results text=|no html}}|banner=}} | ||
+ | |||
+ | {{Home/Module|type=EN Premium Tryouts|troupe={{#if: {{#cargo_query:tables=EN_Tryout|fields=troupe = troupe|where=name_enserver LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=EN_Tryout|fields=troupe = troupe|where=name_enserver LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}} |}}|enname={{#cargo_query:tables=EN_Tryout|fields=name_enserver = enname|where=name_enserver LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|startdate={{#cargo_query:tables=EN_Tryout|fields=start = startdate|where=name_enserver LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|enddate={{#cargo_query:tables=EN_Tryout|fields=end = enddate|where=name_enserver LIKE '%BIRTHDAY%'|order by=number DESC|limit=1|more results text=|no html}}|timezone={{#cargo_query:tables=EN_Event|fields=timezone = timezone|where=|order by=number DESC|limit=1|more results text=|no html}}|banner=}} | ||
+ | </div> | ||
+ | </tab> |
Latest revision as of 08:12, 31 March 2021
Test for auto EN home modules (like the JP ones) + auto rerelease event banners?
Last updated Wednesday, 31 Mar 2021
FROM CURRENT MAIN PAGE[edit]