Anyone currently working on the 2021 Schedule?

[txrodriguez]

I can do the leg work for the schedule and can send via text file just the games but I'll need someone to create an sql file and write the commands.

[elwerto]

If you help with it, I can make de SQL file, no problem.

Last year I went to nflpickemscript.com forum and contribute somehow; but now the site apears to be under construction.

Does anyone know anything about that other site?

[thewizardoffoss]

I can probably make the SQL file, just have to look at how the last few were done. I scraped the schedule from ESPN pretty easily though so it shouldn’t be difficult. If you could send me your DB Schema or a sample from last year I could get this rolling.

[searnhardt]

nflp_schedule_2021.sql.txt

I believe this file should work assuming that you've made the changes from the thread in 2019 involving team name changes. Also, as of posting, there are 5 games later in the season that haven't had times set so I just put an 8:20 start time. Those will probably need to be edited. Comments and pointing out of mistakes are welcome!

[savagegeek22]

I've been using Kevin's DB and SQL here for a few years now. If there is anything I can do to help here let me know. I have a crazy family that likes to compete and pick all the time, so I figured I'd be the manager. I can test this nflp_schedule_2021.sql.txt file on my setup searnhardt. Thanks ALL for keeping this going. I paid Kevin $50.00 when I first started this for my large family... I'll be donating again.

[stevenmybarra]

nflp_schedule_2021.sql.txt

I believe this file should work assuming that you've made the changes from the thread in 2019 involving team name changes. Also, as of posting, there are 5 games later in the season that haven't had times set so I just put an 8:20 start time. Those will probably need to be edited. Comments and pointing out of mistakes are welcome!

I used your sql statement and it worked, but im getting an "Error getting cutoff date:" when i try to look at Week 18 Results. Do you know what I need to edit to fix?

[savagegeek22]

I seem to get this every year as well when finishing up the season. I'm still trying to figure it out as well. Also, I had to update two teams due to their name change of course, and helmet icons, since that changed as well this year. If I figure it out first, I'll post.

[stevenmybarra]

I seem to get this every year as well when finishing up the season. I'm still trying to figure it out as well. Also, I had to update two teams due to their name change of course, and helmet icons, since that changed as well this year. If I figure it out first, I'll post.

nevermind, I fixed it. there are date errors on week 17 and week 18 of nflp_schedule_2021.sql.txt

Weeks 17 and 18 are in 2022, not 2021.

[stevenmybarra]

nflp_schedule_2021.sql.txt

I believe this file should work assuming that you've made the changes from the thread in 2019 involving team name changes. Also, as of posting, there are 5 games later in the season that haven't had times set so I just put an 8:20 start time. Those will probably need to be edited. Comments and pointing out of mistakes are welcome!

your sql worked fine. schedule imported fine, but weeks 17 and 18, the dates are wrong. supposed to be 2022 not 2021

[elwerto]

nflp_schedule_2021.sql.txt
I believe this file should work assuming that you've made the changes from the thread in 2019 involving team name changes. Also, as of posting, there are 5 games later in the season that haven't had times set so I just put an 8:20 start time. Those will probably need to be edited. Comments and pointing out of mistakes are welcome!

your sql worked fine. schedule imported fine, but weeks 17 and 18, the dates are wrong. supposed to be 2022 not 2021

I fixed the year issue for the weeks 17 & 18.;feel free to use it.

2021-schedule-V1-2.sql.txt

[savagegeek22]

Verified that it works, but in the browser entry_form.php?week=17 and entry_form.php?week=18 the Time of how long the game starts does not show up... I'm assuming because of the year change, but then again I probably did something else wrong LOL

[elwerto]

My Mistake, wrong file, please use this one instead:
2021-schedule-V1-3.sql.txt

[searnhardt]

Sorry about the year problem with weeks 17 and 18. Thanks for catching it, fixing it, and publishing it! From: elwerto ***@***.*** Sent: Thursday, September 2, 2021 4:07 PM To: rothkj1022/phppickem ***@***.***> Cc: SEarnhardt ***@***.***>; Comment ***@***.***> Subject: Re: [rothkj1022/phppickem] Anyone currently working on the 2021 Schedule? (#50) My Mistake, wrong file, please use this one instead: 2021-schedule-V1-3.sql.txt<https://github.com/rothkj1022/phppickem/files/7101492/2021-schedule-V1-3.sql.txt> — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#50 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AA5CUMKPX33ZWOH4GTDFDMDT77KPXANCNFSM5BPJYMLQ>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[BrowncoatSix]

Please note: I'm not the best php coder, and therefore you should backup your data and comb through this for any errors.

I've modified the script to retain years of schedules, results, and to build history.

I currently use this to build the schedule:
the filename is: buildNFLSchedule.php
buildNFLSchedule.txt

good luck