search

ensignlee / ssbook

ssbook
5 stars 3 forks source link

Remove games with no scores after 3 days #149

Closed ensignlee closed 13 years ago

ensignlee commented 13 years ago

This will include situations where A) a game gets postponed B) a pitching change happens

For these games, we should remove all bets associated with those games (and ideally the games themselves) from the system.

Right now, the game just stays ungraded forever, which isn't a terrible solution, but it'd be nice to clean this up

Ideally, this would happen 3 days after a game goes by with no score.

camerondavison commented 13 years ago

Removing a game marks any bets for that game as canceled.

Remove games that are dupes, same teams same hour different pitchers ASAP

camerondavison commented 13 years ago

FYI on this one.

SELECT * FROM user_bets ub JOIN scores s ON ( ub.scoreid = s.id ) WHERE active =0 AND parlayid IS NULL

is showing about 60 bets that were cancelled. You may get some questions.