OOTP Developments Forums - View Single Post

fhomess · 06-22-2009, 03:04 PM

StatsLab SQL Utilities for OOTP9
Download
- Patch #1
- Patch #2

I'd like to introduce you all to a new set of online league utilities created for use with the OOTP SQL database export. 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. Finally after a lot of programming and testing, I think they're ready to be shared with the OOTP community. All the standard features from Getch's utils are there along with some new features.

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
- 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

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

I 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. 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

While there's been a lot of testing, I'm sure there are probably a few bugs that have made it through. If so, the best way to get them addressed is to post here and/or send me a PM on these forums.

What about OOTPX? I'll need to incorporate the new pitching model and a couple of issues with the SQL dump need to get addressed before these utils will work properly.

06-22-2009, 03:04 PM	#1 (permalink)
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 2,284 Thanked 26x in 11 posts	StatsLab SQL Utilities StatsLab SQL Utilities for OOTP9 Download - Patch #1 - Patch #2 I'd like to introduce you all to a new set of online league utilities created for use with the OOTP SQL database export. 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. Finally after a lot of programming and testing, I think they're ready to be shared with the OOTP community. All the standard features from Getch's utils are there along with some new features. 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 - 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 Your league website will need MySQL and PHP, both of which you are likely to have if you've got a league forum. I 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. 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 While there's been a lot of testing, I'm sure there are probably a few bugs that have made it through. If so, the best way to get them addressed is to post here and/or send me a PM on these forums. What about OOTPX? I'll need to incorporate the new pitching model and a couple of issues with the SQL dump need to get addressed before these utils will work properly. __________________ StatsLab - SQL based utilities for Online Leagues - Patch #1 - Patch #2 The Baseball Saga - My fictorical replay dynasty thread (HTML) Last edited by fhomess; 10-01-2009 at 08:41 PM.