|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
Thread Tools |
![]() |
#1 |
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. |
![]() |
![]() |
![]() |
#2 |
Minors (Rookie Ball)
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 |
![]() |
![]() |
![]() |
#3 | |
All Star Starter
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
|
Quote:
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. |
|
![]() |
![]() |
![]() |
#4 |
Minors (Rookie Ball)
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 |
![]() |
![]() |
![]() |
#5 | |
All Star Starter
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
|
Quote:
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. |
|
![]() |
![]() |
![]() |
#6 | |
Hall Of Famer
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:
|
|
![]() |
![]() |
![]() |
#7 | |
All Star Starter
Join Date: Apr 2006
Location: Salt Lake City, UT
Posts: 1,200
|
Quote:
|
|
![]() |
![]() |
![]() |
#8 |
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! |
![]() |
![]() |
![]() |
#9 |
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?
|
![]() |
![]() |
![]() |
Bookmarks |
Thread Tools | |
|
|