OOTP Developments Forums - View Single Post

thehef · 05-25-2024, 06:10 PM

I think the issue here might be that the historical transactions database isn't tracking complete transactions. For example, it's not tracking that on 1/11/77 Bill Buckner and Ivan De Jesus were traded from the Dodgers to the Cubs in exchange for Rick Monday and Mike Garman. Rather, it's only tracking separately that on 1/11/77 Buckner went to the Cubs, De Jesus went to the Cubs, Monday went to LA, and Garman went to LA.

That said, I could envision a second database (the first being the historical txns db) being created that tracks the details of a whole bunch of "significant" trades (& other txns) throughout major league history, and then an indicator being placed in the hist txns db to show the existence of add'l details in the 2nd db, and so then when that hist txn occurs in OOTP, it prompts OOTP to generate an article with a headline such as "Buckner and Monday Exchanged in Swap of Outfielders" or whatever... and then the details are included in a brief article gives a few more details (that are sourced from a few details that would be in the 2nd db). The article itself could then be a mix of player data from OOTP, such as "Buckner hit .315 in 151 games with the Dodgers last season..." and information stored in the 2nd db, such as "Monday was originally drafted by the Athletics in 1965, and is expected to start in center field for the Dodgers." I mean there are a lot of different ways this could be configured, but something like that...

In order for that to be a reasonable suggested feature, though, that 2nd database would need to be created by a user. Probably wouldn't be difficult (as all of the pertinent data for "significant" historical txns is available on retrosheet.org ~ although "significant" would certainly be open to interpretation), but it would be time-consuming... Then again, to start by restricting the 2nd db to including only info regarding txns that involve HOFers and maybe others who reached specific thresholds (batting champs, 300+ HR's, 200 Wins but not in the HOF), it might not be that time-consuming as a starting point...

05-25-2024, 06:10 PM	#2
thehef Hall Of Famer Join Date: Jun 2006 Posts: 5,380	I think the issue here might be that the historical transactions database isn't tracking complete transactions. For example, it's not tracking that on 1/11/77 Bill Buckner and Ivan De Jesus were traded from the Dodgers to the Cubs in exchange for Rick Monday and Mike Garman. Rather, it's only tracking separately that on 1/11/77 Buckner went to the Cubs, De Jesus went to the Cubs, Monday went to LA, and Garman went to LA. That said, I could envision a second database (the first being the historical txns db) being created that tracks the details of a whole bunch of "significant" trades (& other txns) throughout major league history, and then an indicator being placed in the hist txns db to show the existence of add'l details in the 2nd db, and so then when that hist txn occurs in OOTP, it prompts OOTP to generate an article with a headline such as "Buckner and Monday Exchanged in Swap of Outfielders" or whatever... and then the details are included in a brief article gives a few more details (that are sourced from a few details that would be in the 2nd db). The article itself could then be a mix of player data from OOTP, such as "Buckner hit .315 in 151 games with the Dodgers last season..." and information stored in the 2nd db, such as "Monday was originally drafted by the Athletics in 1965, and is expected to start in center field for the Dodgers." I mean there are a lot of different ways this could be configured, but something like that... In order for that to be a reasonable suggested feature, though, that 2nd database would need to be created by a user. Probably wouldn't be difficult (as all of the pertinent data for "significant" historical txns is available on retrosheet.org ~ although "significant" would certainly be open to interpretation), but it would be time-consuming... Then again, to start by restricting the 2nd db to including only info regarding txns that involve HOFers and maybe others who reached specific thresholds (batting champs, 300+ HR's, 200 Wins but not in the HOF), it might not be that time-consuming as a starting point...