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 10-04-2006, 03:54 PM   #21 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 2,906
Good work comedian!

I am starting my universe over just so I can take advantage of this utility!

__________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/

Also, Check out my collection of Circular OOTP logos (Kudos to cephasjames for his original logos)
http://s76.photobucket.com/albums/j10/silvam14/
silvam14 is offline   Reply With Quote
Old 10-05-2006, 05:59 PM   #22 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Fixed a first season bug that was created later on. If you got an error the 1st time you ran it, try again, it is fixed.
__________________
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 10-19-2006, 11:13 PM   #23 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 2,906
I hope you keep adding new things to the almanac when you have time. I really am glad I re-started my universe to use this program!

Good work!
__________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/

Also, Check out my collection of Circular OOTP logos (Kudos to cephasjames for his original logos)
http://s76.photobucket.com/albums/j10/silvam14/
silvam14 is offline   Reply With Quote
Old 10-20-2006, 12:17 AM   #24 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
I do plan on adding more, but when the response to a program is low, it gets put lower on my priority list. However, this is the type of program that I hop back in and work on it, I do several things.

You can hint at what you want to see it in.

The next thing I am going to add is to create menus to tie the different years together. But I am assuming you mean stuff like the year by year rating grids.
__________________
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 10-20-2006, 09:38 AM   #25 (permalink)
Minors (Rookie Ball)
 
Join Date: Sep 2004
Posts: 20
Thanks and Request

I have not used this program yet since it has taken me weeks to try to find my way through to just setting up to play. Your program is really needed and appreciated. I would ask that, if you have not already done so, that you please consider adding the ability to track at least manager history and records. It surprises me that SI overlooked this when they added such an extensive personnel conmponent to the game. Thanks again for your efforts.
biaaarr is offline   Reply With Quote
Old 10-21-2006, 10:21 PM   #26 (permalink)
All Star Reserve
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 965
So far I have run the 1980 & 1981 seasons with no problem then I noticed a few things

1. no color coding like you show in your examples

2. I exitited the program and went on to do a few things, came back and opened the program and when I click on a player I get an error message that asks is I want to continue or quit and i can't look at the stats for any players
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 10-21-2006, 11:46 PM   #27 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
OK, in answer to #1.

Color coding will not be shown until the 3rd season. This is by design.

#2.

I was able to duplicate this, but, if was because I had screwed up. I had picked a league that I had not done an almanac for.

When you are looking at the ratings, what is the date of the season. Is it still 12-31 or have you advanced further into the season? If you have advanced, did you do a new CSV dump or a new stats dump?

I have NOT tested the program that way, but will do it right now. I have basically just tested the ratings after doing the end of the year backup on 12-31. Without looking at the code, I think that could be an issue, if it is, I will correct it.
__________________
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 10-21-2006, 11:50 PM   #28 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
I 'think' that the reason that it is not tracked is because the computer managers are so much based on the teams that they are managing. They have no individual skills. So, if you take the manager of a WS winning team and move him to a last place team, he will not improve because of the managers or coaches. I am working to get this improved in the 2007 version.

The computer manager vs. the human manager are two different objects in the game, so this may complicate things. Also, when a computer manager is fired, does he just go away or does he end up on another team eventually? Does he manage minor league teams. Does anyone know the answer to these questions?

Quote:
Originally Posted by biaaarr View Post
I have not used this program yet since it has taken me weeks to try to find my way through to just setting up to play. Your program is really needed and appreciated. I would ask that, if you have not already done so, that you please consider adding the ability to track at least manager history and records. It surprises me that SI overlooked this when they added such an extensive personnel conmponent to the game. Thanks again for your efforts.
__________________
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 10-22-2006, 12:13 AM   #29 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
OK, 1st, I updated the program to show color coding, even just two seasons.

I simmed my league to mid April and did a CSV dump and I was able to see the ratings without a problem.

Now, when I had the wrong league up there, I was getting an error when I clicked on a player.

It was bombing out on Sammy Byrd. It had his nickname as:

Babe Ruth S Legs

Not good. During the beta of the OOTP game, I noticed that if a player had 2 or more nicknames in the Lahman database, it pulled in both nicknames and put a ; between each one. This caused the dump to be bad, since there were now extra fields in this players record. I suggested they change the semi-colon into a dash. They did not, they just eliminated the 2nd nickname from being pulled in.

The bad news is that I cannot check to see if this problem exists, as the entire line is being pulled in. Even if you change it to a comma dump instead of a semi-colon, it does not help, as my program just changes all of the commas to semis after they are pulled in.

I do not beleive that you have an error in the dump, as you are seeing the list of players.

Can you click on DETAILS and copy and past the first 20 or so lines here, as that may help me.
__________________
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 10-22-2006, 12:19 AM   #30 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
BTW, one of the toughest formulas to write was adding the age to the year by year ratings. That had me stumped on how to do it for quite a bit. Here is the formula I ended up using.

.Item(0, i).Value = .Item(0, i).Value & "/" & (ThePlayersAge(PlayerID) - (FirstYear - lblFirstYear.Text) + i + 1)

It boggled my mind on this routine!!
__________________
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 10-22-2006, 02:51 AM   #31 (permalink)
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,215
When trying to access player ratings, I get following error

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 AUAlmanac.Form1.lbPlayers_MouseClick(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseClick(MouseEve ntArgs e)
at System.Windows.Forms.ListBox.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:/WINDOWS/Microsoft.NET/Fra...7/mscorlib.dll
----------------------------------------
AUAlmanac
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Setting.../AUAlmanac.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...isualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...dows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...em.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL...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.
For example:



When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


And I just dl'd the latest update.
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with Duffys Tavern Live OOTP Chat Room

Soxx World of Baseball Commissioner
kagnew35 is offline   Reply With Quote
Old 10-22-2006, 09:17 AM   #32 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
OK, I am going to add some error trapping today to it so I can see where the problem is.
__________________
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 10-22-2006, 10:13 AM   #33 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
OK, please try running it again and hit ratings.

If it errors, it should popup with a message telling what section it errored in. Let me know what your error message is and I can go from there.

Current build is 1.2.15.1
__________________
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 10-22-2006, 10:31 AM   #34 (permalink)
All Star Reserve
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 965
When I try to view the ratings for pitchers this is the error I get now

ee the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at AUAlmanac.Form1.lbPitchers_MouseClick(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseClick(MouseEve ntArgs e)
at System.Windows.Forms.ListBox.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:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AUAlmanac
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/Targy/Local%20Settings/Apps/2.0/8MOALNKY.WJK/EWVNJ26A.C6C/aual..tion_6f5451800df83779_0001.0002_daf4ca700dbb 9ecd/AUAlmanac.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.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.

For example:





When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 10-22-2006, 10:32 AM   #35 (permalink)
All Star Reserve
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 965
When I try to view the hitters this is the error I get

error happened with dbhitterratings, removing the fielding colums

then nothing shows
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 10-22-2006, 10:33 AM   #36 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
I put the error trapping in the hitters, not the pitchers.

Are you getting an error in the hitters?

I will add some to the pitchers now.
__________________
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 10-22-2006, 10:38 AM   #37 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
OK, try again with hitters and pitchers with this version and see what happens.

If you have yahoo IM or MSN IM, add me and we can debug through that way. I am webcomedian@msn and webcomedian@yahoo.com
__________________
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 10-22-2006, 02:08 PM   #38 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Waiting for Targy to get back so he can help me debug the ratings problem. I am having no problem here with my test league.

I looked at the manager stuff and it will not be easy to do, but not impossible. I have to find in the transaction files when a manager was fired. I then have to figure out who the new manager was and figure out the teams w/l record at that time and apply the split to the managers. I am not sure if the hiring date of the manager is saved anywhere.

This may be an impossible task.
__________________
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 10-22-2006, 09:39 PM   #39 (permalink)
All Star Reserve
 
Kyros's Avatar
 
Join Date: May 2006
Posts: 981
Comedian2004

I just purchased (a few days ago actually) two Seagate Baracudda 320gig SATA 7200rpm 16MB hard drives (to be ran with Raid/0). I then will use my current 120gig 7200rpm 8MB IDE Western Digital HD along side these for storage. For a total of 715gigs for storage (after windows install, ect) I'm all set for your almanacs bud! LOL!!!!!!!!! Yeah, I'm a damned stats freak. Oh well.
Kyros is offline   Reply With Quote
Old 10-22-2006, 09:54 PM   #40 (permalink)
All Star Reserve
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 965
I will post this here because this is the newest and best program yet. WebComedian has put together an awesome collectiojn of add-ons to this game. I had a great conversation with him today and I we went over some great ideas in making the almanac an even more awesome program

Please everyone donate a few duckets to Webby he does all this work for gratis to keep us all happy with these great programs.

I for one know that he has made little through donations, even if you can only send a few dollars it would add up. Remember he does this all for free and never begs for money.

I was so hoping that Markus could integrate his game with these great programs , even allowing him to put together an add-on pack

Or even a one time fee that would get you access to existing and future programs
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy 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 05:27 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