Main Page: Difference between revisions

Jump to navigation Jump to search
Content added Content deleted
(JP/Gl banners tabber)
m (Show banners further into the future)
Line 20: Line 20:
tables = banners
tables = banners
| fields = Image, Rateup_character=Rateup_character, Limited, date_format(Start_date, '%m/%d')=sdate, date_format(End_date, '%m/%d')=edate
| fields = Image, Rateup_character=Rateup_character, Limited, 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 2 DAY) AND Server="JP"
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 10 DAY) AND Server="JP"
| order by = Start_date DESC, Id ASC
| order by = Start_date DESC, Id ASC
| format = template
| format = template