User:Electricsheep/sandbox: Difference between revisions

=Cargo query test=

TODO: account for daily reset at 4

fix UL css

<ul>

{{#cargo_query:

tables = events

| 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"

| order by = Start_date ASC

| format = template

| template = FrontpageEvent

| named args = yes

| default =

}}

</ul>

<ul>

{{#cargo_query:

tables = events

| 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"

| order by = Start_date ASC

| format = template

| template = FrontpageEvent

| named args = yes

| default =

}}

</ul>

<ul>

{{#cargo_query:

tables = events

| 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"

| order by = Start_date ASC

| format = template

| template = FrontpageEvent

| named args = yes

| intro = ----

| default =

}}

</ul>