players_awards table in OOTP15

ctorg · 10-13-2014, 10:37 AM

So I've been fooling around, trying to create an Access DB that will actually output pages for players that look like BB Reference pages. But I just came across something rather perplexing to me.

The players_awards table outputs all the awards given out to players, but it lists all three of the top finishers as having won the awards in question.

For example, if Player A won the MVP, and players B and C were 2nd and 3rd, each player is listed as having won the award in that table, with no way to tell which one actually did win it!

I'm wondering if anyone familiar with what I'm talking about knows of a way around it. I don't think there is one, but I figured I'd ask. This was not an issue in previous versions because the game didn't keep track of second and third place finishers.

fhomess · 10-13-2014, 11:32 AM

The league_history table contains the major award winners listed with just the top finishers. You lose out on monthly and weekly awards in that table, though.

ctorg · 10-13-2014, 11:53 AM

Ah, good. That's okay - I was just trying to get the necessary info for Hall of Fame Monitor scores together.

Thank you!

10-13-2014, 10:37 AM	#1
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	players_awards table in OOTP15 So I've been fooling around, trying to create an Access DB that will actually output pages for players that look like BB Reference pages. But I just came across something rather perplexing to me. The players_awards table outputs all the awards given out to players, but it lists all three of the top finishers as having won the awards in question. For example, if Player A won the MVP, and players B and C were 2nd and 3rd, each player is listed as having won the award in that table, with no way to tell which one actually did win it! I'm wondering if anyone familiar with what I'm talking about knows of a way around it. I don't think there is one, but I figured I'd ask. This was not an issue in previous versions because the game didn't keep track of second and third place finishers. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

10-13-2014, 11:32 AM	#2
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 3,585	The league_history table contains the major award winners listed with just the top finishers. You lose out on monthly and weekly awards in that table, though. __________________ StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development.

10-13-2014, 11:53 AM	#3
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Ah, good. That's okay - I was just trying to get the necessary info for Hall of Fame Monitor scores together. Thank you! __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils