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 10-17-2006, 04:46 PM   #1 (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
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
__________________
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 10-18-2006, 03:47 AM   #2 (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
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
 
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 10-18-2006 at 04:25 AM.
Comedian2004 is offline   Reply With Quote
Old 10-18-2006, 11:28 AM   #3 (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
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.
__________________
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 10-18-2006, 08:12 PM   #4 (permalink)
Minors (Double A)
 
Join Date: Dec 2003
Posts: 153
Thanks: 0
Thanked 0x in 0 posts
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, 10:40 PM   #5 (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
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?
__________________
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 10-18-2006, 10:49 PM   #6 (permalink)
Minors (Double A)
 
Join Date: Dec 2003
Posts: 153
Thanks: 0
Thanked 0x in 0 posts
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-19-2006, 12:31 AM   #7 (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
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...
__________________
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 10-19-2006, 06:57 PM   #8 (permalink)
Minors (Double A)
 
Join Date: Dec 2003
Posts: 153
Thanks: 0
Thanked 0x in 0 posts
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, 08:15 PM   #9 (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 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.
__________________
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 10-19-2006, 11:15 PM   #10 (permalink)
Minors (Double A)
 
Join Date: Dec 2003
Posts: 153
Thanks: 0
Thanked 0x in 0 posts
I really like it. I hope to make more use of it as my games unfold.
American_Ernesider 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 11:15 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