Spritze DB's for OOTP11 - Page 48

Spritze · 09-06-2016, 02:14 AM

Quote:

Originally Posted by szathkey

I've placed the db in the stats file, but my 1871 league still creates fictional players during both the 1871 (and 1872 so far) amateur drafts...Inaugural draft had all real players though.

What am I missing here that this would happen?

This is a newly introduced bug in OOTP17 that OOTPDev has not been able to reproduce.

szathkey · 09-06-2016, 09:13 AM

Thanks Spritze

I can reproduce it for them all day long

liquidlayneo · 09-06-2016, 08:24 PM

First off - THANK YOU for creating this awesome file. I had been contemplating building out my own historical file to recreate an integrated MLB from 1920-1947 and this file makes my life much easier!

I loaded the odb and started up a historical OOTP17 game using the file starting in 1921. Nearly all of the star negro league players that would have been active in 1921 showed up in the FA pool just as one would expect.

Torriente
CP Bell
Charleston
Smokey Joe Williams
Rogan

But there are a large number of lesser players that would have been active that same year that do not appear in the game file. I dug through your master.xls file and it appears that these players have a deathYear set at close to their birthYear, thereby theoretically "expiring" these players before they can grow to their fruition?

Here is one example:
Rube Curry (curry-000rub)
debut = 1920
finalGame = 1928 (would have been active in 1921)
birthYear = 1898
deathYear = 1898 (!)

One other example:
Charlie Blackwell (blackw003cha)
debut = 1915
finalGame = 1928 (would have been active in 1921)
birthYear = 1893
deathYear = 1894 (!)

This appears to be happening to many of the lesser-known players from the era. Of the roughly 100 players that I expected to see in the game file, only the superstar players of 1921 appear to be showing up.

Has anyone else seen this?

Thanks -

Spritze · 09-06-2016, 11:48 PM

Death is ignored by OOTP, so is final year. They do not exist as data in the game.

But debuts can count. Do does birthing year.

Spritze · 09-06-2016, 11:50 PM

Quote:

Originally Posted by szathkey

Thanks Spritze

I can reproduce it for them all day long

Me too. But when I send in a test file it works for them. Must be something I'm clicking on?

liquidlayneo · 09-06-2016, 11:52 PM

both of the player examples i listed above debuted before 1921. why wouldn't OOTP pick them up as viable players?

Spritze · 09-16-2016, 11:12 PM

No draft = no fictional
Draft after 1871 season = 262 fictional players and zero historical. They turn up in 1872 draft.
With no draft no players are added at all.They also turn up in 1872 draft.

Not a database issue. Well, not exactly as it seems generating the historicaldatabase.odb introduces the challenge.

Found that the problem I due to the Draft reveal date of 11/15 (12/15 draft date) generates fictional players and real players show up a year late even using the non Spritze files.
This is what the ODB generator comes up with.
The file that comes with the game uses 12/1 reveal with a 12/15 draft and works just fine.
Changing the draft reveal date by hand does nothing.

Spritze · 09-16-2016, 11:13 PM

Quote:

Originally Posted by liquidlayneo

both of the player examples i listed above debuted before 1921. why wouldn't OOTP pick them up as viable players?

They will show up a year late.

szathkey · 09-20-2016, 03:39 PM

Quote:

Originally Posted by Spritze

No draft = no fictional
Draft after 1871 season = 262 fictional players and zero historical. They turn up in 1872 draft.
With no draft no players are added at all.They also turn up in 1872 draft.

Not a database issue. Well, not exactly as it seems generating the historicaldatabase.odb introduces the challenge.

Found that the problem I due to the Draft reveal date of 11/15 (12/15 draft date) generates fictional players and real players show up a year late even using the non Spritze files.
This is what the ODB generator comes up with.
The file that comes with the game uses 12/1 reveal with a 12/15 draft and works just fine.
Changing the draft reveal date by hand does nothing.

So do I have to change the "reveal date" to December 1st?
Is that for 1871 only or in perpetuity?

The Game · 09-22-2016, 11:12 PM

Does this work for random debut? If so what are the best settings? odd that Honus is 2 for contact. I tried neutralized stats. Also very few players over age 21. i'm using the odb vs master

Spritze · 09-26-2016, 07:50 PM

Quote:

Originally Posted by szathkey

So do I have to change the "reveal date" to December 1st?
Is that for 1871 only or in perpetuity?

Please note the last sentence in my post.

Perpetuity and also always

Spritze · 09-26-2016, 07:54 PM

Quote:

Originally Posted by The Game

Does this work for random debut?

I don't see why it would not.

Honus as a rookie has different ratings than Honus at 28.

szathkey · 10-06-2016, 09:31 PM

...so the first "real" draft class doesn't appear until 1872?

Spritze · 10-07-2016, 01:42 PM

Quote:

Originally Posted by szathkey

...so the first "real" draft class doesn't appear until 1872?

Yes. It is a new bug.

Dreamsicle · 10-21-2016, 04:36 PM

Hi, I downloaded the file in page 47 and extracted the file in the stats folder with the new DB files in its own subfolder. The files in said subfolder are historical_database.odb and master.csv

In my current sim, I pointed the database path to the subfolder as seen in the screenshot attachment. I want to say that the players are working correctly as a former president is in my game but the league expansion does not seem to be working. It is currently 1916 and the Chicago Cubs are still the Orphans and the Cleveland Indians are still the Blues etc. I was wondering if I'm missing some files or if I put the files in the wrong folder or some other problem.

I started my game in 1901 and added all the minor leagues at the start.

Dreamsicle · 11-02-2016, 08:18 PM

Sorry about the double post.

I got the previous issue fixed. I just needed to replace the file directly and backup the old files.

I found out the hard way that drafts add fictional players even if the draft is set to December 1. Just to clarify from a previous post, will real historical players still enter the league? If the answer is no, how can I cull the draft pool of all fictional players? If I keep doing it manually, I'm probably going to develop CTS (faster). I assume the entire draft class will be fictional until the real one in 1965.

Additionally, I seem to remember in OOTP 16 that real historical players were draft eligible even before 1965. What changed in between then and OOTP 17?

Spritze · 11-03-2016, 12:54 AM

Quote:

Originally Posted by Dreamsicle

Sorry about the double post.

I got the previous issue fixed. I just needed to replace the file directly and backup the old files.

I found out the hard way that drafts add fictional players even if the draft is set to December 1. Drafts are broken in OOTP17 Just to clarify from a previous post, will real historical players still enter the league? Usually a year late If the answer is no, how can I cull the draft pool of all fictional players? You cannot easily If I keep doing it manually, I'm probably going to develop CTS (faster). I assume the entire draft class will be fictional until the real one in 1965.

Additionally, I seem to remember in OOTP 16 that real historical players were draft eligible even before 1965. What changed in between then and OOTP 17? Still are, it is just broke

Nothing good comes of this. Since this cannot be fixed I am probably dropping the Spritze database.

Dreamsicle · 11-03-2016, 01:55 AM

Quote:

Originally Posted by Spritze

Nothing good comes of this. Since this cannot be fixed I am probably dropping the Spritze database.

Aw that sucks. The Negro League and *** players make the league feel better and more lively. Your DB is the only way I can even consider a 19th century sim as well.

If it does get dropped, I hope OOTP18 or a future version fixes the bugs so you can continue or at least the default DB comes with Negro League and *** players

mitchkenn · 11-03-2016, 07:20 AM

"For The Love Of God - Don't do it!" i at least can live with the fictional players ..... it ain't that big a deal to me, but the Nero Leagues and minor leaguers are!!! ( admit i was having troubles getting "real" players to show up ....when i used the db exclusively - in the draft and without). Your database was/is one of the best parts of OOTP baseball to me. It gave me hope to get Negro League players and their "stats" (such as they may be) into the game ....

so now, i am just importing the players into a new league ... works great!!!! .... it's a wonderful thing you have created, my man!!

JaBurns · 11-03-2016, 05:41 PM

As above; although I am by no means a data base guru with time and patience (plus a little colourful language) I can add players from your amazing database. I respectfully ask you to please continue your great work!

09-06-2016, 11:48 PM	#944
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	Death is ignored by OOTP, so is final year. They do not exist as data in the game. But debuts can count. Do does birthing year. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

09-16-2016, 11:12 PM	#947
Spritze OOTP Historical Czar Join Date: Dec 2001 Location: Bothell Wa Posts: 7,254	No draft = no fictional Draft after 1871 season = 262 fictional players and zero historical. They turn up in 1872 draft. With no draft no players are added at all.They also turn up in 1872 draft. Not a database issue. Well, not exactly as it seems generating the historicaldatabase.odb introduces the challenge. Found that the problem I due to the Draft reveal date of 11/15 (12/15 draft date) generates fictional players and real players show up a year late even using the non Spritze files. This is what the ODB generator comes up with. The file that comes with the game uses 12/1 reveal with a 12/15 draft and works just fine. Changing the draft reveal date by hand does nothing. __________________ It's madness, madness, I tell you! For the love of God, don't do it!

09-22-2016, 11:12 PM	#950
The Game Hall Of Famer Join Date: Feb 2012 Location: Inside The Game Posts: 30,807	Does this work for random debut? If so what are the best settings? odd that Honus is 2 for contact. I tried neutralized stats. Also very few players over age 21. i'm using the odb vs master Attached Images __________________ 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" Last edited by The Game; 09-22-2016 at 11:14 PM.

10-21-2016, 04:36 PM	#955
Dreamsicle Bat Boy Join Date: Oct 2015 Posts: 7	Hi, I downloaded the file in page 47 and extracted the file in the stats folder with the new DB files in its own subfolder. The files in said subfolder are historical_database.odb and master.csv In my current sim, I pointed the database path to the subfolder as seen in the screenshot attachment. I want to say that the players are working correctly as a former president is in my game but the league expansion does not seem to be working. It is currently 1916 and the Chicago Cubs are still the Orphans and the Cleveland Indians are still the Blues etc. I was wondering if I'm missing some files or if I put the files in the wrong folder or some other problem. I started my game in 1901 and added all the minor leagues at the start. Attached Images Last edited by Dreamsicle; 10-21-2016 at 11:44 PM.

11-03-2016, 07:20 AM	#959
mitchkenn Hall Of Famer Join Date: Jan 2015 Location: Oregon, not by design Posts: 2,853	"For The Love Of God - Don't do it!" i at least can live with the fictional players ..... it ain't that big a deal to me, but the Nero Leagues and minor leaguers are!!! ( admit i was having troubles getting "real" players to show up ....when i used the db exclusively - in the draft and without). Your database was/is one of the best parts of OOTP baseball to me. It gave me hope to get Negro League players and their "stats" (such as they may be) into the game .... so now, i am just importing the players into a new league ... works great!!!! .... it's a wonderful thing you have created, my man!! __________________ "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; 11-07-2016 at 05:15 PM.

09-06-2016, 09:13 AM	#942
szathkey Minors (Double A) Join Date: Jun 2008 Posts: 146	Thanks Spritze I can reproduce it for them all day long

09-06-2016, 08:24 PM	#943
liquidlayneo Bat Boy Join Date: Sep 2016 Posts: 2	First off - THANK YOU for creating this awesome file. I had been contemplating building out my own historical file to recreate an integrated MLB from 1920-1947 and this file makes my life much easier! I loaded the odb and started up a historical OOTP17 game using the file starting in 1921. Nearly all of the star negro league players that would have been active in 1921 showed up in the FA pool just as one would expect. Torriente CP Bell Charleston Smokey Joe Williams Rogan But there are a large number of lesser players that would have been active that same year that do not appear in the game file. I dug through your master.xls file and it appears that these players have a deathYear set at close to their birthYear, thereby theoretically "expiring" these players before they can grow to their fruition? Here is one example: Rube Curry (curry-000rub) debut = 1920 finalGame = 1928 (would have been active in 1921) birthYear = 1898 deathYear = 1898 (!) One other example: Charlie Blackwell (blackw003cha) debut = 1915 finalGame = 1928 (would have been active in 1921) birthYear = 1893 deathYear = 1894 (!) This appears to be happening to many of the lesser-known players from the era. Of the roughly 100 players that I expected to see in the game file, only the superstar players of 1921 appear to be showing up. Has anyone else seen this? Thanks -

09-06-2016, 11:52 PM	#946
liquidlayneo Bat Boy Join Date: Sep 2016 Posts: 2	both of the player examples i listed above debuted before 1921. why wouldn't OOTP pick them up as viable players?

10-06-2016, 09:31 PM	#953
szathkey Minors (Double A) Join Date: Jun 2008 Posts: 146	...so the first "real" draft class doesn't appear until 1872?

11-02-2016, 08:18 PM	#956
Dreamsicle Bat Boy Join Date: Oct 2015 Posts: 7	Sorry about the double post. I got the previous issue fixed. I just needed to replace the file directly and backup the old files. I found out the hard way that drafts add fictional players even if the draft is set to December 1. Just to clarify from a previous post, will real historical players still enter the league? If the answer is no, how can I cull the draft pool of all fictional players? If I keep doing it manually, I'm probably going to develop CTS (faster). I assume the entire draft class will be fictional until the real one in 1965. Additionally, I seem to remember in OOTP 16 that real historical players were draft eligible even before 1965. What changed in between then and OOTP 17?

11-03-2016, 05:41 PM	#960
JaBurns All Star Starter Join Date: Sep 2015 Location: Kelowna, British Columbia Posts: 1,266	As above; although I am by no means a data base guru with time and patience (plus a little colourful language) I can add players from your amazing database. I respectfully ask you to please continue your great work!