Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

Go Back   OOTP Developments Forums > Out of the Park Baseball 12 > OOTP Mods > OOTP Mods - Database Tools

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

Reply
 
LinkBack Thread Tools Display Modes
Old 07-16-2007, 12:25 AM   #101 (permalink)
Bat Boy
 
Join Date: Mar 2007
Posts: 17
Thanks: 0
Thanked 2x in 1 post
Thanks for the update

However it does not seem to be blocking Newcomer of the Year (at least for me)

And, yes, I do have the box checked.
dlevei01 is offline   Reply With Quote
Old 07-24-2007, 11:01 AM   #102 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Hmmm.. I know it is blocking the ROY here. Are you using the default name for the award? I will check the code though.

I installed VB today and wanted to test it, so I added a quick function to the program. However, I am having trouble publishing it now and getting too pissed to work on it right now. I think I am going to go play some golf today and just say F.... It.

BTW, the option I added is for historical leagues:

It downloads a file I created from the Lahman database that contains all the players and the date when they died. The 1st version shows this: (From my season in 1968)

Dead in 1968: Babe Adams - Rafael Almeida - Fred Applegate - Doc Ayers - Dave Barbee - Turner Barber - Benny Bengough - Al Benton - Hal Bevan - Lloyd Bishop - Bill Black - Lena Blackburne - Jack Bliss - Charlie Boardman - Dan Boone - Henry Bostick - Grant Bowler -

This is historically correct and if you wanted to, you can update the dead.csv file with any new dead people.

This file also contains the month, day, year, country and city where they died, so later, I will add stuff like:

On June 5th, 1968, Hal of Famer Babe Adams passed away in Boston. He will be missed.

For fictional leagues, I have another trick up my short sleeves. I will check for retired people that are between 80 and 100 years old and randomly pick one or two to DIE!! Maybe have 0-8 people die each year, showing their age when they died and some other silly trivia. The program will create it's own file to collect the dead people in it, so no one will die twice.
__________________
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-08-2007, 10:27 AM   #103 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
I'm getting an unhandled exception error when I try to select my league. It says "Conversion from string "Lil Evil Eye" to type "Double" is not valid."

Is this a problem with having the data on a drive other than C:?
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 09-08-2007, 01:16 PM   #104 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
I just moved my league to a different drive. I will test it this weekend.

Is 'Lil Evil Eye' a players name?
__________________
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-08-2007, 02:31 PM   #105 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Just tried it with my league with no errors.

Make sure you have the latest CSV dump done.

Also, hit the DEBUG button in the top right hand corner, then run it. It gives me more information to debug it, also slows it down slightly.
__________________
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-08-2007, 02:45 PM   #106 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
Quote:
Originally Posted by Comedian2004 View Post
I just moved my league to a different drive. I will test it this weekend.

Is 'Lil Evil Eye' a players name?
It's not a player name that I know of. It might be a nickname. I don't know why it would come up with that though before I even scan.

I always do a full CSV dump after every sim, so it's all there.

I'll try it with debug on.
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 09-08-2007, 05:10 PM   #107 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
I am going to try the debug but I am now running a fictional league and I always get an ID2 error
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-08-2007, 07:33 PM   #108 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
With debug on , now I get this:

************** Exception Text **************
System.ArgumentNullException: Value cannot be null.
Parameter name: oldValue
at System.String.Replace(String oldValue, String newValue)
at AUHistoryHint.Form1.btnStart_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:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AUHistoryHint
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/Lester/Local%20Settings/Apps/2.0/DEWQZN8D.YYN/V5K4GL50.5DQ/auhi..tion_b70be6f62ece8085_0001.0005_ce42d5b1fed4 646b/AUHistoryHint.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
----------------------------------------
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 09-08-2007, 08:30 PM   #109 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
Just ran Debug:

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 AUHistoryHint.Form1.btnStart_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.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AUHistoryHint
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/Targy/Local%20Settings/Apps/2.0/TA94H4ZJ.Q4Q/ML1L0AM0.5QT/auhi..tion_b70be6f62ece8085_0001.0005_ce42d5b1fed4 646b/AUHistoryHint.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.832 (QFE.050727-8300)
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.832 (QFE.050727-8300)
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.832 (QFE.050727-8300)
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.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.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:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

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.
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-10-2007, 09:19 AM   #110 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
That text you pasted does not help. What I need to know is what section it was working on when it crashed.

Like the ID2 targy mentioned. By having debug turned on, it displays more information when the error happened.

Targy, if you click the ID2 in the debug section, does it skip over that section and still work?
__________________
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-10-2007, 09:21 AM   #111 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
The answer is yes, I have been telling the program to skip ID2 and it works fine
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-10-2007, 09:21 AM   #112 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Lil Evil Eye

While in the game, do a search for Evil and see if you can find this guy. It does search the nicknames.
__________________
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-10-2007, 09:26 AM   #113 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
No one named Evil....also have you had any luck getting rid of the wierd symbols in the hints
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-10-2007, 09:29 AM   #114 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
Quote:
Originally Posted by Comedian2004 View Post
Lil Evil Eye

While in the game, do a search for Evil and see if you can find this guy. It does search the nicknames.
I did a search, and there is no one with that name or nickname.

I am getting the error on startup and whenever I try to choose my league. It gives me the "Lil Evil Eye" error and if I press continue, there is no Date or League text at the top.
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 09-10-2007, 09:32 AM   #115 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
It will let me browse for the folder, and the path does show up in the box, but the error happens every time.

Path is D:\Documents and Settings\Lester\My Documents\Sports Interactive\OOTP Baseball 2007\data\saved_games\SGCBL.lg
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 09-10-2007, 09:37 AM   #116 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
Eureka!!!

I found the player with that nickname by searching the CSV dumps. Couldn't find him using the game search. He is player #2488, and his name is "Sauron the Evil, Jr."

Could it be that the nickname is too long? Or that the util doesn't like commas in the player name? Doing a search from the top of the players.csv file shows that he is the first ", Jr." in the file.
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams

Last edited by Solonor; 09-10-2007 at 09:39 AM.
Solonor is offline   Reply With Quote
Old 09-10-2007, 09:47 AM   #117 (permalink)
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,078
Blog Entries: 3
Thanks: 37
Thanked 299x in 172 posts
Quote:
Originally Posted by Solonor View Post
Eureka!!!

I found the player with that nickname by searching the CSV dumps. Couldn't find him using the game search. He is player #2488, and his name is "Sauron the Evil, Jr."

Could it be that the nickname is too long? Or that the util doesn't like commas in the player name? Doing a search from the top of the players.csv file shows that he is the first ", Jr." in the file.
Commas in text fields inside CSVs are a pain. I think OOTP does stick quotes round text fields but that changes the method of parsing the strings.

I could probably do a similar thing using the .dat files directly. Maybe I should have a word with Larry to see what sort of things he's pulling out and how it could be done with my direct access methodology.
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 09-10-2007, 09:54 AM   #118 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
Searched the csv players file and there is #594 John "Evil Ways" Walker...Is there a way to fix the problem
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-10-2007, 10:05 AM   #119 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
So I figured I would edit the game and take the nickname of Evil Ways out and then do a new dump and see if the problem went away and it did not. It gets to the ID2 where it is gatherering game information and still I am getting an error
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-10-2007, 10:09 AM   #120 (permalink)
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Orlando
Posts: 4,168
Thanks: 134
Thanked 94x in 57 posts
Quote:
Originally Posted by targy View Post
So I figured I would edit the game and take the nickname of Evil Ways out and then do a new dump and see if the problem went away and it did not. It gets to the ID2 where it is gatherering game information and still I am getting an error
I think you're confusing my problem with your problem. Yours doesn't have anything to do with "Lil Evil Eye".
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
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

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



All times are GMT -4. The time now is 08:49 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments