Difference between revisions of "User:AsahiKaen/Sandbox3"

From A3! Wiki
m (and the changes are live !! yatta~)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
=Blog List=
+
'''Test for auto EN home modules (like the JP ones) + auto rerelease event banners?'''
−
{{#cargo_query: tables=Blog_List, Blog_Content
+
<br>''Last updated Wednesday, 31 Mar 2021''
−
|join on=Blog_List.number = Blog_Content.number
 
−
|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)
 
−
|group by=Blog_List.startdate
 
−
|format=dynamic table
 
−
|limit=500
 
−
}}
 
  
−
vs w/o <code>group by=</code>:
+
==FROM CURRENT MAIN PAGE==
−
(note Itaru's duplicate posts, 26 May 20)
+
<tab name="JP Server">
−
{{#cargo_query: tables=Blog_List, Blog_Content
+
<div class="flex-container" style="width: 100%; margin: auto;">
−
|join on=Blog_List.number = Blog_Content.number
+
{{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=
−
|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
+
{{#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}} }}
−
|where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155)
 
−
|order by=Blog_List.number asc
 
−
|format=dynamic table
 
−
|limit=500
 
−
}}
 
  
−
=Template:Multiple (image)=
+
{{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=}}
−
For (attempted) use, find & delete "TEMP.BREAKER" – was used to prevent the cargos
 
−
<noinclude>{{#cargo_TEMP.BREAKERdeclare:_table=Multiple
 
−
|align=String
 
−
|direction=String
 
−
|background=String
 
−
|width=Number
 
−
|image1=String
 
−
|image2=String
 
−
|link1=Page
 
−
|link2=Page
 
−
|footer=Wikitext
 
−
|footer_align=String}}
 
−
</noinclude>
 
  
−
<includeonly>{{#cargo_TEMP.BREAKERstore:_table=Multiple
+
{{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=}}
−
|align={{{align|}}}
+
</div>
−
|direction={{{direction|}}}
+
</tab>
−
|background={{{background|}}}
 
−
|width={{{width|}}}
 
−
|image1={{{image1|}}}
 
−
|image2={{{image2|}}}
 
−
|link1={{{link1|}}}
 
−
|link2={{{link1|}}}
 
−
|footer={{{footer|}}}
 
−
|footer_align={{{footer_align|}}}
 
−
}}</includeonly>
 
  
−
<noinclude>Creates a box with 2 to 10 images arranged vertically or horizontally, with captions for the entire box and/or for each image.
+
<tab name="EN Server">
−
<pre>{{Multiple
+
<div class="flex-container" style="width: 100%; margin: auto;">
−
|align=Position on page (left, right, center)
+
{{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}} }}
−
|direction=(Only if) vertical
 
−
|background=Eg. #FFFFFF, white
 
−
|width=(Omit 'px' suffix)
 
−
|image1=(Omit 'File:' prefix) 1st file name
 
−
|image2=(Omit 'File:' prefix) 2nd file name
 
−
|link1=(If not default img description page) Common link
 
−
|footer=Collective caption
 
−
|footer_align=Position of footer (left, right, center)
 
−
}}</pre>
 
  
−
{{Multiple|align=left|direction=horizontal|background=white|width=150|image1=(Beastkeeper Big Brother) Citron Serious SSR.png|image2=(Beastkeeper Big Brother) Citron Serious SSR+.png|link1=|footer=[[File:Citron Exciting animalS Fullbody.png|Beastkeeper Big Brother: SSR Backstage Story]]|footer_align=center}}
+
{{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=}}
−
</noinclude>
+
 
 +
{{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


Retrieved from "https://yaycupcake.com/a3/index.php?title=User:AsahiKaen/Sandbox3&oldid=50457"