search

ensignlee / ssbook

ssbook
5 stars 3 forks source link

Games are grading incorrectly #72

Closed ensignlee closed 13 years ago

ensignlee commented 13 years ago

If you look at teh NBA bets I made involving the Jazz on 116, you'll see that it says that my 2nd Half Spread lost and my 1st half spread won.

However, the OPPOSITE happened.

camerondavison commented 13 years ago

it looks like the 1st half scores are not showing up for this game. are we missing all of them? looks like I need to get the first half scores and the total scores for NBA

camerondavison commented 13 years ago

some of the NBA has it. its possible that game was when we were still having troubles idenning games. i will look into it.

camerondavison commented 13 years ago

looks like 3 games are missing scores.

SELECT * FROM scores WHERE home_score_half IS NULL and league not in (1, 7) and home_score_total is not null

lemme try and backdate.

camerondavison commented 13 years ago

nba double over time not graded correctly. closed by c1d339d6aa5e27db833e63ac7f512005703b1474.

camerondavison commented 13 years ago

this is fixed, and i reran over the dates that we messed up.