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, 02:21 PM   #1
Layton is my Homeboy
Major Leagues
 
Layton is my Homeboy's Avatar
 
Join Date: Apr 2006
Location: Winnipeg, Mb
Posts: 429
Thanks: 129
Thanked 270x in 100 posts
A couple fields I'm not clear on....

Hello,

I'm wondering if someone can help me figure out what some of the fields in the database mean.

In players table:
"status" field (integer, values 0 through 6)
Is this something to do with retirement, injuries, roster status, something else?

team_roster table:
"list_id" field (integer, values 1 through 4)
Something to do with 25-man, 40-man roster??
I'm guessing
3 = 40-man roster
2 = 25 man roster
1,4 = DL?? Waivers??

players_contract table:
"team_id", presumably the team the player is signed for. Yet, each team only has about 12 to 18 players signed (the dump was done just before the June draft, so rosters should be full.) Does this only list players with major league contracts?

in a bunch of tables:
split_id - I think I get this, but just to confirm:
1 = Total
2 = vs LHP/LHB
3 = vs RHP/RHB

level_id - Again, just confirming:
1 = Major League
2 = AAA
3 = AA
4 = A
5 = Short A
6 = Rookie

Thanks for any help you can provide.
Layton is my Homeboy is offline   Reply With Quote
Old 06-25-2006, 02:22 PM   #2
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 Layton is my Homeboy
Hello,

I'm wondering if someone can help me figure out what some of the fields in the database mean.

In players table:
"status" field (integer, values 0 through 6)
Is this something to do with retirement, injuries, roster status, something else?

team_roster table:
"list_id" field (integer, values 1 through 4)
Something to do with 25-man, 40-man roster??
I'm guessing
3 = 40-man roster
2 = 25 man roster
1,4 = DL?? Waivers??

players_contract table:
"team_id", presumably the team the player is signed for. Yet, each team only has about 12 to 18 players signed (the dump was done just before the June draft, so rosters should be full.) Does this only list players with major league contracts?

in a bunch of tables:
split_id - I think I get this, but just to confirm:
1 = Total
2 = vs LHP/LHB
3 = vs RHP/RHB

level_id - Again, just confirming:
1 = Major League
2 = AAA
3 = AA
4 = A
5 = Short A
6 = Rookie

Thanks for any help you can provide.

Hmm, I'm playing with the status fields as well but mine are all listed as 0.
__________________
When is good enough, good enough?

jarmenia is offline   Reply With Quote
Old 06-25-2006, 03:25 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 a 0-6 in the status field as well, I havent figured out what it means yet.
fantom1979 is offline   Reply With Quote
Old 06-25-2006, 08:34 PM   #4
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
what type of dump are you using? I'm using the access dump.
__________________
When is good enough, good enough?

jarmenia is offline   Reply With Quote
Old 06-25-2006, 10:56 PM   #5
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 am using the Mysql dump
fantom1979 is offline   Reply With Quote
Old 06-26-2006, 12:11 AM   #6
Layton is my Homeboy
Major Leagues
 
Layton is my Homeboy's Avatar
 
Join Date: Apr 2006
Location: Winnipeg, Mb
Posts: 429
Thanks: 129
Thanked 270x in 100 posts
Csv
Layton is my Homeboy is offline   Reply With Quote
Old 06-26-2006, 09:30 AM   #7
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
Hmm, I'm using the access dump. I'll have to check out one of the others to see if the problem still exists.
__________________
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 02:48 AM.

 

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