|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
10-12-2009, 11:33 PM | #1 |
Hall Of Famer
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 |
10-13-2009, 06:37 AM | #2 |
Hall Of Famer
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!
|
10-16-2009, 11:22 AM | #3 |
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. |
10-16-2009, 11:35 AM | #4 |
Major Leagues
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 |
10-16-2009, 12:42 PM | #5 |
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! |
10-16-2009, 07:12 PM | #6 |
All Star Starter
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....
|
10-16-2009, 11:58 PM | #7 |
Hall Of Famer
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...
__________________
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 |
10-17-2009, 02:58 AM | #8 |
Hall Of Famer
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 |
10-17-2009, 11:41 AM | #9 |
All Star Starter
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 1,151
|
Posted!
|
10-19-2009, 05:15 AM | #10 |
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. |
10-20-2009, 12:35 AM | #11 |
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?
|
10-20-2009, 12:17 PM | #12 |
Hall Of Famer
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 |
10-21-2009, 11:12 PM | #13 |
Hall Of Famer
|
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 |
10-21-2009, 11:16 PM | #14 | |
Hall Of Famer
|
Quote:
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. |
|
10-22-2009, 08:28 PM | #15 | |
Minors (Single A)
Join Date: Mar 2002
Location: Cleveland, OH
Posts: 55
|
Quote:
|
|
10-22-2009, 09:25 PM | #16 |
All Star Reserve
Join Date: Sep 2008
Location: Equestria
Posts: 808
|
I tried importing 1969 also, same problem. Crashes at 42%.
__________________
OOTP Resident Brony |
10-22-2009, 10:53 PM | #18 |
Hall Of Famer
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 |
10-24-2009, 05:28 PM | #19 | |
Hall Of Famer
|
Quote:
also crashed without trying to import history
__________________
. "Never confuse composure for ease" Was once Head Cheese of Corporate League Baseball |
|
10-25-2009, 12:31 AM | #20 |
Hall Of Famer
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 |
Bookmarks |
|
|