Home | Webstore
Latest News: FHM 2014: Version 1.6.8 Available! - Beyond the Sideline Football Announced! - OOTP 15 Announced! - OOTP 14: Update #7 Released! - Out Of The Park Baseball 14 Released! - iOOTP Baseball 2013 for iOS Available NOW! - Title Bout Championship Boxing 2.5 released!

OOTP 15 Announced - Pre-Order Now!

Beyond the Sideline Football Announced!
  

Go Back   OOTP Developments Forums > Out of the Park Baseball 14 > OOTP Mods > OOTP Mods - Database Tools

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

Reply
 
LinkBack Thread Tools
Old 03-24-2013, 12:35 PM   #1 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
Spritze's db for OOTP14

There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
13 thanks for this post:
Bigrod (03-25-2013), golander40 (04-06-2013), Jabez54 (03-24-2013), mgom27 (04-20-2013), moonlightmerc (03-24-2013), NYY #23 (04-06-2013), OBSL Commish (07-31-2013), RonP (04-11-2013), szathkey (04-12-2013), tayloraj (03-24-2013), TBPauly (04-01-2013), The Game (03-24-2013)
Old 03-24-2013, 01:53 PM   #2 (permalink)
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 7,052
Thanks: 4,555
Thanked 1,334x in 1,106 posts
Quote:
Originally Posted by Spritze View Post
There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.
This includes all previous custom DB's? Not working with 14 I mean.
The Game is offline   Reply With Quote
Old 03-24-2013, 02:16 PM   #3 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
Yup, more than likely which could be viewed as likely+.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 03-24-2013 at 02:18 PM.
Spritze is offline   Reply With Quote
3 thanks for this post:
Jabez54 (03-24-2013), mgom27 (04-20-2013), The Game (03-24-2013)
Old 03-27-2013, 06:30 PM   #4 (permalink)
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 497
Thanks: 12
Thanked 6x in 6 posts
Quote:
Originally Posted by Spritze View Post
There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.
So, does that mean, that, doing a import dance, from a previous version wont cut the mustard either?
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel
plannine is offline   Reply With Quote
Old 03-28-2013, 02:42 PM   #5 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
That'd move your current stuff but the next year would bomb without an updated db AFAIK. You'd need to try it to know for sure.

All I know for fact is that the format of the master.csv has changed. Which normally means old db's go dead.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-06-2013, 08:48 AM   #6 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
OOTP14 Database posted in the usual place

I tested a few seasons without any trials nor tribulations. This DB has the new OOTP14 format.
__________________
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:
golander40 (04-06-2013), Jabez54 (04-06-2013)
Old 04-09-2013, 03:56 PM   #7 (permalink)
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 2,188
Thanks: 98
Thanked 169x in 157 posts
I am just confirming that the database includes minor league players, Negro League and Japanese (Spritze High School Player database)??

Also, when is the best time to import my saved league to OOTP14? Right now in my dynasty it is February 1st in the off-season.
__________________
You don't save a pitcher for tomorrow. Tomorrow it may rain ~ Leo Durocher

MLB Modified

Pro Boxing Modified


Jeff1787 is offline   Reply With Quote
Old 04-09-2013, 04:24 PM   #8 (permalink)
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 7,052
Thanks: 4,555
Thanked 1,334x in 1,106 posts
Quote:
Originally Posted by Jeff1787 View Post
I am just confirming that the database includes minor league players, Negro League and Japanese (Spritze High School Player database)??

Also, when is the best time to import my saved league to OOTP14? Right now in my dynasty it is February 1st in the off-season.
I am sure Spritz will confirm but yes I believe it also has PCL players. OOTP recommends converting right after the regular season or before your new season. I have converted at all points and never had an issue.
The Game is offline   Reply With Quote
2 thanks for this post:
Jeff1787 (04-09-2013)
Old 04-09-2013, 05:01 PM   #9 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
Markus undooded the OOTP14 database changes so now the old databases will still work. Yay!
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
Gambo (04-10-2013), mgom27 (04-20-2013), OBSL Commish (07-31-2013), The Game (04-09-2013)
Old 04-11-2013, 12:15 AM   #10 (permalink)
All Star Starter
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,953
Thanks: 56
Thanked 608x in 334 posts
So Spritze. Do you have an updated HS database for 2014?

Is the one on the site the incorrect/update for OOTP14 that never was?

Basically can we get your DB with the 2012 season and will it work on OOTP14?
__________________
OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 04-11-2013, 12:48 PM   #11 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
Yes.
Yes, it is the "incorrect" one.
Yes it works anyway in my single test.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-11-2013, 03:13 PM   #12 (permalink)
All Star Starter
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,953
Thanks: 56
Thanked 608x in 334 posts
Okedoke. I'm pretty sure that all those last columns in the master.csv are holdovers from days long gone by anyway so it should work without them. If their needing and update shouldn't be too difficult.

Over the weekend I'm going to get a quasi update to my database based off this one if anybodies interested.

I don't have the time anymore to update it to perfection. I'm figuring everybody will import with the right team and professional debut except for the 2011 and 2012 rookies, who will debut the same time as in SpritzeHSDB (18 years old) and with the team they made their MLB debut. Also, for 2011 and 2012 the team they import on will be the 1st team they made an appearance with.

Since my DB is for historical players mainly this shouldn't be too big a deal for most. (At least for me ). I will keep the setup where neutralized statistics will need to be used so complete accurate histories and stats will be imported. I'll still keep it only containing a limited number of Asian players.

Pretty much everything else will be the same as the original SpritzeDB.
__________________
OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
3 thanks for this post:
Jabez54 (04-11-2013), tayloraj (04-12-2013), The Game (04-11-2013)
Old 04-12-2013, 06:54 AM   #13 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
Quote:
Originally Posted by Gambo View Post
Okedoke. I'm pretty sure that all those last columns in the master.csv are holdovers from days long gone by anyway so it should work without them. If their needing and update shouldn't be too difficult.
The extra columns are required for Random Debut play.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-12-2013, 09:55 AM   #14 (permalink)
All Star Starter
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,953
Thanks: 56
Thanked 608x in 334 posts
So as long as you dont do random debut it should be fine? I'm assuming so.
__________________
OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 04-12-2013, 01:25 PM   #15 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 3,270
Thanks: 32
Thanked 580x in 386 posts
Quote:
Originally Posted by Gambo View Post
So as long as you dont do random debut it should be fine? I'm assuming so.
I assume you can assume away assumptionally!
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-17-2013, 08:20 PM   #16 (permalink)
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 497
Thanks: 12
Thanked 6x in 6 posts
Quote:
Originally Posted by Spritze View Post
There has been a change to the database/csv/odb format for OOTP14 so earlier versions will not work with it.
I'll have an OOTP14 version of the db available within a few days of release.

Just wonderin.....'

Is it ready for Freddie yet?
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel
plannine is offline   Reply With Quote
Old 04-18-2013, 10:07 PM   #17 (permalink)
All Star Reserve
 
Join Date: Jun 2006
Posts: 676
Thanks: 319
Thanked 169x in 105 posts
Quote:
Originally Posted by Spritze View Post
Markus undooded the OOTP14 database changes so now the old databases will still work. Yay!
Will a modded one that currently works for 12, and (according to other posts) will not work for 13, now work for 14?
thehef is offline   Reply With Quote
Old 04-19-2013, 12:16 AM   #18 (permalink)
All Star Starter
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 1,953
Thanks: 56
Thanked 608x in 334 posts
Quote:
Originally Posted by thehef View Post
Will a modded one that currently works for 12, and (according to other posts) will not work for 13, now work for 14?
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
__________________
OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Thank you for this post:
The Game (07-20-2013)
Old 04-19-2013, 10:47 AM   #19 (permalink)
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 7,052
Thanks: 4,555
Thanked 1,334x in 1,106 posts
Quote:
Originally Posted by Gambo View Post
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
what the difference between yours and Spritz, I have an idea, just would like clarification.
The Game is offline   Reply With Quote
2 thanks for this post:
mgom27 (04-20-2013), RANGER11JP (04-19-2013)
Old 04-19-2013, 12:34 PM   #20 (permalink)
Minors (Double A)
 
tayloraj's Avatar
 
Join Date: Mar 2012
Location: Roslindale, MA
Posts: 115
Thanks: 50
Thanked 40x in 27 posts
Quote:
Originally Posted by Gambo View Post
I would say no.

BTW, I do have a version of my DB available for OOTP14 here...

https://www.box.com/s/d0yhb4dqoisv6doop012

I'll admit it's only been tested to a limited extent...
When I go to download, it's telling me that you're out of bandwidth.
tayloraj is offline   Reply With Quote
Thank you for this post:
Jabez54 (04-19-2013)
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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:48 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.1
Copyright © 2013 Out of the Park Developments