Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > 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-16-2010, 08:03 PM   #1
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
StatsLab11

StatsLab11 Is Now Released!

Download it here
Latest Patch: Patch 2.1.1 (You'll need the full file, too)
Fidel's Install Tutorial: http://www.ootpdevelopments.com/boar...sion-11-a.html
Setting Up the SQL Dump: StatsLab Upload Procedure

Donate to StatsLab - StatsLab is free to use. Donations are not required, but greatly appreciated.

StatsLab is a set of web pages/utilities for use with online leagues, and requires PHP and MySQL on a webserver. The ReadMe includes instructions for a new StatsLab install as well as how to upgrade from StatsLab for OOTPX if you're running that.

Features:
- Last Sim module with adjustable date ranges of player stats, team stats, and graphs. Playoff odds, top performances, and more.
- All-Star, End-of-Season Awards, and Hall of Fame voting modules
- Draft Module
- Development Tracker
- Front office module including trade block, payroll projections, and projected FA reports
- Export Tracker
- Career Metrics module containing player and team pages as well as filterable leaderboards pages
- Widgets that can be used to put stats on your online league's home page
- Quite a bit more...

Improvements and Updates for StatsLab11:
- New Career Graphs page in the Career Metrics section
- Last Sim Graphs page has been overhauled.
- Team Stats page will show head-to-head record when looking at leagues or divisions
- You can now optionally have Playoff Odds calculations that "regress to mean", reducing early season sample size issues
- Direct widget calls provide more flexible widget options for your league home page
- New table view of Hall of Fame inductees
- Player page will underline league leading stats
- More filter options on player leaderboards page
- Some minor enhancements to the draft module (including ability to view amateur stats without feeder leagues enabled)
- StatsLab settings now stored in the DB rather than flat files on your server
- Plenty o' bug fixes

Once again, many thanks to John and the rest of the PEBA for beta testing all things StatsLab!

I'm sure it's possible that some things have been missed, so questions/bug reports/enhancement suggestions and the like are all welcome. The best way to get a response from me is to PM me on these forums, although there's enough StatsLab experience floating around the OOTP community that posting in this thread may get your question answered by a forum member faster than I will get to it.

AFAIK, StatsLab11 is compatible with OOTPX (not OOTP9, though).
StatsLab for OOPX Thread

v2.0.2 Added:
- Fixed memory leak on admin page
- Updated server SQL load file for advanced users
- Fixed OPS display on eos awards voting ballot
- Fixed development tracker
- Fixed calculated sim length
- Fixed sorting on draft warroom page
- Improved performance on auto picks in draft module
- Added position filter to projected free agents page
- Fixed various errors on last sim graphs page
- Fixed issue with Ink Scores/HOF Standards on players leaderboard page
- Fixed issue with voting modules disappearing from nav bar if voting is disabled.

v2.1.1 File Last Updated: 1/22/2011
- New Sim Preview page available in Last Sim module, including the following:
- - Noteworthy upcoming matchups
- - Active team win/loss streaks
- - Active player streaks (pitcher wins, batter hits, etc)
- - Hot/Cold lists
- - Listing of players on DL who are expected back in the next sim
- - Triple crown contenders (after 1/3 of the season is complete)
- - Players with chance to hit .400 (after 1/3 of the season is complete)
- Team stats page in Last Sim module now has game splits section to display inning-by-inning scoring and record when winning, losing, or tied after X innings.
- Team stats page in Last Sim module now has Starter and Reliever splits under pitching stats.
- Player stats page in Last Sim module now has ability to display stats accrued versus a single opponent
- Player stats page will now display strength of opposition for pitchers
- Ground balls, fly balls, and ground ball percentage added to player leaderboards
- The Draft admin page now lets you define draft rounds as supplemental rounds (just a display change, and you'll need to schedule an additional round)
- When the draft timer is on, a floating sidebar will now display the time remaining till the next pick is due, and will scroll with your screen
- The draft war room can now be filtered depending on if a player is on your team's draft list or not.
- New widget that can be used to display the last X and/or next X picks in your draft
- - Format is "widget.php?show=draftList&league_id=100&lastX =3&n extX=5"
- Several draft fixes, notably one where the entire draft would uncontrollably auto draft itself even if told not to.
- Fixed issue with pitcher innings in team history pitching records
- Fixed team stats page to show only regular season games when "Season" option is selected
- Various other miscellaneous enhancements and fixes
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 03-20-2011 at 02:20 PM.
fhomess is offline   Reply With Quote
Old 07-16-2010, 08:29 PM   #2
Corsairs
Hall Of Famer
 
Corsairs's Avatar
 
Join Date: Aug 2007
Posts: 2,359
If you're the commissioner of an online league, you simply must put this amazing tool into play. StatsLab was already the preeminent utility suite for online OOTP leagues. With this new release, fhomess has (literally) turned it up to "11". It's never been easier to conduct a draft through StatsLab; every little touch (like user-customizable auto-refreshing of the Draft Results page) makes running things a breeze. Owners now have a plethora of new information at their fingertips. Old menus like the Projected Free Agents page have had new life breathed into them with little touches like the addition of current-year stats, making it easier to determine whom you'd like to target in the upcoming offseason. There's even fun little additions like tons of new Stats of the Day; you'll lose all kinds of time discovering all kinds of little factoids you never knew about your league.

Running an online league without StatsLab is something I could never dream of at this point. Simply put, it's an invaluable tool. Grab it, enjoy it, reap the praise from your owners. Your league will be a better place for it.
__________________
Founder of the Planetary Extreme Baseball Alliance (PEBA)
Premiere OOTP fictional league where creativity counts and imagination is your only limitation
Check for openings - contact us today!
Corsairs is offline   Reply With Quote
Old 07-16-2010, 09:44 PM   #3
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Will this still work with the special shell side import file you sent me?

Quote:
Originally Posted by fhomess View Post
StatsLab11 Is Now Released!

Download it here

StatsLab is a set of web pages/utilities for use with online leagues, and requires PHP and MySQL on a webserver. The ReadMe includes instructions for a new StatsLab install as well as how to upgrade from StatsLab for OOTPX if you're running that.

Features:
- Last Sim module with adjustable date ranges of player stats, team stats, and graphs. Playoff odds, top performances, and more.
- All-Star, End-of-Season Awards, and Hall of Fame voting modules
- Draft Module
- Development Tracker
- Front office module including trade block, payroll projections, and projected FA reports
- Export Tracker
- Career Metrics module containing player and team pages as well as filterable leaderboards pages
- Widgets that can be used to put stats on your online league's home page
- Quite a bit more...

Improvements and Updates for StatsLab11:
- New Career Graphs page in the Career Metrics section
- Last Sim Graphs page has been overhauled.
- Team Stats page will show head-to-head record when looking at leagues or divisions
- You can now optionally have Playoff Odds calculations that "regress to mean", reducing early season sample size issues
- Direct widget calls provide more flexible widget options for your league home page
- New table view of Hall of Fame inductees
- Player page will underline league leading stats
- More filter options on player leaderboards page
- Some minor enhancements to the draft module (including ability to view amateur stats without feeder leagues enabled)
- StatsLab settings now stored in the DB rather than flat files on your server
- Plenty o' bug fixes

Once again, many thanks to John and the rest of the PEBA for beta testing all things StatsLab!

I'm sure it's possible that some things have been missed, so questions/bug reports/enhancement suggestions and the like are all welcome. The best way to get a response from me is to PM me on these forums, although there's enough StatsLab experience floating around the OOTP community that posting in this thread may get your question answered by a forum member faster than I will get to it.

AFAIK, StatsLab11 is compatible with OOTPX (not OOTP9, though).
StatsLab for OOPX Thread
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 07-16-2010, 11:52 PM   #4
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
Quote:
Originally Posted by dangarion View Post
Will this still work with the special shell side import file you sent me?
It should... If I'm remembering correctly, it's included, albeit undocumented.
__________________
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-21-2010, 11:16 AM   #5
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Everything is working great now.

I think I've found a bug in the stats showing on the Awards voting page. The OPS seems a little low for all the players.

I have a guy that has a .431 OBP and a .597 slugging but his OPS shows up as .431.

His OPS shows correctly on his metrics page though.

It should be 1.027

It appears to just being showing the wOBA as the OPS, because the same number is repeated under wOBA.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 07-21-2010, 11:25 AM   #6
MrWorkrate
All Star Starter
 
MrWorkrate's Avatar
 
Join Date: Mar 2002
Location: Raleigh, NC
Posts: 1,262
Not sure if I did something wrong - my development is showing "no development history" across the board and the status for all the leagues says "out of date", but I had development before I went from StatsLab OOTPX to StatsLab OOTP11.

It just seems like it's not finding the table/info where the development was. I installed in a different directory (as per the document) - could it be getting confused somewhere along the line to a folder location or table in the DB?
__________________
I used to come here a lot. Now, not so much.
MrWorkrate is offline   Reply With Quote
Old 07-21-2010, 01:33 PM   #7
Sabermetric Baseball
Minors (Double A)
 
Join Date: Jul 2009
Location: Baltimore, MD
Posts: 178
I'm trying to use StatsLab for the Inaugural Draft in my online league. Very slow and getting timeouts over 90% of the time. Also, when teams try to make picks, sometimes the page will load but their pick won't get in. I have a very fast web host, and loading the files was almost immediate. Any suggestions?
__________________
The Sabermetric Baseball Sim
http://www.sabermetricbaseballsim.com/
Sabermetric Baseball is offline   Reply With Quote
Old 07-21-2010, 05:51 PM   #8
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
Quote:
Originally Posted by dangarion View Post
It appears to just being showing the wOBA as the OPS, because the same number is repeated under wOBA.
Quote:
Originally Posted by MrWorkrate View Post
Not sure if I did something wrong - my development is showing "no development history" across the board and the status for all the leagues says "out of date", but I had development before I went from StatsLab OOTPX to StatsLab OOTP11.
Both should be fixed now (you'll need to re-run dev). Also, make sure you've checked some ratings to track in the dev admin page.
__________________
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-21-2010, 05:57 PM   #9
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
Quote:
Originally Posted by Sabermetric Baseball View Post
I'm trying to use StatsLab for the Inaugural Draft in my online league. Very slow and getting timeouts over 90% of the time. Also, when teams try to make picks, sometimes the page will load but their pick won't get in. I have a very fast web host, and loading the files was almost immediate. Any suggestions?
PM me a link to your StatsLab install and a working login.
__________________
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-21-2010, 06:44 PM   #10
Sabermetric Baseball
Minors (Double A)
 
Join Date: Jul 2009
Location: Baltimore, MD
Posts: 178
Quote:
Originally Posted by fhomess View Post
PM me a link to your StatsLab install and a working login.
I sent you a PM with the information.

Thanks, this goes well above and beyond expectations!
__________________
The Sabermetric Baseball Sim
http://www.sabermetricbaseballsim.com/
Sabermetric Baseball is offline   Reply With Quote
Old 07-23-2010, 01:48 AM   #11
GMGOD
Minors (Triple A)
 
GMGOD's Avatar
 
Join Date: Oct 2005
Posts: 218
Infractions: 0/1 (1)
Thanks Frank Homes and the guys in PEBA for your talents and efforts in offering this great and fun tool to the OOTP community.

We have enjoyed StatsLab in the SIMBL since being turned onto it by Jamey Carter (snort), the Commish of the BCHBL. It's the ultimate tool for any statsfreak and/or baseball fan.

You rule Frank!

Thanks again.
__________________
The SIMBL "An Online League Specifically FOR the GM and BY the GM."

www.simbaseballleague.com

A Premier Online League Always Seeking Quality Owners- Join The SIMBL!
GMGOD is offline   Reply With Quote
Old 07-23-2010, 11:24 AM   #12
John P. Yuda
Minors (Double A)
 
Join Date: May 2002
Location: Alexandria, VA
Posts: 177
Frank,

For those of us moving directly from OOTP9 to 11, is there a direct upgrade or will I need to upgrade to the statslab for X first?

Thanks
John P. Yuda is offline   Reply With Quote
Old 07-24-2010, 08:33 PM   #13
snnort
Minors (Triple A)
 
snnort's Avatar
 
Join Date: Apr 2004
Posts: 272
Issue with ammy draft

Frank... in the SIMBL we are on April 1st. The draft pool was JUST released (to the day)... We set up the ammy draft in StatsLab and when the first team goes to pick any player this message comes up:

"player not draft eligible"

Then if I try to autopick to see if any player is eligible I get this:

"no players remaining in draft pool"

Have you seen this issue? Know the fix?
snnort is offline   Reply With Quote
Old 07-25-2010, 08:46 AM   #14
Solonor
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Maine
Posts: 4,457
After I upgraded, I'm getting a lot of "mysql_num_rows(): supplied argument is not a valid MySQL result resource" errors when I try to run any metrics that include things like Win Shares, HoF Standards...and just now I got it on the Stat of the Day page.

The Stat of the Day error actually had two lines that said that, but the second one included a message "No seasons completed". It was trying to calculate "Highest Number Of Runs Scored Relative to League (Top 25 Teams, SD is number of standard deviations better than league average)".

All my SQL files loaded without error except for coaches.

Any clues?

EDIT: I just looked at the Records Watch page. It's a mess. On the Seasonal side of the page, it shows the leader correctly, but everyone underneath it has 0 for Current and Projected. Everything on the Career side has the projected total showing up under both Years and Projected.
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams

Last edited by Solonor; 07-25-2010 at 08:50 AM.
Solonor is offline   Reply With Quote
Old 07-26-2010, 06:16 PM   #15
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
Quote:
Originally Posted by John P. Yuda View Post
Frank,

For those of us moving directly from OOTP9 to 11, is there a direct upgrade or will I need to upgrade to the statslab for X first?
If you're using the development tracker, you'll need to upgrade to X first. If not, I think you'll be ok making the jump directly, but I haven't tried it myself and don't remember if there was any other tool that required a conversion.

Quote:
Originally Posted by snnort View Post
Frank... in the SIMBL we are on April 1st. The draft pool was JUST released (to the day)... We set up the ammy draft in StatsLab and when the first team goes to pick any player this message comes up:

"player not draft eligible"

Then if I try to autopick to see if any player is eligible I get this:

"no players remaining in draft pool"

Have you seen this issue? Know the fix?
I've seen this happen when you've turned on the draft timer and the util is trying to auto pick but there aren't any players available in the pool. I thought I had fixed that, and it doesn't sound quite like what you're describing anyway. Shoot me a PM with a link to your install and commish credentials to log in to StatsLab and I'll take a look.

Quote:
Originally Posted by Solonor View Post
After I upgraded, I'm getting a lot of "mysql_num_rows(): supplied argument is not a valid MySQL result resource" errors when I try to run any metrics that include things like Win Shares, HoF Standards...and just now I got it on the Stat of the Day page.

The Stat of the Day error actually had two lines that said that, but the second one included a message "No seasons completed". It was trying to calculate "Highest Number Of Runs Scored Relative to League (Top 25 Teams, SD is number of standard deviations better than league average)".

All my SQL files loaded without error except for coaches.

Any clues?

EDIT: I just looked at the Records Watch page. It's a mess. On the Seasonal side of the page, it shows the leader correctly, but everyone underneath it has 0 for Current and Projected. Everything on the Career side has the projected total showing up under both Years and Projected.
Generally speaking, these errors are the result of not having all the proper SQL tables loaded in your install or of not being able to connect to the database. If you don't see them on the admin page, then it's that you're missing a key table or two. If you also send me a PM with a link to your install and commish credentials to log in to StatsLab I can tell for sure.
__________________
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-26-2010, 07:49 PM   #16
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
Quote:
Originally Posted by Solonor View Post
EDIT: I just looked at the Records Watch page. It's a mess. On the Seasonal side of the page, it shows the leader correctly, but everyone underneath it has 0 for Current and Projected. Everything on the Career side has the projected total showing up under both Years and Projected.
Just a separate note on this bit: In the offseason, the current seasonal total is 0 because no games have been played yet. The career total is the player's career total to date. The projected column on both sides of the page will only be updated during the season. Projections are based on current performance in the current season, then projected out to the remainder of the current season based on the player's playing time and the team's remaining games. So during the offseason, the player's projection is 0 because he hasn't collected any of the indicated stat this year. StatsLab doesn't try to project career totals out beyond the current season due to the many different ways OOTP leagues can be configured (aging factors, primarily).
__________________
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-28-2010, 09:24 AM   #17
snnort
Minors (Triple A)
 
snnort's Avatar
 
Join Date: Apr 2004
Posts: 272
Quote:
Originally Posted by snnort View Post
Frank... in the SIMBL we are on April 1st. The draft pool was JUST released (to the day)... We set up the ammy draft in StatsLab and when the first team goes to pick any player this message comes up:

"player not draft eligible"

Then if I try to autopick to see if any player is eligible I get this:

"no players remaining in draft pool"

Have you seen this issue? Know the fix?
Quote:
Originally Posted by fhomess View Post
I've seen this happen when you've turned on the draft timer and the util is trying to auto pick but there aren't any players available in the pool. I thought I had fixed that, and it doesn't sound quite like what you're describing anyway. Shoot me a PM with a link to your install and commish credentials to log in to StatsLab and I'll take a look.
I found out what the issue was and thought I'd post this up for you.

Apparently the draft pool players are not set up as "draft eligible" by the league on the very first day in which they are created. As soon as you flip the league file one day farther... it is then the OOTP gives them their actual "draft eligible" status.

In our case, as soon as we ran the next sim and uploaded the results to statslab, the players were all draft eligible. I went ahead and created a temporary league to test the theory once more and was able to duplicate the exact situation.

In the end, it's not and issue at all with StatsLab, it's just a very small bug in the OOTP code that is easily remedied by making sure than if you use StatsLab to start your ammy draft 75 days prior to the actual draft in-game (by having the players announced that early)... you MUST make sure that opening day is at least the day after the announcement of the player pool in game. Often this just means making opening day start on or after April 2nd, since the draft pool is usually announce on April 1st.
snnort is offline   Reply With Quote
Old 07-28-2010, 09:43 AM   #18
Solonor
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Maine
Posts: 4,457
Just as an update on my issues, everything is fine now that I've moved it to a host with MySQL 5 and gotten the very latest patch. Thank you for the help!!
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 07-28-2010, 11:49 AM   #19
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
Quote:
Originally Posted by snnort View Post
Apparently the draft pool players are not set up as "draft eligible" by the league on the very first day in which they are created. As soon as you flip the league file one day farther... it is then the OOTP gives them their actual "draft eligible" status.
Ah, interesting. Thanks for reporting back on this! I'll add a note to the ReadMe about 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-30-2010, 02:20 PM   #20
DWK
All Star Reserve
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Somewhere in South Carolina
Posts: 636
Any body else having a problem with the End Of The Season Awards button my just doesn't show up. I do have it check in the enable page.
DWK 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 10:43 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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