Attached: Basic script to insert 2019 schedule #42
Comments
|
Forgot to put in the directions in the file: You need to download schedules.json from https://feeds.nfl.com/feeds-rs/schedules.json and place it next to sched.php. |
|
Script worked great, attached is the sql dump. When importing you might need to modify the teamID to match whats in the nflp_teams table LA = Los Angeles Rams (STL) |
|
I'm working on a spanish version of the hole script, let me know if anyone finds it useful. |
|
For LA Rams, the database's teams table needs to change LAR to LA (or STL to LA if you haven't made the updates previously). Also need to rename the gifs in the images folder. |
|
hello do you have a 2020 script ready or will you be doing one? |
|
2020 Schedule, taken from nfl.com Raiders = LV You will want to update teams logos in images/logos You will need to update team names in nflp_teams table to include teamID, city, team, and displayName |
|
The attached file seems to be missing part of week 17. I've added in the missing 9 games and attached an updated one here. |
|
I see that you mentioned last year's script no longer works can you update
or upload a current script that is working for you and let me know which
file the API key needs to go? Sorry pretty new at this.
…On Tue, Sep 8, 2020, 11:19 PM John ***@***.***> wrote:
Thank you, did your css mess up? Is there outdated code that would mess up
the logged in area of the css?
On Tue, Sep 1, 2020, 11:19 AM Robert Biddle ***@***.***>
wrote:
> The attached file seems to be missing part of week 17. I've added in the
> missing 9 games and attached an updated one here.
>
> nflp_schedule_2020.sql.txt
> <https://github.com/rothkj1022/phppickem/files/5157547/nflp_schedule_2020.sql.txt>
>
> —
> You are receiving this because you commented.
> Reply to this email directly, view it on GitHub
> <#42 (comment)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AN62HK4PJEA64MGFEABW66DSDUNIHANCNFSM4IGJZ6DA>
> .
>
|
|
I’m working on an update to the script, but I’m planning manual updates for the 1st 2 weeks at least since it’ll be hard to reliably test until the season is underway. I’m planning to put the API key in the config file as a variable. |
|
Thank you
…On Wed, Sep 9, 2020, 7:25 AM Robert Biddle ***@***.***> wrote:
I’m working on an update to the script, but I’m planning manual updates
for the 1st 2 weeks at least since it’ll be hard to reliably test until the
season is underway.
I’m planning to put the API key in the config file as a variable.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#42 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AN62HK632PXLP4RHDKPQNHTSE5X2LANCNFSM4IGJZ6DA>
.
|
|
I've forked this project and committed changes. There's A LOT of little changes I had made since this project was abandoned and I picked up a few from DJTJs fork. The auto-score update works, but is VERY ugly at the moment. It does rely on having the 'final' column in the schedule table (this was one of DJTJs big changes early on). Much of the code relies on that modification, so if you don't have that column, you might have quite a few updates to make. I'll continue to work on cleaning up the auto-update functionality a bit more, but with only 1 game for 2020 to test with, it's working, but might break later on. It does, however, show the SQL to be run before committing, so it's fairly safe (you can always just not Execute the update). If you have any questions, log an issue in my fork and I'll monitor there so that I stop hijacking this project's issues log. |
|
Looks like you've done some good work rbiddle. I also have done a lot. Just a few of the things I've done include:
...among other things. Perhaps we could work together to bring this thing up-to-date? |
|
Sure; do you want to work off my fork or do you want to start one of your own with your codebase as a starting point and I can push to you the updates I've made. |
Hey guys, we have a group of people working to. How can I PM y’all to connect more on this outside of github? |
|
I got your email; it's late, but tomorrow I'll hop on the discord. Thanks! |
|
The only problem is that a lot of my code is specific to my site as I didn't plan on releasing any of it. There are no admin controls or config files, it's mostly hard coded. I will have to work on changing all that over. |
Same for me, no worries. It’s just a group for us to collaborate and help one another. If your interested let me know how I could contact you or send me a PM. Rbiddle has joined us. |
|
I'm new to this git stuff but I had a question or a request. I've been using @rbiddle version with the added nfl news. I tried to modernize it with the latest bootstrap, etc., but I ran into problems with the entry form. I ended up backtracking and I'm fine with his version, works great, but if you guys get it up to date with @jstackman , i would love to check it out. |
|
Honestly, it's probably a little too late this year to get anything up and running. I'll slowly stop hard-coding my changes in and release something next summer if no one else does first. |
Comment on his version and we could see what’s up. He has been updating it and I’m pretty sure it’s usable at this point. |
|
@stevenmybarra Are you familiar with git at all and just have questions about GitHub or git in general? I'm super lazy and never learned git beyond the basics. I make heavy use of the git desktop client and it holds my hand enough to make it work. If you have changes you want to push to my repo, you'd clone it to your PC, make the updates, then push it to my repo. It won't apply automatically, I'll have to review and pull it in to add your commit(s). If you want an easy way to merge changes you already made, clone my repo, then paste over the files. It's not the best way, but it usually works well enough. |
I've made a basic script to take the schedules.json from the NFL website and insert it into the schedule table. Doesn't back anything up, doesn't delete the existing schedule, doesn't download the schedules.json. All it does is read the schedules.json and inserts it into the database.
sched.txt
The text was updated successfully, but these errors were encountered: