Template:NetplayWidget: Difference between revisions

Template page
No edit summary
(add minutes)
 
(3 intermediate revisions by the same user not shown)
Line 4: Line 4:
{{#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=8
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
Line 18: 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=8
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
Line 32: 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=8
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
Line 44: Line 44:
|-|
|-|
Brasília=
Brasília=
{| class="wikitable sortable " style="width:100%"
!Date
!Name
!Game
!Platform
!Region
!Info
|-
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','America/Sao_Paulo'), "'''%b %d %l%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
|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()
|where=TourneyNetplay.Date >= CURDATE()
|order by=TourneyNetplay.Date ASC
|order by=TourneyNetplay.Date ASC
|limit=8
|format=template
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
Line 63: Line 56:
|more results text=
|more results text=
}}
}}
|}
|-|
|-|
Berlin=
Berlin=
{{#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=8
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes
Line 82: 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=8
|limit=16
|format=template
|format=template
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
Line 96: 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=8
|limit=16
|template=TourneyNetplaySmallRow
|template=TourneyNetplaySmallRow
|named args=Yes
|named args=Yes

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"