Home | Webstore
Latest News: OOTP 26 Available - FHM 12 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 09-11-2006, 05:51 PM   #1
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Anderson Utilities - AUInjuryReport

Guess what? I wrote another one.

http://www.planetootp.com/AUInjuryReport/default.htm

OK, here is what this baby does.

It searches through your entire league and adds up the injuries for each player.

It does it this way. If a player is listed as being injured 1-2 weeks, then it will save 7 and 14 for this injury. (7 days to 14 days). If it said 3 weeks, then it would save 21 and 21 for that. Same thing with month. So, if a solid number, like 7 months if given, it uses the same number for both. If it has a range, like 6-7 weeks, then it will save the 6 and the 7.

It then adds up his days on the DL list. Everytime he was put on the 15 day list, it adds 15, and adds 60 for the 60 day list.

So, you will have this information:

Carl Erskine, 273 days to 303 days, DL = 165

Then, if you click on his name, it brings up a list of all his injuries in a window that you can easily copy and paste: like this:

Erskine, Carl
19520423 Injured (Strained Back Muscle), out for one week.
19520621 Injured (Back Spasms), out for 2 weeks.
19520914 Injured (Fractured Foot), out for 7-8 months.
19530730 Injured (Fractured Cheekbone), out for 4-5 weeks.
19540710 Injured (Strained Back Muscle), out for 2 weeks.

Now of course, a guy could be on the 60 day disabled list for 180 days, or the injury could state 7-8 months and the actual length of the injury could be longer or shorter.

This is just the start of the program. I will be adding some more stuff to this. Any suggestions?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 09-11-2006, 07:06 PM   #2
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Discover gems like this:

Poor Joe was jolted too many times.

His injury total was 2,152 days to 2,268 days. He spent a total of 345 days on the DL!!!

The most in this 50+ year sim goes to Red Kress with 510 days on the DL.



DiMaggio, Joe

19360520 Injured (Strained Back Muscle), out for 1-2 weeks.
19370523 Injured (Fractured Finger), out for one week.
19370601 Injured (Fractured Hand), out for one week.
19380413 Injured (Back Spasms), out for one week.
19380619 Injured (Scratched Cornea), out for 2 weeks.
19380726 Injured (Bruised Hip), day-to-day for one week.
19381011 Injured (Concussion), day-to-day for one week.
19390715 Injured (Strained Calf Muscle), day-to-day for 2 weeks.
19390908 Injured (Strained Rib Cage Muscle), day-to-day for one week.
19400403 Injured (Damaged Meniscus (Knee)), day-to-day for 2 weeks.
19401004 Injured (Dislocated Shoulder), out for 2 months.
19410317 Injured (Stiff Neck), day-to-day for 6 days.
19410321 Injured (Back Spasms), day-to-day for 2 weeks.
19410327 Injured (Scratched Cornea), day-to-day for 3-4 weeks.
19410504 Injured (Strained Hip Muscle), out for 2 weeks.
19410710 Injured (Back Spasms), out for 4 weeks.
19420316 Injured (Fractured Finger), out for 2 weeks.
19420429 Injured (Concussion), out for 1-2 weeks.
19420816 Injured (Bruised Wrist), out for one week.
19430701 Injured (Hyperextended Knee), out for 2 weeks.
19430829 Injured (Strained Tricep Tendon), day-to-day for 2 weeks.
19430912 Injured (Strained Achilles Tendon), day-to-day for 1-2 weeks.
19430923 Injured (Scratched Cornea), day-to-day for 2 weeks.
19440702 Injured (Damaged Meniscus (Knee)), out for 4 weeks.
19440902 Injured (Concussion), out for 3 weeks.
19450511 Injured (Bruised Wrist), day-to-day for 2 weeks.
19450512 Injured (Damaged Meniscus (Knee)), day-to-day for 3 weeks.
19450819 Injured (Bruised Wrist), day-to-day for 2 weeks.
19450826 Injured (Torn Back Muscle), day-to-day for 2-3 months.
19460521 Injured (Fractured Cheekbone), out for 11 months.
19470530 Injured (Fractured Ribs), out for 2 weeks.
19470630 Injured (Fractured Elbow), out for 13 months.
19480630 Injured (Strained Achilles Tendon), out for one week.
19480901 Injured (Strained Rib Cage Muscle), out for one week.
19490402 Injured (Concussion), out for 2 weeks.
19490607 Injured (Fractured Finger), out for 1-2 weeks.
19490720 Injured (Scratched Cornea), out for 4 weeks.
19490831 Injured (Fractured Finger), out for 1-2 weeks.
19500516 Injured (Herniated Disc (Back)), out for 2-3 months.
19500908 Injured (Back Spasms), out for 2 weeks.
19510406 Injured (Sore Knee), day-to-day for 1-2 weeks.
19510424 Injured (Blurred Vision), day-to-day for one week.
19520331 Injured (Fractured Finger), out for 1-2 weeks.
19520614 Injured (Dislocated Finger), day-to-day for one week.
19520704 Injured (Damaged Meniscus (Knee)), out for 2 weeks.
19520819 Injured (Sore Knee), day-to-day for 6 days.
19520820 Injured (Bruised Cheekbone), day-to-day for 6 days.
19520906 Injured (Bruised Ankle), day-to-day for one week.
19530404 Injured (Torn Ankle Ligaments), out for 8 months.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 09-11-2006 at 07:42 PM.
Comedian2004 is offline   Reply With Quote
Old 09-11-2006, 07:33 PM   #3
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
When you click on a player's name on the left, it will display all his injuries on the top right and his entire history on the bottom right.

There is a splitter between the two windows, so you could slide the bottom window down to allow the top window to show more.

This splitter option is new to me, but I got it to work, just not ice perfect yet.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 09-14-2006, 02:37 PM   #4
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
New option:

Double click on a players name and bring up a grid showing his lifetime stats.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 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 12:49 PM.

 

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