Spritze DB's for OOTP11

[reflections]

Originally Posted by actionjackson

I wish I could help you out my Mogul friend who is sustained by Guinness. I would like to welcome you over to OOTP though.

I have never used the Spritzey High School db before. I have one thought (at a time; two is too many) though and that would be to check what database you are pointing to when you tell the game to load up either the historical database or the Master. Is it the one that came with the game? That one will give you 115, because that's how many players debuted in 1871. The Gambo/Spritze db and the Spritze High School db should be giving you hundreds more, when you startup on 01/01/1871.

Did you perhaps overwrite the stats folder in the OOTP11 Baseball folder when you downloaded the Gambo/Spritze and then overwrite the Gambo/Spritze when downloading the Spritzey High School? The best way to avoid this is to copy/paste the stats folder itself into say the Out of the Park Developments folder in My Documents (Documents with Windows 7), rename it something like "Default", so you'll know the difference between databases and then cut/paste it back into the stats folder. Once you've done that you can get rid of the 28 files (26 csv files, 1 odb file, 1 text file) within the stats folder apart from the Default folder that you just copied/created. Keep the Default folder and get rid of the rest. Then create a folder called: "Gambo/Spritze" and extract the Gambo/Spritze files from their zip file into it. Same thing for the Spritze High School. You now have three different databases to play with. Just be sure to point to the right one when you're setting up a game.

If you over wrote the stats folder don't worry. It's not as big a deal this year as it was in previous years when you had to uninstall/reinstall. You have a zip file called "stats" in My Computer (Computer if you have Windows 7) > Local Disk (C: ) [looks stupid because a close bracket has to be separated from a colon, otherwise you get a ] > Program Files (Program Files (x86) with Windows 7) > Out of the Park Developments > OOTP Baseball 11 > default_data. Extract the stats zip file in there to your "Default" folder within your stats folder to overwrite what you may or may not have overwritten with the other two downloads...And voila...Three databases. Now off you go until you reach the next fork in the massive learning curve involved in this game. I spent all of my time with OOTPX (quite a bit of time with OOTP11 too!) just learning all the different options and figuring out how I wanted to play. Not time wasted though. Complex? Yes. At times unwieldy and frustrating? Yes. Great game? Yes, once you get it to do what you want it to do, which takes time.

Once again, welcome to the OOTP boards and just for future reference, despite the fact that this is a database issue, you probably would've gotten more traffic (and thus more potential respondents) in the General Discussions sub-forum. Let the mods move it if they want to. That's fine, but if you want help in a more timely fashion, that's probably where you should post. Keep asking those questions - no such thing as a stupid one. You'll get there eventually. Drop me a PM anytime if there's something you don't want to ask on the boards. Cheers.

Been along time my friend..it's been a crazy trip for me. lol.
The idea of being able to use multiple databases was just too much for me to keep passing up. lol
I think I may have done the overwriting part. lol. I'm gonna go through right now and check it out.
I'm definitely digging this version of OOTP, a much different and quicker version than the last one I played years ago.

[actionjackson]

Originally Posted by reflections

Been along time my friend..it's been a crazy trip for me. lol.
The idea of being able to use multiple databases was just too much for me to keep passing up. lol
I think I may have done the overwriting part. lol. I'm gonna go through right now and check it out.
I'm definitely digging this version of OOTP, a much different and quicker version than the last one I played years ago.

If you overwrote it, extract the Program Files stats zip file to a new folder named "Default" within the stats folder in My Documents like I indicated above. If you still have the zip files for the other two db's extract them into two separate folders within the stats folder as I said. If you don't have them, re-download them from Padres Fans site. Three zips and some deletions of files outside the three folders and you're there. Markus putting in the backup game files within the Program Files folder was a stroke of genius and a real time saver , but you have to use it to benefit from it. Otherwise it's uninstall/re-install and that sucks. Cheers.

[reflections]

Originally Posted by actionjackson

If you overwrote it, extract the Program Files stats zip file to a new folder named "Default" within the stats folder in My Documents like I indicated above. If you still have the zip files for the other two db's extract them into two separate folders within the stats folder as I said. If you don't have them, re-download them from Padres Fans site. Three zips and some deletions of files outside the three folders and you're there. Markus putting in the backup game files within the Program Files folder was a stroke of genius and a real time saver , but you have to use it to benefit from it. Otherwise it's uninstall/re-install and that sucks. Cheers.

It worked.
Thank you sir for the help. Not used to the things overwriting and not completely replacing. I should have a dynasty up in the near future now starting in 1871.

[actionjackson]

Originally Posted by reflections

It worked.
Thank you sir for the help. Not used to the things overwriting and not completely replacing. I should have a dynasty up in the near future now starting in 1871.

Out of curiousity, which of the three folders are you going with? I use Gambo-Spritze.

[actionjackson]

Originally Posted by reflections

It worked.
Thank you sir for the help. Not used to the things overwriting and not completely replacing. I should have a dynasty up in the near future now starting in 1871.

Also, the modifications are endless with this game. We'll have you up and modificating in no time.

[actionjackson]

Originally Posted by actionjackson

Out of curiousity, which of the three folders are you going with? I use Gambo-Spritze.

Actually on second thought, I use a hybrid of Gambo-Spritze plus certain things pasted into the Master file from the default folder like debut/final years and such. I've touched it up a bit, so it's definitely a hybrid and I might be using Bristolduke's Master file. I honestly can't remember. There's clearly a lot of cross-pollination in the Gambo-Spritze that I use. I also pared down 1871 to just the 115 players that were there by eliminating the 1871 stats2 entries for the players that I don't want showing up. Some people use the G-S to combat the dearth of players in Ye Olde Tyme Base-Ball, but that's not my style. Give 'em to me as they arrived IRL and let's get drafting, trading etc. Have fun.

[reflections]

Originally Posted by actionjackson

Actually on second thought, I use a hybrid of Gambo-Spritze plus certain things pasted into the Master file from the default folder like debut/final years and such. I've touched it up a bit, so it's definitely a hybrid and I might be using Bristolduke's Master file. I honestly can't remember. There's clearly a lot of cross-pollination in the Gambo-Spritze that I use. I also pared down 1871 to just the 115 players that were there by eliminating the 1871 stats2 entries for the players that I don't want showing up. Some people use the G-S to combat the dearth of players in Ye Olde Tyme Base-Ball, but that's not my style. Give 'em to me as they arrived IRL and let's get drafting, trading etc. Have fun.

Well the one i'm gonna start soon is gonna be a historical/fictional type with a huge expanded look at baseball.
I'm gonna use the Spritze HighSchool db and have at count 12 leagues (European baseball anyone), and a mixture of 12 minor leagues. I'll lay it out in the beginning of the dynasty.
I love the ease of using different databases, so I am thinking already of another type of dynasty too, involving my favorite team..it's one I started in Mogul and came into too many problems. My 1970 Los Angeles Dodgers one. Plus for christmas, my g/f is getting me a new, faster computer.. oh man. lot's of ideas..almost too many. lol

[actionjackson]

Originally Posted by reflections

Well the one i'm gonna start soon is gonna be a historical/fictional type with a huge expanded look at baseball.
I'm gonna use the Spritze HighSchool db and have at count 12 leagues (European baseball anyone), and a mixture of 12 minor leagues. I'll lay it out in the beginning of the dynasty.
I love the ease of using different databases, so I am thinking already of another type of dynasty too, involving my favorite team..it's one I started in Mogul and came into too many problems. My 1970 Los Angeles Dodgers one. Plus for christmas, my g/f is getting me a new, faster computer.. oh man. lot's of ideas..almost too many. lol

Nice g/f! Faster computer with decent storage capability reeeaaalllyyy helps in every aspect of this game. You'll be rockin' in 2011.

[Spritze]

Spritze2010HighSchool database available on my FTP site and at Padre's Fan site.

Includes 2010 Lahman stats and "real" minor league stats for several hundred more players.

[EKomrska15]

What did I do wrong? I downloaded the highschool version on Padres website (V3) and chose 1989 as my starting year and somehow Fergie Jenkins is still on the Cubs even though he retired in 83 (IRL) and Maddux is on the Braves even though he was on the Cubs in 89 (I am going to rewrite Cub lore with him)

What would be the best solution or DB of yours to get the correct players at that given year of 1989?

[plannine]

I believe, that version of the DB puts them on their primary team only.
I don't know if it is based on games or years of service, but either way he'd be a brave.

[plannine]

Originally Posted by Spritze

Spritze2010HighSchool database available on my FTP site and at Padre's Fan site.

Includes 2010 Lahman stats and "real" minor league stats for several hundred more players.

One of the main changes I've done to your DB is with the teams. Since I came from the world of table top games (APBA/Strat), my worlds are usually ML only. I've tried playing with the minors, but I find, I really don't care what happens there.

So, with so many additional players available in your DB (Negro, Minors, Japan etc) plus the possibility of longer careers, I decided to modify the teams file to get more teams in. So far I've just changed 1901-1960, (which seems to work in a couple of tests) and here is what I did.

I've left the "standard" ML for 1901-1924

At that point I move all the existing teams to a two division AL with the East being the AL teams and the west being the NL teams. (This keeps a ML 'historic' NL/AL playoff in place).

Then I add the following cities/teams (from the PCL and Negro Leagues) to the new National League:
(1925):
Eastern Division
Kansas City Monarchs
Indianapolis Clowns
Newark Eagles
Birmingham Barons

Western Division
Oakland Oaks
Los Angeles Angels
Portland Beavers
San Francisco Seals



Then in 1935 I add more teams to the PCL/NL, making it look as follows:


National
Eastern Division
Newark Eagles
Kansas City Monarchs
Birmingham Barons
Mexico City Red Devils
Havana Sun Kings
Jersey City Skeeters
Indianapolis Clowns
Memphis Blues

Western Division
Los Angeles Angels -
San Francisco Seals
Oakland Oaks
Portland Beavers
Seattle Rainiers
Hollywood Stars
San Diego Padres
Sacramento Solons


Other changes/adjustments goes as follows (1950-60)

Actual ML changes kept:
1954 - AL StB moves to Balt
1955 - AL Phil moves to KC-A
Additional modified changes:
1960 - NL HAV moves to Houston
1960 - AL KC-M (or KC-A) moves to Minnesota

--------------------------------------------------------

These are my projected moves (any ideas/comments) without any dates set dates yet.

Jersey City moves to Atlanta
Mexico City moves to Texas
Hollywood moves to Montreal
Sacramento moves to Toronto
Indianpolis moves to Arizona
--------------------------------------------------------

At some point I plan to add a few more teams:

ADD Florida
ADD Tampa Bay
ADD (Dominican Republic)
ADD (Puerto Rico)


It's still a long way from being 'perfect', but at least for me, it makes it a little more 'mine' rather then being 'just another replay'.


side note:
I've also noticed that if a team (or teams) automatically leaves the league, with out a new team(s) coming in to the league (and drafting from the other teams) some of the players may be stuck in limbo (player hell). Even if a new team comes in, if they are not picked in the draft, they may be stuck out of the league on their old team. (I am guessing that if you are playing with salary/FA the might come back when their contract is up - i play with salaries turned off)

[Gambo]

Originally Posted by plannine

I believe, that version of the DB puts them on their primary team only.
I don't know if it is based on games or years of service, but either way he'd be a brave.

In time I will my update for the database with the real teams and such and this won't be an issue.

[EKomrska15]

So you are saying in time I can play in 89 as the Cubs and I will have Maddux on my team and prevent the disaster of him leaving? That would be great

I'll hold off on my historical league then!

[Gambo]

Yes. I'll start tweaking around with it ASAP

[Gambo]

Originally Posted by EKomrska15

So you are saying in time I can play in 89 as the Cubs and I will have Maddux on my team and prevent the disaster of him leaving? That would be great

I'll hold off on my historical league then!

Actually...you can already do this with the version of the database available. Gambo/Spritze at Padres site. It just wont be updated with 2010, really no difference except one year.

Also, I am going to hold off on making the tweaks for 2010. I want to wait until retrosheet released their updated transaction database so it has the 2010 rookies pro debut and all. This way when I do release mine it has 2009 and 2010's players correct.

[actionjackson]

Originally Posted by Gambo

Actually...you can already do this with the version of the database available. Gambo/Spritze at Padres site. It just wont be updated with 2010, really no difference except one year.

Also, I am going to hold off on making the tweaks for 2010. I want to wait until retrosheet released their updated transaction database so it has the 2010 rookies pro debut and all. This way when I do release mine it has 2009 and 2010's players correct.

By all means correct me if I've misunderstood you, but wouldn't BB-Ref be the place to go for that stuff? There's this page and this page. The default sorting is alphabetical, but you can also sort them by debut date by clicking on the header of the "Debut" column. Like I said I don't know if it's that debut or the professional debut at any level that you're looking for, but BB-Ref might be the place to check while you're waiting. They also have both every round of both those drafts here and here if that's what you're looking for.

[Chicagofan76]

Originally Posted by EKomrska15

So you are saying in time I can play in 89 as the Cubs and I will have Maddux on my team and prevent the disaster of him leaving? That would be great

I'll hold off on my historical league then!

still wont help the cubs..


question if i switch to the new DB from whichever version i am currently using the changes/players will be according to the new 1 correct not the old 1 in an existing historical league? or would i have to start a new historical league and use the latest DB?

[Gambo]

Originally Posted by actionjackson

By all means correct me if I've misunderstood you, but wouldn't BB-Ref be the place to go for that stuff? There's this page and this page. The default sorting is alphabetical, but you can also sort them by debut date by clicking on the header of the "Debut" column. Like I said I don't know if it's that debut or the professional debut at any level that you're looking for, but BB-Ref might be the place to check while you're waiting. They also have both every round of both those drafts here and here if that's what you're looking for.

Kind of yes but no. The issue is when I do my version I also include the transactions between the pro debut date and opening day of their debut season. Until the retrosheet database is up that information is either not there or is speculated by baseball-reference from another source I don't know. The retrosheet database is updated up to about February 2010.

So using that information I would know they were drafted in June 2004 with the A's, and they debuted on September 1st 2010 but I can not be certain of what teams they were with on opening day of 2005,2006,2007,2008,2009 or 2010. Baseball-reference may give some of that info but it's not certain.

Secondly, it's much easier for my purposes to do it via a database than go through each player.

[Gambo]

Originally Posted by Chicagofan76

still wont help the cubs..


question if i switch to the new DB from whichever version i am currently using the changes/players will be according to the new 1 correct not the old 1 in an existing historical league? or would i have to start a new historical league and use the latest DB?

Depends, if your going Spritze to Spritze probably yes but if your going Gambo to Spritze then there will likely be differences in debut years and players will be doubled/missing.