Main Page: Difference between revisions
Query event data from cargo
(Banner info queried from cargo table) |
(Query event data from cargo) |
||
Line 38:
<div class="fp-item-header">Recent Updates</div>
<div class="fp-item-content">
<!-- Recent Updates
<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="Event" 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
| 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
| 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>
|