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 06-03-2011, 09:20 AM   #1 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Cē PCL Database

ctorg and myself are in the midst of compiling the data to create a Pacific Coast League 'lahman style' db for use with OOTP.

You can follow the progress here as we move through the 1903-1957 seasons of the PCL.
__________________


Cooleyvol is offline   Reply With Quote
5 thanks for this post:
AESP_pres (06-03-2011), jmm8356 (06-04-2011), mjj55409 (06-03-2011), No Pepper (06-03-2011), Rastafreaky (07-01-2011)
Old 06-04-2011, 08:46 AM   #2 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
UPDATE:

We have completed 1903-1919 and hope to have a test db for testing available soon.

We would like 2-3 people who would volunteer to test this initial database for us. If you're interested contact myself or ctorg. You could also post here.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-04-2011, 08:51 AM   #3 (permalink)
Hall Of Famer
 
spleen1015's Avatar
 
Join Date: Jan 2002
Location: Indianapolis, Indiana
Posts: 5,193
Thanks: 61
Thanked 132x in 78 posts
I'll help you test it.
__________________
GM Indianapolis 500s- Classic Baseball Union

The American Baseball Congress - a fictional/historical league dynasty currently in 1871
spleen1015 is offline   Reply With Quote
Old 06-10-2011, 01:55 PM   #4 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
UPDATE:

1903-1919 are complete and are being coverted to lahman db format for testing.


Data gathering has commenced on 1920-1929 and 1930-1939.

As far as 1920-1929 goes.........1920, 21, 22, 23, 24, and 25 are completed.

ctorg has 1930-39.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-10-2011, 02:49 PM   #5 (permalink)
Major Leagues
 
tarmer's Avatar
 
Join Date: May 2005
Location: Out in Leftfield
Posts: 361
Blog Entries: 1
Thanks: 14
Thanked 7x in 7 posts
Quote:
Originally Posted by Cooleyvol View Post
UPDATE:

We have completed 1903-1919 and hope to have a test db for testing available soon.

We would like 2-3 people who would volunteer to test this initial database for us. If you're interested contact myself or ctorg. You could also post here.
Mark - I can give it a shot if you like
tarmer is offline   Reply With Quote
Old 06-12-2011, 02:40 PM   #6 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
UPDATE:

1903-1909 -- Complete
1910-1919 -- Complete
1920-1929 -- Complete
1930-1939 -- Complete
1940-1949 -- Complete
1950-1957 -- Complete


It is hoped that all data will be mined this week, so we are hoping to have a test db very soon for those willing to help.

Thanks to Spleen/tarmer for volunteering to help us on that part of the project.
__________________



Last edited by Cooleyvol; 06-17-2011 at 03:01 PM.
Cooleyvol is offline   Reply With Quote
Old 06-15-2011, 03:13 PM   #7 (permalink)
All Star Reserve
 
Dr. P.R. Park III's Avatar
 
Join Date: Jul 2006
Posts: 761
Thanks: 76
Thanked 137x in 58 posts
Would it be possible to help test as well?
Dr. P.R. Park III is offline   Reply With Quote
Old 06-15-2011, 03:36 PM   #8 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Quote:
Originally Posted by Dr. P.R. Park III View Post
Would it be possible to help test as well?
Sure. That'll give us three testers plus ctorg and myself. We'll be in touch once I finish the 40s. I'm hoping by Thursday, all data mining will be finished. Its mined in a format very close to what we need it in in order to convert it to a lahman style db, so I don't anticipate much time after that.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-17-2011, 03:04 PM   #9 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
All data is gathered. We hope to have something for testing very soon, so if Spleen, Tony (have it already), and the Doc would PM their email addresses to me, I'll be in touch with a download link very soon.

Instructions on what we're looking for will also be included.


Thanks to you three for helping us work the kinks out (if there are any). This has been a very smooth process thusfar and I want to thank ctorg for helping out on the data side of this. I think we're going to provide something that many will find interesting to use in whatever way they choose to use it.
__________________


Cooleyvol is offline   Reply With Quote
Thank you for this post:
jmm8356 (06-18-2011)
Old 06-21-2011, 12:13 PM   #10 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Latest update is that the data is now in Access db form and has been sent to be 'Spritzinated'.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-21-2011, 01:34 PM   #11 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
I has questions that I have posed in a very long, boring and nearly pointless e-mail I sent you earlier today.

To all interested parties......the Lahman portion of the PCL database should take only a little time to complete BUT to add all the extra stuff OOTP12 requires to recreate history will take a small modicum of time. I did the easy one this morning so the PCL batting.csv is essentially done. The rest will take more time as they have a much larger number of funktions that need to funktion funktionally. Plus we've got to lay down the boogie.
Spritze is offline   Reply With Quote
Thank you for this post:
Kobeck (07-01-2011)
Old 06-21-2011, 01:50 PM   #12 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Quote:
Originally Posted by Spritze View Post
I has questions that I have posed in a very long, boring and nearly pointless e-mail I sent you earlier today.

To all interested parties......the Lahman portion of the PCL database should take only a little time to complete BUT to add all the extra stuff OOTP12 requires to recreate history will take a small modicum of time. I did the easy one this morning so the PCL batting.csv is essentially done. The rest will take more time as they have a much larger number of funktions that need to funktion funktionally. Plus we've got to lay down the boogie.
I do believe that I answered in that boring email you speak of. I tried to do it equally as boring.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-21-2011, 04:23 PM   #13 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
The question then becomes "Did you lay down that boogie til you die?"
Spritze is offline   Reply With Quote
Old 06-21-2011, 04:36 PM   #14 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Quote:
Originally Posted by Spritze View Post
The question then becomes "Did you lay down that boogie til you die?"
Still being alive, I am in the process.

"Driven to Tears" by the Police presently.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-21-2011, 06:54 PM   #15 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
Quote:
Originally Posted by Cooleyvol View Post
I do believe that I answered in that boring email you speak of. I tried to do it equally as boring.
One from this morning with 6 attachments?
Spritze is offline   Reply With Quote
Old 06-21-2011, 08:43 PM   #16 (permalink)
All Star Starter
 
Charlie Hough's Avatar
 
Join Date: May 2006
Posts: 1,880
Thanks: 58
Thanked 427x in 227 posts
Wow, this will be a phenomenal addition to OOTP! Is this database going to be real stats, neutralized, or will there be options for either one?
Charlie Hough is offline   Reply With Quote
Old 06-21-2011, 09:37 PM   #17 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
Real. Because the point is to have the PCL be on par with the Majors. Neutered to ML equivalents is possible though if more than nobody wanted/needed that.

Now who is going to do the International League?
Spritze is offline   Reply With Quote
Old 06-21-2011, 10:47 PM   #18 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Quote:
Originally Posted by Spritze View Post
One from this morning with 6 attachments?
I didnt receive an email with attachments.
__________________


Cooleyvol is offline   Reply With Quote
Old 06-24-2011, 08:02 PM   #19 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
If anyone is following the hillbilly construction of this......

The Lahman style Master and Batting and Pitching CSV files are complete.

Still to do..... Fielding (which I don't completely have yet)

AND The various OOTP additions to the Lahman files.
Spritze is offline   Reply With Quote
Old 06-24-2011, 08:21 PM   #20 (permalink)
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Woodland Mills, TN
Posts: 5,993
Thanks: 57
Thanked 506x in 304 posts
Quote:
Originally Posted by Spritze View Post
If anyone is following the hillbilly construction of this......

The Lahman style Master and Batting and Pitching CSV files are complete.

Still to do..... Fielding (which I don't completely have yet)

AND The various OOTP additions to the Lahman files.
I'm workin' on it, Chief.

Slavedriver
__________________


Cooleyvol 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:35 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