|
||||
|
|
OOTP 19 - General Discussions Everything about the 2018 version of Out of the Park Baseball - officially licensed by MLB.com and the MLBPA. |
|
Thread Tools |
04-17-2018, 02:25 PM | #1 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
I made a thing! First usable results from my database
I've been working on a project to roll my own MySQL database from OOTP data. While mostly done for the sake of learning a new thing, I also had some clear goals in mind for how to improve my playing experience.
The most challenging part was getting to understand and then calculate all of the advanced stats. From there, things have been getting easier and now I've moved back into my professional wheelhouse: Excel. I've always wanted a better way to manage my organizational depth chart. It's easy to get lost in a sea of numbers and lose context. The below screenshot shows all of the relievers in the fictional Baltimore organization. The charts visualize the stats and ratings for the top 5 players. The players can be sorted based on any of the visible stats as well as a number of hidden ratings. The data in the table updates automatically from a csv that the database outputs. (This is currently a manual export due to weirdness in the server instance - grr!) Anyhow, this is the Bullpen Depth worksheet. I'm open to any suggestions on how to improve, but mostly just showing off.
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery |
04-17-2018, 02:31 PM | #3 |
Major Leagues
Join Date: May 2012
Posts: 400
|
Awesome work!
|
04-17-2018, 02:32 PM | #4 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
This one's the Outfield Depth worksheet. Same concept.
One note about the batting and fielding ratings. I configured the dump to show OSA ratings rather than true ratings. Also, the raw values for ratings (OSA or otherwise) are on a scale of 0-~250. I don't have a feel for how to convert these to my prefered 20-80 scale. If anyone has ideas, I'd love to hear them. For now, I just removed the labels from the axis. I'm still playing around with the design and formatting of the charts, so they're not all consistent at this point. OF Depth:
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery |
04-17-2018, 02:44 PM | #5 |
Hall Of Famer
Join Date: Apr 2015
Posts: 7,167
|
def share that in mods section.
|
04-17-2018, 03:33 PM | #6 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
Again because of a weirdness in my server installation, this one's not connected to a workbook, but...
Have you ever been in this situation? You're negotiating a trade with Dallas and you're close to a deal but you think that they could throw in a young corner outfielder to sweeten the pot. Rather than scrolling through all of the pulldowns in the lower-right corner of the trade screen, you can Find-a-Batter (tm)! This nifty stored procedure will let you choose an upper age limit, a position or group of positions, and a PARENT organization and show you all the relevant details. You can name a position directly (2-9) or choose Infield, Outfield, Middle Infield, Corner Infield, Corner Outfield. If you choose none, then it will show you all batters in that age group and that organization. Don't want to specify an age limit? You don't have to! Want to see all the under-23 third basemen in any organization on the planet? We can do that too! Just NULL the organization and you'll get it!
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery |
04-17-2018, 03:49 PM | #7 |
Hall Of Famer
Join Date: Aug 2003
Posts: 9,502
|
Nice work!
|
04-17-2018, 03:53 PM | #8 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
"That's all well and good," you say. "But I'm stacked with outfielders. What I need is a reliever. Any reliever."
We've got you covered with Find-a-Pitcher (tm)! Enter an age (or no age), a role (Starter, Reliever, Closer, All Relievers or all pitchers), and a Parent organization (or no organization at all) - and you'll get a custom list of pitchers. One is sure to fit your needs!
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery |
04-17-2018, 05:32 PM | #9 |
Hall Of Famer
Join Date: Sep 2012
Posts: 2,467
|
Really cool!
__________________
Not only do I play OOTP but I also write science-fiction: My Website A brief history of the Australia-New Zealand Baseball League (AUNZBL 2019-2119)--A Dynasty Report The National Penterham Four-Bases Association--A Dynasty Report |
04-17-2018, 05:39 PM | #10 |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
|
I have no earthly idea what you're doing here, but I'll echo the "great work!" sentiments. It's fun to create something that helps you enjoy this game even more, isn't it? I've done many different things (nothing as complicated as this though) to tailor the game to do things the way I want them done.
|
04-17-2018, 06:00 PM | #11 | |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
|
Quote:
|
|
04-17-2018, 06:16 PM | #12 |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
Agreed!
__________________
MySQL, MyStruggle - A self-indulgent blog about my attempts to roll my own MySQL Database with OOTP Logo Gallery |
04-17-2018, 06:22 PM | #13 | |
Hall Of Famer
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
|
Quote:
__________________
"This is my opening farewell " - Jackson Browne “They make a desolation and call it peace.” ― Agha Shahid Ali "Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt "I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen "Hello darkness, my old Friend ...." - Paul Simon Before Mays, before DiMaggio, there was Oscar Charleston. "All the lies about Babe Ruth are true." - Waite Hoyt Avatar is the late great Townes Van Zandt. rip. |
|
04-17-2018, 06:27 PM | #14 |
Hall Of Famer
Join Date: Aug 2010
Location: Indiana
Posts: 9,798
|
I am very impressed with the programming. I have done enough Excel in my day to appreciate the skill at work here. Nice job!
|
04-17-2018, 08:42 PM | #15 |
Hall Of Famer
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,486
|
This is really good stuff.
|
04-17-2018, 11:36 PM | #16 |
Hall Of Famer
Join Date: Apr 2015
Posts: 7,167
|
you can do that in sql too. make a query or report etc.. save for re-use. you wouldn't have to export and use excel.
sql is easy stuff.. at least at this level of use.. syntax may be slightly differnet, but same same logic as what you are using in excel. edit: lol it is in the dB, nevermind.. leaving the above to look stupid anyway... what's wrong with mysql intallation? check mysql.ini? a good all-in-one that comes wokrign out of the box is mariadB and i use a free heidi-sql for a front end. setup differnet users for access to different dB, or at least i like to.. keeps 'tree' view clean. Last edited by NoOne; 04-17-2018 at 11:44 PM. |
04-18-2018, 01:18 AM | #17 | |
All Star Starter
Join Date: Dec 2005
Location: Los Angeles
Posts: 1,158
|
Quote:
Yeah, all of the depth chart stuff is in excel using csv output generated by the dB. The find-a-batter and pitcher are stored procedures accessed directly from the dB. If you know anything about MySQL server on Mac, I’d love to trouble-shoot it with someone. By default, Mac doesn’t create a my.cnf for MySQL and I need to create one to be able to write to a file from the server. To complicate matters, the server is running, but can’t be restarted or stopped. Something about a missing pid file. Seriously, if you know anything about this, I’d like to pick your brain. 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 |
|
04-18-2018, 03:36 AM | #18 | |
Major Leagues
Join Date: Feb 2014
Posts: 417
|
Quote:
Wow Great stuff Sent from my iPhone using Tapatalk
__________________
Using Tapatalk |
|
04-18-2018, 03:38 AM | #19 |
Major Leagues
Join Date: Nov 2007
Posts: 361
|
This is where OOTP has made little progress over the years considering it is basically a spreadsheet kinda game.
|
04-18-2018, 05:02 AM | #20 |
Minors (Triple A)
Join Date: Mar 2017
Posts: 202
|
Really cool stuff.
__________________
|
Bookmarks |
|
|