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-08-2007, 02:44 AM   #81 (permalink)
Bat Boy
 
Join Date: Mar 2007
Posts: 17
Thanks: 0
Thanked 2x in 1 post
As requested, O programming master.

Apparently the batters in my league are quite prolific. According to your most excellent program (must find money to donate, as should everyone else!) I had 5 instances of more than 11 runs scored in an inning (4 12s and a 13! ) Of course, they were all in either the minors or spring training.


Speaking of which, is there any way to have the minor league team name show up instead of the parent major league club in game mentions like those (runs in an inning)? And yes, I do have the No Minors History checked adn Top Level only checked
dlevei01 is offline   Reply With Quote
Old 07-08-2007, 02:49 AM   #82 (permalink)
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 5,496
Thanks: 254
Thanked 297x in 160 posts
I suppose there's no way to replace "In Game #1094 . . ." with the date of the game, is there? Likewise, is it possible to identify the team for which the player of note plays? Instead of "Joe Camel blah blah blah . . " it would read "San Jose's Joe Camel blah blah blah . . ."
pstrickert is offline   Reply With Quote
Old 07-08-2007, 10:34 AM   #83 (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
Well, you answered my question about the more than 11 runs in an inning.

The minor league team should be being displayed, as it looks it up in the teams.csv file. It is really, really, really, really early in the morning here. (9am), so my brain is not awake yet, but I will check. It is possible that I am not doing a minor league check there, so I will check and see.

As far as the In Game #1094 (wow, I had one of those also), The reason I am putting in the #, in that format, #1094, is if you click on the line in my program, it will take you to the box score and let you see it. Of course, you have to have box scores saved turned on in OOTP. I will add more information to those lines showing the date. If you use the CHECK DUMPS option, those links will not work. I will add that, as I save all box scores, like you should do!

I put the date in others where I do not have the box score number so that you can go look at it. In those cases, I would have to load in another file and look up that game. I could actually do that when you click on the link, but if I had it do it when it found it, then it would slow down the program.

Now that I think about it, I read that file in earlier, so I guess I could actually read it into memory in an array for later use by my program. You are making my brain think early.

I get started on a program and I have a hard time calling the program done. I keep adding stuff and fine tuning it. I am having so much fun with this one, that I keep adding more and more stuff.

To me it is so interesting to look at the file after I AUTOSIM 5 or 6 months and see stuff that I would have never knew happened. Like:

The biggest win this year was 20 runs.
A pitcher throwing 10 walks or hitting 3 batters.
A 23 inning game.
A 15 hit shutout.
A batter walking 5 times. It don't happen very often. I see Gehrig and Schulte doing it in mine.
Less Bell hitting 3 triples in one game.
Seeing games with 11 run innings and clicking on it and seeing that the team came back from 7-0 to win with 11 in the last of the ninth.

I am also noticing that I and others use the program different for different leagues. I play historical now, so I may autosim 10-40 years, hop in and play out a year for a team. It is nice to have the dumps option on and see something that happened during those years. It is even better when I can view that box score. Now if I was playing a fictional league with full minor leagues, I would want to see the games where it happened in the minors. I see some minor league hitters name a lot of there getting 5 hit games or winning the MVP, I may want to go peek at this guy and make a trade for him. But that is me.

I am going back to sleep.
__________________
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-08-2007, 09:18 PM   #84 (permalink)
Minors (Triple A)
 
daveawrit's Avatar
 
Join Date: Mar 2007
Location: San Angelo
Posts: 223
Thanks: 9
Thanked 13x in 10 posts
I am getting an error that says:

"Unhandled exception has occured in your application. If you click to continue the application will ignore this error and attempt to continue. If you click quit the application will close immediately.

Value cannot be null
Parameter name: oldvalue"

If I click continue it remains on "Checking out 2969 player's history files...."

This happens almost immediately after clicking the start button, and it is the first time using the program... may just be I have the wrong file selected or something.
daveawrit is offline   Reply With Quote
Old 07-08-2007, 11:17 PM   #85 (permalink)
Bat Boy
 
Join Date: Mar 2007
Posts: 17
Thanks: 0
Thanked 2x in 1 post
I had that same problem. You are likely going to the wrong folder for your path. Go to just the league folder, not the import/export folder. That fixed it for me. If I'm wrong, hey, what do I know....
dlevei01 is offline   Reply With Quote
Old 07-10-2007, 08:24 PM   #86 (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
Program was updated a few minutes ago.

Updated interface with easier to follow layout. Drop down menu for some items.

New special team trivia added - Month by Month w/l breakdown

Really cool option:

A teams record when a certain pitcher is starting:

So, if Vida Blue's team is 24-2 when HE started, this would be displayed, if the option was set for 20+ wins, as the default is.

Also shows pitchers record if their team loses 20+ games when he has started.

Really wish OOTP showed this. This is a very valueable stat.

I also debugged the most runs in an inning. I got very confused with that code. It now shows that Boston scored 11 runs in the 1st inning, Boston beat Chicago 12-3.

Makes it easier to find a game where a team scored 11 runs in one inning and lost. Note, the links work on that, if you wisely save box scores.

I know sometimes it says: Boston beat Chicago 2-21, and it should be 21-2. So what. Sue me.
__________________
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-2007, 08:40 PM   #87 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
Question...I did my csv dump and opened the program, I like the new interface. I heck all the things that i do not want the game to show and one of those is injuries. I run the program and check all the entries and there are career ending injuries still listed. I also choose to save my settings. Reopen the program and all the settings are saved except one and that is injuries so I have to recheck that box...I would also like the team that i am picking as a special team to be saved until I choose to change it
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 07-10-2007, 11:56 PM   #88 (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
OK, the CEI are being displayed from the history file. I will add an option for CEI.

As far as saving the options, every time I add an option, I have to add them to the save and load option. So, I do not update this option often. I will update it next time.

I think I have an error with the pitchers team thing, I have to double check it.
__________________
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-12-2007, 07:11 AM   #89 (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 ran the program and have all awards shut off and no minors. I just checked the entries and it showed minor league teams that have scored a certain amount of runs in an inning and a few entries for awards
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 07-12-2007, 07:34 AM   #90 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
Another one, have injuries check to ignore and I started the game and got a CEI
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 07-12-2007, 09:50 AM   #91 (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
The minor league teams scoring the runs. That may be tricky to limit, as the file that contains a zero or a one for the team name. Which, I thnk it home/away. It use to house the team number. Now I will have to look it up in the games.csv file, just not sure if it is doable.

The minor leagues awards. I will look at that. I know I can block the CEI though.
__________________
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-12-2007, 10:34 AM   #92 (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 fixed the CEI thing, those should not show up if you are telling it to ignore injuries.

I will look at the minor league awards later this week. I have to create a league with some history that has a minor league.
__________________
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-14-2007, 04:17 PM   #93 (permalink)
Minors (Triple A)
 
biggamejrs's Avatar
 
Join Date: Dec 2001
Location: Greenville, USA
Posts: 206
Thanks: 4
Thanked 2x in 1 post
this program looks awesome!!

below is an error i get after it reads players and begins gathering team info. i click continue and if ran about 30 mins seemingly doing nothing. any advice?


this program looks awesome!!

*edit-reread post 59

it errors on getting game information, let me know if you need more info.
thanks

Last edited by biggamejrs; 07-14-2007 at 04:27 PM. Reason: info
biggamejrs is offline   Reply With Quote
Old 07-14-2007, 04:38 PM   #94 (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
Click the debug check mark and run it and let me know where it is when it errors.

Clicking continue at that point just aborts it.
__________________
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-14-2007, 05:00 PM   #95 (permalink)
Minors (Triple A)
 
biggamejrs's Avatar
 
Join Date: Dec 2001
Location: Greenville, USA
Posts: 206
Thanks: 4
Thanked 2x in 1 post
getting game information
__________________
Go Braves!!
biggamejrs is offline   Reply With Quote
Old 07-15-2007, 12:22 AM   #96 (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
If you hit the debug before you ran it, it would tell you more information on what section of the game information you are getting.

Did the program work before? If so, what month are you in?
__________________
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-15-2007, 09:57 AM   #97 (permalink)
Bat Boy
 
Join Date: Mar 2007
Posts: 17
Thanks: 0
Thanked 2x in 1 post
Holy Errors Batman!

Don't worry, I'm talking the baseball kind.
The News York Giants committed 5 errors in BOTH games of a doubleheader.

That's the fun and odd stuff that your wonderful program finds!

Amyone up for fielding practice?

And as a Tigers fan, defaulting to the times the Yankees have been shut out is pure inpsired genius

Last edited by dlevei01; 07-15-2007 at 12:54 PM.
dlevei01 is offline   Reply With Quote
Old 07-15-2007, 11:27 AM   #98 (permalink)
Major Leagues
 
orwell's Avatar
 
Join Date: May 2004
Location: Ft. Worth, TX
Posts: 354
Thanks: 2
Thanked 10x in 6 posts
"Index was outside the bounds of the array."

This is an excellent program. Thanks for putting so much time into it.

With the latest update, a new error has appeared when I run it. It processes the players ok but it starts to gather games information an "unhandled exception error" occurs (index outside bounds of the array.

Thanks.
__________________
"Who will scout the scouts?"
orwell is offline   Reply With Quote
Old 07-15-2007, 01:41 PM   #99 (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
Try it again after and note the ID number of the error. You can now see an option to disable that ID part of the program. If you turn debug on, I would have a better understanding what part you mean.

Orwell reports: gathers games information

I don't use that phrase. I use compliling games and also getting game information.

Let me know the date of your sim, i.e. June 4th, 2004

Very important is to know the date of the sim. Is it before preseason? There may be a problem if you run it after the preseason starts and before the start of the season. OOTP does not wipe out the box scores and some other files. And the CSV files are not in sync yet. So weird things happen. The best time to run the program for solo play where you play the games out would be around November. Make it compile around 500 or so and then you are set for playing and simming until maybe around the all-star game, or even as early as May. Then you run it again. But maybe changing it so that it does not display as much as before. Tweak it.

It has to be tweaked for the way that you play the game. Hopefully I gave you enough options to tweak until the cows come home.
__________________
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-15-2007, 02:39 PM   #100 (permalink)
Minors (Triple A)
 
biggamejrs's Avatar
 
Join Date: Dec 2001
Location: Greenville, USA
Posts: 206
Thanks: 4
Thanked 2x in 1 post
I got mine to work by just hitting the merge button. I didnt see what player it errored on tho.
My league date is May 29, 2009.

Also, did you get my donation yesterday?
__________________
Go Braves!!
biggamejrs 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 02:14 PM.


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