phppickem
phppickem copied to clipboard
rothkj1022
2023 schedule?
I do not have one yet. Perhaps we will get lucky and have someone help :-)
I am almost done with a script that will create the sql and all you do is copy and paste and your done.
Greg
On Sat, Aug 6, 2022, 7:27 AM savagegeek22 @.***> wrote:
I do not have one yet. Perhaps we will get lucky and have someone help :-)
— Reply to this email directly, view it on GitHub https://github.com/rothkj1022/phppickem/issues/51#issuecomment-1207206155, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYNAVQ5RMCOOIICL66FN54TVXZK4VANCNFSM5ZYX66AQ . You are receiving this because you authored the thread.Message ID: @.***>
Awesome! That would be great. Here is last years SQL file as well for reference. 2021-schedule-V1-3.sql.txt .
Here is what I have so far. Its a ruby script that does what is expected. With the exception of the week 18 where no times have been set yet and I just made it put the date as 1/1/2024 on those games. I also attached the output of the file so you can see
Let me know what you think.
Greg
You will need to rename the "scrapping_code.txt" to "scrapping_code.rb to get it to run.
If you need help then ping me and just give me the schema and I can run it for you.
load to pickem.txt scrapping_code.txt
If you get it to import correctly can you export the nflp_schedule table as a SQL file? Thanks!
If you get it to import correctly can you export the nflp_schedule table as a SQL file? Thanks!
Change file type to .sql nflp_schedule.txt
Ok all I see I have an issue. My dates are not working as expected. I will get this competed and let you know. Getting close though.
Catching up... I see that week 15 and Week 18 have TBD(To Be determined) would that mess up the time when scripting this? I was going to just fill it in manually and then share it... unless someone comes up with it faster :-) Thanks again for helping with this.
Sorry for all the back and forth here but it appears ESPN has once again changed their code on the backend that I was scrapping to get the schedule built. I know its getting to crunch time so I got the schedule working and exported from my site. You will have to know that there are games in week 15 that times have not been determined and the same for week 18.
Change the file from txt to sql if you want to import. You will have to change the name of your database as well.
Good luck Pickem nflp_schedule.txt
Thanks so much! would love to donate for the efforts on this script you are working on. Thanks again for your time on this.
Well I just wanted to get a schedule out there for people to use now and I can work on finding a free API to generate the SQL when the season starts. Sorry it took so long
Greg
Thanks for the schedule gunchman01. After taking a few years off from it, I decided to restart up my pickem pool website. I came here to see if anybody had a '23 schedule uploaded not knowing that the creator is no longer doing upkeep on this project. Glad to see people still using php pickem, and offering community support. Cheers.
gunchman01
Lifesaver @gunchman01 I had my family & friends all pressuring me to update our little NFL pool, and you made that task quite easy for me and all the other admins. Thank you so much!!
Glad to hear. You will have to update the schedule for Washington games as it does not put them in as WAS.
Greg
On Mon, Aug 29, 2022, 12:07 PM elwerto @.***> wrote:
gunchman01
Lifesaver @gunchman01 https://github.com/gunchman01 I had my family & friends all pressuring me to update our little NFL pool, and you made that task quite easy for me and all the other admins. Thank you so much!!
— Reply to this email directly, view it on GitHub https://github.com/rothkj1022/phppickem/issues/51#issuecomment-1230588032, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYNAVQ2UGM3OD7K7REDEFTTV3TU35ANCNFSM5ZYX66AQ . You are receiving this because you were mentioned.Message ID: @.***>
@gunchman01 It took me a few minutes to figure that one out, but I think I have it fixed. I just changed the team abbreviation in the database to WSH instead of WAS. I also had to edit my helmet icon name to match it. Thanks again!
Awesome, thanks!
On Mon, Aug 29, 2022, 2:30 PM Phaseprism @.***> wrote:
@gunchman01 https://github.com/gunchman01 It took me a few minutes to figure that one out, but I think I have it fixed. I just changed the team abbreviation in the database to WSH instead of WAS. I also had to edit my helmet icon name to match it. Thanks again!
— Reply to this email directly, view it on GitHub https://github.com/rothkj1022/phppickem/issues/51#issuecomment-1230767494, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYNAVQ7NVRHPL7CKYKQGC2LV3UFXHANCNFSM5ZYX66AQ . You are receiving this because you were mentioned.Message ID: @.***>
Glad to hear. You will have to update the schedule for Washington games as it does not put them in as WAS. Greg … On Mon, Aug 29, 2022, 12:07 PM elwerto @.> wrote: gunchman01 Lifesaver @gunchman01 https://github.com/gunchman01 I had my family & friends all pressuring me to update our little NFL pool, and you made that task quite easy for me and all the other admins. Thank you so much!! — Reply to this email directly, view it on GitHub <#51 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYNAVQ2UGM3OD7K7REDEFTTV3TU35ANCNFSM5ZYX66AQ . You are receiving this because you were mentioned.Message ID: @.>
Yeah, I realized that, and made an easy fix. Thanx for the note, though.