Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

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

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

Reply
 
Thread Tools
Old 09-21-2017, 12:17 PM   #1
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,018
Thanks: 320
Thanked 548x in 337 posts
OOTP MySQL Reference

For anyone interested in rolling their own MySQL database to play around with OOTP or advanced stats in general, I am working on a project that documents my efforts to do just that. In the process, I'll be writing about various elements of OOTP tables and the nuts and bolts of sabrmetrics.

This project is really for my own benefit as an aid to better understanding MySQL and advanced statistics, but figured I would link to it here in case there are any other nerds interested in the same. I don't pretend to be an expert - and this will likely be more a catalog of my mistakes as I stumble towards understanding than a definitive guide. Well, can't sell it any better than that.

MySQL, MyStruggle
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery

Last edited by cavebutter; 09-21-2017 at 12:21 PM.
cavebutter is offline   Reply With Quote
Old 09-21-2017, 04:16 PM   #2
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,449
Thanks: 165
Thanked 1,155x in 437 posts
Fun project. Don't make the mistake of thinking the OOTP data dump is a well thought out database. There's a lot of good information in it, but you're going to pull your hair out trying to make sense of it where no sense is to be made. You can often assume that if something doesn't make sense, like a game_id column in players_career stats, then it's just not reporting anything useful.

I took a quick glance through your blog and have the following couple of notes:
  • You say you're going to use the parks table to adjust your statistics using the park factors from that table. You will get bad results doing this. Those are in-game configuration settings, not calculated park factors based on actual results. They don't change from year to year. If you want to know how to adjust the stats, you have to calculate park factors based on home/road splits and save that off somewhere.
  • Players_career_fielding_stats:
    • rto = Runners Thrown Out (for catchers)
    • ipf = innings played fraction. Innings played = (3*IP + IPF)/3. The pitching stats table has this, too, but for whatever reason also includes an outs column that does the 3*IP+IPF calculation for you.
    • Detailed UZR data isn't anywhere in the data dump
__________________
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
Thank you for this post:
cavebutter (09-21-2017)
Old 09-21-2017, 04:37 PM   #3
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,018
Thanks: 320
Thanked 548x in 337 posts
Thanks so much for the notes!

Too bad about the park factors. I really thought I had found a shortcut.
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP

Logo Gallery
cavebutter is offline   Reply With Quote
Old 10-25-2017, 06:28 PM   #4
mchris41
Bat Boy
 
Join Date: Jul 2016
Posts: 9
Thanks: 2
Thanked 1x in 1 post
I've been doing something similar, let me know if you want to compare some notes.

My main peeve right now is that there are no lookup tables, example, an at bat will have a result of 9, but nothing to tell you what 9 means. It does this all over the place, I've jotted these down somewhere I need to find them and once I do I'll share.

Last edited by mchris41; 10-25-2017 at 06:34 PM.
mchris41 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 12:56 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 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments