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

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

Reply
 
Thread Tools
Old 05-28-2018, 05:14 AM   #41
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,910
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, 05:40 PM   #42
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,402
Does this DB contain Negro League players, minor league players and Japanese players? If so, do they all start at age 18?
Jeff1787 is offline   Reply With Quote
Old 05-31-2018, 05:46 PM   #43
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
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
"Hello darkness, my old Friend ...." - Paul Simon
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 06-01-2018, 03:31 PM   #44
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,910
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, 10:43 AM   #45
Carlton
Hall Of Famer
 
Carlton's Avatar
 
Join Date: Mar 2002
Posts: 3,765
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, 370 views)
Carlton is offline   Reply With Quote
Old 06-24-2018, 01:10 AM   #46
diesel230
All Star Reserve
 
diesel230's Avatar
 
Join Date: May 2004
Location: Long Island NY
Posts: 668
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, 03:37 PM   #47
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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, 02:03 PM   #48
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
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, 12:55 PM   #49
reflections
Minors (Double A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 174
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, 01:16 PM   #50
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
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
"Hello darkness, my old Friend ...." - Paul Simon
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 02:21 PM.
mitchkenn is offline   Reply With Quote
Old 01-20-2019, 04:12 PM   #51
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 01-20-2019, 06:44 PM   #52
reflections
Minors (Double A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 174
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, 07:00 PM   #53
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
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
"Hello darkness, my old Friend ...." - Paul Simon
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 01-20-2019, 07:12 PM   #54
reflections
Minors (Double A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 174
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, 09:34 AM   #55
flatlander
Bat Boy
 
Join Date: Jan 2019
Posts: 6
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, 08:48 PM   #56
reflections
Minors (Double A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 174
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:45 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