SuperCombo Wiki:Community portal: Difference between revisions

From SuperCombo Wiki
No edit summary
No edit summary
Line 32: Line 32:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(TourneyNetplay.Date, "'''%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(TourneyNetplay.Date, "'''%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
Line 53: Line 53:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','US/Central'), "'''%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','US/Central'), "'''%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
Line 74: Line 74:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','US/Pacific'), "'''%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','US/Pacific'), "'''%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
Line 95: Line 95:
{{#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
Line 116: Line 116:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Europe/Berlin'), "'''%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','Europe/Berlin'), "'''%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
Line 137: Line 137:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Europe/London'), "'''%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','Europe/London'), "'''%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
Line 158: Line 158:
{{#cargo_query:
{{#cargo_query:
tables=TourneyNetplay
tables=TourneyNetplay
|fields=DATE_FORMAT(CONVERT_TZ(TourneyNetplay.Date,'US/Eastern','Asia/Tokyo'), "'''%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','Asia/Tokyo'), "'''%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

Revision as of 20:35, 11 April 2021

FGC Discord Portal

Online Tournament Calendar

  • This feature is an experiment and will be re-evaluated at the end of April 2021.
  • To add your event read this page.

Icon legend

Icon signup.png Sign up/bracket link
Icon coin.png Crowdfunding page (Matcherino,Tiltify)
Icon chat.png Chat server (Discord)
Icon stream.png Stream channel
Icon info.png Info link

Upcoming Online Tournaments

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info

Error: Table TourneyNetplay not found.
Date Name Game Platform Region Info