| 
 | ||||
| 
 | ||||
| 
 | |||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome | 
|  | 
|  | Thread Tools | 
|  07-14-2006, 11:27 PM | #1 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
				
				Anderson Utilities 2006 - AUCEI
			 
			
			Ok, here is another Anderson Utility. Career Ending Injury Report. This creates a nice HTML report with links to the teams and players for players that had the dreaded CEI. http://www.sim2005.com/AUCEI/publish.htm A couple notes: 1. This program does install, so once you initially install it, it can be ran from your START menu or you can create a shortcut to it. You do not need to run it from the browser after it is installed. 2. You need IE to install it. 3. You need to be in your 2nd season for the program to display anything. 4. You must do a HTML report for the players and team links to work. The program will work correctly and display the report, however, the links won't work, because they were never created by OOTP. That's it. It is very quick and easy. Let me know of any problems or any suggestions. Larry 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  07-16-2006, 12:58 PM | #2 | 
| All Star Starter Join Date: Dec 2001 
					Posts: 1,534
				 Infractions: 1/0 (0) | 
			
			Larry, this might be a stupid question but will all of these modules be available under one gui at some point? | 
|   |   | 
|  07-16-2006, 02:17 PM | #3 | |
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | Quote: 
 I am not sure yet. Maybe. Writing them individually is a lot easier than writing one huge program and they run better. But, after I write several, I may merge them into one big program. 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | |
|   |   | 
|  08-04-2006, 03:21 AM | #4 | 
| Minors (Single A) Join Date: Mar 2002 
					Posts: 82
				 |   
			
			Larry, this is kind of funny. My league only has 16 teams and 4 years history, so very few players. There have only been 4 CIs so far. But there are the cursed Aguilar brothers in this league. First in 2006 Frank is done with a fractured skull and then a year later Gary with a torn back muscle. Go figure, huh. Mike | 
|   |   | 
|  08-21-2006, 03:36 AM | #5 | 
| All Star Reserve Join Date: Jun 2006 
					Posts: 818
				 | 
			
			AUCEI only seems to pull data for the first defined league...is that by design?
		 | 
|   |   | 
|  08-21-2006, 03:36 PM | #6 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			It now should pull from all the leagues. Larry 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  08-22-2006, 03:46 AM | #7 | 
| All Star Reserve Join Date: Jun 2006 
					Posts: 818
				 | 
			
			Many thanks!
		 | 
|   |   | 
|  08-28-2006, 10:10 AM | #8 | 
| Hall Of Famer Join Date: Mar 2003 
					Posts: 9,005
				 | 
			
			How about a yield calculation? Total the # of players in a season. Total the number of CEI. Divide the two and express as a %. | 
|   |   | 
|  02-04-2007, 01:47 PM | #9 | 
| Bat Boy Join Date: Apr 2005 
					Posts: 11
				 | 
			
			The link for AUCEI is no longer working?? Any help would be appreciated! Thanks for the hard work on all of these excellent utilities!!
		 | 
|   |   | 
|  02-05-2007, 12:56 PM | #10 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			Ah, you are correct. I will look at it later today.
		 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  | 
| Bookmarks | 
| 
 | 
 |