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 08-12-2008, 06:51 AM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
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.

__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 08-13-2008, 10:49 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
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:

__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 08-13-2008 at 10:51 AM.
Comedian2004 is offline   Reply With Quote
Old 08-13-2008, 11:11 AM   #3 (permalink)
Hall Of Famer
 
darkcloud4579's Avatar
 
Join Date: Jun 2003
Posts: 5,297
Blog Entries: 29
Thanks: 89
Thanked 77x in 45 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.
__________________
SLOP: Commissioner
FOBL: Marlboro Townies
FOFC-FBCB: Kansas Jayhawks
ZOMGFL: Colorado Buffaloes
Omnivore FBS Computer Ranking
darkcloud4579 is offline   Reply With Quote
Old 08-13-2008, 11:50 AM   #4 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 4,219
Thanks: 286
Thanked 1,693x in 530 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, 12:25 PM   #5 (permalink)
DWK
All Star Reserve
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 580
Thanks: 17
Thanked 15x in 14 posts
Great job Larry
__________________
Humble Beginnings - 1905 Chicago Cubs
MLB 93 - St Louis Cardinals
MLB2012 - Los Angeles Dodgers
Sabermetric Baseball - Detroit Tigers

DWK is offline   Reply With Quote
Old 08-15-2008, 02:15 PM   #6 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
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...
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 08-17-2008, 06:54 AM   #7 (permalink)
Hall Of Famer
 
f.montoya's Avatar
 
Join Date: Nov 2004
Posts: 5,842
Thanks: 204
Thanked 181x in 89 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 - Sign up, Connect OOTP and Play!)
Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)
AllYouSports - "Because Facebook don't do baseball stats"
f.montoya is offline   Reply With Quote
Old 08-17-2008, 07:40 AM   #8 (permalink)
Hall Of Famer
 
HolyCow98's Avatar
 
Join Date: Dec 2001
Location: Douglasville, GA
Posts: 2,603
Thanks: 6
Thanked 1x in 1 post
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.
HolyCow98 is offline   Reply With Quote
Old 09-07-2008, 08:07 AM   #9 (permalink)
DWK
All Star Reserve
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 580
Thanks: 17
Thanked 15x in 14 posts
amazing Larry
__________________
Humble Beginnings - 1905 Chicago Cubs
MLB 93 - St Louis Cardinals
MLB2012 - Los Angeles Dodgers
Sabermetric Baseball - Detroit Tigers

DWK is offline   Reply With Quote
Old 09-07-2008, 08:58 AM   #10 (permalink)
All Star Starter
 
ashantewarrier's Avatar
 
Join Date: Feb 2004
Location: Somerset, NJ via Brooklyn, NY
Posts: 1,522
Thanks: 804
Thanked 165x in 107 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


"Hitting is better than sex." - Reggie Jackson

OOTP MLB & NCAA Caps & Jerseys
http://s1232.photobucket.com/profile/ashantewarrier
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 02:28 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