|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
09-21-2017, 11:17 AM | #1 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
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 11:21 AM. |
09-21-2017, 03:16 PM | #2 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
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:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
09-21-2017, 03:37 PM | #3 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
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 |
10-25-2017, 05:28 PM | #4 |
Bat Boy
Join Date: Jul 2016
Posts: 14
|
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 05:34 PM. |
Bookmarks |
Thread Tools | |
|
|