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

OOTP Baseball 20 - AVAILABLE NOW!

  

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 05-28-2018, 04:14 AM   #41
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,658
Thanks: 124
Thanked 489x in 297 posts
Quote:
Originally Posted by Spritze View Post



Thanks spritze
Going to give this a test run today
Cheers
sprague is offline   Reply With Quote
Old 05-31-2018, 04:40 PM   #42
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,927
Thanks: 372
Thanked 386x in 309 posts
Does this DB contain Negro League players, minor league players and Japanese players? If so, do they all start at age 18?
__________________
The key to hitting for high average is to relax, concentrate, and don't hit the fly ball to center field ~ Stan Musial

1946: MLB Revitalized
Jeff1787 is offline   Reply With Quote
Old 05-31-2018, 04:46 PM   #43
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,280
Thanks: 1,370
Thanked 1,162x in 743 posts
i haven't used it yet in a game, but Sptrize explained what's in and not in in this post.
http://www.ootpdevelopments.com/boar...5&postcount=36
hope it helps.
__________________
"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
Thank you for this post:
Jeff1787 (05-31-2018)
Old 06-01-2018, 02:31 PM   #44
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,658
Thanks: 124
Thanked 489x in 297 posts
Quote:
Originally Posted by mitchkenn View Post
i haven't used it yet in a game, but Sptrize explained what's in and not in in this post.
http://www.ootpdevelopments.com/boar...5&postcount=36
hope it helps.
Actually I am testing the game now and I think I do see both negro players and Japanese players in the game. I just called up a few random years and they seemed there. As for no 19 th century minor leaguers, I will know when I get to 1890 and see if Ed Breckinridge appears.
I am in 1874 now
sprague is offline   Reply With Quote
Old 06-10-2018, 09:43 AM   #45
Carlton
Hall Of Famer
 
Join Date: Mar 2002
Posts: 3,712
Thanks: 436
Thanked 426x in 279 posts
Works perfectly importing by file.

In case someone needs a 1901 import (attached) to save you some ctrl V hand cramps

I took out all the Ballplayer first names and make sure you import using neut stats
Attached Files
File Type: txt 1901 imports.txt (5.6 KB, 120 views)
Carlton is offline   Reply With Quote
Thank you for this post:
JaBurns (06-11-2018)
Old 06-24-2018, 12:10 AM   #46
diesel230
All Star Reserve
 
diesel230's Avatar
 
Join Date: May 2004
Location: Long Island NY
Posts: 565
Thanks: 214
Thanked 208x in 127 posts
I added Sadaharu Oh in his final season, 1980 and his career stats werent correct. Any ideas?
diesel230 is offline   Reply With Quote
Old 06-24-2018, 02:37 PM   #47
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,069
Thanks: 287
Thanked 3,175x in 1,855 posts
They would be his career MLE's.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-12-2018, 01:03 PM   #48
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 63
Thanks: 25
Thanked 26x in 11 posts
How many players in the db? (and by extension what players besides the MLB 1876-current .. or 1871-current if OOTP normally has NA players?)

Trying to see if I can do an all-time history (18XX-present) using one minor league (maybe starting in 30s?) whereby whole game is stocked with real players. But wondering how the some-enter-at-18 vs. most-enter-as-IRL will affect Major League time. And how many franchises can be supported by the total number of players.
froghair is offline   Reply With Quote
Old 01-20-2019, 11:55 AM   #49
reflections
Minors (Single A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 74
Thanks: 144
Thanked 12x in 7 posts
Noob here. Wondering how I would use the Spritze database in game? I was able to pull a player in from reading the past posts, but how would I be able to set it up for the database to pull the players in for a draft, instead of going player by player. Sorry if this is a stupid question.
reflections is offline   Reply With Quote
Old 01-20-2019, 12:16 PM   #50
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,280
Thanks: 1,370
Thanked 1,162x in 743 posts
Quote:
Originally Posted by reflections View Post
Noob here. Wondering how I would use the Spritze database in game? I was able to pull a player in from reading the past posts, but how would I be able to set it up for the database to pull the players in for a draft, instead of going player by player. Sorry if this is a stupid question.
if you want to use the Spritze database to import players, you must have the game using Spritze database. you set that up when you first go to import players - it asks which database ... not at my game right now, so can't recall all the steps off the top of my head.
__________________
"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; 01-20-2019 at 01:21 PM.
mitchkenn is offline   Reply With Quote
Old 01-20-2019, 03:12 PM   #51
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,069
Thanks: 287
Thanked 3,175x in 1,855 posts
easy way = rename historical_database.odb so you still have it then replace it with the spritze one which you will also need to rename.

there are about 5 ways to set things up though, just depends on your preferences.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Thank you for this post:
reflections (01-20-2019)
Old 01-20-2019, 05:44 PM   #52
reflections
Minors (Single A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 74
Thanks: 144
Thanked 12x in 7 posts
Quote:
Originally Posted by Spritze View Post
easy way = rename historical_database.odb so you still have it then replace it with the spritze one which you will also need to rename.

there are about 5 ways to set things up though, just depends on your preferences.

This will probably be a really stupid question, but is the spritze one already in the game? or do I have to download it from somewhere else? I haven't played in a few years and I can't find a mods website anymore.
reflections is offline   Reply With Quote
Old 01-20-2019, 06:00 PM   #53
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,280
Thanks: 1,370
Thanked 1,162x in 743 posts
nope, not in the game. it's an alternative to the database that comes in the game. you need to download it. here's the link.

https://www.dropbox.com/s/huimrk5jab...abase.zip?dl=0

reading this entire thread, which may get tedious, pretty much will explain what it is.

good luck. enjoy.
__________________
"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
Thank you for this post:
reflections (01-20-2019)
Old 01-20-2019, 06:12 PM   #54
reflections
Minors (Single A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 74
Thanks: 144
Thanked 12x in 7 posts
Quote:
Originally Posted by mitchkenn View Post
nope, not in the game. it's an alternative to the database that comes in the game. you need to download it. here's the link.

https://www.dropbox.com/s/huimrk5jab...abase.zip?dl=0

reading this entire thread, which may get tedious, pretty much will explain what it is.

good luck. enjoy.
Thank you. I have been away for a few years from the game, and the computer where I had all my mods on decided to break down and I just never had the ability to get back into the game until now.
reflections is offline   Reply With Quote
Old 01-29-2019, 08:34 AM   #55
flatlander
Bat Boy
 
Join Date: Jan 2019
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
Can I switch to this historical database after we have already held the inaugural draft? Specifically, I'm concerned with generating duplicate players, I don't know how the game/database works, if they check current players and retired players from my game to prevent duplicates or if players drafted are stored somewhere else to prevent duplicates.

If it normally cannot be done, is there a way to manually add the players already in my game so they won't get duplicated in future drafts?

Thanks all.
flatlander is offline   Reply With Quote
Old 02-07-2019, 07:48 PM   #56
reflections
Minors (Single A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 74
Thanks: 144
Thanked 12x in 7 posts
Tag along question to flatander, is there a way to have the current updated database that comes with the game, merged with the spritze? So you can newer players?
reflections 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 12:40 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