Database question

Kemp · 09-04-2009, 05:54 PM

I import the csv files from my league into a large Access database and run various reports. I'm working on a report that will help me prep for the amateur draft and I found a field called "draft_eligible" in the Players table.

It appears that that field has either a '0' or a '1' depending on whether the player is draft eligible or not. Great! Only problem is, I compared this flag to the in game Draft Pool report and it appears that not all of the players from the draft report have a '1' in the "draft_eligible" field.

I believe this may be an error. Does anyone else look at or use this field for anything?

Thanks!

Kemp · 09-04-2009, 06:12 PM

Ahhh, I think I figured it out. The game is not flagging any player coming out of a feeder league that does not have any stats.

Regardless, I think the game should be flagging those players. I'm going to report this as a bug.

fhomess · 09-04-2009, 07:26 PM

Best way to get the full list of eligible feeder league players is to compare the player's age to the feeder league age limit on the draft date.

09-04-2009, 05:54 PM	#1 (permalink)
Kemp All Star Starter Join Date: Feb 2002 Posts: 1,178 Thanked 12x in 4 posts	Database question I import the csv files from my league into a large Access database and run various reports. I'm working on a report that will help me prep for the amateur draft and I found a field called "draft_eligible" in the Players table. It appears that that field has either a '0' or a '1' depending on whether the player is draft eligible or not. Great! Only problem is, I compared this flag to the in game Draft Pool report and it appears that not all of the players from the draft report have a '1' in the "draft_eligible" field. I believe this may be an error. Does anyone else look at or use this field for anything? Thanks!

09-04-2009, 07:26 PM	#3 (permalink)
fhomess Hall Of Famer Join Date: Nov 2002 Posts: 2,724 Thanked 255x in 119 posts	Best way to get the full list of eligible feeder league players is to compare the player's age to the feeder league age limit on the draft date. __________________ StatsLab11 - PHP/MySQL based utilities for Online Leagues Other Mods: 19th Century: Schedules, FaceGen BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds PEBA - Connecticut Nutmeggers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

09-04-2009, 06:12 PM	#2 (permalink)
Kemp All Star Starter Join Date: Feb 2002 Posts: 1,178 Thanked 12x in 4 posts	Ahhh, I think I figured it out. The game is not flagging any player coming out of a feeder league that does not have any stats. Regardless, I think the game should be flagging those players. I'm going to report this as a bug.