| 
 | ||||
| 
 | ||||
| 
 | |||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome | 
|  | 
|  | Thread Tools | 
|  09-11-2006, 05:51 PM | #1 | 
| Hall Of Famer 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] | 
|   |   | 
|  09-11-2006, 07:06 PM | #2 | 
| Hall Of Famer 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. | 
|   |   | 
|  09-11-2006, 07:33 PM | #3 | 
| Hall Of Famer 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] | 
|   |   | 
|  09-14-2006, 02:37 PM | #4 | 
| Hall Of Famer 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] | 
|   |   | 
|  | 
| Bookmarks | 
| 
 | 
 |