StatsLab SQL Utilities for OOTPX

fhomess · 07-02-2009, 01:53 PM

StatsLab SQL Utilities for OOTPX Online Leagues
Full Download for OOTPX (up to 1.3.2)
- Base download for OOTPX
- Patch #1
- Patch #2.3
- Patch #3.2
Fidel's install video: http://www.ootpdevelopments.com/boar...-statslab.html

A couple of weeks ago I released these utilities for OOTP9 with the promise that I'd release them for OOTPX after a bit more work, so here they are. Inspired by Getch's online league utilities and a new job in which I had to do a lot with MySQL and PHP, I decided to write these several months ago, and with any project I take on, it grew a bit larger than originally anticipated. All the standard features from Getch's utils are there along with some new features.

The OOTPX version of these utilities adds individual pitch ratings to the ratings reports and development tracker. If you've been using the OOTP9 version of the development tracker, there is a document included to walk you through the conversion process and ensure that your development tracker adds the new pitch ratings cleanly.

Feature List:
- Export Tracker
- All-Star Voting
- End-of-Season Awards Voting including Batter of the Year, Pitcher of the Year, Rookie of the Year, and Gold Gloves
- Development Tracker (with individual pitch ratings)
- Draft Utility including team draft lists, draft scheduler/timer, auto-drafting
- Organizational Ratings Report
- Last Sim Utility including Spring Training Standings, Box Scores, Stats, Top Performances, Playoff Odds
- Career Metrics Utility including Win Shares, OPS+, ERA+, Black Ink, Gray Ink, HOF Standards, Similarity Scores, Leaderboards (career, seasonal, and progressive)
- Support for multiple league universes (via duplicate installs pointing to same DB)
- Comprehensive ReadMe file included with installation instructions
- Conversion process included for leagues using the OOTP9 version of these utils.

Your league website will need MySQL and PHP, both of which you are likely to have if you've got a league forum.

Thanks go out to FOOL-X, who's commish Alan T has been helping test the OOTPX version of these utils.

I also need to send out some props to the two online leagues who've already been using these utilities for the past month or so as beta testers of the OOTP9 version. The PEBA and FBL have gone through a bunch of growing pains with the utils and have been very patient during the process. Commishes John and Jason have also proposed some excellent enhancements that are now part of the utilities for your enjoyment. It's become incredibly clear to me that both John and Jason are incredibly dedicated to their leagues and you'd be hard pressed to find a better commish, so if you're looking for an online league, check them out for openings.

Here's a link to their leagues and utilities installs:
PEBA: 2 major leagues in the PEBA universe: Planetary Extreme Baseball Alliance, League of the Rising Sun - Commish: Corsairs
FBL: Federal Baseball League - Commish: jdettbarn

Alan T · 07-02-2009, 02:19 PM

Great tools, I love these. Thanks for all of the hard work on them!

dangarion · 07-02-2009, 02:50 PM

I'm getting this online for RWBL (hopefully). But I'm running across slight issue after doing the install. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/....../html_functions.php on line 47 (the ...... was placed by me since that's server info.)

fhomess · 07-02-2009, 03:11 PM

Quote:

Originally Posted by dangarion

I'm getting this online for RWBL (hopefully). But I'm running across slight issue after doing the install. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/....../html_functions.php on line 47 (the ...... was placed by me since that's server info.)

That'll be fixed when you load your SQL data. I've adjusted the html_functions.php to handle that error.

Alan T · 07-02-2009, 03:13 PM

Edit: nevermind. Do what fhomess suggests. My work around that I did for that probably isn't helpful and defeats the purpose of him improving his app anyways

fhomess · 07-02-2009, 03:16 PM

Quote:

Originally Posted by Alan T

Edit: nevermind. Do what fhomess suggests. My work around that I did for that probably isn't helpful and defeats the purpose of him improving his app anyways

You need to manually go to the admin.php page after the install.php page and you can load them there. It's in the updated ReadMe since you installed it.

kagnew35 · 07-02-2009, 04:12 PM

OK, am dummy, where do I install this? Unzipped to desktop and see no readme

fhomess · 07-02-2009, 04:42 PM

Quote:

Originally Posted by kagnew35

OK, am dummy, where do I install this? Unzipped to desktop and see no readme

The readme is a pdf file called "SQL Utilities Read Me.pdf". It should be in whatever location you unzipped the files to.

The files themselves are to be installed on you league's website.

kq76 · 07-02-2009, 06:09 PM

I haven't used it yet as we haven't yet switched, but thank you very much fhomess! Utilities like these bring a lot to a league, a lot of which I wouldn't want to go without.

dangarion · 07-02-2009, 06:32 PM

So I got the SQL in now. I'm assuming the default passwords for all the users at the beginning is baseball?

Alan T · 07-02-2009, 06:40 PM

Quote:

Originally Posted by dangarion

So I got the SQL in now. I'm assuming the default passwords for all the users at the beginning is baseball?

Yep!

bd3 · 07-02-2009, 08:57 PM

anybody have a link to a OOTP X league using this utility. Would like to see it in action.

Alan T · 07-02-2009, 09:32 PM

Quote:

Originally Posted by bd3

anybody have a link to a OOTP X league using this utility. Would like to see it in action.

This is the one that we are using for FOOL-X

FOOL-X STATSLAB

fhomess · 07-03-2009, 01:58 AM

Quote:

Originally Posted by Alan T

This is the one that we are using for FOOL-X

FOOL-X STATSLAB

Alan, you'll want to download the latest version from this thread. The names display issue is addressed in it.

bd3 · 07-03-2009, 11:51 AM

Quote:

Originally Posted by Alan T

This is the one that we are using for FOOL-X

FOOL-X STATSLAB

getting a blank page when I click on the link.
Thanks

Alan T · 07-03-2009, 12:36 PM

Quote:

Originally Posted by fhomess

Alan, you'll want to download the latest version from this thread. The names display issue is addressed in it.

Just did so. Looks good.

Quote:

Originally Posted by bd3

getting a blank page when I click on the link.
Thanks

Hmm. weird. What browser are you using?

fhomess · 07-03-2009, 12:51 PM

Quote:

Originally Posted by Alan T

Hmm. weird. What browser are you using?

That was fixed in a later build. It wouldn't show unless you were logged in.

bd3 · 07-03-2009, 02:25 PM

Quote:

Originally Posted by Alan T

Just did so. Looks good.

Hmm. weird. What browser are you using?

tried in both firefox and ie

worked this time though.

Have to say this looks really nice.

endgame · 07-03-2009, 02:32 PM

Curious. In the past, a solo player could setup his league as if it were an online league and direct his league upload path (am I using that term correctly) to his own local hard drive, much like was possible in 6.5<

Is this routine possible with this version in order to make use of these utilities?

pstrickert · 07-03-2009, 02:54 PM

Inquiring minds want to know. Mine, too!

07-02-2009, 01:53 PM	#1 (permalink)
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 2,749 Thanks: 15 Thanked 275x in 125 posts	StatsLab SQL Utilities for OOTPX StatsLab SQL Utilities for OOTPX Online Leagues Full Download for OOTPX (up to 1.3.2) - Base download for OOTPX - Patch #1 - Patch #2.3 - Patch #3.2 Fidel's install video: http://www.ootpdevelopments.com/boar...-statslab.html A couple of weeks ago I released these utilities for OOTP9 with the promise that I'd release them for OOTPX after a bit more work, so here they are. Inspired by Getch's online league utilities and a new job in which I had to do a lot with MySQL and PHP, I decided to write these several months ago, and with any project I take on, it grew a bit larger than originally anticipated. All the standard features from Getch's utils are there along with some new features. The OOTPX version of these utilities adds individual pitch ratings to the ratings reports and development tracker. If you've been using the OOTP9 version of the development tracker, there is a document included to walk you through the conversion process and ensure that your development tracker adds the new pitch ratings cleanly. Feature List: - Export Tracker - All-Star Voting - End-of-Season Awards Voting including Batter of the Year, Pitcher of the Year, Rookie of the Year, and Gold Gloves - Development Tracker (with individual pitch ratings) - Draft Utility including team draft lists, draft scheduler/timer, auto-drafting - Organizational Ratings Report - Last Sim Utility including Spring Training Standings, Box Scores, Stats, Top Performances, Playoff Odds - Career Metrics Utility including Win Shares, OPS+, ERA+, Black Ink, Gray Ink, HOF Standards, Similarity Scores, Leaderboards (career, seasonal, and progressive) - Support for multiple league universes (via duplicate installs pointing to same DB) - Comprehensive ReadMe file included with installation instructions - Conversion process included for leagues using the OOTP9 version of these utils. Your league website will need MySQL and PHP, both of which you are likely to have if you've got a league forum. Thanks go out to FOOL-X, who's commish Alan T has been helping test the OOTPX version of these utils. I also need to send out some props to the two online leagues who've already been using these utilities for the past month or so as beta testers of the OOTP9 version. The PEBA and FBL have gone through a bunch of growing pains with the utils and have been very patient during the process. Commishes John and Jason have also proposed some excellent enhancements that are now part of the utilities for your enjoyment. It's become incredibly clear to me that both John and Jason are incredibly dedicated to their leagues and you'd be hard pressed to find a better commish, so if you're looking for an online league, check them out for openings. Here's a link to their leagues and utilities installs: PEBA: 2 major leagues in the PEBA universe: Planetary Extreme Baseball Alliance, League of the Rising Sun - Commish: Corsairs FBL: Federal Baseball League - Commish: jdettbarn __________________ 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 Last edited by fhomess; 05-10-2010 at 03:12 PM.

07-02-2009, 02:19 PM	#2 (permalink)
Alan T Moderator Join Date: Mar 2002 Location: Mass. Posts: 1,963 Thanks: 15 Thanked 136x in 94 posts	Great tools, I love these. Thanks for all of the hard work on them! __________________ - Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week)

07-02-2009, 02:50 PM	#3 (permalink)
dangarion All Star Reserve Join Date: Feb 2003 Location: Orange, CA Posts: 509 Thanks: 8 Thanked 3x in 3 posts	I'm getting this online for RWBL (hopefully). But I'm running across slight issue after doing the install. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/....../html_functions.php on line 47 (the ...... was placed by me since that's server info.) __________________ DanGarion GM - Los Angeles Angels of Anaheim The Peanuts and Cracker Jack Baseball League PCJBL!

07-02-2009, 03:13 PM	#5 (permalink)
Alan T Moderator Join Date: Mar 2002 Location: Mass. Posts: 1,963 Thanks: 15 Thanked 136x in 94 posts	Edit: nevermind. Do what fhomess suggests. My work around that I did for that probably isn't helpful and defeats the purpose of him improving his app anyways __________________ - Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week) Last edited by Alan T; 07-02-2009 at 03:15 PM.

07-02-2009, 04:12 PM	#7 (permalink)
kagnew35 All Star Starter Join Date: Dec 2005 Location: Las Vegas, Nev Posts: 1,967 Thanks: 184 Thanked 58x in 14 posts	OK, am dummy, where do I install this? Unzipped to desktop and see no readme __________________ Elder Statesman of the Board http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room

07-02-2009, 06:09 PM	#9 (permalink)
kq76 Global Moderator Join Date: Nov 2002 Location: Vancouver Posts: 7,623 Thanks: 281 Thanked 332x in 190 posts	I haven't used it yet as we haven't yet switched, but thank you very much fhomess! Utilities like these bring a lot to a league, a lot of which I wouldn't want to go without. __________________ Useful Links: Manuals \| Downloads \| Newsletters \| Knowledge Base \| New Tech Support \| Updated Forum Rules Interactive Online League Directory - find or advertise a league today! Canadian Baseball League - uses OOTP11, running steadily since April 2002

07-02-2009, 06:32 PM	#10 (permalink)
dangarion All Star Reserve Join Date: Feb 2003 Location: Orange, CA Posts: 509 Thanks: 8 Thanked 3x in 3 posts	So I got the SQL in now. I'm assuming the default passwords for all the users at the beginning is baseball? __________________ DanGarion GM - Los Angeles Angels of Anaheim The Peanuts and Cracker Jack Baseball League PCJBL!

07-02-2009, 08:57 PM	#12 (permalink)
bd3 Minors (Single A) Join Date: Feb 2003 Posts: 51 Thanks: 0 Thanked 3x in 3 posts	anybody have a link to a OOTP X league using this utility. Would like to see it in action. __________________ CDL - Oakland A's UBL - Florida Marlins Last edited by bd3; 07-02-2009 at 08:58 PM.

07-03-2009, 02:32 PM	#19 (permalink)
endgame Hall Of Famer Join Date: Aug 2002 Posts: 10,771 Thanks: 894 Thanked 756x in 429 posts	Curious. In the past, a solo player could setup his league as if it were an online league and direct his league upload path (am I using that term correctly) to his own local hard drive, much like was possible in 6.5< Is this routine possible with this version in order to make use of these utilities? __________________ "Try again. Fail again. Fail better." -- Samuel Beckett _____________________________________________

07-03-2009, 02:54 PM	#20 (permalink)
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 5,889 Thanks: 331 Thanked 385x in 223 posts	Inquiring minds want to know. Mine, too!

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