| 
 | ||||
| 
 | ||||
| 
 | |||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome | 
|  | 
|  | Thread Tools | 
|  07-10-2006, 02:52 AM | #1 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
				
				Anderson Utilities 2006 - AUTrade
			 
			
			OK, this is a first run of this. I just finished the code a few minutes ago. I am too tired to go through all of the testing, but it looks like it is getting the correct information. I thought I would put it up here for you guys to look at. I have not setup error checking with various leagues, etc. I also have not 'smoothed out' the program, so the HTML is a little quirky, but still readable and useable. Here is the idea of this program: You first pick a league, then you click on TRADES. Two new drop downs will appear, one with a list of teams and the other with a list of years. Select the team and year you want to see and click on REPORT. Give it a few seconds and IE should popup with your report. It should show the trade, then show the stats for the players involved in the trade, starting at the year of the trade. So, if you pick 1956 and the player's first year was 1952, it would just show his stats from 1956 and later. It should show all players involved in the trade. This is a quick way to check out trades and see how well the computer did on some of them. Close IE and pick another year/team. The player links and team links should work if you click on them. On the line where it says SO AND SO WAS TRADED.... Why one team and just one year? Well, early versions of the program would report on a whole teams history and it just took too long to get this information. I may change it up a little later on to allow you to pick multiple years. KNOWN ISSUES: The html spacing is funky a little. That requires the use of some brain cells that have already fell asleep, so it will be looked at later. The program is designed for a maximum trade of 2 players. I do not think that the computer will include more than 2 players in a trade, not that I have seen. I do not think it will crash if there were more than 2 players, it will just not show the 3rd player. Some players show no stats. In all situations that I have checked, the player had no stats to be shown. I only display MLB stats, so he may have been sent to the minors or something. If you find a situation where it shows players involved in the trade, but does not show their stats, when indeed they did have stats, please post the trade line. Future Enhancements: I plan on adding the ability to do ALL teams for a given year. So, if you select 1934 and hit all teams, it will create an HTML for each team. Also a team history. So, if you select one team and hit the history button, it will display an HTML for that team showing all the trades in the teams history. The above two take a while to do, so it may not be something that everyone wants to use anyhow. Fine tune the HTML graphics. Right now, the HTML is saved as a generic name. I will change it to be a name based on the team and the year. So, you could manually do the teams you want and have a collection. I will have a menu generator in it also to link to the HTML files that you create. I would like to come up with some kind of system that rates the trade on a scale. This could be pretty complicated, but it is something I am still considering. The link to the program is: http://www.sim2005.com/AUTrade/publish.htm I will be doing modifications to the program throughout the week. I will add a section that displays what is new later on. 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  07-10-2006, 07:05 PM | #2 | 
| Major Leagues Join Date: Jan 2005 
					Posts: 421
				 | 
			
			nice, I have been waiting for this one, can't wait to give it a quick try.
		 | 
|   |   | 
|  07-11-2006, 12:25 AM | #3 | 
| Major Leagues Join Date: May 2006 Location: PA 
					Posts: 407
				 | 
			
			I'm not having much luck with this one.  I get the team drop down, but the year drop down doesn't have the data.  Not sure if all my trades involve more than two people. Scrolling through the transactions, it looks like the AI is always throwing in a minor leaguer.  Although you may mean two on one side. Just glancing at the CSV files, I didn't see where the transactions are stored. | 
|   |   | 
|  07-11-2006, 12:28 AM | #4 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			OK, like I said, this one is a tough one. I have not fully tested it. I will look further into it this week.
		 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  07-11-2006, 01:19 AM | #5 | 
| Major Leagues Join Date: May 2006 Location: PA 
					Posts: 407
				 | 
			
			No problem.  I realized I was still at the very end of year 1, and thought that may be the potential issue.  Created a test league, and simmed a couple years, and it is working fine.   I've got to finish up the playoffs, so I'll try again once I'm in year two, to see if that helps. Looking good so far though. | 
|   |   | 
|  08-12-2006, 11:18 AM | #6 | 
| Minors (Rookie Ball) Join Date: Nov 2005 
					Posts: 25
				 | 
			
			I'm really looking forward to this one too!  but I also can not get it to work.  I get to the team and year drop down list, but when I hit report I get an error message, I hit continue but nothing happens.  THis is the error I get: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.IndexOutOfRangeException: Index was outside the bounds of the array. at AUTrade.Form1.btnReport_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) Any suggestions or thoughts of what I am doing wrong?? Thanks, BillyO | 
|   |   | 
|  08-12-2006, 11:00 PM | #7 | |
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			I have not looked at this program since the patches were released. I will look at it soon and make sure nothing changed in it. Quote: 
 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | |
|   |   | 
|  08-18-2006, 06:26 AM | #8 | 
| Hall Of Famer Join Date: Mar 2003 Location: Location: 
					Posts: 3,414
				 | 
			
			Just using this this morning - superb! Formatting looks super. One thing is that the trade analysis includes postseason stats on a seperate year line.  Is this intentional?  If so, cool.  If not, just a headsup!
		 | 
|   |   | 
|  09-04-2006, 07:08 PM | #9 | |
| All Star Reserve Join Date: Jul 2003 Location: Stinky Windsor 
					Posts: 919
				 | Quote: 
 | |
|   |   | 
|  09-04-2006, 07:12 PM | #10 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			I have not looked at this program since the patch. I will check it to see if the patch messed it up.
		 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  09-07-2006, 11:06 AM | #11 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  09-07-2006, 07:43 PM | #12 | 
| All Star Reserve Join Date: Jul 2003 Location: Stinky Windsor 
					Posts: 919
				 | 
			
			I am still getting an error message on this one.  Could it be that I only ever did a database dump four and half years into the league.  In other words, my current season is incomplete? I'm in 1904, but AUTrade only offers up to 1903.  Perhaps there isnt the necessary data for 1903 and before.
		 | 
|   |   | 
|  09-07-2006, 07:48 PM | #13 | |
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			No, it should be ok to run it anytime. What error? Quote: 
 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | |
|   |   | 
|  09-07-2006, 10:22 PM | #14 | 
| All Star Reserve Join Date: Jul 2003 Location: Stinky Windsor 
					Posts: 919
				 | 
			
			The error message is "Index was outside the bounds of the array" Maybe I should redump the database... | 
|   |   | 
|  09-09-2006, 10:39 PM | #15 | 
| Minors (Rookie Ball) Join Date: Nov 2005 
					Posts: 25
				 | 
			
			I am still getting an error also. heres what I got: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.IndexOutOfRangeException: Index was outside the bounds of the array. at AUTrade.Form1.btnReport_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/Microsoft.NET/Frame...7/mscorlib.dll ---------------------------------------- AUTrade Assembly Version: 1.0.0.0 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Documents%20and%20Setting...45/AUTrade.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/M...isualBasic.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/S...089/System.dll ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/S...dows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/S...em.Drawing.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/S...e.Remoting.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. | 
|   |   | 
|  09-09-2006, 11:09 PM | #16 | 
| Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. 
					Posts: 7,085
				 | 
			
			Gonna re-code this program from scratch. Watch for an update soon. 
				__________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT] | 
|   |   | 
|  | 
| Bookmarks | 
| 
 | 
 |