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

Coming soon: Collection Missions

  

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

OOTP Mods Logos, roster packs, historical databases, OOTP tools, FaceGen files... it's all here!

Reply
 
Thread Tools
Old 11-08-2015, 09:46 PM   #1
silverwolf
Minors (Double A)
 
Join Date: Sep 2012
Posts: 166
Thanks: 32
Thanked 61x in 36 posts
International Complex in SQL Dump

Working on some offline utilities to monitor league compliance with roster rules, and I cannot find any way to tell if a player is in the international complex or not from the players table in the SQL dump. Players in the complex have the same team ID as players on the major league roster.

StatsLab uses the SQL data dumps, and has no info about the int'l complex in it at this point, either.

Anyone look at this before and have any suggestions, or am I missing something obvious?
silverwolf is offline   Reply With Quote
Old 11-08-2015, 10:31 PM   #2
eriqjaffe
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 6,765
Thanks: 329
Thanked 3,215x in 1,029 posts
Quote:
Originally Posted by silverwolf View Post
Working on some offline utilities to monitor league compliance with roster rules, and I cannot find any way to tell if a player is in the international complex or not from the players table in the SQL dump. Players in the complex have the same team ID as players on the major league roster.

StatsLab uses the SQL data dumps, and has no info about the int'l complex in it at this point, either.

Anyone look at this before and have any suggestions, or am I missing something obvious?
I don't have any of the table structure in front of me, but instead of looking for players who are in the international complex, maybe look for players who meet the following:

1) Are not on a major league or minor league roster
2) Are not retired
3) Are not free agents
4) Are under 20 years of age

There may be some other criteria I'm not thinking of, but I think that will pretty much leave you with players who are in the international comples.
__________________


I'm also the commissioner of the OTBA. Drop me a line if you'd like to join!
eriqjaffe is offline   Reply With Quote
Old 11-08-2015, 10:57 PM   #3
silverwolf
Minors (Double A)
 
Join Date: Sep 2012
Posts: 166
Thanks: 32
Thanked 61x in 36 posts
Quote:
Originally Posted by eriqjaffe View Post
1) Are not on a major league or minor league roster
Thanks for the suggestion, got me thinking the right direction.

What I am seeing is that the complex players have their current team_id is the same as the major league team_id in players table. They aren't FAs or retired.

There is a team_roster table, which has only 3 fields: team_id, player_id, list_id. Found the definition of list_id from an old thread as:

team->roster.all_players = 1
team->roster.active = 2
team->roster.secondary = 3
team->roster.disabled_list = 4

I'm seeing through some looking that complex players don't show in that table, but major league and 40-man guys do show.

So any player that shows with the major league team_id in players, but does not show on the roster in team_roster is likely in the complex, especially if they are young (under 20), and don't show any prior stats. (Should work for my league, at least.)
silverwolf 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 10:56 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