User:Electricsheep/sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
Line 7: | Line 7: | ||
{{#cargo_query: |
{{#cargo_query: |
||
tables = events |
tables = events |
||
| fields = Image, NameEN, |
| 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" |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Event" AND Server="JP" |
||
| order by = Start_date ASC |
| order by = Start_date ASC |
||
Line 19: | Line 19: | ||
{{#cargo_query: |
{{#cargo_query: |
||
tables = events |
tables = events |
||
| fields = Image, NameEN, |
| 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" |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Rewards" AND Server="JP" |
||
| order by = Start_date ASC |
| order by = Start_date ASC |
||
Line 31: | Line 31: | ||
{{#cargo_query: |
{{#cargo_query: |
||
tables = events |
tables = events |
||
| fields = Image, NameEN, |
| 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" |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 4 DAY) AND Category="Login" AND Server="JP" |
||
| order by = Start_date ASC |
| order by = Start_date ASC |