Latest News: OOTP PATCH 9.1.6 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 08-28-2006, 09:23 AM   #1 (permalink)
Hall Of Famer
 
Raidergoo's Avatar
 
Join Date: Mar 2003
Location: 39.84 N -84.12 W
Posts: 7,229
AU suggestion for utility

AUTrainerRoom

Output I would like to see

Name hitters : career BA / OBP / OPS
pitchers W-L / ERA

Example:

Ted Williams .317/.458/1.001

09-19-1938 Injured (Dead Arm), out for 2 weeks.
08-12-1939 Injured (Damaged Meniscus (Knee)), out for 3 weeks.
08-15-1940 Injured (Bruised Wrist), day-to-day for 2 weeks.
08-22-1942 Injured (Fractured Wrist), out for 2 weeks.
06-21-1946 Injured (Herniated Disc (Back)), out for 7 weeks.
05-16-1947 Injured (Strained Anterior Cruciate Ligament), out for 3 months.
06-24-1948 Injured (Fractured Cheekbone), out for 7-8 months.
03-22-1949 Injured (Fractured Cheekbone), out for 5 weeks.
05-08-1949 Injured (Dead Arm), out for 2 weeks.
03-30-1952 Injured (Strained Achilles Tendon), out for 3 weeks.
09-27-1952 Injured (Strained Rib Cage Muscle), day-to-day for 2 weeks.
10-05-1952 Injured (Dislocated Shoulder), day-to-day for 2-3 months.



I'd like to do a data dump and get all the injuries from the history of the league.
__________________
Raidergoo is offline   Reply With Quote
Old 08-28-2006, 09:39 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,379
I had something like this in my mind already. I also want to include injury total (45-78 weeks), plus (205 total days on DL)
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 08-28-2006, 05:11 PM   #3 (permalink)
Hall Of Famer
 
Raidergoo's Avatar
 
Join Date: Mar 2003
Location: 39.84 N -84.12 W
Posts: 7,229
Terrific! Maybe give it a spiffy name like AUDrJobe.
__________________
Raidergoo is offline   Reply With Quote
Old 08-29-2006, 01:04 PM   #4 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 2,894
How about a team history of trades over a span of time (user customizeable)

That would be cool
__________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/

Also, Check out my collection of Circular OOTP logos (Kudos to cephasjames for his original logos)
http://s76.photobucket.com/albums/j10/silvam14/
silvam14 is offline   Reply With Quote
Old 08-29-2006, 02:14 PM   #5 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,379
You mean sort of like the AUTrade that I already have?

Quote:
Originally Posted by silvam14
How about a team history of trades over a span of time (user customizeable)

That would be cool
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 08-29-2006, 02:17 PM   #6 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 2,894
Quote:
Originally Posted by Comedian2004
You mean sort of like the AUTrade that I already have?
That is a great utility, but it only runs one year at a time. I was thinking one that lists all trades from a group of years. With or without stats is fine with me.

Speaking of that utility, why is that the only one that needs to be run from the internet, and does not have a stand alone installer?
__________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/

Also, Check out my collection of Circular OOTP logos (Kudos to cephasjames for his original logos)
http://s76.photobucket.com/albums/j10/silvam14/
silvam14 is offline   Reply With Quote
Old 08-29-2006, 04:33 PM   #7 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,379
I originally had it doing the whole team's history, but it just took too long, as there was too many files it had to dig the information out of.

I am working on a Report utility, I will add that ability to it.

As far as stand alone, I just forgot to change the update options. I will do it though.

Quote:
Originally Posted by silvam14
That is a great utility, but it only runs one year at a time. I was thinking one that lists all trades from a group of years. With or without stats is fine with me.

Speaking of that utility, why is that the only one that needs to be run from the internet, and does not have a stand alone installer?
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 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 10:23 PM.


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