Difference between revisions of "User:AsahiKaen/Sandbox3"

From A3! Wiki
m (auto-replacement of EN revival event banner; checks for pacific timezones)
m (and the changes are live !! yatta~)
 
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=azuma|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=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=spring|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=}}
+
{{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={{#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}} }}
 
 
<!--TIMEZONE-ADJUSTED-->
 
 
{{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 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}}|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 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=}}
 
{{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]

Event

To You Who Flies to the Future

To You Who Flies to the Future event banner.png



Limited Scout

Each Start Line

x225px



Premium Scout

APRIL BIRTHDAY SP 2024

x225px


EN Event

Towards Full Bloom

Towards Full Bloom EN event banner.png



EN Tryout

2nd Anniversary Winter

2nd Anniversary Winter EN gacha.png



EN Premium Tryouts

OCTOBER BIRTHDAY 2021

OCTOBER BIRTHDAY 2021 EN gacha.png