Fields & Tables

[Andreas Raht]

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]

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