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

Closed Thread
 
Thread Tools
Old 07-13-2006, 05:22 AM   #1
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
Fields & Tables

There have be questions about the financial modifier and the meaning of the values in some fields on the beta testing forums. It makes sense to post these queries and answers in a public forum, so I'll start a thread right here and now



Sorry, the financial modifier is not in the SQL dump. Please use a constant in your tool or in your queries holding the value of the financial coefficient that's being used in your league. Since this value doesn't change for a league, it's easier this way than working with a lookup table for this value (IMHO).

This table might help you with the field "category" in the league leaders table (players_league_leader.*):

case 0: cat_str = "GS"; category = PVDID_BATTING_STATS_GS;
case 1: cat_str = "PA"; category = PVDID_BATTING_STATS_PA;
case 2: cat_str = "AB"; category = PVDID_BATTING_STATS_AB;
case 3: cat_str = "H"; category = PVDID_BATTING_STATS_H;
case 4: cat_str = "K"; category = PVDID_BATTING_STATS_K;
case 5: cat_str = "TB"; category = PVDID_BATTING_STATS_TB;
case 6: cat_str = "2B"; category = PVDID_BATTING_STATS_D;
case 7: cat_str = "3B"; category = PVDID_BATTING_STATS_T;
case 8: cat_str = "HR"; category = PVDID_BATTING_STATS_HR;
case 9: cat_str = "SB"; category = PVDID_BATTING_STATS_SB;
case 10: cat_str = "RBI"; category = PVDID_BATTING_STATS_RBI;
case 11: cat_str = "R"; category = PVDID_BATTING_STATS_R;
case 12: cat_str = "BB"; category = PVDID_BATTING_STATS_BB;
case 13: cat_str = "IBB"; category = PVDID_BATTING_STATS_IBB;
case 14: cat_str = "HP"; category = PVDID_BATTING_STATS_HP;
case 15: cat_str = "SH"; category = PVDID_BATTING_STATS_SH;
case 16: cat_str = "SF"; category = PVDID_BATTING_STATS_SF;
case 17: cat_str = "EBH"; category = PVDID_BATTING_STATS_EBH;
case 18: cat_str = "AVG"; category = PVDID_BATTING_STATS_AVG;
case 19: cat_str = "OBP"; category = PVDID_BATTING_STATS_OBP;
case 20: cat_str = "SLG"; category = PVDID_BATTING_STATS_SLG;
case 21: cat_str = "RC"; category = PVDID_BATTING_STATS_RC;
case 22: cat_str = "RC/27"; category = PVDID_BATTING_STATS_RC27;
case 23: cat_str = "ISO"; category = PVDID_BATTING_STATS_ISO;
case 24: cat_str = "TAVG"; category = PVDID_BATTING_STATS_TAVG;
case 25: cat_str = "OPS"; category = PVDID_BATTING_STATS_OPS;
case 26: cat_str = "VORP"; category = PVDID_BATTING_STATS_VORP;
case 27: cat_str = "G"; category = PVDID_PITCHING_STATS_G;
case 28: cat_str = "GS"; category = PVDID_PITCHING_STATS_GS;
case 29: cat_str = "W"; category = PVDID_PITCHING_STATS_W;
case 30: cat_str = "L"; category = PVDID_PITCHING_STATS_L;
case 31: cat_str = "Winning %"; category = PVDID_PITCHING_STATS_WINP;
case 32: cat_str = "SV"; category = PVDID_PITCHING_STATS_S;
case 33: cat_str = "HLD"; category = PVDID_PITCHING_STATS_HLD;
case 34: cat_str = "IP"; category = PVDID_PITCHING_STATS_IP;
case 35: cat_str = "BF"; category = PVDID_PITCHING_STATS_BF;
case 36: cat_str = "HRA"; category = PVDID_PITCHING_STATS_HRA;
case 37: cat_str = "BB"; category = PVDID_PITCHING_STATS_BB;
case 38: cat_str = "K"; category = PVDID_PITCHING_STATS_K;
case 39: cat_str = "WP"; category = PVDID_PITCHING_STATS_WP;
case 40: cat_str = "ERA"; category = PVDID_PITCHING_STATS_ERA;
case 41: cat_str = "BABIP"; category = PVDID_PITCHING_STATS_BABIP;
case 42: cat_str = "WHIP"; category = PVDID_PITCHING_STATS_WHIP;
case 43: cat_str = "K/BB"; category = PVDID_PITCHING_STATS_KBB;
case 44: cat_str = "RA/9"; category = PVDID_PITCHING_STATS_R9;
case 45: cat_str = "HR/9"; category = PVDID_PITCHING_STATS_HR9;
case 46: cat_str = "H/9"; category = PVDID_PITCHING_STATS_H9;
case 47: cat_str = "BB/9"; category = PVDID_PITCHING_STATS_BB9;
case 48: cat_str = "K/9"; category = PVDID_PITCHING_STATS_K9;
case 49: cat_str = "VORP"; category = PVDID_PITCHING_STATS_VORP;
case 50: cat_str = "RA"; category = PVDID_PITCHING_STATS_RA;
case 51: cat_str = "GF"; category = PVDID_PITCHING_STATS_GF;
case 52: cat_str = "QS"; category = PVDID_PITCHING_STATS_QS;
case 53: cat_str = "QSP"; category = PVDID_PITCHING_STATS_QSP;
case 54: cat_str = "CG"; category = PVDID_PITCHING_STATS_CG;
case 55: cat_str = "CGP"; category = PVDID_PITCHING_STATS_CGP;
case 56: cat_str = "SHO"; category = PVDID_PITCHING_STATS_SHO;
case 57: cat_str = "GB%"; category = PVDID_PITCHING_STATS_GBFBP;

If there are any more questions, please ask and/or send me a PM.


Andreas Raht is offline  
Old 07-21-2006, 08:07 AM   #2
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
The list_id in team_roster table tells you on which roster table the record has been found:

team->roster.all_players = 1
team->roster.active = 2
team->roster.secondary = 3
team->roster.disabled_list = 4
Andreas Raht is offline  
Closed Thread

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 07:32 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