06-27-2006, 08:55 AM
|
#5 (permalink)
|
|
Hall Of Famer
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,289
Thanks: 27
Thanked 46x in 31 posts
|
Quote:
|
Originally Posted by dougaiton
If you're just using the 'players' table, retired players have no skills in certain areas, at least in the 'Players' table. When I run DB queries, I use 'running ratings', which for retired players are always set to 0. All active players will have running ratings >0, so a simple conditional (where running_rating_1>0) should weed out the retired.
As for the other tables, which I presume you're more interested in, I've no idea. Sorry.
|
That's good info. I would have thought there would be a status of "announced retirement" or something along those lines.
__________________
When is good enough, good enough?
|
|
|