Main Page: Difference between revisions
Query Raid data from cargo
(Query event data from cargo) |
(Query Raid data from cargo) |
||
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, Id ASC
| format = template
| template = FrontpageBanner
Line 30:
<div class="fp-item-header">Current Raid Boss</div>
<div class="fp-item-content">
<!-- Current Raid Boss
{{#cargo_query:
tables = raids
| 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>
|