Latest News: OOTP PATCH 9.1.6 released! - 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-17-2006, 03:46 PM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
Anderson Utilities - AUPitcher

An early release of this program (for good behaviour):

http://www.planetootp.com/AUPitcher/default.htm

Pick a team, then pick a pitcher. A sortable grid showing his game by game is displayed with all the information how he did that game.
  • It hides all fields that all zeros in them (the CG game field for RP or the SAVE field for all starters).
  • It colors the wins in green and the losses in red to make them stick out easier.
  • Colors in blue the higher of the total for ground ball vs. fly balls
  • all fields are sortable
  • can click on row and see box score of game, if it exists
I am going to add more color coding, need suggestions here. Also add a quick reference to the game result
__________________
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-18-2006, 02:47 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
Here is a screen shot of the program in use:

It is cleared when using it. Note the coloring. The Aqua under IP means it was a quality start. The Blue under K or BB means that he struck out more than he walked or vice versa. Same thing goes with the GB/FB.

Added some more filters, including a team filter. Very good visual on how a pitcher has done vs. certain teams.
Attached Images
 
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

Last edited by Comedian2004 : 10-18-2006 at 03:25 AM.
Comedian2004 is offline   Reply With Quote
Old 10-18-2006, 10:28 AM   #3 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
Added the players W-L S to the screen and also his 'team record when he pitched'. Then fixed a bug to correctly show it if he was traded.

Interesting to look at starters to see their team record when he pitched. Also with the RPs, as you can really see how some pitchers are only brought in when losing or winning.
__________________
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-18-2006, 07:12 PM   #4 (permalink)
Minors (Single A)
 
Join Date: Dec 2003
Posts: 95
Any idea what I'm doing wrong?

I'm getting a message that states "I could not find the CSV dump"

I am guessing I've not done something right.....any suggestions?
American_Ernesider is offline   Reply With Quote
Old 10-18-2006, 09:40 PM   #5 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
Have to ask the obvious, have you done a CSV dump for the league in question. Also, have you tried any other of my programs with success?

Quote:
Originally Posted by American_Ernesider View Post
Any idea what I'm doing wrong?

I'm getting a message that states "I could not find the CSV dump"

I am guessing I've not done something right.....any suggestions?
__________________
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-18-2006, 09:49 PM   #6 (permalink)
Minors (Single A)
 
Join Date: Dec 2003
Posts: 95
I'm not feeling particularly bright right now. :-)

I haven't done a "CSV dump." How do I do that?

I just ran across some of your utilities and both have had the same message.

Sorry for what probably seem like such stupid questions! I'm learning...
American_Ernesider is offline   Reply With Quote
Old 10-18-2006, 11:31 PM   #7 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
It's cool. In order to use any of my stuff, yoiu need to open OOTP, under the menu, select DATABASE and then under tools, select CSV DUMP. This dumps all the info that my program needs.

Quote:
Originally Posted by American_Ernesider View Post
I'm not feeling particularly bright right now. :-)

I haven't done a "CSV dump." How do I do that?

I just ran across some of your utilities and both have had the same message.

Sorry for what probably seem like such stupid questions! I'm learning...
__________________
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, 05:57 PM   #8 (permalink)
Minors (Single A)
 
Join Date: Dec 2003
Posts: 95
Quote:
Originally Posted by Comedian2004 View Post
It's cool. In order to use any of my stuff, yoiu need to open OOTP, under the menu, select DATABASE and then under tools, select CSV DUMP. This dumps all the info that my program needs.
That did it! Thanks!

I was wondering, what does the "Team Record when pitching" look at? I show pitcher that is 9-8 and the "Team Record when pitching" is 0-24.
American_Ernesider is offline   Reply With Quote
Old 10-19-2006, 07:15 PM   #9 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
The team record is something that is still being 'debugged'. I think it works fine if the player is on the same team the entire time, but if he was traded, it screws up. Still working on that.

My programs automatically update your version when I put up a new version.

What do you think of the 'concept' of the program?

Quote:
Originally Posted by American_Ernesider View Post
That did it! Thanks!

I was wondering, what does the "Team Record when pitching" look at? I show pitcher that is 9-8 and the "Team Record when pitching" is 0-24.
__________________
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, 10:15 PM   #10 (permalink)
Minors (Single A)
 
Join Date: Dec 2003
Posts: 95
I really like it. I hope to make more use of it as my games unfold.
American_Ernesider 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 07:15 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