This would be great if I could figure out how to use it. I am using pickem for a weekend (fri, sat, sun) NHL pool, this would be very useful so I did not have to update the scores manually.

CommentFileSizeAuthor
#4 Image 13.99 KBdavipilot
#2 Image 18.22 KBdavipilot
#2 Image 210.99 KBdavipilot
#2 Image 313.74 KBdavipilot

Comments

jvandervort’s picture

Load it, enabled it.
Download the latest pickem from https://github.com/jvandervort/drupal6-pickem2
Run update.php.
Make sure your pickem game set has a sport set to "NHL"

At least that should get you close.
Both of these versions are BETA so I'd test it all first:)

EDIT: Github no longer being used.

davipilot’s picture

StatusFileSize
new13.74 KB
new10.99 KB
new8.22 KB

I set everything up as stated above.

Image 1 shows the game set setup.
Image 2 shows the week setup.
Image 3 shows the game setup.

I loaded the game on the 14th. I went in today to see if the scores would be entered and the actual score was 2-3 Boston.

Am I missing something?

How does the system know to go and grab the scores?

jvandervort’s picture

Check out the sports_scores table. What are the team names?

davipilot’s picture

StatusFileSize
new3.99 KB

Buffalo & Boston

jvandervort’s picture

Make sure the:
1. pickem gameset sport = sport scores sport.
2. pickem gameset teams abbrev = sports scores team names
3. pickem game date = sports scores game date.
4. sports scores game data looks right.

nagapampa’s picture

gid: e402f7ceee9d11638f1ee8a3617c568f sport:NFL final:1 in_progress :0 gametime:FINAL gamedate:2010-12-16 20:20:00 home_team:San Diego visiting_team:San Francisco home_score:7 visiting_score:34

Here is the ESPN feed bottomline sports scores for the game on Thursday. This is the data populated in the drupal 'sports_scores_games' table. The home score and visiting score need to be switched (San Diego won, not SF). You mention in the comment above that (2. pickem gameset teams abbrev = sports scores team names). The feed above gives the full name of the team city, not the abbreviation. Does this mean the ESPN bottomline scores cannot be used? The scores are updating in this table only and not in the pickem module.

jvandervort’s picture

Just updated pickem to update if abbreviations match OR team names match.
Still on github though (d.o to follow.)

@justintime will have to patch sports scores to not reverse the scores.

justintime’s picture

Sorry everyone, I forgot to subscribe to the issue queue when I created the module. I've fixed the bug @jvandervort mentioned, and released beta2 of the module.

fordprefect76’s picture

My pickem leagues are not updating. I can see the data updating in the sports_scores_games table. Where does sports_scores update the pickem_games table. I am looking through your code but I can not find the line that does the update. What am I missing?

jvandervort’s picture

@fordprefect, make sure to start a new thread when you have a question so the originator doesn't get unnecessary email.

Download pickem 6.x-2.3 and make sure that you've done all the steps in #5 above
(except in 6.x-2.3 the team name can match as well as the abbreviation.)
The code that actually does update is in pickem.module (line 1249 in 6.x-2.3).

Marko B’s picture

I Really dont understand what does this mean.

Make sure the:
1. pickem gameset sport = sport scores sport.
2. pickem gameset teams abbrev = sports scores team names
3. pickem game date = sports scores game date.
4. sports scores game data looks right.

any help?

jvandervort’s picture

Status: Active » Fixed

@deepM, those are the steps to integrate sports scores module with the pickem module.
What are you trying to accomplish? And feel free to start a support thread so you get you own email responses.

Marko B’s picture

ok but what is "pickem gameset sport = sport scores sport." etc

file, database table, variable ??

jvandervort’s picture

@deepM,
pickem gameset sport is a setting in the pickem module on a gameset object.
A gameset is a set of games and teams (and consequently has a "sport" ie NFL, NHL, etc...
Sports scores has a setting called "sport" which can have a value like NFL, NHL, etc... which would match the "sport" from the pickem module. If they do match "sports" and they do match "games", the sport scores module can update the scores in the pickem module, alleviating the league commissioner the responsibility of adding the scores him/herself. Which is nice. The NFL scores worked really well this last season until the playoffs.

Marko B’s picture

ok, thanx on clearing.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.