User:Electricsheep/sandbox: Difference between revisions

Jump to navigation Jump to search
Content added Content deleted
VisualWikitext
Line 7: Line 7:
{{#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, 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, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate
| 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, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate
| 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
Retrieved from "https://bluearchive.wiki/wiki/User:Electricsheep/sandbox"