Difference between revisions of "User:AsahiKaen/Sandbox3"
From A3! Wiki
m (submitting to check if the EN countdowns show up) |
m (and the changes are live !! yatta~) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 8: | Line 8: | ||
{{#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}} }} | {{#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= | + | {{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= | + | {{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> | </div> | ||
</tab> | </tab> | ||
| Line 16: | Line 16: | ||
<tab name="EN Server"> | <tab name="EN Server"> | ||
<div class="flex-container" style="width: 100%; margin: auto;"> | <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}}|banner=}} | + | {{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=|order by=number DESC|limit=1|more results text=|no html}} | {{#cargo_query:tables=EN_Tryout|fields=troupe = troupe|where=|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}}|banner=}} | + | {{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}}|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> | </div> | ||
</tab> | </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]
