Latest News: OOTP PATCH 9.2.2 released - buy before Oct. 17th and save $10! - OOTP 9 RELEASED! - Title Bout Championship Boxing 2.5 released! - OOTP 2007 receives Editors Choice Award from PC Gamer - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 9!

Go Back   OOTP Developments Forums > OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 07-10-2006, 01:52 AM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
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.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 07-10-2006, 06:05 PM   #2 (permalink)
Minors (Triple A)
 
turdfurgeson's Avatar
 
Join Date: Jan 2005
Posts: 210
nice, I have been waiting for this one, can't wait to give it a quick try.
turdfurgeson is offline   Reply With Quote
Old 07-10-2006, 11:25 PM   #3 (permalink)
Minors (Double A)
 
Join Date: May 2006
Posts: 133
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.
glenn is offline   Reply With Quote
Old 07-10-2006, 11:28 PM   #4 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
OK, like I said, this one is a tough one. I have not fully tested it. I will look further into it this week.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 07-11-2006, 12:19 AM   #5 (permalink)
Minors (Double A)
 
Join Date: May 2006
Posts: 133
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.
glenn is offline   Reply With Quote
Old 08-12-2006, 10:18 AM   #6 (permalink)
Bat Boy
 
Join Date: Nov 2005
Posts: 15
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
BillyO is offline   Reply With Quote
Old 08-12-2006, 10:00 PM   #7 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
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:
Originally Posted by BillyO
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
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 08-18-2006, 05:26 AM   #8 (permalink)
Hall Of Famer
 
dougaiton's Avatar
 
Join Date: Mar 2003
Location: Location:
Posts: 3,411
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!
dougaiton is offline   Reply With Quote
Old 09-04-2006, 06:08 PM   #9 (permalink)
Minors (Triple A)
 
84Hammy's Avatar
 
Join Date: Jul 2003
Location: Stinky Windsor
Posts: 247
Quote:
Originally Posted by BillyO
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
I am getting this same error. Is there a setting either for explorer or my system that I need to alter?
84Hammy is offline   Reply With Quote
Old 09-04-2006, 06:12 PM   #10 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
I have not looked at this program since the patch. I will check it to see if the patch messed it up.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 09-07-2006, 10:06 AM   #11 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Updated to be available offline.

http://www.planetootp.com/AUTrade/default.htm
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 09-07-2006, 06:43 PM   #12 (permalink)
Minors (Triple A)
 
84Hammy's Avatar
 
Join Date: Jul 2003
Location: Stinky Windsor
Posts: 247
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.
84Hammy is offline   Reply With Quote
Old 09-07-2006, 06:48 PM   #13 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
No, it should be ok to run it anytime.

What error?

Quote:
Originally Posted by 84Hammy
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.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 09-07-2006, 09:22 PM   #14 (permalink)
Minors (Triple A)
 
84Hammy's Avatar
 
Join Date: Jul 2003
Location: Stinky Windsor
Posts: 247
The error message is "Index was outside the bounds of the array"
Maybe I should redump the database...
84Hammy is offline   Reply With Quote
Old 09-09-2006, 09:39 PM   #15 (permalink)
Bat Boy
 
Join Date: Nov 2005
Posts: 15
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.
BillyO is offline   Reply With Quote
Old 09-09-2006, 10:09 PM   #16 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Gonna re-code this program from scratch.

Watch for an update soon.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 12:57 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 Out of the Park Developments