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=Blog_List, Blog_Content
+
'''Test for auto EN home modules (like the JP ones) + auto rerelease event banners?'''
|join on=Blog_List.number = Blog_Content.number
+
<br>''Last updated Wednesday, 31 Mar 2021''
|fields=Blog_List.startdate = Date, CONCAT('[[File:',Blog_List.chara, ' SD Icon Round.png|33px|middle]] [[', Blog_List.chara,']]') = Author, CONCAT('[[Troupe Member Blog#Blog-',Blog_Content.number,'|',Blog_Content.title,']]') = Title, Blog_Content.translator = Translator
+
 
|where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155)
+
==FROM CURRENT MAIN PAGE==
|group by=Blog_List.startdate desc
+
<tab name="JP Server">
|format=dynamic table
+
<div class="flex-container" style="width: 100%; margin: auto;">
|limit=500
+
{{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]

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