User:Electricsheep/sandbox: Difference between revisions
Jump to navigation
Jump to search
Content added Content deleted
Line 1: | Line 1: | ||
__TOC__ |
__TOC__ |
||
=Cargo query test table output= |
=Cargo query test table output= |
||
{{BannerTable | |
|||
{{#cargo_query: |
{{#cargo_query: |
||
tables = |
tables = raids |
||
| fields = |
| fields = Image, Name, Start_date=Start_date, End_date=End_date |
||
| where = Server=" |
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="JP" |
||
| order by = Start_date |
| order by = Start_date ASC |
||
| limit = 1 |
|||
| more results text = |
|||
| format = template |
| format = template |
||
| template = |
| template = FrontpageRaid |
||
| named args = yes |
| named args = yes |
||
| default = None! |
|||
}} |
}} |
||
{{#cargo_query: |
|||
tables = raids |
|||
| fields = Name, Start_date=Start_date, End_date=End_date |
|||
| where = End_date > NOW() AND Start_date < DATE_ADD(NOW(), INTERVAL 6 DAY) AND Server="JP" |
|||
| order by = Start_date ASC |
|||
| offset = 1 |
|||
| more results text = |
|||
| format = template |
|||
| template = FrontpageRaid |
|||
| named args = yes |
|||
| default = |
|||
}} |
}} |
||