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 07-10-2006, 02:52 AM   #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 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]
Comedian2004 is offline   Reply With Quote
Old 07-10-2006, 07:05 PM   #2
turdfurgeson
Major Leagues
 
turdfurgeson's Avatar
 
Join Date: Jan 2005
Posts: 421
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-11-2006, 12:25 AM   #3
glenn
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.
glenn is offline   Reply With Quote
Old 07-11-2006, 12:28 AM   #4
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
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]
Comedian2004 is offline   Reply With Quote
Old 07-11-2006, 01:19 AM   #5
glenn
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.
glenn is offline   Reply With Quote
Old 08-12-2006, 11:18 AM   #6
BillyO
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
BillyO is offline   Reply With Quote
Old 08-12-2006, 11:00 PM   #7
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
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:
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
__________________
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 08-18-2006, 06:26 AM   #8
dougaiton
Hall Of Famer
 
dougaiton's Avatar
 
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!
dougaiton is offline   Reply With Quote
Old 09-04-2006, 07:08 PM   #9
84Hammy
All Star Reserve
 
84Hammy's Avatar
 
Join Date: Jul 2003
Location: Stinky Windsor
Posts: 919
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, 07:12 PM   #10
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
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]
Comedian2004 is offline   Reply With Quote
Old 09-07-2006, 11:06 AM   #11
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Updated to be available offline.

http://www.planetootp.com/AUTrade/default.htm
__________________
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-07-2006, 07:43 PM   #12
84Hammy
All Star Reserve
 
84Hammy's Avatar
 
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.
84Hammy is offline   Reply With Quote
Old 09-07-2006, 07:48 PM   #13
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
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:
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.
__________________
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-07-2006, 10:22 PM   #14
84Hammy
All Star Reserve
 
84Hammy's Avatar
 
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...
84Hammy is offline   Reply With Quote
Old 09-09-2006, 10:39 PM   #15
BillyO
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.
BillyO is offline   Reply With Quote
Old 09-09-2006, 11:09 PM   #16
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
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]
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 04:54 AM.

 

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