|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
04-17-2017, 10:33 AM | #1 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
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 |
04-17-2017, 07:40 PM | #2 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
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. 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. |
|
04-18-2017, 10:49 AM | #3 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
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 |
Bookmarks |
Thread Tools | |
|
|