Latest News: Updated Patch #4, version 10.4.31 available! - OOTP 10 RELEASED! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 10!

Go Back   OOTP Developments Forums

> OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools


Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools Display Modes
Old 08-12-2008, 07:51 AM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
AUDeepDeep

I had one of those "I can't sleep" nights, so, since I just installed the 2008 version of VB (non-express) and I did not want to do any 'work', I sat down and wrote a new program.

It is not complete yet, but here is a peek of it. It should be self explanatory.


Some of the things I want to add are:

vs. Team
look in the almanac and create a lifetime
HTML pages
Automate creating the HTML for players with XX home runs
And whatever else I can steal from BR.com and what you guys suggest

NOTE: This early version includes spring training. Adding the date of the game and the team is going to be harder. Not really harder, just slower, as that information is NOT in that CSV file, so I would have to load in another one and it would slow it down.

The RBIS are RBIs that were obtained from the long ball.

__________________
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-13-2008, 11:49 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
Anyone interested in this program?

The hitter list on the left now only shows players with 1 or more HR, also shows how many home runs they have. You can now filter out the spring training and post season games. You can also click on the game number to see the actual box score of the game.

Here is an updated screenshot:

__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

Last edited by Comedian2004; 08-13-2008 at 11:51 AM.
Comedian2004 is offline   Reply With Quote
Old 08-13-2008, 12:11 PM   #3 (permalink)
Hall Of Famer
 
darkcloud4579's Avatar
 
Join Date: Jun 2003
Location: All over the place..
Posts: 4,948
Blog Entries: 24
Thanked 16x in 10 posts
Holy cow. I wish I had your skills, as I have tons of ideas and all I can do is mess around in Excel. Might be time for me to upgrade some skillsets.

In any case, I love this. Nice gee-whiz fodder for immersiniks everywhere. Great work.
__________________
My OOTP Mods: GmEXcel for OOTP X (formerly MarketCalc)
Daylight Fading: OOTP X solo dynasty
Here We Go W-Y-O: NCAA 10 Dynasty
FOOL: St. Louis Terriers (1961-65), Compton Brothers (1966-69), Chicago/Quad City T-Storms (1970-1978), Boston Bombers/St. Louis Terriers (1980-1988), Boston Settlers (2027), Newark Terriers (2037-2041) 11 FOOL Classic appearances (w/5 different teams), 5 FOOL Titles
FOBL: Bantam Originals (6th season)
FBCB-FOFC: Oklahoma Sooners (2031-)
Wyoming Cowboys (2027-30)
'27 MWC Coach of the Year & Conference Champs
Creator of fast-sim, Commissioner of FOOL-H

Omnivore CFB Computer Rankings
darkcloud4579 is offline   Reply With Quote
Old 08-13-2008, 12:50 PM   #4 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 3,278
Thanked 53x in 25 posts
Wow, This kicks butt! Great work!
__________________
Senior "Nancy Boy" of the OOTP Boards
_______________________________________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/
silvam14 is offline   Reply With Quote
Old 08-15-2008, 01:25 PM   #5 (permalink)
DWK
Major Leagues
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 312
Great job Larry
__________________
Between The Lines Baseball League - Commissioner/New York Yankees GM
Beyond The Ivy - New York Yankees GM
Golden Era Baseball - Brooklyn Dodgers GM
DWK is offline   Reply With Quote
Old 08-15-2008, 03:15 PM   #6 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
No new updates, been busy with 'real' work, but should have this ready for the public soon.

Another quick and easy program is one that I would love to see display this:

The Tigers are 31-20 when Inge is playing 3B
The Tigers are 2-20 when hitting no home runs.

Verlander is 14-2 when pitching on 4 days rest
Verlander is 2-11 when pitching on 3 days rest

All sort of different scenarios could be checked for. When leading after X innings, when scoring X runs, when allowing X runs, when pitcher was laid before the game, etc...
__________________
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-17-2008, 07:54 AM   #7 (permalink)
Hall Of Famer
 
f.montoya's Avatar
 
Join Date: Nov 2004
Posts: 5,028
Thanked 13x in 6 posts
Larry, you are a genius. Can you call this your ABS utility(Anderson's Sports Bureau)? I simply love this idea!
__________________
Fidel Montoya

Asahi2 Baseball Commissioner(Historical League Since 2004)
www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - No website knowledge necessary!)
Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)
f.montoya is offline   Reply With Quote
Old 08-17-2008, 08:40 AM   #8 (permalink)
Hall Of Famer
 
HolyCow98's Avatar
 
Join Date: Dec 2001
Location: C:\My Documents\Sports Interactive\OOTP Baseball 2007\data\ballparks
Posts: 2,600
Wow...that would be cool to have. I know as my favorite players reach their primes and beyond I would be reviewing those crazy stats and the vs team stats alot....I just like that kind of stuff.
__________________
National Pastime Baseball League Maryland Admirals
Jamaica League Santa Cruz Crocodiles GM
Gridiron Glory College Football Central Florida Golden Knights Head Coach
American College Football Assiciation Desoto State Demons Head Coach
American Basketball Assiciation Miami Floridians Head Coach
Coalition of College Basketball Coaches- Jacksonville Dolphins
HolyCow98 is offline   Reply With Quote
Old 09-07-2008, 09:07 AM   #9 (permalink)
DWK
Major Leagues
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 312
amazing Larry
__________________
Between The Lines Baseball League - Commissioner/New York Yankees GM
Beyond The Ivy - New York Yankees GM
Golden Era Baseball - Brooklyn Dodgers GM
DWK is offline   Reply With Quote
Old 09-07-2008, 09:58 AM   #10 (permalink)
All Star Starter
 
ashantewarrier's Avatar
 
Join Date: Feb 2004
Location: Somerset, NJ via Brooklyn, NY
Posts: 1,047
Thanked 4x in 3 posts
Larry you are the Man! Thanks!
__________________
"I'm not concerned with your liking or disliking me... All I ask is that you respect me as a human being."
-Jackie Robinson, #42 Brooklyn Dodgers
ashantewarrier 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 09:37 AM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2009 Out of the Park Developments