Home | Webstore
Latest News: OOTP Update 20.5 - OOTP 20 Available - FHM 5 Available

Collection Missions for Perfect Team Released!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

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

Reply
 
Thread Tools
Old 04-30-2010, 01:30 PM   #61
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
Quote:
Originally Posted by ejbucs View Post
One player to check on.

Max Carey loaded in with the 1901 league. His birthday gets shown in game as 1/11/1900, which makes him 1 year old. His real birthday was 1/11/1890, which means that he shouldn't get loaded until 1908 for the 18 year old DB.
Thanks, I'll adjust his Birthdate in the Lahman stuff. You might also want to let them know of the error at baseball1.com as that is where major league players birthdates come from.
Spritze is offline   Reply With Quote
Old 04-30-2010, 07:04 PM   #62
Aumakua
Major Leagues
 
Join Date: Apr 2010
Location: Flat lands
Posts: 407
Thanks: 37
Thanked 146x in 88 posts
Quote:
Originally Posted by ejbucs View Post
As long as you don't select the "Retire players according to history" check in teh Gane Setup, they should play until they retire in-game.
but if the player keeps playing with no real life stats for the computer to calculate their ratings on, how is that handled? So if the guy was 30 years old in 1920 and has no stats after that year but you have the game recalculate every year based on real stats, what happens?

Thanks
Aumakua is offline   Reply With Quote
Old 04-30-2010, 11:25 PM   #63
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
Previous versions had the OOTP development engine take over for players not covered by recalc. This is possibly/probably/perhaps/maybe still in effect though I haven't had any time to check it out.
Spritze is offline   Reply With Quote
Old 05-01-2010, 01:55 AM   #64
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
The main file uploaded to padresfan site... does it have the Max Carey correction in it? Is there a way we can fix the rare error like this ourselves, if not?
Elysian Fields is offline   Reply With Quote
Old 05-01-2010, 08:15 AM   #65
plannine
All Star Reserve
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 526
Thanks: 20
Thanked 14x in 13 posts
Quote:
Originally Posted by Aumakua View Post
3) does the no asians file still have the negro league players? debating which way to go since I have no clue who the asian stars are other than the guys who played in MLB.

Thanks,
A good starting place to learn about them is here or Japanese baseball links


Once you learn a little about them, you'll start to love them (in both historic and current teams/players).
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel

Last edited by plannine; 05-01-2010 at 08:34 AM.
plannine is offline   Reply With Quote
Old 05-03-2010, 11:05 PM   #66
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Any update on the high school database (all players -white, black, brown, asian) you were working on? Not a lot of time to work on it, I'd imagine.

Looking forward to it.
Elysian Fields is offline   Reply With Quote
Old 05-05-2010, 04:12 PM   #67
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
High School Version is done as are a few others so I ran a sim-test and found I need to further cut the abilities of Asian players of the 80's and 90's. They are too good relative to major leaguers. The 30's through 70's look good as is. I'll be doing that this afternoon, so after I re-test it all should be good to go.

I also added all the new version 11 info and processes to the outputs and created the ability to make many different versions (college/real debuts, high school, Asian, non-asian etc) quickly.
Spritze is offline   Reply With Quote
Thank you for this post:
Elysian Fields (05-05-2010)
Old 05-05-2010, 05:22 PM   #68
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
Spritze, is there, or do you see any possibility of being able to run historical players thru a high school/college feeder system? I would like to start back in history and have all real players enter thru such a system. Using just mlb and negro lg players. no Japanese that didn't play in mlb with no fictional players at all
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room

Last edited by kagnew35; 05-05-2010 at 05:25 PM.
kagnew35 is offline   Reply With Quote
Old 05-06-2010, 12:00 AM   #69
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
I have never used feederers for anything but one might hope it might be workable.

Once I get the new Asian MLE formula tested I'll try it and see.

Made the Asian changes and the test sim is rolling along. Once that passes the my eyeball test I'll post the final High School and College\Real Life db's.
Spritze is offline   Reply With Quote
3 thanks for this post:
Elysian Fields (05-06-2010), kagnew35 (05-06-2010), plannine (05-06-2010)
Old 05-06-2010, 11:50 PM   #70
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
OK, the new high school versions are on the "secret" site.

Both the No Asians and the full version.

I'll do the collegiate version either Sat or Sun evening depending on how Mother's Day falls out.

The Zip files now contain BOTH the CSV's and the ODB file.

The full Stats folder with everything included has been zipped so players can change these files to suit their personalized needs.

Last edited by Spritze; 05-06-2010 at 11:53 PM.
Spritze is offline   Reply With Quote
4 thanks for this post:
Aumakua (05-07-2010), kagnew35 (05-07-2010), MrEndshiftresign (05-07-2010), spacer99 (05-07-2010)
Old 05-07-2010, 01:17 AM   #71
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
Started a 1939 lg, looks great, thank you
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room
kagnew35 is offline   Reply With Quote
Old 05-07-2010, 09:09 AM   #72
mikecos23
Minors (Single A)
 
mikecos23's Avatar
 
Join Date: Apr 2010
Location: Reading, PA, USA
Posts: 59
Thanks: 11
Thanked 2x in 2 posts
Spritze any chance I can get access to the file also? Sorry for some reason I can't PM on the board, just activated my account, been lurking for years...you can email me at michael.dicosimo@gmail.com...thanks, been looking forward to this db for a couple of weeks now, your db on OOTPX was great - thanks for all your hard work!
mikecos23 is offline   Reply With Quote
Old 05-07-2010, 04:23 PM   #73
Rainers
Minors (Single A)
 
Rainers's Avatar
 
Join Date: Apr 2002
Location: Renton, WA
Posts: 85
Thanks: 44
Thanked 24x in 15 posts
Spritze,

I know you probably hate people asking when is this going to be out or when is that going to be out; You are doing great work and we all should be patient. But...I am going to release the 4th grader in me and ask when the separate Asian (KBO and NPB split) databases will be ready. I have a universe on hold and it's burning a hole in my proverbial computer pocket.


Rainers

Last edited by Rainers; 05-07-2010 at 04:24 PM.
Rainers is offline   Reply With Quote
Old 05-07-2010, 07:12 PM   #74
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Negro Leaguers

Do you have to change their race? I was just playing around with this work of art last night briefly and I looked at Sol White... and well he was white.

Not a problem for me at all, but I was just wondering if that's the deal.
Elysian Fields is offline   Reply With Quote
Old 05-07-2010, 10:48 PM   #75
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
Quote:
Originally Posted by Rainers View Post
Spritze,

I know you probably hate people asking when is this going to be out or when is that going to be out; You are doing great work and we all should be patient. But...I am going to release the 4th grader in me and ask when the separate Asian (KBO and NPB split) databases will be ready. I have a universe on hold and it's burning a hole in my proverbial computer pocket.


Rainers
That DB is done I just didn't put it up because I didn't know if anyone was interested. Since you are, I'll upload it to the "secret site" Saturday night as I am out of town til then.
Spritze is offline   Reply With Quote
Old 05-07-2010, 10:50 PM   #76
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,145
Thanks: 305
Thanked 3,214x in 1,888 posts
Quote:
Originally Posted by Elysian Fields View Post
Do you have to change their race? I was just playing around with this work of art last night briefly and I looked at Sol White... and well he was white.

Not a problem for me at all, but I was just wondering if that's the deal.
Race is not contained in any of the OOTP DB's, mine or any other. There is not any field for it.
Spritze is offline   Reply With Quote
Old 05-07-2010, 11:16 PM   #77
Aumakua
Major Leagues
 
Join Date: Apr 2010
Location: Flat lands
Posts: 407
Thanks: 37
Thanked 146x in 88 posts
Spritze I sent you a PM asking for the site to download the file from and a question about editing the odb file.

I will ask it here too just incase someone else can help. For anyone editing the database file what program are you using? I tried open office but it will only open in their writer program and it is a mess.

thanks!
Aumakua is offline   Reply With Quote
Old 05-07-2010, 11:33 PM   #78
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 464
Thanks: 995
Thanked 186x in 111 posts
Quote:
Originally Posted by Spritze View Post
Race is not contained in any of the OOTP DB's, mine or any other. There is not any field for it.
Got it. Interesting.
Elysian Fields is offline   Reply With Quote
Old 05-08-2010, 01:57 AM   #79
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
Having teams with too few players, ie, 2003 Montreal with only 8 total???? At opening day, had large
FA pool??
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room
kagnew35 is offline   Reply With Quote
Old 05-08-2010, 01:59 AM   #80
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
Quote:
Originally Posted by Elysian Fields View Post
Do you have to change their race? I was just playing around with this work of art last night briefly and I looked at Sol White... and well he was white.

Not a problem for me at all, but I was just wondering if that's the deal.
If you dl and install the all in one mod, the facegen pics should be right, for those done so far.
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room
kagnew35 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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

Forum Jump


All times are GMT -4. The time now is 07:04 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments