Main Page: Difference between revisions

Content added Content deleted

Inline

Revision as of 18:18, 18 February 2022

Countdown to daily reset:
00:00:00

Current Gacha Banner

Kirara: 05/08 - 05/15

Kaede: 05/08 - 05/15

Tsukuyo: 05/08 - 05/15

Kaho: 05/08 - 05/15

Current Raid Boss

Recent Updates

@@ Line 20: / Line 20: @@
 | fields = Image, Rateup_character=Rateup_character, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate
 | where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 2 DAY) AND Server="JP"
-| order by = Start_date DESC
+| order by = Start_date DESC, Id ASC
 | format = template
 | template = FrontpageBanner
@@ Line 30: / Line 30: @@
 <div class="fp-item-header">Current Raid Boss</div>
 <div class="fp-item-content">
-<!-- Current Raid Boss goes here -->
+<!-- Current Raid Boss is queried from the information found on the [Raid] page-->
+{{#cargo_query:
-[[File:Raid_Banner_3_jp(市街地)_268670724.png|300px|frameless|link=ShiroKuro]]
+  tables = raids
-{{Icon|Urban|size=24}} [[ShiroKuro|Slumpia: ShiroKuro]]: 02/16 - 02/22
+| fields = Image, Name, Environment, Start_date=Start_date, End_date=End_date
+| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="JP"
+| order by = Start_date ASC
+| limit = 1
+| more results text =
+| format = template
+| template = FrontpageRaid
+| named args = yes
+| default = None!
+}}
+{{#cargo_query:
+  tables = raids
+| fields = Name, Environment, Start_date=Start_date, End_date=End_date
+| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="JP"
+| order by = Start_date ASC
+| offset = 1
+| more results text =
+| format = template
+| template = FrontpageRaid
+| named args = yes
+| default =
+}}
 </div>
 </div>