Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 01-05-2022, 08:45 PM   #1
tm1681
All Star Starter
 
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
Any interest in a bit of a revamped injury database?

So, I was playing a custom game in OOTP a few weeks ago and noticed that some injuries had very similar descriptions. I went into injuries_english.txt and saw that there were numerous repeats, as well as separate injuries that are basically the same thing. This led me to go down a bit of a tweaking rabbit hole. I exported the file to Excel as a comma delimited spreadsheet and got to work.

First, I sorted all of the injuries according to physical injury or illness. Then, I sorted them by "New Body Part" grouping. Then, I sorted them by actual body part. Since I grew up in the home of the Mayo Clinic (Rochester, MN), I decided to go all the way down the rabbit hole and figured that while I was at it I'd look up the common recovery time for the injuries listed in the database, and in the process cross-reference those with MLB/NFL/NBA news items. In the process, I noticed that the min/max injury time of quite a few injuries needed tweaking. Once I got done with that, I thought it troublesome that the "sprain" listings had such variable min/max lengths, separated them into Grade 1 and Grade 2 sprains in accordance with medical terminology, came up with injury times for those, and turned down the likelihood for both from what was usually a 5 so half the players in a game don't end up with various sprains to their joints and ligaments.

Finally, I sorted the injuries for the different body parts by severity just in case I wanted to tweak things further, and just for a bit of current-time flavor I added a 7-10 day "Covid-19" illness that can easily be deleted because it's the last line in the file.

Once I was done, I converted everything back to text, tested it out, and it appears everything works without issue. THE ONLY CAVEAT: if you were to install this over the current "injuries_english.txt" while playing an active game you have to use the "Reset Injuries and IL Status" function if you have that available, or create a character just to use Commissioner Mode and do it. Otherwise current injuries and their descriptors won't match up. I didn't appear to have any issues when using it with a new game.

So, here it is if any of you want to use it or tweak it further. I have absolutely zero knowledge of Korean, so I did nothing with that file.
Attached Files
File Type: txt injuries_english.txt (22.7 KB, 341 views)
tm1681 is offline   Reply With Quote
Old 01-08-2022, 05:12 PM   #2
Kylecolletti50
Minors (Rookie Ball)
 
Kylecolletti50's Avatar
 
Join Date: Apr 2020
Location: New Jersey
Posts: 44
I just added this, I will play with it over the next few days and let you know how it goes. Thanks!
__________________
“You play to win the game” -Herm Edwards
Kylecolletti50 is offline   Reply With Quote
Old 01-08-2022, 05:38 PM   #3
tm1681
All Star Starter
 
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
Quote:
Originally Posted by Kylecolletti50 View Post
I just added this, I will play with it over the next few days and let you know how it goes. Thanks!
Thanks!

One change I've made since uploading this: I've removed the surgery scar tissue line because it's pretty clear that the scar tissue injury isn't connected to any surgery that a player has. It just randomly pops up.

Another one I've gone back and forth on is Post-Concussion Syndrome. I've thought about deleting that line because in my fictional universe does anybody really need to have a TBI? I have benign cyst in my brain from an old head injury, so that's just a bit of a personal thing to me.
tm1681 is offline   Reply With Quote
Old 01-14-2022, 08:00 AM   #4
Kylecolletti50
Minors (Rookie Ball)
 
Kylecolletti50's Avatar
 
Join Date: Apr 2020
Location: New Jersey
Posts: 44
I haven't noticed any issues so far. I do like skimming through the injury lists now and reading some of the differences, it adds to the depth. I like this, good work!
__________________
“You play to win the game” -Herm Edwards
Kylecolletti50 is offline   Reply With Quote
Old 01-15-2022, 12:43 AM   #5
tm1681
All Star Starter
 
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
Quote:
Originally Posted by Kylecolletti50 View Post
I haven't noticed any issues so far. I do like skimming through the injury lists now and reading some of the differences, it adds to the depth. I like this, good work!
Thanks! One cosmetic thing I might do is capitalize the injury diagnoses just so they look more...official?

Another bugbear for me is Post-concussion syndrome. I have a benign brain cyst from an old head injury that can't be operated in, so it's just there, attached to my pineal gland. Because of that, I just kinda don't like the idea of players having long-term traumatic brain injuries in my fictional universe.

That said, it's an entry easy enough to delete on your own if you go into the text file itself.
tm1681 is offline   Reply With Quote
Old 01-15-2022, 12:51 AM   #6
Syd Thrift
Hall Of Famer
 
Syd Thrift's Avatar
 
Join Date: May 2004
Posts: 10,606
You are of course free to play the game however you want; however, the base game is based on a sport that Ray Chapman, Tony Conigliaro, Mickey Cochrane, JR Richard, and Dickie Thon played in (among many others) so, sadly, major head injury needs to be there by default (sorry for what you’ve had to deal with though).
__________________
Quote:
Originally Posted by Markus Heinsohn
You bastard....
The Great American Baseball Thrift Book - Like reading the Sporting News from back in the day, only with fake players. REAL LIFE DRAMA THOUGH maybe not
Syd Thrift is offline   Reply With Quote
Old 01-15-2022, 08:07 PM   #7
tm1681
All Star Starter
 
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
Quote:
Originally Posted by Syd Thrift View Post
You are of course free to play the game however you want; however, the base game is based on a sport that Ray Chapman, Tony Conigliaro, Mickey Cochrane, JR Richard, and Dickie Thon played in (among many others) so, sadly, major head injury needs to be there by default (sorry for what you’ve had to deal with though).
Well of course, so that's why I've kept them all in.
tm1681 is offline   Reply With Quote
Old 04-05-2022, 09:20 PM   #8
cyrusb
Minors (Double A)
 
Join Date: Feb 2021
Posts: 110
I'm not sure if tweaking the "frequency" field in the injuries.txt file will actually have the exact same effect you're implying.

As far as I understand it, for every discrete event the game will check whether or not an injury occurs (for example, every plate appearance the game checks whether the pitcher injures his arm)

If yes, then the game decides how long the injury is going to be (for example, the game decides that the injury to the arm will last 200 days)

Then the game checks the injury.txt file and looks for an injury that is classified as (1) an arm injury (2) that occurs when throwing the ball (3) and can have a duration of 200 days

Let's say there are a few options like "torn rotator cuff", "elbow inflammation," and "elbow ligament tear"

then there are settings relevant to each of those potential injuries

Frequency (1 = rare 5 = common)
Chance of re-injury (0 = none 1 = sometimes. 2 = often)
Nagging (0=no or 1=yes)
Requires surgery (0 = no. 1 = sometimes. 2 = yes)
Influence on throwing (0 .. 3)

So changing the frequency or the duration of a specific injury will not change the fact that the game will still be looking for an injury type that fulfills what it has already decided will happen

I really appreciate the effort you put into this text file, and I'm interested in using it. But I'm wondering if you have created it with the same understanding of how the game works? Or please correct me if I'm wrong about any of this.

Thanks!
cyrusb is offline   Reply With Quote
Old 05-08-2022, 05:17 PM   #9
HoustonGM
Major Leagues
 
Join Date: Apr 2006
Location: New Jersey
Posts: 448
I tried this out and like it for sure. For added realism, I upped COVID-19 frequency to 5, but have run a couple season long tests and have not seen it occur once. Any idea how to tweak the file to get that to occur more frequently, or is it a consequence of the fact that the "illness" injury occurs rarely in general and that can't be tweaked on the user side?
HoustonGM is offline   Reply With Quote
Reply

Bookmarks


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 11:46 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments