Spritze DB's for OOTP11 - Page 28

Spritze · 04-02-2015, 01:51 PM

Link to newest non-randomizing version for OOTP 16

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

Thought I'd try Dropbox since that is what so many users on this forum use.

The thread after this one will be where I build the ReadMe for this version as I notice things in playing..

Spritze · 04-02-2015, 01:56 PM

Tested with OOTP16 for the years 1871-1923. Worked without challenges.

If you start a league in 1901 or later the main difference is some additional Negro and Cuban players and the MiLB player records for ML players who debuted in the decade of 1901-1910 are complete and ML 2014 has been added. The Federal League has also been added so refer to the contraction notes below.

If you start before 1901 you will notice that "Real" team names are being used even though players must still be drafted. Odd numbers of teams in a league is now supported by OOTP so that has been implemented.

Starting in 1871 the number of teams in the leagues are 9,11,9,8,13,8,6,6,8,8,8,14,16,33,16,16,16,16,16,25 ,17,12,12,12,12,12,12,12,12,8. When the number of teams increase Expansion will occur, when the number of teams decrease Contraction will occur. Upon contraction you will need to release all the contracted teams major and minor league players and personnel by hand. For players this can be done in 2 clicks, Select All and then make them free agents. I do this from the player list after choosing to include minor league players in the list.

I then run a Free Agent draft to disperse the players around the league. This should be done just after the next calendar year to keep players from sticking on the defunct teams. If it is done earlier players can be left behind. Even though they won't show on the free agent list they can still be seen on the major league player list as free agents.

Single league years have been split into two leagues as required by OOTP. You may need to edit the schedules to your liking as what OOTP uses as its defaults pre-1901 is just plain silly at times.

Years with 3 leagues have the extra leagues attached as a "Western" division to either the NL or AL. For these years you will need to use the Custom Playoff feature of OOTP. Make sure to change back from Custom Playoffs after the third league folds or the game will blow upon reaching the next seasons playoffs. If it does just edit the custom playoff format and you can continue.

Player records now include the pro/semi-pro/amateur 1850's and 1860's for players who played ML ball as early as 1871. If you choose to import history when you start a game (even in 1871) these stats will be imported. These stats have also been heavily altered by using 1871 as the base year for generating MLE's. In the 1850's and 60's rules were constantly evolving so the stats looked very weird. After MLE's they seem to fit pretty well.

Spritze · 04-02-2015, 02:26 PM

Working on it. .....Done

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

Replace the historicaldatabase.odb file in the Stats folder with this one and away you go!

Jeff1787 · 04-02-2015, 04:52 PM

I re-downloaded the file and now it works perfectly....Thanks

Painmantle · 04-03-2015, 11:06 AM

Quote:

Originally Posted by Spritze

Working on it.

Painmantle · 04-07-2015, 01:39 AM

All I can say is WOW, amazing work. unfreakin believable work. I imported historical teams from every era to fill a 20 team league and had enough players to have 3 levels of minors filled with 30/35/40 roster limits and 600+ Free Agents because of players getting released, ALL of real players, and having random entry is just like getting an extra scoop of Ice Cream with my cake, which I can have and eat it too!!!

Thanks for your time and effort
thank you
thank you
thank you

It would be impossible to thank you enough Spritze!! This is the mod that has made my dream league come true!!!

Spritze · 04-07-2015, 01:48 AM

You are welcome.

Painmantle · 04-07-2015, 03:08 AM

ok, after alot of messing around, I have a question about wether the database is working as intended. When importing historical teams of a specific year . I imported the 1914-1919 Boston Red Sox...No babe Ruth..when I imported a yankee team from those years there is Babe Ruth. Same case for the Cincinnati Reds of the mid-70's and Joe Morgan.

When I started a regular Historical game with the 75 reds the team was full of players who used to be on the team, granted these guys started out on the reds, but the 75 team had Frank Robinson, Lee May,Tommy Harper...etc...etc

Now with the case of Ruth, it is putting him on the Yankees no matter what year I import, I realize Ruth started on the Baltimore Orioles in the minors of the International league and I believe they had somewhat of an association with the Yankees as a minor league team.

Basically no matter what I do, the players are being put on their original teams no matter how far removed from them they are, in Frank Robinson's case he hadn't played for the Reds since 1965

Is the Database working as intended or is there a problem?

Spritze · 04-07-2015, 05:36 AM

The database is working as intended.

Players are on the team they spent the most time with. Since for most of baseball history players always began on independent teams and OOTP does not do independent teams (yet) it is a compromise. The database is meant to work with a draft for this reason and because players are available at around 18 so they can choose college or to go pro and because of all the Negro, Cuban and Asian players included who never got a chance to play in the majors at all.

Painmantle · 04-07-2015, 06:57 AM

Ok Thanks, Just making sure

The Game · 04-07-2015, 09:18 AM

Quote:

Originally Posted by Spritze

Working on it. .....Done

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

Replace the historicaldatabase.odb file in the Stats folder with this one and away you go!

Real stats or neutralized stats, I can never remember? I am using neutralized and setting it up right now.

Spritze · 04-07-2015, 11:02 AM

Neutered is best as it puts everyone in the same context.

Real works as well, just a bit differently.

gbmoore121 · 04-07-2015, 07:23 PM

I'm getting a "moved or deleted" error at dropbox.

I appreciate your work on this. Thanks Spritze.

Spritze · 04-07-2015, 09:22 PM

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

Try this one....I made random a part of the regular Spritze DB now. The random ODB is now incorporated.

MarkInCincy · 04-08-2015, 05:25 AM

Quote:

Originally Posted by Spritze

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

Try this one....I made random a part of the regular Spritze DB now. The random ODB is now incorporated.

Thank you!!!!! Dreams do come true...........

The Game · 04-08-2015, 06:14 PM

Spritze, thank you for finally making your DB compatible with RD. While my league got borked somehow by the Cubs and Sox getting switched from NL to AL for both the RD feature worked pretty well. Had a decent mix of Negro Leaguers I had never heard of and a slew of *** players that have not played MLB. i plan on redoing my RD league soon or just playing as the White Sox in the NL for one season then switching them back to the AL.

MUFC1878 · 04-08-2015, 06:29 PM

How many *** players that never made it to the US are in the db?

Lukas Berger · 04-08-2015, 06:32 PM

Quote:

Originally Posted by MUFC1878

How many *** players that never made it to the US are in the db?

All of them, I think.

MarkInCincy · 04-08-2015, 10:35 PM

Quote:

Originally Posted by Spritze

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

Try this one....I made random a part of the regular Spritze DB now. The random ODB is now incorporated.

Quick question, when I select the stats path which file do I point it to the .odb or the master.csv and do I pick the plain one or the one with the ootp in front? I either picked the wrong one (think it was the plain .odb) or messed up something else cause I got 0 players...it was probably me, just checking if it made a difference....

Spritze · 04-08-2015, 11:24 PM

historicaldatabase.odb

The files with OOTP in front are just the ones that came with the game.

04-02-2015, 01:51 PM	#541
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Link to newest non-randomizing version for OOTP 16 https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0 Thought I'd try Dropbox since that is what so many users on this forum use. The thread after this one will be where I build the ReadMe for this version as I notice things in playing.. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-12-2015 at 04:45 PM.

04-02-2015, 01:56 PM	#542
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Spritze HS for OOTP 16 Tested with OOTP16 for the years 1871-1923. Worked without challenges. If you start a league in 1901 or later the main difference is some additional Negro and Cuban players and the MiLB player records for ML players who debuted in the decade of 1901-1910 are complete and ML 2014 has been added. The Federal League has also been added so refer to the contraction notes below. If you start before 1901 you will notice that "Real" team names are being used even though players must still be drafted. Odd numbers of teams in a league is now supported by OOTP so that has been implemented. Starting in 1871 the number of teams in the leagues are 9,11,9,8,13,8,6,6,8,8,8,14,16,33,16,16,16,16,16,25 ,17,12,12,12,12,12,12,12,12,8. When the number of teams increase Expansion will occur, when the number of teams decrease Contraction will occur. Upon contraction you will need to release all the contracted teams major and minor league players and personnel by hand. For players this can be done in 2 clicks, Select All and then make them free agents. I do this from the player list after choosing to include minor league players in the list. I then run a Free Agent draft to disperse the players around the league. This should be done just after the next calendar year to keep players from sticking on the defunct teams. If it is done earlier players can be left behind. Even though they won't show on the free agent list they can still be seen on the major league player list as free agents. Single league years have been split into two leagues as required by OOTP. You may need to edit the schedules to your liking as what OOTP uses as its defaults pre-1901 is just plain silly at times. Years with 3 leagues have the extra leagues attached as a "Western" division to either the NL or AL. For these years you will need to use the Custom Playoff feature of OOTP. Make sure to change back from Custom Playoffs after the third league folds or the game will blow upon reaching the next seasons playoffs. If it does just edit the custom playoff format and you can continue. Player records now include the pro/semi-pro/amateur 1850's and 1860's for players who played ML ball as early as 1871. If you choose to import history when you start a game (even in 1871) these stats will be imported. These stats have also been heavily altered by using 1871 as the base year for generating MLE's. In the 1850's and 60's rules were constantly evolving so the stats looked very weird. After MLE's they seem to fit pretty well. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-03-2015 at 09:05 AM.

04-02-2015, 02:26 PM	#543
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Spritze Random DB for OOTP Working on it. .....Done https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0 Replace the historicaldatabase.odb file in the Stats folder with this one and away you go! __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-12-2015 at 04:45 PM.

04-02-2015, 04:52 PM	#544
Jeff1787 Hall Of Famer Join Date: Oct 2005 Location: The Doghouse Posts: 3,535	I re-downloaded the file and now it works perfectly....Thanks __________________ 1903: The hatchet is finally buried

04-07-2015, 01:39 AM	#546
Painmantle Hall Of Famer Join Date: Apr 2006 Location: Greenfield ,IN Posts: 3,053	All I can say is WOW, amazing work. unfreakin believable work. I imported historical teams from every era to fill a 20 team league and had enough players to have 3 levels of minors filled with 30/35/40 roster limits and 600+ Free Agents because of players getting released, ALL of real players, and having random entry is just like getting an extra scoop of Ice Cream with my cake, which I can have and eat it too!!! Thanks for your time and effort thank you thank you thank you It would be impossible to thank you enough Spritze!! This is the mod that has made my dream league come true!!! __________________ “As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth “Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker My Dynasties The Beantown Bambino

04-07-2015, 01:48 AM	#547
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	You are welcome. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

04-07-2015, 03:08 AM	#548
Painmantle Hall Of Famer Join Date: Apr 2006 Location: Greenfield ,IN Posts: 3,053	ok, after alot of messing around, I have a question about wether the database is working as intended. When importing historical teams of a specific year . I imported the 1914-1919 Boston Red Sox...No babe Ruth..when I imported a yankee team from those years there is Babe Ruth. Same case for the Cincinnati Reds of the mid-70's and Joe Morgan. When I started a regular Historical game with the 75 reds the team was full of players who used to be on the team, granted these guys started out on the reds, but the 75 team had Frank Robinson, Lee May,Tommy Harper...etc...etc Now with the case of Ruth, it is putting him on the Yankees no matter what year I import, I realize Ruth started on the Baltimore Orioles in the minors of the International league and I believe they had somewhat of an association with the Yankees as a minor league team. Basically no matter what I do, the players are being put on their original teams no matter how far removed from them they are, in Frank Robinson's case he hadn't played for the Reds since 1965 Is the Database working as intended or is there a problem? __________________ “As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth “Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker My Dynasties The Beantown Bambino Last edited by Painmantle; 04-07-2015 at 03:10 AM.

04-07-2015, 05:36 AM	#549
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	The database is working as intended. Players are on the team they spent the most time with. Since for most of baseball history players always began on independent teams and OOTP does not do independent teams (yet) it is a compromise. The database is meant to work with a draft for this reason and because players are available at around 18 so they can choose college or to go pro and because of all the Negro, Cuban and Asian players included who never got a chance to play in the majors at all. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

04-07-2015, 06:57 AM	#550
Painmantle Hall Of Famer Join Date: Apr 2006 Location: Greenfield ,IN Posts: 3,053	Ok Thanks, Just making sure __________________ “As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth “Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker My Dynasties The Beantown Bambino

04-07-2015, 11:02 AM	#552
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	Neutered is best as it puts everyone in the same context. Real works as well, just a bit differently. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-07-2015 at 01:22 PM.

04-07-2015, 07:23 PM	#553
gbmoore121 All Star Reserve Join Date: Feb 2002 Location: Arizona Posts: 602	I'm getting a "moved or deleted" error at dropbox. I appreciate your work on this. Thanks Spritze. __________________ WWPF- via DDS Pro Football

04-07-2015, 09:22 PM	#554
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0 Try this one....I made random a part of the regular Spritze DB now. The random ODB is now incorporated. __________________ It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-12-2015 at 04:46 PM.

04-08-2015, 06:14 PM	#556
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,937	Spritze, thank you for finally making your DB compatible with RD. While my league got borked somehow by the Cubs and Sox getting switched from NL to AL for both the RD feature worked pretty well. Had a decent mix of Negro Leaguers I had never heard of and a slew of *** players that have not played MLB. i plan on redoing my RD league soon or just playing as the White Sox in the NL for one season then switching them back to the AL. __________________ Go today don't wait for tomorrow It isn't promised, all the time you get borrowed Don't live your life for other people Don't bottle your emotions till they crack and fill a couple just sorrows Take your mind and refocus go get a paper write your goals out Throw your middle fingers to all your haters "Stay Strong"

04-08-2015, 06:29 PM	#557
MUFC1878 All Star Reserve Join Date: Sep 2012 Location: Venezuela Posts: 621	How many *** players that never made it to the US are in the db?

04-08-2015, 11:24 PM	#560
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,253	historicaldatabase.odb The files with OOTP in front are just the ones that came with the game. __________________ It's madness, madness, I tell you! For the love of God, don't do it!