Home | Webstore
Latest News: OOTP 18.8.76 Update Available - OOTP 18 Available - FHM 4 Available - MLB Manager 2017 Available Now

Autumn Sale - Buy OOTP 18 and FHM 4 Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 18 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 07-02-2009, 02:53 PM   #1
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 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
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 05-10-2010 at 04:12 PM.
fhomess is offline   Reply With Quote
5 thanks for this post:
Corsairs (10-16-2009), Goody (05-31-2010), MrWorkrate (08-07-2009), Recte44 (05-17-2010), udbacker58 (01-04-2010)
Old 07-02-2009, 03:19 PM   #2
Alan T
All Star Starter
 
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)
Alan T is offline   Reply With Quote
Old 07-02-2009, 03:50 PM   #3
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 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 Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 07-02-2009, 04:11 PM   #4
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
Quote:
Originally Posted by dangarion View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-02-2009, 04:13 PM   #5
Alan T
All Star Starter
 
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 04:15 PM.
Alan T is offline   Reply With Quote
Old 07-02-2009, 04:16 PM   #6
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
Quote:
Originally Posted by Alan T View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-02-2009, 05:12 PM   #7
kagnew35
All Star Starter
 
kagnew35's Avatar
 
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
kagnew35 is offline   Reply With Quote
Old 07-02-2009, 05:42 PM   #8
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
Quote:
Originally Posted by kagnew35 View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-02-2009, 07:09 PM   #9
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 8,713
Thanks: 1,066
Thanked 855x in 479 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.
__________________
Support the one-and-done DH
(I think it's better than both the AL and NL games)
or more flexible substitution rules.
kq76 is offline   Reply With Quote
Old 07-02-2009, 07:32 PM   #10
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 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 Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 07-02-2009, 07:40 PM   #11
Alan T
All Star Starter
 
Join Date: Mar 2002
Location: Mass.
Posts: 1,963
Thanks: 15
Thanked 136x in 94 posts
Quote:
Originally Posted by dangarion View Post
So I got the SQL in now. I'm assuming the default passwords for all the users at the beginning is baseball?
Yep!
__________________
- Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week)
Alan T is offline   Reply With Quote
Old 07-02-2009, 09:57 PM   #12
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 09:58 PM.
bd3 is offline   Reply With Quote
Old 07-02-2009, 10:32 PM   #13
Alan T
All Star Starter
 
Join Date: Mar 2002
Location: Mass.
Posts: 1,963
Thanks: 15
Thanked 136x in 94 posts
Quote:
Originally Posted by bd3 View Post
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
__________________
- Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week)
Alan T is offline   Reply With Quote
Old 07-03-2009, 02:58 AM   #14
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
Quote:
Originally Posted by Alan T View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-03-2009, 12:51 PM   #15
bd3
Minors (Single A)
 
Join Date: Feb 2003
Posts: 51
Thanks: 0
Thanked 3x in 3 posts
Quote:
Originally Posted by Alan T View Post
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
__________________
CDL - Oakland A's
UBL - Florida Marlins
bd3 is offline   Reply With Quote
Old 07-03-2009, 01:36 PM   #16
Alan T
All Star Starter
 
Join Date: Mar 2002
Location: Mass.
Posts: 1,963
Thanks: 15
Thanked 136x in 94 posts
Quote:
Originally Posted by fhomess View Post
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 View Post
getting a blank page when I click on the link.
Thanks

Hmm. weird. What browser are you using?
__________________
- Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week)
Alan T is offline   Reply With Quote
Old 07-03-2009, 01:51 PM   #17
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
Quote:
Originally Posted by Alan T View Post
Hmm. weird. What browser are you using?
That was fixed in a later build. It wouldn't show unless you were logged in.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-03-2009, 03:25 PM   #18
bd3
Minors (Single A)
 
Join Date: Feb 2003
Posts: 51
Thanks: 0
Thanked 3x in 3 posts
Quote:
Originally Posted by Alan T View Post
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.
__________________
CDL - Oakland A's
UBL - Florida Marlins
bd3 is offline   Reply With Quote
Old 07-03-2009, 03:32 PM   #19
endgame
Hall Of Famer
 
endgame's Avatar
 
Join Date: Aug 2002
Posts: 15,620
Thanks: 3,655
Thanked 3,499x in 1,886 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
_____________________________________________
endgame is offline   Reply With Quote
Old 07-03-2009, 03:54 PM   #20
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 10,806
Thanks: 2,086
Thanked 2,683x in 1,536 posts
Inquiring minds want to know. Mine, too!
pstrickert is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:23 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright © 2015 Out of the Park Developments