Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

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

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

Reply
 
Thread Tools
Old 11-09-2012, 03:01 PM   #21
saturn2187
All Star Reserve
 
Join Date: Nov 2012
Posts: 514
Thanks: 217
Thanked 73x in 45 posts
How does one send a PM? Just wasted 20 minutes trying to figure it out!!
saturn2187 is offline   Reply With Quote
Old 11-09-2012, 08:24 PM   #22
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
Knowledge is power! I see you did figure it out. Now you are both more knowledgeable and more powerful than you were 20 minutes ago.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 11-10-2012 at 04:42 PM.
Spritze is offline   Reply With Quote
Old 11-09-2012, 10:53 PM   #23
saturn2187
All Star Reserve
 
Join Date: Nov 2012
Posts: 514
Thanks: 217
Thanked 73x in 45 posts
thank you.
saturn2187 is offline   Reply With Quote
Old 11-10-2012, 04:44 PM   #24
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
New Version put on the FTP this morning. Most additions pre-1920's.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 11-29-2012, 04:59 PM   #25
leafs.nation
Bat Boy
 
Join Date: Nov 2012
Location: Komoka, Ontario, Canada
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
OK...I'm pretty technically literate, but this PM thing has me baffled. I continue to get this message:

leafs.nation, you do not have permission to access this page. This could be due to one of several reasons:
  1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
  2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Any help would be appreciated so that I can get the DB link. Thanks!
leafs.nation is offline   Reply With Quote
Old 11-29-2012, 05:01 PM   #26
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Quote:
Originally Posted by leafs.nation View Post
OK...I'm pretty technically literate, but this PM thing has me baffled. I continue to get this message:

leafs.nation, you do not have permission to access this page. This could be due to one of several reasons:
  1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
  2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Any help would be appreciated so that I can get the DB link. Thanks!
You are a new user, new users probably have to wait till they can get PMs.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 11-29-2012, 05:09 PM   #27
leafs.nation
Bat Boy
 
Join Date: Nov 2012
Location: Komoka, Ontario, Canada
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
OK...in the meantime, how do I get the link for the DB? And how long do I have to wait?
leafs.nation is offline   Reply With Quote
Old 11-29-2012, 07:36 PM   #28
saturn2187
All Star Reserve
 
Join Date: Nov 2012
Posts: 514
Thanks: 217
Thanked 73x in 45 posts
i dont think its about being a new user. at least for me, it was just hard to find the 'send message' link. Click on the guys profile , and immediately under his icon you'll see the link.
saturn2187 is offline   Reply With Quote
Old 11-30-2012, 08:39 AM   #29
leafs.nation
Bat Boy
 
Join Date: Nov 2012
Location: Komoka, Ontario, Canada
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
saturn2187....genius. Not sure if that was there previously, but that did the trick! Greatly appreciated!!
leafs.nation is offline   Reply With Quote
Old 12-05-2012, 06:09 PM   #30
Torgo Johnson
Bat Boy
 
Join Date: Oct 2012
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
NOTE: I logged out and logged back in and now it works. Nevermind.

Last edited by Torgo Johnson; 12-05-2012 at 07:00 PM.
Torgo Johnson is offline   Reply With Quote
Old 02-18-2013, 11:17 PM   #31
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,961
Thanks: 409
Thanked 396x in 318 posts
Spritze:

I am doing a replay from 1901. I am now using OOTP13. I was using your DB for OOTP12 and when the amateur draft started in 1925 it only had 21 players in the draft pool. Now I have added your DB for OOTP13. How can I update the draft pool to include more players who turned 18 in 1925??

Thanks...
__________________




Jeff1787 is offline   Reply With Quote
Old 02-19-2013, 01:17 AM   #32
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
1925 should have about 200 players debuting so I'm thinking your game went haywire.

Back up to your last save and switch to a currenter db?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 02-19-2013, 01:42 AM   #33
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,961
Thanks: 409
Thanked 396x in 318 posts
The most current DB is yours for OOTP13. Unfortunately, my last back-up is from a long time ago. I guess my game is done. A lot of time down the tubes!!!
__________________




Jeff1787 is offline   Reply With Quote
Old 02-19-2013, 12:17 PM   #34
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
Last save not last backup. They are different things. By default the game saves every Dec 31st.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 02-22-2013, 01:03 PM   #35
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,961
Thanks: 409
Thanked 396x in 318 posts
Where is that last save located? I can't seem to find it. Also, at this point what I have done is to load your DB and then manually import most of the important players for 1925. 1926 and future years should import normally.

Jeff

PS I have a stupid question. Will the DB work for OOTP14? I think I know the answer!!
__________________




Jeff1787 is offline   Reply With Quote
Old 02-22-2013, 01:44 PM   #36
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
At this moment it is OOTP14 compatible. If something changes in 14 I'll change the db to match.

Save game is on the first or second menu on the left. I don't have the game in front of me as I am at work.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 02-23-2013, 01:12 PM   #37
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,961
Thanks: 409
Thanked 396x in 318 posts
Hi Spritze...Sorry to be a pest, but for the life of me I can't find a save file that you mentioned.

Jeff
__________________




Jeff1787 is offline   Reply With Quote
Old 03-14-2013, 02:45 PM   #38
Aumakua
Major Leagues
 
Join Date: Apr 2010
Location: Flat lands
Posts: 407
Thanks: 37
Thanked 146x in 88 posts
So what is the best way to set up a new game with this database? Real stats vs neutralized? Potential based on career totals vs 3 year averages recalculated every year or peak seasons?

Here is what I am trying to do:

-Start season in 1890 with a draft
-I want all players to be in the draft at a young age, including asian and black players, which is why I love this database
-Idealy I wanted players to progress on their own but based on how they did in real life. But I did not want injuries to effect their potential, for instance Griffey going downhill in Cincinatti because of constant issues, I want the game to base his potential on his prime which is why I was thinking "peak seasons" but then I don't really want a Roger Maris to be a top 10 all time player because of that... If I recalculate then someone like Griffey will fall apart just like he did in real life.

any suggestions on what settings to use?
I wish there was a "Based on career" for potential that used their AVERAGES per at bat to calculate, so players who had careers cut short would not be hurt because of lower career numbers.
Aumakua is offline   Reply With Quote
Old 03-17-2013, 10:44 PM   #39
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,174
Thanks: 310
Thanked 3,228x in 1,897 posts
I use 3 year recalc and Griff had 686 HR's last time so Cincinnati didn't mess with him too much.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-19-2013, 11:04 AM   #40
Aumakua
Major Leagues
 
Join Date: Apr 2010
Location: Flat lands
Posts: 407
Thanks: 37
Thanked 146x in 88 posts
Quote:
Originally Posted by Spritze View Post
I use 3 year recalc and Griff had 686 HR's last time so Cincinnati didn't mess with him too much.

What is the difference between loading the database from the "master" file versus the .obd (or whatever the extension is)?

I understand if I load from the master file I can edit stuff myself because it will then read each file in that folder, but if I load by .obd it doesn't use any of those files because its all compiled in that single file. But are there advantages to using one over the other in the game?

thanks,
Aumakua is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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 03:15 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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

 

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