|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
10-17-2006, 03:46 PM | #1 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
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.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT] |
10-18-2006, 02:47 AM | #2 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
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.
__________________
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 03:25 AM. |
10-18-2006, 10:28 AM | #3 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
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] |
10-18-2006, 07:12 PM | #4 |
Major Leagues
Join Date: Dec 2003
Posts: 354
|
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? |
10-18-2006, 09:40 PM | #5 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
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?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT] |
10-18-2006, 09:49 PM | #6 |
Major Leagues
Join Date: Dec 2003
Posts: 354
|
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... |
10-18-2006, 11:31 PM | #7 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
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.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT] |
10-19-2006, 05:57 PM | #8 | |
Major Leagues
Join Date: Dec 2003
Posts: 354
|
Quote:
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. |
|
10-19-2006, 07:15 PM | #9 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
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?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT] |
10-19-2006, 10:15 PM | #10 |
Major Leagues
Join Date: Dec 2003
Posts: 354
|
I really like it. I hope to make more use of it as my games unfold.
|
Bookmarks |
|
|