Template:NetplayWidget: Difference between revisions

Template page
No edit summary
(add minutes)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
=== [[Shoryuken Wiki:Community portal/Tournaments/2021/Netplay|Upcoming Online Tournaments]] ===
=== Upcoming Online Tournaments ===
<tabber>
<tabber>
US Eastern=
US Eastern=
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(TourneyNetplay.Date, "'''%b %d %l%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(TourneyNetplay.Date, "'''%b %d %l:%i%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|where=TourneyNetplay.Date >= CURDATE()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|format=template
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
|delimiter=\n
|delimiter=\n
|more results text=
}}
}}
|-|
|-|
Line 16: Line 18:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','US/Central'), "'''%b %d %l%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','US/Central'), "'''%b %d %l:%i%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|where=TourneyNetplay.Date >= CURDATE()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|format=template
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
|delimiter=\n
|delimiter=\n
|more results text=
}}
}}
|-|
|-|
Line 28: Line 32:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','US/Pacific'), "'''%b %d %l%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','US/Pacific'), "'''%b %d %l:%i%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|where=TourneyNetplay.Date >= CURDATE()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|format=template
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
|delimiter=\n
|delimiter=\n
|more results text=
}}
|-|
Brasília=
{{#cargo_query:
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','America/Sao_Paulo'), "'''%b %d %l:%i%p'''") = Date, TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|named args=Yes
|delimiter=\n
|more results text=
}}
}}
|-|
|-|
Line 40: Line 60:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Europe/Berlin'), "'''%b %d %l%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Europe/Berlin'), "'''%b %d %l:%i%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|where=TourneyNetplay.Date >= CURDATE()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|format=template
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
|delimiter=\n
|delimiter=\n
|more results text=
}}
}}
|-|
|-|
Line 52: Line 74:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Europe/London'), "'''%b %d %l%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Europe/London'), "'''%b %d %l:%i%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|where=TourneyNetplay.Date >= CURDATE()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|limit=16
|format=template
|format=template
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
|delimiter=\n
|delimiter=\n
|more results text=
}}
}}
|-|
|-|
Line 64: Line 88:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Asia/Tokyo'), "'''%b %d %l%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|fields=TourneyNetplay.Name, TourneyNetplay.Game, TourneyNetplay.Platform, TourneyNetplay.Region, DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Asia/Tokyo'), "'''%b %d %l:%i%p:'''") = Date, TourneyNetplay.Bracket, TourneyNetplay.Crowdfunding, TourneyNetplay.Coupon, TourneyNetplay.Chat, TourneyNetplay.Stream, TourneyNetplay.Stream_2, TourneyNetplay.Info, TourneyNetplay.Name
|where=TourneyNetplay.Date >= CURDATE()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|format=template
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
|delimiter=\n
|delimiter=\n
|more results text=
}}
}}
</tabber>
</tabber>

Latest revision as of 20:35, 11 April 2021

Upcoming Online Tournaments

Error: Table TourneyNetplay not found.

Error: Table TourneyNetplay not found.

Error: Table TourneyNetplay not found.

Error: Table TourneyNetplay not found.

Error: Table TourneyNetplay not found.

Error: Table TourneyNetplay not found.

Error: Table TourneyNetplay not found.
Retrieved from "https://wiki.supercombo.gg/index.php?title=Template:NetplayWidget&oldid=185321"