StatsLab Patch #1

fhomess · 08-28-2009, 07:37 PM

StatsLab SQL Utilities for OOTPX Online Leagues
Download StatsLab for OOTPX (release thread)

Download StatsLab Patch 1 for OOTPX

After a fair amount of work, I believe I'm finally ready to release patch number 1 for my StatsLab utils. There's a number of fixes included, as well as some major enhancements that I think begin to realize some of the cool potential of using SQL for this type of a utility. Again, many thanks to John of the PEBA for performing a lot of testing and providing a lot of suggestions. There have been many suggestions from others as well. I apologize if your favorite hasn't yet made it in.

There is a patch readme file included. I have not updated the utility's readme, so all the enhancements are in this new readme. If you've been running the development tracker, you will need to run a conversion, which is described in the readme.

If you've never installed StatsLab, you can install the base StatsLab and then the Patch over it with no conversion necessary.

Enhancement List:
- OOTPX Ratings now calculated correctly (exception is stuff affected by pitcher role)
- New playoff pages in Last Sim section
- New team stats pages in Last Sim section
- Player game logs available from Stats page in Last Sim section
- New graphing functionality available in Last Sim section
- Stats page in Last Sim can now toggle between the Last Sim and entire season
- New history pages for All-Star voting, End-of-Season Awards voting, and the amateur draft.
- New Team Leaderboards page in Career Metrics
- New ratings search page to help narrow down those trade targets
- Ability to split outfielders into their respective positions in All-Star and Awards voting
- Several other minor enhancements and fixes

As with all amateur development, there's probably some bugs that have slipped through the cracks. Feel free to send me any questions via PM or post them here in this forum. I tend to respond to PM's a bit faster, though.

Alan T · 08-28-2009, 10:05 PM

Pretty neat stuff. Thanks!

Upgraded to the new patch. I'm enjoying the graphs alot!

indiansfan · 08-28-2009, 11:23 PM

I'm totally new to statslab. I've read the readme file but still have no clue how to get this to work? Any step by step help?

fhomess · 08-29-2009, 01:41 AM

Quote:

Originally Posted by indiansfan

I'm totally new to statslab. I've read the readme file but still have no clue how to get this to work? Any step by step help?

The original util readme has the instructions on installation. If there's a particular step that you're having trouble with, such as setting up the SQL database or uploading the files to your website, feel free to shoot me a PM with specifics.

fhomess · 09-01-2009, 12:42 PM

There was a minor issue found with how the development tracker handles Ground Ball Percentage. If you've installed this patch, you'll need to reinstall and re-run the conversion to get it fixed. The link in the first post of this thread contains the fixed version.

Jaxxvain · 02-27-2010, 11:49 PM

I don't claim to be a web guru, but...

I am getting stuck on this step...

5. Point your browser to ootpsql/Conversion_1.php.

Can anyone be more specific, is there a link for this? A full path to type into my address bar?

Thanks in advance.

Cooleyvol · 02-28-2010, 12:29 AM

where did you upload that particular file to on your server? That'll be the url to input.

08-28-2009, 07:37 PM	#1 (permalink)
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 2,723 Thanks: 13 Thanked 255x in 119 posts	StatsLab Patch #1 StatsLab SQL Utilities for OOTPX Online Leagues Download StatsLab for OOTPX (release thread) Download StatsLab Patch 1 for OOTPX After a fair amount of work, I believe I'm finally ready to release patch number 1 for my StatsLab utils. There's a number of fixes included, as well as some major enhancements that I think begin to realize some of the cool potential of using SQL for this type of a utility. Again, many thanks to John of the PEBA for performing a lot of testing and providing a lot of suggestions. There have been many suggestions from others as well. I apologize if your favorite hasn't yet made it in. There is a patch readme file included. I have not updated the utility's readme, so all the enhancements are in this new readme. If you've been running the development tracker, you will need to run a conversion, which is described in the readme. If you've never installed StatsLab, you can install the base StatsLab and then the Patch over it with no conversion necessary. Enhancement List: - OOTPX Ratings now calculated correctly (exception is stuff affected by pitcher role) - New playoff pages in Last Sim section - New team stats pages in Last Sim section - Player game logs available from Stats page in Last Sim section - New graphing functionality available in Last Sim section - Stats page in Last Sim can now toggle between the Last Sim and entire season - New history pages for All-Star voting, End-of-Season Awards voting, and the amateur draft. - New Team Leaderboards page in Career Metrics - New ratings search page to help narrow down those trade targets - Ability to split outfielders into their respective positions in All-Star and Awards voting - Several other minor enhancements and fixes As with all amateur development, there's probably some bugs that have slipped through the cracks. Feel free to send me any questions via PM or post them here in this forum. I tend to respond to PM's a bit faster, though. __________________ StatsLab11 - PHP/MySQL based utilities for Online Leagues Other Mods: 19th Century: Schedules, FaceGen BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds PEBA - Connecticut Nutmeggers

08-28-2009, 10:05 PM	#2 (permalink)
Alan T Moderator Join Date: Mar 2002 Location: Mass. Posts: 1,963 Thanks: 15 Thanked 136x in 94 posts	Pretty neat stuff. Thanks! Upgraded to the new patch. I'm enjoying the graphs alot! __________________ - Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week)

09-01-2009, 12:42 PM	#5 (permalink)
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 2,723 Thanks: 13 Thanked 255x in 119 posts	There was a minor issue found with how the development tracker handles Ground Ball Percentage. If you've installed this patch, you'll need to reinstall and re-run the conversion to get it fixed. The link in the first post of this thread contains the fixed version. __________________ StatsLab11 - PHP/MySQL based utilities for Online Leagues Other Mods: 19th Century: Schedules, FaceGen BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds PEBA - Connecticut Nutmeggers

02-27-2010, 11:49 PM	#6 (permalink)
Jaxxvain All Star Reserve Join Date: May 2006 Posts: 509 Thanks: 54 Thanked 50x in 37 posts	I don't claim to be a web guru, but... I am getting stuck on this step... 5. Point your browser to ootpsql/Conversion_1.php. Can anyone be more specific, is there a link for this? A full path to type into my address bar? Thanks in advance. __________________ Jaxxvain aka Molson ~~~~~~~~ BBS - West Reading Eagles DDB - Twin Falls Captains ECBL - Charleston Strays HBA - Lincoln Legends MLIB III - Los Angeles Lazers WBH - Toluca Toucans WWBL- Oregon Pioneers

02-28-2010, 12:29 AM	#7 (permalink)
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Woodland Mills, TN Posts: 5,794 Thanks: 51 Thanked 456x in 272 posts	where did you upload that particular file to on your server? That'll be the url to input. __________________

08-28-2009, 11:23 PM	#3 (permalink)
indiansfan Minors (Rookie Ball) Join Date: Jul 2009 Posts: 20 Thanks: 0 Thanked 0x in 0 posts	I'm totally new to statslab. I've read the readme file but still have no clue how to get this to work? Any step by step help?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode