|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
All Star Starter
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,659
Thanks: 26
Thanked 426x in 221 posts
|
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.
__________________
OOTP Mods: OOTPXI Historical Face Gen Project http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html Spritze/Gambo Database http://web.mac.com/sixwilsons/OOTPMo...Databases.html OOTP Stadium Chart and Ballpark Images http://web.mac.com/sixwilsons/OOTPMo...Ballparks.html MLB Compiled Uniform & Logo Pack http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html |
|
|
|
| 19 thanks for this post: | AESP_pres (10-13-2009), attackemu (10-24-2009), bubba22plus (10-13-2009), bulldog55 (12-19-2009), cameron (10-13-2009), Captain Walrus (10-26-2009), darkcloud4579 (10-16-2009), Difar (10-13-2009), endgame (10-16-2009), golander40 (10-12-2009), gollum65 (11-04-2009), jtb (10-19-2009), kagnew35 (01-13-2010), Mt Fire Fighter (10-13-2009), phillosopherp (10-20-2009), Pronkytonk (10-19-2009), Scott Vibert (10-26-2009), silvam14 (10-16-2009), TribeWarpath (10-15-2009) |
|
|
#4 (permalink) |
|
Major Leagues
Join Date: Oct 2003
Location: NorthCarolina
Posts: 330
Thanks: 3
Thanked 5x in 5 posts
|
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 |
|
|
|
|
|
#6 (permalink) |
|
All Star Starter
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 1,150
Thanks: 75
Thanked 270x in 120 posts
|
Nope. I think Gambo wanted to run some tests with the patch that was just released before posting....
|
|
|
|
| Thank you for this post: | golander40 (10-16-2009) |
|
|
#7 (permalink) |
|
All Star Starter
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,659
Thanks: 26
Thanked 426x in 221 posts
|
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...
__________________
OOTP Mods: OOTPXI Historical Face Gen Project http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html Spritze/Gambo Database http://web.mac.com/sixwilsons/OOTPMo...Databases.html OOTP Stadium Chart and Ballpark Images http://web.mac.com/sixwilsons/OOTPMo...Ballparks.html MLB Compiled Uniform & Logo Pack http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html |
|
|
|
| Thank you for this post: | golander40 (10-17-2009) |
|
|
#8 (permalink) |
|
All Star Starter
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,659
Thanks: 26
Thanked 426x in 221 posts
|
I have it up and running. I'm sending it to padres now.
__________________
OOTP Mods: OOTPXI Historical Face Gen Project http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html Spritze/Gambo Database http://web.mac.com/sixwilsons/OOTPMo...Databases.html OOTP Stadium Chart and Ballpark Images http://web.mac.com/sixwilsons/OOTPMo...Ballparks.html MLB Compiled Uniform & Logo Pack http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html |
|
|
|
| 2 thanks for this post: | AESP_pres (10-17-2009), CBLCardinals (10-22-2009) |
|
|
#10 (permalink) |
|
All Star Reserve
Join Date: Apr 2008
Location: Sweden
Posts: 664
Thanks: 35
Thanked 4x in 2 posts
|
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. |
|
|
|
|
|
#12 (permalink) |
|
All Star Starter
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,659
Thanks: 26
Thanked 426x in 221 posts
|
I havent found any yet. Seems to be working just fine.
__________________
OOTP Mods: OOTPXI Historical Face Gen Project http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html Spritze/Gambo Database http://web.mac.com/sixwilsons/OOTPMo...Databases.html OOTP Stadium Chart and Ballpark Images http://web.mac.com/sixwilsons/OOTPMo...Ballparks.html MLB Compiled Uniform & Logo Pack http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html |
|
|
|
|
|
#13 (permalink) |
|
Hall Of Famer
Join Date: Oct 2003
Location: still kicking
Posts: 2,098
Thanks: 9
Thanked 34x in 21 posts
|
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.
__________________
Corporate League Baseball is back! teams avail! "Toleration is not the opposite of intolerance but the counterfeit of it. Both are despotisms: the one assumes to itself the right of withholding liberty of conscience, the other of granting it." (Thomas Paine, The Rights of Man, p. 58. "When school children start paying union dues, that's when I'll start representing the interests of school children." -Albert Shanker, President, American Federation of Teachers |
|
|
|
|
|
#14 (permalink) | |
|
Hall Of Famer
Join Date: Oct 2003
Location: still kicking
Posts: 2,098
Thanks: 9
Thanked 34x in 21 posts
|
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
__________________
Corporate League Baseball is back! teams avail! "Toleration is not the opposite of intolerance but the counterfeit of it. Both are despotisms: the one assumes to itself the right of withholding liberty of conscience, the other of granting it." (Thomas Paine, The Rights of Man, p. 58. "When school children start paying union dues, that's when I'll start representing the interests of school children." -Albert Shanker, President, American Federation of Teachers Last edited by jazzrack; 10-21-2009 at 11:23 PM. |
|
|
|
|
|
|
#15 (permalink) | |
|
Minors (Rookie Ball)
Join Date: Mar 2002
Location: Cleveland, OH
Posts: 49
Thanks: 16
Thanked 1x in 1 post
|
Quote:
|
|
|
|
|
|
|
#18 (permalink) |
|
All Star Starter
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,659
Thanks: 26
Thanked 426x in 221 posts
|
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.
__________________
OOTP Mods: OOTPXI Historical Face Gen Project http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html Spritze/Gambo Database http://web.mac.com/sixwilsons/OOTPMo...Databases.html OOTP Stadium Chart and Ballpark Images http://web.mac.com/sixwilsons/OOTPMo...Ballparks.html MLB Compiled Uniform & Logo Pack http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html |
|
|
|
|
|
#19 (permalink) | |
|
Hall Of Famer
Join Date: Oct 2003
Location: still kicking
Posts: 2,098
Thanks: 9
Thanked 34x in 21 posts
|
Quote:
![]() also crashed without trying to import history
__________________
Corporate League Baseball is back! teams avail! "Toleration is not the opposite of intolerance but the counterfeit of it. Both are despotisms: the one assumes to itself the right of withholding liberty of conscience, the other of granting it." (Thomas Paine, The Rights of Man, p. 58. "When school children start paying union dues, that's when I'll start representing the interests of school children." -Albert Shanker, President, American Federation of Teachers |
|
|
|
|
|
|
#20 (permalink) |
|
All Star Starter
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,659
Thanks: 26
Thanked 426x in 221 posts
|
Let me test what I have. It may just be corrupted .rar file.
__________________
OOTP Mods: OOTPXI Historical Face Gen Project http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html Spritze/Gambo Database http://web.mac.com/sixwilsons/OOTPMo...Databases.html OOTP Stadium Chart and Ballpark Images http://web.mac.com/sixwilsons/OOTPMo...Ballparks.html MLB Compiled Uniform & Logo Pack http://web.mac.com/sixwilsons/OOTPMo...Gen_Files.html |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|