Sim Dynasty

View Old Forum Thread

Old Forum Index » Baseball Beta Testing » Beta News » Internal Change for Boxscores
Admin

Internal Change for Boxscores

February 12, 2010 at 08:24PM View BBCode

As of game 69, I'm inserting data into the database for boxscores slightly differently. In the midst of making this change, I had some mistakes in the previous few games but this should be correct as of game 69.

The change has to do with how the database is updated with team stats like hits and errors. This should result in a slight performance increase.

Tyson
ballplayer3

February 18, 2010 at 06:25PM View BBCode

Were the mistakes related to Innings Pitched? This seems to be short for all teams and pitchers, resulting in extremely high WHIP and ERA.

Mike
Admin

February 18, 2010 at 06:41PM View BBCode

No, that was a different problem:

http://www.simdynasty.com/oldforum-viewthread.jsp?tid=254823

Tyson
tworoosters

February 19, 2010 at 11:23PM View BBCode

I am unable to view boxscore results at this time, I get a recap of the innings and a picture of the scoreboatd. See attached.
tworoosters has attached this image:
boxscoregrab.tiff
Admin

February 20, 2010 at 06:59AM View BBCode

Looks like a problem related to playoffs. I'll take a look.

Tyson
Admin

February 20, 2010 at 05:30PM View BBCode

I'm still not sure where the problem is, been looking at it for a while today. I'm going to pause the playoffs and run them manually after I find the issue.

Tyson
tworoosters

February 21, 2010 at 01:24AM View BBCode

I get this:

select * from boxscoreplaypo where boxscoreplay_playoff_id = 72945 order by boxscoreplay_playnum asc, boxscoreplay_id asc

at the top of the recap now.
Admin

February 21, 2010 at 09:14PM View BBCode

Yeah, I was in the middle of debugging and was printing that out. I'll remove it once I get this figured out, hopefully tomorrow.

Tyson
Admin

February 22, 2010 at 07:53PM View BBCode

This has been fixed and the playoffs have been turned back on.

Tyson

Pages: 1