Home | Webstore
Latest News: OOTP 13 THIRD Update Available: Version 13.3.9! - OOTP 13 Released! Download Now! - iOOTP 2012 Available NOW on the AppStore - Title Bout Championship Boxing 2.5 released!

Download OOTP 13 Now! | Download iOOTP 2012 from the AppStore

Go Back   OOTP Developments Forums > Out of the Park Baseball 13 > 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 04-27-2007, 08:22 AM   #1 (permalink)
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,113
Blog Entries: 3
Thanks: 38
Thanked 309x in 179 posts
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)
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,113
Blog Entries: 3
Thanks: 38
Thanked 309x in 179 posts
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: 489
Thanks: 12
Thanked 6x in 6 posts
Is there anyway to limit it to Majors or Majors & AAA teams? (or just control the depth of the output)

looks interesting
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel
plannine is offline   Reply With Quote
Old 04-27-2007, 12:24 PM   #4 (permalink)
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,113
Blog Entries: 3
Thanks: 38
Thanked 309x in 179 posts
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

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:26 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