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 07-30-2012, 03:58 PM   #461
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,378
I cannot get to this DB. Even after I set up an Apple ID, the MobilMe site would not allow me entry in order to download the DB. Any other access point?
bigMatt is offline   Reply With Quote
Old 08-02-2012, 01:36 PM   #462
clamel
All Star Starter
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 1,037
I am going to have a go with your DB , new HS for 13.

However
I would like to have answers to these Questions.

I will start my game in 1987 (for whatever reasons ;-) )
I will have amateur drafts every year from that year of 1987.

Now to get it correct at what time will I set the draft date to ??
(I hread about some november dates ?)

I will assume that a player like Ken Griffey Jr will be available to be drafted this year in 1987. No doubt on that, but since HS players are included some players that in RL was drafted later could be on the available list already in 1987, OR ?

Similar we have Chipper Jones that was drafted out of HS in 1990, but in your DB he could then make himself (how) unavailable and pop up 4 years later after his college years.

Is this really the case ???

We also have the effect that a newly drafted player doesn´t get signed correctly and could then perhaps go off to college. Will he later pop up again or just drift into oblivia ?
Manny Ramirez out of HS in 1991 as in RL, or 4 years later, or what ??

Since some OOTP11 or 12 drafted players need to be signed, so some effect must be obvious.

I agree it would be easier to just permit players pop up with their "correct" team when they really did.

I understand that Triple, Double and Single A leagues are needed, but what about Rookie Ball ???


Any more hints on how to set this up without surprises down the road ??

Ex. Financials that looks strange. I found out that OOTP lowest ML salary for 1987 is 114000, but in RL it was 62500 I think.
clamel is offline   Reply With Quote
Old 08-02-2012, 02:49 PM   #463
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by clamel View Post
Now to get it correct at what time will I set the draft date to ??
(I hread about some november dates ?)
OOTP defaults to after the Whirled Series.


Quote:
Originally Posted by clamel View Post
I will assume that a player like Ken Griffey Jr will be available to be drafted this year in 1987. No doubt on that, but since HS players are included some players that in RL was drafted later could be on the available list already in 1987, OR ?

Similar we have Chipper Jones that was drafted out of HS in 1990, but in your DB he could then make himself (how) unavailable and pop up 4 years later after his college years.

Is this really the case ???

We also have the effect that a newly drafted player doesn´t get signed correctly and could then perhaps go off to college. Will he later pop up again or just drift into oblivia ?
Manny Ramirez out of HS in 1991 as in RL, or 4 years later, or what ??

Since some OOTP11 or 12 drafted players need to be signed, so some effect must be obvious.

I agree it would be easier to just permit players pop up with their "correct" team when they really did.

I understand that Triple, Double and Single A leagues are needed, but what about Rookie Ball ???


Any more hints on how to set this up without surprises down the road ??

Ex. Financials that looks strange. I found out that OOTP lowest ML salary for 1987 is 114000, but in RL it was 62500 I think.
All of the questions noted above mostly depend on your choices and how you play the game.

If you have a draft players can make their pro debut after HS or go play college ball for a while or they may or may not sign with you and wait for the next draft. It all just depends.

You might also investigate Gambo's Pro Debut database as an alternative to the High School Graduates database. It is a different take on a similar theme.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-02-2012, 03:18 PM   #464
clamel
All Star Starter
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 1,037
Quote:
Originally Posted by Spritze View Post
OOTP defaults to after the Whirled Series.




All of the questions noted above mostly depend on your choices and how you play the game.

If you have a draft players can make their pro debut after HS or go play college ball for a while or they may or may not sign with you and wait for the next draft. It all just depends.

You might also investigate Gambo's Pro Debut database as an alternative to the High School Graduates database. It is a different take on a similar theme.
Hmm Whirled Series ???
So 1987 draft should be after, I assume World Series, so that Ken Griffey can then be picked after the 1987 season. Am I correct on this ??

What depends on if a player starts his pro-career after HS or College ??
(The DB yours or Gambos, not something hidden)

As I understand and have seen Gambo have their true pro-debut. Then your DB has ALL players after HS coming in no options and Gambo has a mixed set as in RL.

Thanks in all cases for these outstanding jobs.
clamel is offline   Reply With Quote
Old 08-02-2012, 04:14 PM   #465
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by clamel View Post
Hmm Whirled Series ???
So 1987 draft should be after, I assume World Series, so that Ken Griffey can then be picked after the 1987 season. Am I correct on this ??.
YES

Quote:
Originally Posted by clamel View Post
What depends on if a player starts his pro-career after HS or College ??
(The DB yours or Gambos, not something hidden).
OOTP decides if you have a draft. No draft = you decide?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-02-2012, 04:27 PM   #466
clamel
All Star Starter
 
Join Date: Apr 2008
Location: Across the Pond
Posts: 1,037
Quote:
Originally Posted by Spritze View Post
YES

OOTP decides if you have a draft. No draft = you decide?
I tested a fast one with drafts 1 nov as default.
Ken Griffey popped up in Seattle Mariners direct jan 1 1987, so I guess he will not be in the draft upcoming Nov 1987, which he should be.

What´s wrong in this. Or is it the 1988 drafted players that pops up in nov -87 ?

Also a bit sad over the handling of Major League Service time and options. It kind of getting out of hand with neutralized stats.
Any way to fix this ??? Those options and how long MLservice time is crucial for contracts.
Also if being able to drop a player from 25-man squad.

Last edited by clamel; 08-02-2012 at 04:30 PM.
clamel is offline   Reply With Quote
Old 08-02-2012, 07:18 PM   #467
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by clamel View Post
. Or is it the 1988 drafted players that pops up in nov -87 ?.
Yes

Quote:
Originally Posted by clamel View Post
.
Also a bit sad over the handling of Major League Service time and options. It kind of getting out of hand with neutralized stats.
Any way to fix this ??? Those options and how long MLservice time is crucial for contracts.
Also if being able to drop a player from 25-man squad.
These items are just how OOTP rolls. It has no options for a minor league database so it makes many incorrect assumptions.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-06-2012, 11:41 AM   #468
jhart05
Major Leagues
 
jhart05's Avatar
 
Join Date: Feb 2012
Location: Milwaukee, WI
Posts: 315
Has anyone recently set up a league around 1973 using the Spritze DB? If so, can you check something for me?

I'm seeing an issue with fielding ratings given when first creating the league.

For example Dave May. He's on Baltimore in 1973. Played over half his games over his career in CF. However the game isn't giving him any rating in CF when I start it up. A Zero for experience when I go into the editor. This makes me wonder how many more players have this issue.

I've verified my options are correct, neutralized stats and all that. I've verified I have it pointed to the Spritze DB. I'm using the "full career" option (not at home, forget the actual term in the game) when creating fielding ratings and pitchers endurance. I've also tried it using the 3-year option. Same deal.

When I set up 1973 using the default OOTP DB, he is given a CF rating. So I know the game itself is fine. It has to be something off with the DB.

Any ideas?

I would really like to use this DB, but I see this as a game braking error for me. Yes, I'm aware I can edit any player. But I'm really not interested in checking all 3,000 or so players.

Last edited by jhart05; 08-06-2012 at 11:42 AM.
jhart05 is offline   Reply With Quote
Old 08-06-2012, 12:38 PM   #469
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Don't use neutered stats, the "Real" stats are the neutered ones due to the way OOTP reads these things.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-06-2012, 01:39 PM   #470
jhart05
Major Leagues
 
jhart05's Avatar
 
Join Date: Feb 2012
Location: Milwaukee, WI
Posts: 315
Quote:
Originally Posted by Spritze View Post
Don't use neutered stats, the "Real" stats are the neutered ones due to the way OOTP reads these things.

Just to make sure I'm not losing my mind ...

This is a change from prior versions of the game then, that I just missed the memo somewhere, correct?

Because with OOTP8 we needed to selected that neutralized stats deal to get your DB to read correctly.

I'll try that out when I get home tonight.

Thanks.

Last edited by jhart05; 08-06-2012 at 04:25 PM.
jhart05 is offline   Reply With Quote
Old 08-06-2012, 01:55 PM   #471
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by jhart05 View Post
Just to make sure I'm not loosing my mind ...

This is a change from prior versions of the game then, that I just missed the memo somewhere, correct?
Nor losing it either. Stuff keeps changing. I found out from Gambo that the game looks to the non-neutered db side for lots of stuff even if you choose neutered. So the only way around that was to make non-neutered neutered. I suppose I could just copy the newts into both places. Just didn't think of it at the appropriate time.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-10-2012, 03:14 PM   #472
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 193
Real stats

Just wondering

I am using the HS DB and am in the 1873 draft. I am noticing that when I click on the players in the draft pool they have no "real" batting or pitching stats...only fielding.

Does this effect their ratings? What is the issue?
szathkey is offline   Reply With Quote
Old 11-10-2012, 02:39 PM   #473
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
New Spritze HS database

Just downloaded an update to the usual place.

"I am noticing that when I click on the players in the draft pool they have no "real" batting or pitching stats...only fielding." Please remember that this db is meant to be used unneutered as it has been previously neutered by the neuterer. So always choose "Real Stats". Other than that I don't know what the problem foretells.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 11-23-2012, 01:37 PM   #474
Killemall1057
Bat Boy
 
Join Date: Jun 2012
Posts: 3
I would like to try this DB out, but can't figure out how to PM. Is it based on a user level? It says I don't have permission, and I don't see any "PM" buttons like other message boards. Thanks.

EDIT: Nevermind figured it out. Sent a PM

Last edited by Killemall1057; 11-23-2012 at 01:48 PM. Reason: Nevermind
Killemall1057 is offline   Reply With Quote
Old 12-22-2012, 10:31 AM   #475
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Dec 2012 Spritze HS Database available

Just downloaded an update to the usual place.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 01-13-2013, 12:23 PM   #476
Kivlehan
Minors (Double A)
 
Join Date: Dec 2001
Location: Allentown, PA
Posts: 160
Quote:
Originally Posted by Spritze View Post
Just downloaded an update to the usual place.
Which is where? ootpmods.com shows an update in 2011 and the link in your footer is down. I'd love to download it and try it.
Kivlehan is offline   Reply With Quote
Old 01-19-2013, 10:01 PM   #477
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
2012 Lahman data added to the latest update

Available in the usual place.

PM me if you need a link.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-04-2013, 12:40 PM   #478
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Newest db posted to the ftp site

Dated today.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-06-2013, 02:35 AM   #479
Elysian Fields
Major Leagues
 
Join Date: Apr 2010
Posts: 484
Quote:
Originally Posted by Spritze View Post
Dated today.
For 14 are we supposed to choose "real stats" or neutered? I read you said neutered, but looking above to last year's db it was supposed to be "real stats".
Elysian Fields is offline   Reply With Quote
Old 08-06-2013, 11:22 AM   #480
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Real stats and neutered were the same last year - this year they are not. Real stats are now more realer.
__________________
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 10:51 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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments