NFL 2010 Gameset?

I started on the 2010 gameset (I did last year's), but ran into a bug and have been waiting to see if jvandervort releases an update (he was very responsive last year). I haven't added any games, but I do have the 2010 week data finished. I'll post it here if you want to use it as your starting point.

I'll upload it and do some week and game QA. I'll let you know if I find anything.

Thanks again.

would you be willing to work a little more SQL magic to make a Eastern timezone version?

I'm also in the central timezone, but I used an Eastern timezone last year and changing the global pickem settings to central will throw off last year's data.

I went ahead and truncated all of last years pickem tables...then started from scratch and ran the SQL statement. I'll do the QA tomorrow and post the results.

I just finished the week by week and game by game review...and all looks good. I'll be adding the playoff weeks (with tentative dates based on last year's schedule) and posting the exported gameset.

okay...found a couple minor issues with the gameset:

1. I set the game scores to NULL...after import they were defaulted to 0 / 0 which makes everything appear as ties.
2. I renamed a couple team abbreviations to KC and SD instead of KAN and SAN.
3. I also needed to run the 'update pickem_games set gametime = date_add(gametime, interval 1 hour)' for the week table(not applicable for the central time geameset).
4. small logo location points to a non-existant directory so I emptied the fields out in the database.

I'll post the gameset after I add the playoff info.

Go ahead and post what you've got. I'm not sure we want tentative playoff weeks, but we'll check it out.
There is a risk for an unsuspecting site admin to just add the games and not fix the weeks start date which may have either the incorrect date or incorrect time. This would throw off the pick lockup date/time. Just a FYI I guess.

Relating to the timezone, I'd also like to keep the timezone to eastern so that we match
http://www.nfl.com/schedules
It helps for QC and is mostly official:)

Good to have you guys helping, thanks again.

The main reason is the NFL schedule is in the Eastern time zone and includes daylight saving time (DST).
The schedule doesn't explicitly show it, but games after Nov 7 are an hour later when measured against GMT.
As designed the module handles this by setting itself into a matching timezone which also has DST.

I think this is the best solution, but I'm open to suggestions. I think entering and checking the game times is easier when they all match exactly what the nfl posts on its website.

2010 EDT gameset attached...no playoff data. I reviewed the weeks and games for accuracy and everything checks out...although an extra set of eye's wouldn't hurt.

QC:
- Weeks matched Games first start time.
- Weeks matched NFL schedule.
- All Teams bye weeks matched NFL schedule.
- Various games choosen at random matched NFL schedule.

Fixes:
- Renamed Bucaneers to Buccaneers in team list.
- Added small logo file names to team list.

If no one has anymore corrections in a couple days, I'll add this to the CVS release.

I just uploaded the updated gameset...looks good!

Question:
Where are the small_logo used? I don't see logos used anywhere on my site.

Thanks again for a great module!!!

The location for the small logos is currently only the pick screen.
Picture attached.

Committed to dev.