2023 / 2024 schedule out yet available?

[savagegeek22]

Just curious how ya'll create your schedules easily if there is a way? Guess no one has an updated schedule out yet. Thanks

[rbiddle]

Are you on the discord? I make an excel file each year to generate SQL for the update and just posted it there.

https://discord.gg/mByMgc7n

[savagegeek22]

Ok. Thank you rbiddle.

[savagegeek22]

Hi Robert, For some reason, I can't verify myself on Discord. I've verified my email, but now it wants to bot me, but still can't get to the script for some reason. Any clues ? Thanks so much

…

On 07/26/2023 7:31 PM EDT Robert Biddle ***@***.***> wrote: Are you on the discord? I make an excel file each year to generate SQL for the update and just posted it there.. https://discord.gg/mByMgc7n — Reply to this email directly, view it on GitHub #53 (comment), or unsubscribe https://github.com/notifications/unsubscribe-auth/ANLUW2E5U2Z3J3D23PPVNU3XSGSDXANCNFSM6AAAAAA2ZAHFEA. You are receiving this because you authored the thread.Message ID: ***@***.***>

[parenttechnology]

Can anyone post their 2023 schedule here?. I also tried Discord and verified. Was not able to located the file. A SQL export preferred...

[thewizardoffoss]

fetchSchedule.php.zip

This is a page that I wrote it scrapes the games/times from ESPN. There's a debug flag towards top of the code that just echos the output into the browser if set to true, if set to false it deletes all data from picks/ picksummary / schedule tables and then dumps new schedule into the schedule table.

I've used it for a few years and figured I would share it here as people seem to have this question every year.

** Use at your own risk. I recommend a full DB backup before running something like this. **

[parenttechnology]

Perfect! I will try it out!

[searnhardt]

That worked great. Very much appreciated! From: The Wizard of Foss ***@***.***> Sent: Tuesday, August 1, 2023 3:18 PM To: rothkj1022/phppickem ***@***.***> Cc: Subscribed ***@***.***> Subject: Re: [rothkj1022/phppickem] 2023 / 2024 schedule out yet available? (Issue #53) fetchSchedule.php.zip<https://github.com/rothkj1022/phppickem/files/12233194/fetchSchedule.php.zip> This is a page that I wrote it scrapes the games/times from ESPN. There's a debug flag towards top of the code that just echos the output into the browser if set to true, if set to false it deletes all data from picks/ picksummary / schedule tables and then dumps new schedule into the schedule table. I've used it for a few years and figured I would share it here as people seem to have this question every year. ** Use at your own risk. I recommend a full DB backup before running something like this. ** — Reply to this email directly, view it on GitHub<#53 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AA5CUMMZROHQW4KHSD5O2DTXTFI57ANCNFSM6AAAAAA2ZAHFEA>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.******@***.***>>

[savagegeek22]

Wow thewizardoffoss, THANK YOU!!!
Thank you so much for your effort on this.

[elwerto]

Here's my version of the build schedule with the espn api to run from command line.

Also de SQL for this 2023-2024 season, pay attention to the collate version of your DB, mine is COLLATE utf8_general_ci.

I hope it helps.
buildSchedule2_ElWert0.txt
SQL_nfl_schedule_2023_by_elWert0.txt

[jimmz86]

Here's my version of the build schedule with the espn api to run from command line.

Also de SQL for this 2023-2024 season, pay attention to the collate version of your DB, mine is COLLATE utf8_general_ci.

I hope it helps. buildSchedule2_ElWert0.txt SQL_nfl_schedule_2023_by_elWert0.txt

the gametime is off by 1 hour,

UPDATE nflp_schedule
SET gameTimeEastern = DATE_ADD(gameTimeEastern, INTERVAL 1 HOUR);