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 07-04-2011, 10:02 AM   #41
mikecos23
Minors (Single A)
 
mikecos23's Avatar
 
Join Date: Apr 2010
Location: Reading, PA, USA
Posts: 73
I was curious about this as well, if this would work for OOTP12 or not. Been thinking about running a complete history of baseball with the players randomly mixed up. Thanks!
mikecos23 is offline   Reply With Quote
Old 07-11-2011, 10:15 PM   #42
Mr. Capo
Minors (Triple A)
 
Mr. Capo's Avatar
 
Join Date: Jun 2006
Posts: 240
Quote:
Originally Posted by mikecos23 View Post
I was curious about this as well, if this would work for OOTP12 or not. Been thinking about running a complete history of baseball with the players randomly mixed up. Thanks!
Me too, please let us know if this is compatible with OOTP12.

Cross-era play (as in random debut) is my favorite way to play OOTP, and I've always wondered why there is not more support for it within the game and the community.
Mr. Capo is offline   Reply With Quote
Old 07-11-2011, 10:19 PM   #43
jonpfl
Minors (Triple A)
 
jonpfl's Avatar
 
Join Date: Jun 2011
Posts: 200
Quote:
Originally Posted by Mr. Capo View Post
Me too, please let us know if this is compatible with OOTP12.

Cross-era play (as in random debut) is my favorite way to play OOTP, and I've always wondered why there is not more support for it within the game and the community.
I think this should be an option in the game and not something that is a mod.

Does anyone know if the developers read the mod section?

Thx
jonpfl
jonpfl is offline   Reply With Quote
Old 07-11-2011, 10:34 PM   #44
Mr. Capo
Minors (Triple A)
 
Mr. Capo's Avatar
 
Join Date: Jun 2006
Posts: 240
Exactly! It should be an option within the game.

When I tell people about OOTP, their response is often, "oh, so you can have, like, Roger Clemens pitch to Babe Ruth..." or something like that. To many people, it's the most obvious appeal about a game like this.
Mr. Capo is offline   Reply With Quote
Old 07-13-2011, 10:25 AM   #45
Mr. Capo
Minors (Triple A)
 
Mr. Capo's Avatar
 
Join Date: Jun 2006
Posts: 240
Quote:
Originally Posted by jonpfl View Post
I think this should be an option in the game and not something that is a mod.

Does anyone know if the developers read the mod section?

Thx
jonpfl
This is a pretty quiet corner of the forums down here, and we're pretty deep in this thread. Easy to get overlooked. Maybe we should be lobbying for this feature loudly in the suggestions forum.
Mr. Capo is offline   Reply With Quote
Old 07-29-2011, 03:27 AM   #46
dcundy
Minors (Single A)
 
Join Date: Nov 2002
Posts: 71
does this work with 12

anyone know if the random database will work with 12??

also trying to modify database. Have always wanted to condense the whole span of majors to 50 years or so. Just a project i started when random database idea first surfaced. I would like to start sim around 1901 and then as sim continues import rookies from lets say years 1902-05 for second year's draft and 1905-1908 for third year's draft and then 1909-1912 for forth and so on. so instead of simming 130 years or so i could get them all in 50 years of simming. i know this is somewhat crazy but l'd like to be able to modify the random database to do this.

could have ruth, gehrig and possibly dimaggio on same yankees team for example or cobb, heilmann, greenberg on tigers team

i know there are best of databases or quick starts out there only dif with this setup is they would have entire careers in database

any one got any ideas how to achieve this??
dcundy is offline   Reply With Quote
Old 10-30-2011, 01:56 PM   #47
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,893
Blog Entries: 1
It doesn't appear to work with 12 when I tried.
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 11-03-2011, 04:27 PM   #48
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by molarmite View Post
It doesn't appear to work with 12 when I tried.
Database structure has changed for ver 12 so nuttin' for earlier versions will work without making structural changes that have structurally changed the database structures.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 11-03-2011, 08:26 PM   #49
Chicagofan76
Banned
 
Join Date: Oct 2009
Location: Diamond, IL
Posts: 6,339
Infractions: 2/2 (3)
Quote:
Originally Posted by Spritze View Post
Database structure has changed for ver 12 so nuttin' for earlier versions will work without making structural changes that have structurally changed the database structures.
I was able to convert my random DB from 11 to 12 (I still point to the 11 random DB stats folder)
Chicagofan76 is offline   Reply With Quote
Old 11-03-2011, 08:45 PM   #50
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,893
Blog Entries: 1
Quote:
Originally Posted by Chicagofan76 View Post
I was able to convert my random DB from 11 to 12 (I still point to the 11 random DB stats folder)
Would you be able to upload the file at all for us to download?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 11-03-2011, 08:59 PM   #51
Chicagofan76
Banned
 
Join Date: Oct 2009
Location: Diamond, IL
Posts: 6,339
Infractions: 2/2 (3)
Quote:
Originally Posted by molarmite View Post
Would you be able to upload the file at all for us to download?
I didnt make it. It was made for me by someone else. I have passed his name onto 2 other people so he could make a random DB for other people but it seems he doesnt want to.
Chicagofan76 is offline   Reply With Quote
Old 11-18-2011, 08:17 PM   #52
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,375
This is exclusively how I played 10. I had a league going for 7 seasons. I skipped 11. I have not been able to get it working with 12. Am so bummed.
bigMatt is offline   Reply With Quote
Old 11-19-2011, 03:16 AM   #53
Chicagofan76
Banned
 
Join Date: Oct 2009
Location: Diamond, IL
Posts: 6,339
Infractions: 2/2 (3)
Quote:
Originally Posted by bigMatt View Post
This is exclusively how I played 10. I had a league going for 7 seasons. I skipped 11. I have not been able to get it working with 12. Am so bummed.
well see if you can downlaod teh demo for 11 convert your season, then convert it again to 12, but make sure that the database shows where ever you put the Random DB in 10 and it should work. I had a Random DB made for me for 11, i converted it to 12 and it seems to work (i dont play it much)

Heres what my 12 database path says
C:\Documents and Settings\HP_Administrator.TODDPC\My Documents\Out of the Park Developments\OOTP Baseball 11\stats\RandomDB
Note: I have yet to get to another draft yet. but i dont expect problems
Chicagofan76 is offline   Reply With Quote
Old 11-19-2011, 10:18 PM   #54
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,375
Quote:
Originally Posted by Chicagofan76 View Post
well see if you can downlaod teh demo for 11 convert your season, then convert it again to 12, but make sure that the database shows where ever you put the Random DB in 10 and it should work. I had a Random DB made for me for 11, i converted it to 12 and it seems to work (i dont play it much)

Heres what my 12 database path says
C:\Documents and Settings\HP_Administrator.TODDPC\My Documents\Out of the Park Developments\OOTP Baseball 11\stats\RandomDB
Note: I have yet to get to another draft yet. but i dont expect problems
Thanks for the suggestion. I thought it worked - and it did, as far as the current season. But the next season rookie draft yielded only fictional players. The random file couldn't be read. Bah!
bigMatt is offline   Reply With Quote
Old 11-20-2011, 06:39 AM   #55
Chicagofan76
Banned
 
Join Date: Oct 2009
Location: Diamond, IL
Posts: 6,339
Infractions: 2/2 (3)
Quote:
Originally Posted by bigMatt View Post
Thanks for the suggestion. I thought it worked - and it did, as far as the current season. But the next season rookie draft yielded only fictional players. The random file couldn't be read. Bah!
i'll test mine later today
Chicagofan76 is offline   Reply With Quote
Old 11-20-2011, 11:56 AM   #56
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by bigMatt View Post
Thanks for the suggestion. I thought it worked - and it did, as far as the current season. But the next season rookie draft yielded only fictional players. The random file couldn't be read. Bah!
The database structure has changed for OOTP12.

When you convert a league it will only work for one year as you have found. Conversion only affects the active year.

That is because the conversion does not change the formats of any of the CSV or ODB files. Unless those are changed as well the game cannot progress.

I posted a D-I-Y on how to create your own Random DB for ANY version of OOTP, even ones that do not exist yet, a few months ago. Ones so generated will progress nicely.

It takes about 20 minutes to create such a db using the instructions once you get used to it and save the steps as Macros in spreadsheets. Expect 1 - 3 hrs the first time depending on when the light bulb gets lit up for you.

If you are good with databases and program one to do these steps it takes less than a minute to generate a random db and no two so generated will ever be the same.

I'd definately use neutered stats as your base/starting csv files. It puts cross-era players on the same level and a random db is one giant cross-era playground.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 11-20-2011, 02:06 PM   #57
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,893
Blog Entries: 1
Do you have the link for that step-by-step process?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 11-20-2011, 11:43 PM   #58
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,375
Quote:
Originally Posted by molarmite View Post
Do you have the link for that step-by-step process?

Here You Go
bigMatt is offline   Reply With Quote
Old 11-25-2011, 12:38 PM   #59
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Randon db for OOTP12 available. PM me for the ftp link.

I made 20 different ones but only put up one. If it plays OK I'll put up the rest.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze 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 05:46 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