Latest News: OOTP PATCH 9.1.2 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 04-27-2007, 08:22 AM   #1 (permalink)
Moderator*
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Buckingham, England
Posts: 2,900
Pitching Lineups report (coming soon)

I don't think this style of report exists in the game.

A very basic initial layout is at http://www.bourtonville.co.uk/pitchi...0427130837.htm

What it does (at the moment) is go through each team and produce their starting rotation with their win-loss figure and ERA (these figures are only for their current team at the current level so a traded player would only show stats from their new team - for example if you look at Patrick Misch at the Phillies there are no stats listed as he was traded from the Giants on the 28th July 2007)

The next scheduled starter is underlined.

What will happen to this in the future is

1. Expand the sections to not just starting rotation but spot starters, mop-up, middle, set-up and closer positions.
2. Tabulate the stats and present more stats (probably the basic 16 that MLB show on stats page, W,L,ERA,G,GS,CG,SHO,SV,IP,H,R,ER,HR,HBP,BB,SO) and list current season to date and the previous two seasons - these will be cumulative for the level that they are currently at and include all teams they have played for at that level.
3. Put some hyperlinks in to move around the report.
4. Attempt to split it up by League Name, Sub League and Division Name (but that will take a bit more digging)
5. Tart it up. Use the team colours and such.
6. Remove the All Star teams from the report.

Of course, such a report might be of no use to anyone. If it is, I'll continue on it.

The example one I posted is taken from Rolen 2006 played through to Trading Deadline 2007. I then saved the game, pointed my program at the save game directory and asked it to produce the report - it doesn't require csv exports or the like.

Last edited by Tony M : 04-27-2007 at 08:28 AM.
Tony M is offline   Reply With Quote
Old 04-27-2007, 12:14 PM   #2 (permalink)
Moderator*
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Buckingham, England
Posts: 2,900
Updated the report to be tabulated and put closers in.

This takes about 20 seconds to produce on my machine.

http://www.bourtonville.co.uk/pitchi...0427171101.htm
Tony M is offline   Reply With Quote
Old 04-27-2007, 12:21 PM   #3 (permalink)
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 375
Is there anyway to limit it to Majors or Majors & AAA teams? (or just control the depth of the output)

looks interesting
__________________
"Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game.
Ted Williams (1918-2002)
plannine is offline   Reply With Quote
Old 04-27-2007, 12:24 PM   #4 (permalink)
Moderator*
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Buckingham, England
Posts: 2,900
Quote:
Originally Posted by plannine View Post
Is there anyway to limit it to Majors or Majors & AAA teams? (or just control the depth of the output)

looks interesting
Yep. I'm just adding in the rest of the depth chart for pitching and then going to run it for Majors before uploading that output for delectation.

Now at http://www.bourtonville.co.uk/pitchi...0427172806.htm

just the Major League Level with spot, set-up, mopup and middle relievers added in

Last edited by Tony M : 04-27-2007 at 12:30 PM.
Tony M 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 05:26 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