User:Electricsheep/sandbox: Difference between revisions
→Cargo query test
No edit summary |
|||
Line 1:
__TOC__
=Cargo query test=
TODO: account for daily reset at 4
fix UL css
<ul>
{{#cargo_query:
tables =
| fields = Image,
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL
| order by = Start_date
| format = template
| template =
| named args = yes
| default =
}}
</ul>
<ul>
{{#cargo_query:
tables = events
| fields = Image, NameEN, 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 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, 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
| order by =
| format = template
| template = FrontpageEvent
| named args = yes
| intro = ----
| default =
}}
</ul>
|