How to tell if a player is retired in DB Dump

jarmenia · 06-25-2006, 01:57 PM

I would think this would show up in the status field, but for me, the status is set to zero for every player. Anyone know how to tell if a player is retired?

Comedian2004 · 06-26-2006, 10:23 AM

Good luck in finding out, I asked this question over 3 weeks ago and never got an answer.

fantom1979 · 06-26-2006, 01:13 PM

I have yet to figure it out as well. Hopefully in time when most of the bugs are squashed out, Markus will be able to explain some of the fields in these tables.

dougaiton · 06-27-2006, 04:56 AM

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.

jarmenia · 06-27-2006, 08:55 AM

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.

Andreas Raht · 06-28-2006, 08:24 AM

There should be a flag "retired" in the player table... Markus and I are currently in London but I'll check that out tomorrow! It will be in the patch 2.

fantom1979 · 06-28-2006, 09:22 PM

Quote:

Originally Posted by Andreas Raht

There should be a flag "retired" in the player table... Markus and I are currently in London but I'll check that out tomorrow! It will be in the patch 2.

excellent news.. there also seem to be other fields in tables that come up as Null or "0" even though it seems like there should be data there. For example, the fields "tb" and "s" in the league_history_batting_stats table are all zeros. This is in a Sql dump. Do you want these reported here, or in the tech forum, or are they a current design choice?

Andreas Raht · 06-30-2006, 04:39 AM

I've just added the "retired" flag to the SQL dump player table for patch 2. It was actually missing! Also several other fields have been added. The player table has been split into 4 tables now.

jarmenia · 07-02-2006, 08:21 PM

Quote:

Originally Posted by Andreas Raht

I've just added the "retired" flag to the SQL dump player table for patch 2. It was actually missing! Also several other fields have been added. The player table has been split into 4 tables now.

Great News.

06-25-2006, 01:57 PM	#1
jarmenia Hall Of Famer Join Date: Mar 2002 Location: Tampa, FL USA Posts: 4,503	How to tell if a player is retired in DB Dump I would think this would show up in the status field, but for me, the status is set to zero for every player. Anyone know how to tell if a player is retired? __________________ When is good enough, good enough?

06-26-2006, 10:23 AM	#2
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	Good luck in finding out, I asked this question over 3 weeks ago and never got an answer. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

06-26-2006, 01:13 PM	#3
fantom1979 Hall Of Famer Join Date: Jul 2002 Location: Detroit, MI Posts: 3,498	I have yet to figure it out as well. Hopefully in time when most of the bugs are squashed out, Markus will be able to explain some of the fields in these tables. __________________

06-27-2006, 04:56 AM	#4
dougaiton Hall Of Famer Join Date: Mar 2003 Location: Location: Posts: 3,414	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. __________________ tThis shower of clowns My park-adjusted, historically split Born in '69 league file! (also at Joe's wonderful site +BBSC)

06-28-2006, 08:24 AM	#6
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 8,992	There should be a flag "retired" in the player table... Markus and I are currently in London but I'll check that out tomorrow! It will be in the patch 2. __________________ Andreas Raht andreas@ootpdevelopments.com Out of the Park Developments

06-30-2006, 04:39 AM	#8
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 8,992	I've just added the "retired" flag to the SQL dump player table for patch 2. It was actually missing! Also several other fields have been added. The player table has been split into 4 tables now. __________________ Andreas Raht andreas@ootpdevelopments.com Out of the Park Developments