|
<div class="fp-item-header">Current Gacha Banner</div>
<div class="fp-item-content">
<tabs style="display:inline;" class="server-toggle-parent" plain>
<tab name="JP">{{FrontpagePanelBanners|JP}}</tab>
<tab name="GL">{{FrontpagePanelBanners|GL}}</tab>
{{#cargo_query:
tables = banners
| fields = Image, Rateup_character=Rateup_character, Limited, 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 10 DAY) AND Server="JP"
| order by = Start_date DESC, Id ASC
| format = template
| template = FrontpageBanner
| named args = yes
}}
</tab>
<tab name="GL">
{{#cargo_query:
tables = banners
| fields = Image, Rateup_character=Rateup_character, Limited, 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="GL"
| order by = Start_date DESC, Id ASC
| format = template
| template = FrontpageBanner
| named args = yes
}}
</tab>
</tabs>
</div>
<div class="fp-item-content">
<!-- Current Raid Boss is queried from the information found on the [Raid] page-->
<tabs style="display:inline;" class="server-toggle-parent" plain>
{{#cargo_query:
<tab name="JP">{{FrontpagePanelRaid|JP}}</tab>
tables = raids
<tab name="GL">{{FrontpagePanelRaid|GL}}</tab>
| fields = Image, Name, Environment, Start_date=Start_date, End_date=End_date
</tabs>
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 7 DAY) AND Server="JP" AND (Type="Raid" OR Type="Elimination")
| order by = Start_date ASC
| limit = 1
| more results text =
| format = template
| template = FrontpageRaid
| named args = yes
| default =
}}{{#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 7 DAY) AND Server="JP" AND (Type="Raid" OR Type="Elimination")
| order by = Start_date ASC
| offset = 1
| more results text =
| format = template
| template = FrontpageRaid
| named args = yes
| default =
}}{{#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 7 DAY) AND Server="JP" AND Type="Limit Break"
| order by = Start_date ASC
| limit = 1
| more results text =
| format = template
| template = FrontpageRaid
| named args = yes
| default =
}}
</div>
</div>
<div class="fp-item-content">
<!-- Recent Updates are queried from the information found in [Events] section -->
<tabs style="display:inline;" class="server-toggle-parent" plain>
<ul>
<tab name="JP">{{FrontpagePanelEvents|JP}}</tab>
{{#cargo_query:
<tab name="GL">{{FrontpagePanelEvents|GL}}</tab>
tables = events
</tabs>
| fields = Image, NameEN, Start_date=Start_date, End_date=End_date, _pageName=Page
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND (Category="Event" OR Category="MiniEvent" OR Category="Collab") AND Server="JP"
| order by = Start_date ASC
| format = template
| template = FrontpageEvent
| named args = yes
| default =
}}
</ul>
<ul>
{{#cargo_query:
tables = world_raids
| fields = Image, Name, Environment, Start_date=Start_date, End_date=End_date
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 7 DAY) AND Server="JP"
| order by = Start_date ASC
| more results text =
| format = template
| template = FrontpageWorldRaid
| named args = yes
| default =
}}
</ul>
<ul>
{{#cargo_query:
tables = events
| fields = Image, NameEN, Start_date=Start_date, End_date=End_date, _pageName=Page
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Joint Firepower Exercise" AND Server="JP"
| order by = Start_date ASC
| format = template
| template = FrontpageJointFirepowerExercise
| named args = yes
| default =
}}
</ul>
<ul>
{{#cargo_query:
tables = events
| fields = Image, NameEN, Start_date=Start_date, End_date=End_date
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Rewards" AND Server="JP"
| order by = Start_date ASC
| format = template
| template = FrontpageEvent
| named args = yes
| default =
}}
</ul>
<ul>
{{#cargo_query:
tables = events
| fields = Image, NameEN, Start_date=Start_date, End_date=End_date, _pageName=Page
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Guide mission" AND Server="JP"
| order by = Start_date ASC
| format = template
| template = FrontpageEvent
| named args = yes
| intro =
| default =
}}
</ul>
<ul>
{{#cargo_query:
tables = events
| fields = Image, NameEN, Start_date=Start_date, End_date=End_date
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Login" AND Server="JP"
| order by = Start_date ASC
| format = template
| template = FrontpageEvent
| named args = yes
| intro = ----
| default =
}}
</ul>
</div>
</div>
|