Thursday, March 31, 2011

Delayed Games 3/31 *update

** Update. Fixes Season 3 League  Player Stats. Check out pitchers and hitters stats. Thanks! 

Well if you too are just thrilled the boys of summer have made their return then you might have missed checking your team. Which is Ok for the next day or so. Tonight I did a small update on the Sim to fix player stats not being recorded.

The Problem
Pretty much this stems from my misunderstanding of database management and design of 2 years ago. When I set out creating the Baseballczar db structure I put too much info into the player db. Later I realized I could easily separate out player stats, thus reducing load on the server (I did this prior to season 2).  However much of the work was ad hoc and I missed a key item in the Sim that created new seasonal player stat records.  Some players did not get Season 3 records started or had Season 2 written over because of this problem. I believe this is now fixed as of this sim update.

The Next Problem
Some Season 3 records will not be accurate. It seems that some player records covering half the teams in BBZ are affected. I know my team, The Flying Zoies, has missing Season 3 stats for all my pitchers, though after the update today the pitchers did have new stat records as I expected. Hopefully this will not happen again.

Solution Stats
Friday I will run a fix to update all the Season 3 records for all the players. Player career stats and box scores are separate entities but I can grab the box scores and put together Season 3 for each player. Unfortunately I cannot rebuild Season 2 stats.

Pitchicons
These are the little smiley faces next to each pitcher. Some are were grossly inaccurate. The Sim handles the pitchers based on the last 4 League games. As far as I can tell relievers are being used correctly. I did an update to the app that handles the pitichicon and it should be accurate now.

Keep in mind if a pitcher has low innings, but the Pitchicon "Bad", it is because pitchicons are based on the last 4 games, not total season stats.

Other Notes
I am trying to get some of these smaller buggy items out of the way Friday, like the site displaying week 8 when it is in fact week 2.  If there are any seemingly small problems please shoot me an email or post them here via a comment. I will get to them soon.

Thanks again for playing,

RG

No comments:

Post a Comment