Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > OOTP Mods > OOTP Mods - Database Tools
Register Blogs FAQ Calendar Today's Posts Search

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

Reply
 
Thread Tools
Old 10-12-2009, 11:33 PM   #1
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
Upated database for Final patch and FINAL update to GamboDB

This is a 2-part post so be sure to read the bottom part too...

First, I have finished up my database for when the final patch is released. Everything is ready to go and I am just waiting for the patch to be released so I can run a couple of tests to make sure everything works right. I will post it when it is ready.

Since I've had some time waiting for the patch to be released I have made two major changes with this release, thanks to Spritze.

1) I have added in an addtional 520+ players who are in Sprinze's database. This consists of Japanese players, Negro Leaguers and Career Minor league guys. This gives the database more depth, especially in the 1930s-1950s.
2) Updated the career fielding ratng information using Spritzes fielding information. I had hated that if you used career fielding information that the positions the payers were rated at was not complete. E.g. Danny Tartabull, Gary Sheffield etc came into the league as infielders but the game will not import them with ratings for that. I wanted to do something about that, but LO and BEHOLD. Spritze had already done it and tweaked much of the data.
I loved the results and decided to implement it.

Second of all,

Unless there is a major flaw in the database. This will be the last version of the GamboDB I will do. With twin year olds and a busy job I dont have any desire to put in the time to update and fix up the database any more. I just want to enjoy my kids and the game (and some others) The database has gotten to a point where I'm satisfied with it. Taking it to the next level of satisfaction would be too much.

Spritze's database work and abilities are closer to going the place I want my database to go than so I hope to work with him on updating his database but this will be the last one with my name as the major person.

Thanks for all the support.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 10-13-2009, 06:37 AM   #2
spleen1015
Hall Of Famer
 
spleen1015's Avatar
 
Join Date: Jan 2002
Posts: 5,951
Thanks for all of your hard work. You have brought a lot to the community. Good luck with those twins!
spleen1015 is offline   Reply With Quote
Old 10-16-2009, 11:22 AM   #3
clamel
All Star Starter
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 1,033
Are this DB then working with the new patch GAMBO ?????

Will you have to do changes to any files ????

Last edited by clamel; 10-16-2009 at 11:25 AM.
clamel is offline   Reply With Quote
Old 10-16-2009, 11:35 AM   #4
JoeRockHead
Major Leagues
 
JoeRockHead's Avatar
 
Join Date: Oct 2003
Location: NorthCarolina
Posts: 333
Thanks Gambo. I have really liked your data bases.
Good luck and god bless in your future endeavers in life. I as
a parent also know how hectic life can get as well.
__________________
Regards:John Nellis
JoeRockHead is offline   Reply With Quote
Old 10-16-2009, 12:42 PM   #5
timmermac
Major Leagues
 
Join Date: Feb 2004
Location: Portland, OR
Posts: 449
Has this been put on PadresFan's site yet?
__________________
Running with the 1950 Braves.

Crush the baseball. Drive it before you. And hear the lamentation of the opponent's women.

I am king of the diamond! Let there be a grand clubhouse feast! Bring me the finest meats and cheeses in all the land!
timmermac is offline   Reply With Quote
Old 10-16-2009, 07:12 PM   #6
PadresFan
All Star Starter
 
PadresFan's Avatar
 
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 1,151
Nope. I think Gambo wanted to run some tests with the patch that was just released before posting....
PadresFan is offline   Reply With Quote
Old 10-16-2009, 11:58 PM   #7
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
I am in the process of installing the patch and will run a couple of tests and will then put it up...

Here is the updated readme... I'll send it to Padres tonight if it checks out...
Attached Files
File Type: doc Gambo DB X readme.doc (49.5 KB, 641 views)
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 10-17-2009, 02:58 AM   #8
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
I have it up and running. I'm sending it to padres now.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 10-17-2009, 11:41 AM   #9
PadresFan
All Star Starter
 
PadresFan's Avatar
 
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 1,151
Posted!
PadresFan is offline   Reply With Quote
Old 10-19-2009, 05:15 AM   #10
clamel
All Star Starter
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 1,033
I looked it breifly over and I must ask a question

In all Master.csv files I found a player named Trey Hillman
obviously a minor leaguers with the ID hillmtr99m

Why can´t I find him in any batter,pitcher,fielder csv-file.
How will he come into the game ????

I understand that the master(mlb),csv makes players like Ichiro Suzuki drop into the league 2001 not in the early 1990´s and that the master.csv will bring in Suzuki, Irabu, Kuroda very early in their career, when they played in Japan.

However this Trey Hillman and the rest of the ID xxx99m is a question.

PS Never mind I guess all these guys are just as Hillman only managers and they could be left alone.

Last edited by clamel; 10-19-2009 at 07:22 AM.
clamel is offline   Reply With Quote
Old 10-20-2009, 12:35 AM   #11
phillosopherp
All Star Reserve
 
Join Date: Sep 2008
Posts: 512
will there have to be any chances for the next final patch? Just wondering if I should wait or just dl now?
__________________
Quote:
Originally Posted by satchel View Post
I'd much rather get screwed by the government than by a private company. One is necessary, the other an organ of greed.
phillosopherp is offline   Reply With Quote
Old 10-20-2009, 12:17 PM   #12
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
I havent found any yet. Seems to be working just fine.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 10-21-2009, 11:12 PM   #13
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Blog Entries: 25
I am trying to get a 1969 league started using the DB but the game crashes during the import. i was trying last night (3 times) so i don't have what ever error it gave me, i'll run it again and see what it was.

I have not had any problems with you other DB's in the past so i wonder if it's just me.
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 10-21-2009, 11:16 PM   #14
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Blog Entries: 25
Quote:
Problem signature:
Problem Event Name: APPCRASH
Application Name: ootp10.exe
Application Version: 2.0.0.0
Application Timestamp: 4ad73f8a
Fault Module Name: ootp10.exe
Fault Module Version: 2.0.0.0
Fault Module Timestamp: 4ad73f8a
Exception Code: c0000005
Exception Offset: 00488ae4
OS Version: 6.0.6002.2.2.0.256.1
Locale ID: 1033
Additional Information 1: c89a
Additional Information 2: 8686cffd0befdfaf23e358b244a26a52
Additional Information 3: d9bc
Additional Information 4: 1321c7fd5321101cafe9a0ecfc57bd0
player import at 42%

and thats all the information that i get from the error, the game just shuts down

i have tried various import settings with the same result.
i guess i'll try 68 & 70 for fun
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 10-21-2009 at 11:23 PM.
jazzrack is offline   Reply With Quote
Old 10-22-2009, 08:28 PM   #15
TribeWarpath
Minors (Single A)
 
TribeWarpath's Avatar
 
Join Date: Mar 2002
Location: Cleveland, OH
Posts: 55
Quote:
Originally Posted by jazzrack View Post
I am trying to get a 1969 league started using the DB but the game crashes during the import. i was trying last night (3 times) so i don't have what ever error it gave me, i'll run it again and see what it was.

I have not had any problems with you other DB's in the past so i wonder if it's just me.
I've been having the same issues with other years as well. It usually gets to anywhere from 40 to 45 percent before crashing.
TribeWarpath is offline   Reply With Quote
Old 10-22-2009, 09:25 PM   #16
bubba22plus
All Star Reserve
 
bubba22plus's Avatar
 
Join Date: Sep 2008
Location: Equestria
Posts: 808
Quote:
Originally Posted by jazzrack View Post
player import at 42%

and thats all the information that i get from the error, the game just shuts down

i have tried various import settings with the same result.
i guess i'll try 68 & 70 for fun
I tried importing 1969 also, same problem. Crashes at 42%.
__________________
OOTP Resident Brony
bubba22plus is offline   Reply With Quote
Old 10-22-2009, 10:32 PM   #17
AESP_pres
Hall Of Famer
 
AESP_pres's Avatar
 
Join Date: Jun 2007
Location: Province of Quebec
Posts: 3,708
Blog Entries: 25
No problem without the complete history, but crash with the complete history like the other at 42%.
AESP_pres is offline   Reply With Quote
Old 10-22-2009, 10:53 PM   #18
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
As the database gets larger the crash seems to come alot earlier. One tip I can definitely give you guys is go ahead and open the batting2.csv in notebook (backup first of course) and go ahead and delete up to about 20 years prior to your import.

E.G. if your importing 1969...open batting2.csv in notebook and delete until you get to 1949 (the first player idea that says 1949 after the 1st comma)

If that still doesn't get it to import (it will probably be quicker this way anyway) let me know.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 10-24-2009, 05:28 PM   #19
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Blog Entries: 25
Quote:
Originally Posted by Gambo View Post
As the database gets larger the crash seems to come alot earlier. One tip I can definitely give you guys is go ahead and open the batting2.csv in notebook (backup first of course) and go ahead and delete up to about 20 years prior to your import.

E.G. if your importing 1969...open batting2.csv in notebook and delete until you get to 1949 (the first player idea that says 1949 after the 1st comma)

If that still doesn't get it to import (it will probably be quicker this way anyway) let me know.
still crashed at 42

also crashed without trying to import history
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 10-25-2009, 12:31 AM   #20
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
Let me test what I have. It may just be corrupted .rar file.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Reply

Bookmarks


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 12:30 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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