|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Global Moderator
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. |
|
|
|
|
|
#2 (permalink) |
|
Global Moderator
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 |
|
|
|
|
|
#3 (permalink) |
|
Major Leagues
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 |
|
|
|
|
|
#4 (permalink) | |
|
Global Moderator
Join Date: Feb 2006
Location: Here
Posts: 6,113
Blog Entries: 3
Thanks: 38
Thanked 309x in 179 posts
|
Quote:
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. |
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|