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 (permalink)
jarmenia Hall Of Famer Join Date: Mar 2002 Location: Tampa, FL USA Posts: 4,289 Thanks: 27 Thanked 46x in 31 posts	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 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,895 Thanks: 0 Thanked 27x in 17 posts	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 (permalink)
fantom1979 Hall Of Famer Join Date: Jul 2002 Location: Detroit, MI Posts: 3,496 Thanks: 42 Thanked 48x in 25 posts	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. __________________ Useful OOTP Links: Webstore -- Download -- Download (OLD VERSIONS) -- Tech Support -- License Problems -- Newsletters -- Padresfan's Mod Site -- OOTP Merchandise

06-27-2006, 04:56 AM	#4 (permalink)
dougaiton Hall Of Famer Join Date: Mar 2003 Location: Location: Posts: 3,411 Thanks: 0 Thanked 0x in 0 posts	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 (permalink)
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 6,720 Thanks: 200 Thanked 1,393x in 513 posts	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 Out of the Park Baseball Development Team Title Bout Development Team

06-30-2006, 04:39 AM	#8 (permalink)
Andreas Raht Administrator Join Date: Jun 2002 Location: Hollern/Stade/Germany Posts: 6,720 Thanks: 200 Thanked 1,393x in 513 posts	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 Out of the Park Baseball Development Team Title Bout Development Team

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