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 04-17-2017, 11:33 AM   #1
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,018
Thanks: 321
Thanked 548x in 337 posts
2 MySQL Data Questions

I've fallen down a rabbit hole again. I am a novice with MySQL, but my questions have more to do with specific OOTP data than with SQL itself (I have books and the internet for that). Cross-posting to the General forum too, as I am not sure how much traffic this sub-forum gets, so trying my luck there as well.

1. On the players_career_batting _stats table, there is a field called split_id, and it effectively breaks a player's season into different records. In most cases, the player is on the same team in the same year for these splits. My question is, how do I interpret these splits? What do they mean?

2. Where can I find players' historical salaries? The players_contract table seems to only show the values for their current contracts.

Thanks!
__________________
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
Thank you for this post:
alanbg (04-17-2017)
Old 04-17-2017, 08:40 PM   #2
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,449
Thanks: 165
Thanked 1,155x in 437 posts
Quote:
Originally Posted by cavebutter View Post
1. On the players_career_batting _stats table, there is a field called split_id, and it effectively breaks a player's season into different records. In most cases, the player is on the same team in the same year for these splits. My question is, how do I interpret these splits? What do they mean?
The split_id field defines the scope of the data and is slightly different depending on the table. The batting and pitching tables both use 1 to define regular season stats.

1 - Regular Season Totals
2 - Regular Season Vs LH
3 - Regular Season Vs RH
21 - Postseason

The fielding table uses 0 for regular season stats and doesn't give you any other splits.

Quote:
Originally Posted by cavebutter View Post
2. Where can I find players' historical salaries? The players_contract table seems to only show the values for their current contracts.
You can't. OOTP doesn't export historical salaries.
__________________
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 (04-18-2017)
Old 04-18-2017, 11:49 AM   #3
cavebutter
All Star Starter
 
cavebutter's Avatar
 
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,018
Thanks: 321
Thanked 548x in 337 posts
Thanks!!


Sent from my iPhone using Tapatalk
__________________
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
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 02:01 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