Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 06-25-2006, 01:57 PM   #1
jarmenia
Hall Of Famer
 
jarmenia's Avatar
 
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,490
Thanks: 79
Thanked 163x in 85 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?

jarmenia is offline   Reply With Quote
Old 06-26-2006, 10:23 AM   #2
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 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]
Comedian2004 is offline   Reply With Quote
Old 06-26-2006, 01:13 PM   #3
fantom1979
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,497
Thanks: 45
Thanked 50x in 27 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.
fantom1979 is offline   Reply With Quote
Old 06-27-2006, 04:56 AM   #4
dougaiton
Hall Of Famer
 
dougaiton's Avatar
 
Join Date: Mar 2003
Location: Location:
Posts: 3,414
Thanks: 1
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.
dougaiton is offline   Reply With Quote
Old 06-27-2006, 08:55 AM   #5
jarmenia
Hall Of Famer
 
jarmenia's Avatar
 
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,490
Thanks: 79
Thanked 163x in 85 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?

jarmenia is offline   Reply With Quote
Old 06-28-2006, 08:24 AM   #6
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,834
Thanks: 855
Thanked 4,829x in 1,561 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 is offline   Reply With Quote
Old 06-28-2006, 09:22 PM   #7
fantom1979
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,497
Thanks: 45
Thanked 50x in 27 posts
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?
fantom1979 is offline   Reply With Quote
Old 06-30-2006, 04:39 AM   #8
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,834
Thanks: 855
Thanked 4,829x in 1,561 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 is offline   Reply With Quote
Old 07-02-2006, 08:21 PM   #9
jarmenia
Hall Of Famer
 
jarmenia's Avatar
 
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,490
Thanks: 79
Thanked 163x in 85 posts
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.
__________________
When is good enough, good enough?

jarmenia is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:37 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments