Home | Webstore
Latest News: OOTP Hotfix 21.1.33 - OOTP 21 Available - FHM 6 Available

OOTP Baseball 21 Available Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 21 > 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-24-2016, 01:48 PM   #961
KurtBevacqua
Hall Of Famer
 
KurtBevacqua's Avatar
 
Join Date: May 2003
Posts: 2,957
Blog Entries: 2
Thanks: 15
Thanked 53x in 34 posts
Is there an updated file to be downloaded that will allow random historic drafting?
__________________
"The type and formula of most schemes of philanthropy or humanitarianism is this: A and B put their heads together to decide what C shall be made to do for D. The radical vice of all these schemes, from a sociological point of view, is that C is not allowed a voice in the matter, and his position, character, and interests, as well as the ultimate effects on society through C's interests, are entirely overlooked. I call C the Forgotten Man"

- William Graham Sumner
KurtBevacqua is offline   Reply With Quote
Old 11-24-2016, 02:02 PM   #962
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,365
Thanks: 1,401
Thanked 1,204x in 774 posts
this file MAY look old, but it was updated in July, at least that's when i downloaded it.

see this link:
http://www.ootpdevelopments.com/boar...ml#post4048088
it's from the day Spritze uploaded it. The posts before and after explain it and how to load it. But be aware - it has some issues .... as mentioned in the posts around this link:
http://www.ootpdevelopments.com/boar...ml#post4111808

still it's a great piece, and has uses. i use to to import some players (such as Negro League ones) not already in the game.

Good luck and have fun.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.
mitchkenn is offline   Reply With Quote
Old 11-24-2016, 02:05 PM   #963
KurtBevacqua
Hall Of Famer
 
KurtBevacqua's Avatar
 
Join Date: May 2003
Posts: 2,957
Blog Entries: 2
Thanks: 15
Thanked 53x in 34 posts
Quote:
Originally Posted by mitchkenn View Post
this file MAY look old, but it was updated in July, at least that's when i downloaded it.

see this link:
http://www.ootpdevelopments.com/boar...ml#post4048088
it's from the day Spritze uploaded it. The posts before and after explain it and how to load it. But be aware - it has some issues .... as mentioned in the posts around this link:
http://www.ootpdevelopments.com/boar...ml#post4111808

still it's a great piece, and has uses. i use to to import some players (such as Negro League ones) not already in the game.

Good luck and have fun.
The file is no longer there to download
__________________
"The type and formula of most schemes of philanthropy or humanitarianism is this: A and B put their heads together to decide what C shall be made to do for D. The radical vice of all these schemes, from a sociological point of view, is that C is not allowed a voice in the matter, and his position, character, and interests, as well as the ultimate effects on society through C's interests, are entirely overlooked. I call C the Forgotten Man"

- William Graham Sumner
KurtBevacqua is offline   Reply With Quote
Old 11-24-2016, 03:09 PM   #964
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,365
Thanks: 1,401
Thanked 1,204x in 774 posts
Quote:
Originally Posted by Spritze View Post
https://www.dropbox.com/s/c3dpdch32l...OTP17.zip?dl=0

Link to latest version of this file.
try this one ... it seems to still be active as of this afternoon.
https://www.dropbox.com/s/c3dpdch32l...OTP17.zip?dl=0
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.

Last edited by mitchkenn; 11-24-2016 at 04:13 PM. Reason: add link
mitchkenn is offline   Reply With Quote
Thank you for this post:
KurtBevacqua (11-24-2016)
Old 11-24-2016, 06:06 PM   #965
KurtBevacqua
Hall Of Famer
 
KurtBevacqua's Avatar
 
Join Date: May 2003
Posts: 2,957
Blog Entries: 2
Thanks: 15
Thanked 53x in 34 posts
I have that one, I guess that at least confirms I have the latest and greatest, thanks.
__________________
"The type and formula of most schemes of philanthropy or humanitarianism is this: A and B put their heads together to decide what C shall be made to do for D. The radical vice of all these schemes, from a sociological point of view, is that C is not allowed a voice in the matter, and his position, character, and interests, as well as the ultimate effects on society through C's interests, are entirely overlooked. I call C the Forgotten Man"

- William Graham Sumner
KurtBevacqua is offline   Reply With Quote
Old 02-04-2017, 04:22 PM   #966
plannine
All Star Reserve
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 529
Thanks: 21
Thanked 15x in 14 posts
Quote:
Originally Posted by Spritze View Post
No draft = no fictional
Draft after 1871 season = 262 fictional players and zero historical. They turn up in 1872 draft.
With no draft no players are added at all.They also turn up in 1872 draft.

Not a database issue. Well, not exactly as it seems generating the historicaldatabase.odb introduces the challenge.

Found that the problem I due to the Draft reveal date of 11/15 (12/15 draft date) generates fictional players and real players show up a year late even using the non Spritze files.
This is what the ODB generator comes up with.
The file that comes with the game uses 12/1 reveal with a 12/15 draft and works just fine.
Changing the draft reveal date by hand does nothing.
When I set the draft date to September 1 1871, I don't get fictional players until 1882/3. Makes no sense.

If I use September until 1881, then switch to June for the draft, so far I have not had 'fake players', but I don't know if I am missing any real players
- but we will have to wait and see
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel

Last edited by plannine; 02-04-2017 at 08:53 PM.
plannine is offline   Reply With Quote
Old 05-20-2017, 06:40 PM   #967
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 106
Thanks: 25
Thanked 0x in 0 posts
Any chance of reviving this DB?

Would love to be able to draft everyone at HS age and watch them develop in Historical mode again...I know it was said that it could be looked at later in the "season" after bugs with the game had been worked out
szathkey is offline   Reply With Quote
Old 05-20-2017, 07:41 PM   #968
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,292
Thanks: 361
Thanked 3,281x in 1,940 posts
I do plan on updating this. I'm going to start working on it as soon as I can get the supermodels off my lap and out of the kitchen.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
3 thanks for this post:
dewelar (05-24-2017), mitchkenn (05-20-2017), RANGER11JP (05-22-2017)
Old 05-20-2017, 08:48 PM   #969
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,365
Thanks: 1,401
Thanked 1,204x in 774 posts
Quote:
Originally Posted by Spritze View Post
I do plan on updating this. I'm going to start working on it as soon as I can get the supermodels off my lap and out of the kitchen.
good to hear ... but there are priorities in life and well, supermodels in the kitchen certainly should be at or at least near the top of the list.

and if you ever get the new database up and functioning, give us a shout and i'll set a Dr. Pepper aside for you one day.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.

Last edited by mitchkenn; 05-22-2017 at 08:49 PM.
mitchkenn is offline   Reply With Quote
Old 05-21-2017, 12:54 AM   #970
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 106
Thanks: 25
Thanked 0x in 0 posts
agreed...sorry to interupt...carry on
szathkey is offline   Reply With Quote
Old 05-22-2017, 02:27 PM   #971
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Quote:
Originally Posted by Spritze View Post
I do plan on updating this. I'm going to start working on it as soon as I can get the supermodels off my lap and out of the kitchen.
Keep them in the kitchen. They might know how to make you something to eat and you won't have to worry that they will eat too much.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 07-03-2017, 06:26 PM   #972
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,038
Thanks: 615
Thanked 2,194x in 1,764 posts
How is the update going? I'm back at the HSBL draft and players from the Spritze Db are importing with nerfed Defense ratings. Looks like I will have to once again import every single player manually from the OOTP Db as that is the only way I've found to remedy the situation

Thanks
Rhett
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino
Painmantle is offline   Reply With Quote
Old 07-05-2017, 11:13 PM   #973
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,292
Thanks: 361
Thanked 3,281x in 1,940 posts
Batting and pitching are done and fielding has the new structure but the new fields are empty. Next step is to figure out how to fill them and then it will be done.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
7 thanks for this post:
dpd376 (07-10-2017), JaBurns (07-10-2017), mitchkenn (07-06-2017), Painmantle (07-19-2017), RANGER11JP (07-06-2017), txranger (07-06-2017), Ty Cobb (07-11-2017)
Old 08-15-2017, 11:31 AM   #974
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 102
Thanks: 86
Thanked 17x in 13 posts
Quote:
Originally Posted by Spritze View Post
Batting and pitching are done and fielding has the new structure but the new fields are empty. Next step is to figure out how to fill them and then it will be done.
Is it possible to just use the default fielding file and then copy and paste to fill out the missing seasons?
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 08-19-2017, 04:29 AM   #975
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Hi Spritze,

I came across this by accident today.

http://lahman.r-forge.r-project.org/

Thought it might interest you.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 09-05-2017, 12:05 PM   #976
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,365
Thanks: 1,401
Thanked 1,204x in 774 posts
Quote:
Originally Posted by Spritze View Post
Batting and pitching are done and fielding has the new structure but the new fields are empty. Next step is to figure out how to fill them and then it will be done.
hows this coming? or have other projects taken priority? have a good day.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.
mitchkenn is offline   Reply With Quote
Old 09-05-2017, 11:25 PM   #977
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,292
Thanks: 361
Thanked 3,281x in 1,940 posts
Per Matt Arnold, the new fielding fields are not used. I just found this out a few days ago so really it is now all done given that info. I'll put this on dropbox as soon as I can.

My only other project is healing my wound/injury and learning to walk/hobble again. Still got a month or two to go on that one.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
2 thanks for this post:
ArcAngel (09-05-2017), szathkey (09-06-2017)
Old 09-06-2017, 01:04 AM   #978
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 106
Thanks: 25
Thanked 0x in 0 posts
Sorry to hear you got hurt, Spritze...speedy recovery!
szathkey is offline   Reply With Quote
Old 09-06-2017, 03:58 AM   #979
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,038
Thanks: 615
Thanked 2,194x in 1,764 posts
Quote:
Originally Posted by Spritze View Post
Per Matt Arnold, the new fielding fields are not used. I just found this out a few days ago so really it is now all done given that info. I'll put this on dropbox as soon as I can.

My only other project is healing my wound/injury and learning to walk/hobble again. Still got a month or two to go on that one.
Well, What is the possible explanation for players in ootp18 being so poorly rated out of the gate when importing with the DataBase? I'm talking so poorly that the highest rated position player had a Rating of 12 (1-20 scale) and skill ratings were also proportionally and comparatively low when compared to past seasons using this DataBase with other versions of OOTP.
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino

Last edited by Painmantle; 09-06-2017 at 04:00 AM.
Painmantle is offline   Reply With Quote
Old 09-06-2017, 06:23 AM   #980
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,294
Thanks: 1,782
Thanked 228x in 166 posts
Spritze,

Whatever did you do to yourself????
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP 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 11:59 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 © 2020 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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