search

rothkj1022 / phppickem

PHP Pick 'Em is a free php web application that allows you to host a weekly NFL pick 'em football pool on your website.
MIT License
29 stars 57 forks source link

2023 schedule? #51

Open gunchman01 opened 2 years ago

gunchman01 commented 2 years ago

Anyone got the 2023 schedule?

savagegeek22 commented 2 years ago

I do not have one yet. Perhaps we will get lucky and have someone help :-)

gunchman01 commented 2 years ago

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: @.***>

savagegeek22 commented 2 years ago

Oh, sweet! Thank you so very much for doing this.

parenttechnology commented 2 years ago

Awesome! That would be great. Here is last years SQL file as well for reference. 2021-schedule-V1-3.sql.txt .

gunchman01 commented 2 years ago

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

savagegeek22 commented 2 years ago

Thank you! Will give it a shot and report back.

parenttechnology commented 2 years ago

If you get it to import correctly can you export the nflp_schedule table as a SQL file? Thanks!

gunchman01 commented 2 years ago

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

gunchman01 commented 2 years ago

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.

savagegeek22 commented 2 years ago

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.

gunchman01 commented 2 years ago

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

savagegeek22 commented 2 years ago

Thanks so much! would love to donate for the efforts on this script you are working on. Thanks again for your time on this.

gunchman01 commented 2 years ago

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

Phaseprism commented 2 years ago

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.

elwerto commented 2 years ago

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!!

gunchman01 commented 2 years ago

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: @.***>

Phaseprism commented 2 years ago

@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!

gunchman01 commented 2 years ago

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: @.***>

elwerto commented 2 years ago

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.