Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 09-10-2010, 08:07 AM   #261
3fbrown
Major Leagues
 
Join Date: May 2008
Posts: 414
Quote:
Originally Posted by Bristolduke View Post
In your set up when is the first year player draft held? I seem to recall if it is held before the season (maybe during) that it exhausts the pool and then generates fictional players. I always run historical drafts in November. That would be my first thought.

Second thought would be, in what year did the first fictional player occur (e.g. was there a or more fictional players in 1902) and what was the last real player taken. That might point to a bad record in the DB(the players taken for that year will need to be looked at alphabetically to find the bad record). Once it gets an error it will just stay with fictional.
I always have my first year player draft on Christmas day - it is easy to remember, and I know I have to have it before Jan 1.

Every player taken in the 1902 draft was real, and every player taken in the 1903 draft was fictional.

I have an idea though, thanks to this suggestion. I edited the debut dates in master.csv, but that is all I edited. I did not touch the batting.csv, etc. The first guy in the 1903 draft (alphabetically) should have been Ed Abbaticchio, who was edited, so maybe that screwed things up. I will try changing all of his information to see if that helps. I don't know why it wasn't a problem in 1902 though, there were plenty of guys that got pushed back to 1902.
3fbrown is offline   Reply With Quote
Old 09-10-2010, 08:51 AM   #262
3fbrown
Major Leagues
 
Join Date: May 2008
Posts: 414
It wasn't Abbaticchio causing the problem - I deleted the appropriate lines from the data files, and it didn't change anything.

All I did was adjust some debut dates and delete some guys from the master.csv file entirely. I tried simulating with the unedited files minus the .odb) and that worked OK.

I'll keep experimenting, but any ideas are welcome.

Should I move this to a new thread? I didn't mean to hijack...
3fbrown is offline   Reply With Quote
Old 09-12-2010, 05:46 PM   #263
wallball
Minors (Single A)
 
wallball's Avatar
 
Join Date: Jun 2008
Posts: 97
Hey guys, I've been reading this thread for a couple of hours and have tried a few times on my own but still can't figure it out. Is there any sort of Spritze/Gambo 101 thread? All I'm trying to do is play a historical league where guys enter the draft at the same year they entered the minors.
However every time I try I end up with a bunch of fictional players.
__________________
-------------------------------------------
USBL United States Baseball League

WBL World Baseball League





Last edited by wallball; 09-12-2010 at 05:48 PM.
wallball is offline   Reply With Quote
Old 09-12-2010, 11:19 PM   #264
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
This is more like Gambo/Sprize 0 level

1) Download either Spritze or Gambo database from Padres site.
2) Extract .rar file (.rar is like a .zip file) to the /stats directory (or any other one)
3) Enter OOTP11
4) Create historical league
5) Point to the historicaldatabase.odb file you downloaded/extracted
6) Pick your year, neutralized stats, fielding by 3 year (or career)
7) Go ahead and play...
__________________
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 09-13-2010, 05:04 PM   #265
wallball
Minors (Single A)
 
wallball's Avatar
 
Join Date: Jun 2008
Posts: 97
Thanks. The strange thing is that it only seems to give me real players when I use the master.csv file. The historical_database.odb file gives me fictional players.
__________________
-------------------------------------------
USBL United States Baseball League

WBL World Baseball League




wallball is offline   Reply With Quote
Old 09-16-2010, 07:25 PM   #266
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Version 11.3 is now available

The R, L, B thing has been fixed, all players whose major league careers ended between 1943 and 1977 have been finished with their full minor league MLE's added. Changed the MLE formulas a little bit to make players in unfinished years a bit worse per Gambo's recommendation. Changed the yearly minor league fielding neutralization a little bit as well, to make minor league fielders a little bit better.

All Korean players of the 80's have had a first pass taken at filling out their records.

All in all it plays really well 1871 on. Which is sorta the point.

Available on the secret site and at Padre's pretty soon.
Spritze is offline   Reply With Quote
Old 09-17-2010, 11:43 AM   #267
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
I'll fix up my version and get that posted somewhat shortly.
__________________
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 09-17-2010, 04:01 PM   #268
pucku33
Major Leagues
 
Join Date: Aug 2009
Posts: 323
I started a new league using 1995 as my starting point, and simulated throughout 2010 to see if everything would work properly before i began my journey through history.

When I reached the mid-2000's I noticed that alot of the rookies were missing from the draft. The real life 2007-08-09-10 rookies were not there or were very rare. No strasburg also. Any idea how I can get a roster that will import all historical rookies into the draft up until the 2010 season? I love the fact that you can get players when they are 18, that is pure genius! Just wondering why the newer players are not there. Thanks
__________________
Come visit my Youtube channel!
pucku33 is offline   Reply With Quote
Old 09-18-2010, 01:13 AM   #269
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The 2010 rookies will be there NEXT year as of Dec 2009 they were not major league players.

I spot checked the rest and the other years are there, most of them still in the minors.
Spritze is offline   Reply With Quote
Old 09-18-2010, 01:03 PM   #270
pucku33
Major Leagues
 
Join Date: Aug 2009
Posts: 323
Quote:
Originally Posted by Spritze View Post
The 2010 rookies will be there NEXT year as of Dec 2009 they were not major league players.

I spot checked the rest and the other years are there, most of them still in the minors.
i appreciate your response and hard work with the mods sir. I notice that if I start a new 2010 league, all the rookies (07,08,09, etc) are there. however, when simming up to 2010, they are not in the drafts. unless you are stating that since they were not in the majors as of dec 09 that they are not in the mod that was provided. I was quick to assume that since the "high school" mod had players joining at 18 and below that all rookies would be included as well. Is there anyway to add them in? I would like to be able to draft them when I hit the mid 2000's. Thanks.
__________________
Come visit my Youtube channel!
pucku33 is offline   Reply With Quote
Old 09-18-2010, 01:08 PM   #271
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Any players who debuted in 2010 are not in the mod.

Players who debuted in the major leagues before 2010 are in the db or at least the ones I checked are.
Spritze is offline   Reply With Quote
Old 09-18-2010, 02:56 PM   #272
pucku33
Major Leagues
 
Join Date: Aug 2009
Posts: 323
Quote:
Originally Posted by Spritze View Post
Any players who debuted in 2010 are not in the mod.

Players who debuted in the major leagues before 2010 are in the db or at least the ones I checked are.
is there a way to get the rookies that have not debuted before 2010 in the mod?
__________________
Come visit my Youtube channel!
pucku33 is offline   Reply With Quote
Old 09-25-2010, 12:21 AM   #273
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
I am finishing up the final touches on my version (real debut / real teams). This should be available pretty soon.

(and no there are no 2010 rookies)
__________________
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 09-27-2010, 12:19 AM   #274
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,388
I finished up and sent it to Padres. Once his site is back up it should be there. Here's to waiting!
__________________
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-10-2010, 03:52 PM   #275
bronco6710
Minors (Single A)
 
bronco6710's Avatar
 
Join Date: May 2003
Posts: 59
Hey guys, I'm thinking about stepping outside of the basic Lahman DB and using a custom DB for the next historical league I start. There's a lot of DB's to sort through so I thought I'd ask a couple questions.

1. What is the main difference between the Gambo/Spritze DB and the Spritze High School DB? Is it just the age 18 thing for entering the league?

2. What are the "Real Team" Spritze DBs (I'm looking at the database list on PadresFan), and are those only for use without the amateur draft?

3. Are there still any randomized (random debut year) databases available for use with OOTP 11? If not, is there a utility or some other way to randomize the debut years in a database?

Thanks.
bronco6710 is offline   Reply With Quote
Old 10-11-2010, 08:36 AM   #276
Bristolduke
All Star Starter
 
Join Date: May 2006
Posts: 1,409
I'll let Gambo/Spritze discuss the differences. Also, in the Spritze case I think only the HS has beed updated on Padres fan (again Spritze can confirm), the older versions had some issues which I believe he has fixed.

With respect to the random DB, until this last patch is released (the beta is available), randomized DB in 11 was not really practical. It appears that it will be fixed with the official patch release. The random DB tool (elsewhere on this forum) will not work with X or 11 (too many new fieelds have been added). I had been trying to create random DB for folks who request them and will do that again once the patch is out. PM me if you are interested.
__________________
Commish of the Home Nations Baseball Association
Commish of the Baseball Association League
Commish of the League of WAR
Commish of the On-Line Dynasty League
SIMBL2 - Westbury Cannons
Great Lakes Baseball - Toledo Neptunes
World Baseball - Guantanamo Marines
OMLB - Cincinnati Reds
Bristolduke is offline   Reply With Quote
Old 10-13-2010, 12:51 PM   #277
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by bronco6710 View Post
Hey guys, I'm thinking about stepping outside of the basic Lahman DB and using a custom DB for the next historical league I start. There's a lot of DB's to sort through so I thought I'd ask a couple questions.

1. What is the main difference between the Gambo/Spritze DB and the Spritze High School DB? Is it just the age 18 thing for entering the league?

2. What are the "Real Team" Spritze DBs (I'm looking at the database list on PadresFan), and are those only for use without the amateur draft?

3. Are there still any randomized (random debut year) databases available for use with OOTP 11? If not, is there a utility or some other way to randomize the debut years in a database?

Thanks.
1. That is the main difference but not the only difference.
2. Gambo/Spritze db is the latest ver of the Real Team db.
3. Not as far as I know.
Spritze is offline   Reply With Quote
Old 10-16-2010, 03:17 PM   #278
plannine
All Star Reserve
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 567
re-thinking comment
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel

Last edited by plannine; 10-16-2010 at 03:31 PM.
plannine is offline   Reply With Quote
Old 12-05-2010, 12:24 AM   #279
reflections
Minors (Double A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 174
Having a couple issues, I had a pseudo historical/fictional world starting in 1871 that worked good with Gambo/Spritze latest off of PadreFans site. I looked over the Spritze High School latest and found that it would be more of what I needed. So I downloaded that, but the first time I tried to restart a historical world, it gave me 36 players. Then I tried it one more time and it gave me 115 players, when I look at the database it has far more players that should be coming in when I start it up in 1871. Any ideas and any help will be much appreciated.
reflections is offline   Reply With Quote
Old 12-05-2010, 02:59 PM   #280
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
I wish I could help you out my Mogul friend who is sustained by Guinness. I would like to welcome you over to OOTP though.

I have never used the Spritzey High School db before. I have one thought (at a time; two is too many) though and that would be to check what database you are pointing to when you tell the game to load up either the historical database or the Master. Is it the one that came with the game? That one will give you 115, because that's how many players debuted in 1871. The Gambo/Spritze db and the Spritze High School db should be giving you hundreds more, when you startup on 01/01/1871.

Did you perhaps overwrite the stats folder in the OOTP11 Baseball folder when you downloaded the Gambo/Spritze and then overwrite the Gambo/Spritze when downloading the Spritzey High School? The best way to avoid this is to copy/paste the stats folder itself into say the Out of the Park Developments folder in My Documents (Documents with Windows 7), rename it something like "Default", so you'll know the difference between databases and then cut/paste it back into the stats folder. Once you've done that you can get rid of the 28 files (26 csv files, 1 odb file, 1 text file) within the stats folder apart from the Default folder that you just copied/created. Keep the Default folder and get rid of the rest. Then create a folder called: "Gambo/Spritze" and extract the Gambo/Spritze files from their zip file into it. Same thing for the Spritze High School. You now have three different databases to play with. Just be sure to point to the right one when you're setting up a game.

If you over wrote the stats folder don't worry. It's not as big a deal this year as it was in previous years when you had to uninstall/reinstall. You have a zip file called "stats" in My Computer (Computer if you have Windows 7) > Local Disk (C: ) [looks stupid because a close bracket has to be separated from a colon, otherwise you get a ] > Program Files (Program Files (x86) with Windows 7) > Out of the Park Developments > OOTP Baseball 11 > default_data. Extract the stats zip file in there to your "Default" folder within your stats folder to overwrite what you may or may not have overwritten with the other two downloads...And voila...Three databases. Now off you go until you reach the next fork in the massive learning curve involved in this game. I spent all of my time with OOTPX (quite a bit of time with OOTP11 too!) just learning all the different options and figuring out how I wanted to play. Not time wasted though. Complex? Yes. At times unwieldy and frustrating? Yes. Great game? Yes, once you get it to do what you want it to do, which takes time.

Once again, welcome to the OOTP boards and just for future reference, despite the fact that this is a database issue, you probably would've gotten more traffic (and thus more potential respondents) in the General Discussions sub-forum. Let the mods move it if they want to. That's fine, but if you want help in a more timely fashion, that's probably where you should post. Keep asking those questions - no such thing as a stupid one. You'll get there eventually. Drop me a PM anytime if there's something you don't want to ask on the boards. Cheers.

Last edited by actionjackson; 12-05-2010 at 03:15 PM.
actionjackson 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 07:35 PM.

 

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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments