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
Register Blogs FAQ Calendar Today's Posts Search

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

Reply
 
Thread Tools
Old 08-26-2011, 10:55 PM   #61
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Edible means something you eat. In this case a very nice buttery smooth caramel sauce. I think it is all the butter that makes it slide off. I've been forced to put the unfortunate sauce on ice cream and use the failures up that way. Bad luck that.
Spritze is offline   Reply With Quote
Old 08-30-2011, 11:28 PM   #62
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,621
Quote:
Originally Posted by Spritze View Post
Yes.
BUT
This is the solo league version so solowers who fly solo can play soloey.

The edible version is not yet finished. I can't get the caramel to stick.
I'm having a hard time trying to get this database to load. I unzipped the files into "C:\Users\Eriq\Documents\Out of the Park Developments\OOTP Baseball 12\PCL," but when I point OOTP to the master.csv in there and try to import any year (say, 1946), I get the following:

Quote:
The loading of the historical league failed. Please make sure the year is between 1971 and 2010, and the path to the database is correct!
This is with OOTP 12.3.22.
__________________
eriqjaffe is offline   Reply With Quote
Old 08-31-2011, 06:04 PM   #63
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
First make a copy of EVERYTHING in the Stats folder that comes with the game. Put them in your PCL folder.

Then overlay these files on that set. It will overwrite what it needs to automagically.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-31-2011, 09:59 PM   #64
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,621
Quote:
Originally Posted by Spritze View Post
First make a copy of EVERYTHING in the Stats folder that comes with the game. Put them in your PCL folder.

Then overlay these files on that set. It will overwrite what it needs to automagically.
Ah, thanks. I'll give that a try tonight.
__________________
eriqjaffe is offline   Reply With Quote
Old 08-31-2011, 10:11 PM   #65
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Sorry. I was planning directions with this and the modded MLB db that I plan on putting out this weekend.
Cooleyvol is offline   Reply With Quote
Old 08-31-2011, 11:38 PM   #66
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,621
No problem.

However, I'm running into another issue now - once the league is imported, all the PCL teams get assigned to the AL, the NL winds up with 0 teams in it, and the game won't let me proceed beyond the initial import. I can't edit the structure since it's a historical league.
__________________
eriqjaffe is offline   Reply With Quote
Old 09-01-2011, 07:01 AM   #67
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Quote:
Originally Posted by eriqjaffe View Post
No problem.

However, I'm running into another issue now - once the league is imported, all the PCL teams get assigned to the AL, the NL winds up with 0 teams in it, and the game won't let me proceed beyond the initial import. I can't edit the structure since it's a historical league.
You have to create a fictional league (I set it in the year I plan on starting). Once you do that, delete the teams and then delete all FA (players will be dumped there once you delete the clubs).


Now go to the screen and import your historical clubs into the empty league.
Cooleyvol is offline   Reply With Quote
Old 09-01-2011, 12:13 PM   #68
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 7,621
Quote:
Originally Posted by Cooleyvol View Post
You have to create a fictional league (I set it in the year I plan on starting). Once you do that, delete the teams and then delete all FA (players will be dumped there once you delete the clubs).


Now go to the screen and import your historical clubs into the empty league.
<smacks forehead>

I don't know why I didn't think of that myself. Thanks, cooley!
__________________
eriqjaffe is offline   Reply With Quote
Old 09-01-2011, 01:31 PM   #69
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Quote:
Originally Posted by eriqjaffe View Post
<smacks forehead>

I don't know why I didn't think of that myself. Thanks, cooley!
This all would be avoided if the historical PCL was added to the list of leagues you can add to a universe. <hint, hint, Markus>
Cooleyvol is offline   Reply With Quote
Old 09-02-2011, 10:03 PM   #70
dcpcarmona
All Star Starter
 
dcpcarmona's Avatar
 
Join Date: Jul 2003
Location: at the New Moon
Posts: 1,644
Quote:
Originally Posted by Spritze View Post
rename the attachment as noted above and unzip it. You'll find the pcl Lahman style files inside. Use any way you wish.

I'm sure Cooley will have other stuff later but in case you are tired of waiting go with this.
not working for me, any ideas?
__________________
"People ask me what I do in winter when there's no baseball. I'll tell you what I do. I stare out the window and wait for spring." -Rogers Hornsby
dcpcarmona is offline   Reply With Quote
Old 09-02-2011, 10:10 PM   #71
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Be more specific. What's not working?
Cooleyvol is offline   Reply With Quote
Old 09-13-2011, 03:50 PM   #72
AESP_pres
Hall Of Famer
 
AESP_pres's Avatar
 
Join Date: Jun 2007
Location: Province of Quebec
Posts: 3,999
Blog Entries: 25
Spritze or Cooleyvol (or anyone else...) I have a question concerning the database :

Currently I replay the baseball history as it was (working now on the rooster movement for 1893). Is it possible to add it as a new league to my world in 1903 (like I did in 84 and 90 with the UA and the PL)? I do all the move manually and I was wondering if a player jump from one league to another if the game will use the database from the league the player is currently to update the rating each season or a player created from a database rest attach to it forever...
AESP_pres is offline   Reply With Quote
Old 09-14-2011, 12:24 AM   #73
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Databases do not cross-pollinate.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-14-2011, 02:18 AM   #74
AESP_pres
Hall Of Famer
 
AESP_pres's Avatar
 
Join Date: Jun 2007
Location: Province of Quebec
Posts: 3,999
Blog Entries: 25
If I understand you well you mean the players rating won't update accordingly to the database of the league they are in even if the same PlayerID is use? So a player created in the PCL will not use the game database after I moved him to the ML and vice et versa... too bad as it won't work for what I do actually.

Last edited by AESP_pres; 09-14-2011 at 02:20 AM.
AESP_pres is offline   Reply With Quote
Old 09-14-2011, 10:18 AM   #75
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
You could try to meld them into a single db. We used players Lahman ID's so you could do that if you so chose. Just make the PCL a third major league?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 09-14-2011 at 10:19 AM.
Spritze is offline   Reply With Quote
Old 09-14-2011, 10:54 AM   #76
AESP_pres
Hall Of Famer
 
AESP_pres's Avatar
 
Join Date: Jun 2007
Location: Province of Quebec
Posts: 3,999
Blog Entries: 25
This is what I was thinking.

Continue what I do already in my game.

Actually I'm in 1894 with this structure

1894 : Major League ---- National League (12 teams) + American League (empty)
1901 : Major League ---- National League (8 teams) + American League (8 teams)
1903 : Major League (same structure) + PCL

Of course the PCL would be created as a second major league using the PCL database to get the players.

After I will continue what I do actually by making all the teams/players move manually as I did since 1871.

Is it possible by using the 2 databases to do that or the player keep the info from the database used to create them even if he move from the ML to the PCL and exist in the league he moved in database.
AESP_pres is offline   Reply With Quote
Old 09-15-2011, 12:12 PM   #77
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by AESP_pres View Post
Is it possible by using the 2 databases to do that or the player keep the info from the database used to create them even if he move from the ML to the PCL and exist in the league he moved in database.
Be most pleasantly pleased to please reconsider this sentence structure. I am unclear as to if there is a question in there and if so what it might be.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-15-2011, 02:03 PM   #78
AESP_pres
Hall Of Famer
 
AESP_pres's Avatar
 
Join Date: Jun 2007
Location: Province of Quebec
Posts: 3,999
Blog Entries: 25
Now you make me feel like mgom
Ok I'll try to write it in a better way

What I do currently is replaying the ML by simulating everything manually since 1871. From the start I've done all the team movements, players movement and the league creation (NL, AL, UA and PL) manually. So I use the game database only to get the players. All this is done with the database included in the game.

With your PCL database now available what I want to do when 1903 will happen in my game is to add it as a second major league (as I will do with the Federal League later).

What I want to know is if a player created in one database always use his original database when his ratings are recalculated or if he will use the database of the league he is currently in.

This is an exemple of what I mean.

Doc Newton (newtodo01)
1900 : Original import (OOTP database)
1901 : OOTP database
1902 : OOTP database
1903 : Move to the PCL
1904 : PCL
1905 : OOTP database
....

When his rating will be calculated in 1903 (and the following years of his career) what will happen? the OOTP database will be use or the PCL database will be.

Hope I'm clearer this time

Last edited by AESP_pres; 09-15-2011 at 02:05 PM.
AESP_pres is offline   Reply With Quote
Old 09-15-2011, 11:06 PM   #79
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
In setup you will note that each league points to a single database. Player ratings will only come from the db the league he is in points to. Hence my suggestion of merging the two db's.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 09-16-2011, 12:49 AM   #80
AESP_pres
Hall Of Famer
 
AESP_pres's Avatar
 
Join Date: Jun 2007
Location: Province of Quebec
Posts: 3,999
Blog Entries: 25
Quote:
Originally Posted by Spritze View Post
Player ratings will only come from the db the league he is in points to.
So if I follow my exemple if I do like that :

Doc Newton (newtodo01)
Before 01/01/1903 : manually move from the ML to the PCL
before 01/01/1905 : manually move from the PCL to the ML

He will use the PCL database in 1903 and the "stats" database for 1905.

Did I uderstand correctly?
AESP_pres 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 08:53 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