User:Electricsheep/sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
No edit summary |
|||
Line 1: | Line 1: | ||
__TOC__ |
__TOC__ |
||
=Cargo query test= |
=Cargo query test= |
||
TODO: account for daily reset at 4 |
|||
fix UL css |
|||
<ul> |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables = |
tables = events |
||
| fields = Image, |
| 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 |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Event" AND Server="JP" |
||
| order by = Start_date |
| order by = Start_date ASC |
||
| format = template |
| format = template |
||
| template = |
| template = FrontpageEvent |
||
| named args = yes |
| 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> |
<ul> |
||
{{#cargo_query: |
{{#cargo_query: |
||
tables = events |
tables = events |
||
| fields = Image, NameEN, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate |
| 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 |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Login" AND Server="JP" |
||
| order by = |
| order by = Start_date ASC |
||
| format = template |
| format = template |
||
| template = FrontpageEvent |
| template = FrontpageEvent |
||
| named args = yes |
| named args = yes |
||
| intro = ---- |
|||
| default = |
|||
}} |
}} |
||
</ul> |
</ul> |