Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 06-25-2006, 02:57 PM   #1 (permalink)
Hall Of Famer
 
jarmenia's Avatar
 
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,276
Thanks: 26
Thanked 43x in 29 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, 11:23 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 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, 02:13 PM   #3 (permalink)
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,494
Thanks: 41
Thanked 45x in 24 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, 05:56 AM   #4 (permalink)
Hall Of Famer
 
dougaiton's Avatar
 
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.
dougaiton is offline   Reply With Quote
Old 06-27-2006, 09:55 AM   #5 (permalink)
Hall Of Famer
 
jarmenia's Avatar
 
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,276
Thanks: 26
Thanked 43x in 29 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, 09:24 AM   #6 (permalink)
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 6,468
Thanks: 146
Thanked 1,088x in 415 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, 10:22 PM   #7 (permalink)
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,494
Thanks: 41
Thanked 45x in 24 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, 05:39 AM   #8 (permalink)
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 6,468
Thanks: 146
Thanked 1,088x in 415 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, 09:21 PM   #9 (permalink)
Hall Of Famer
 
jarmenia's Avatar
 
Join Date: Mar 2002
Location: Tampa, FL USA
Posts: 4,276
Thanks: 26
Thanked 43x in 29 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
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 09:55 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments