|
||||
| ||||
|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
Thread Tools |
|
|
#1 |
|
Minors (Single A)
Join Date: Oct 2002
Posts: 66
|
Players_league_leader categories
I'm working with a CSV dump of my league. My question is with the players_league_leader file, and the categories field. I'm assuming each category, like 7 for example, would relate to doubles, 8 to triples, etc. Where is the reference for this? I can't find any relational information from any of the other csv files.
__________________
Southerners are very strange about that war -- Shelby Foote |
|
|
|
|
|
#2 |
|
Minors (Single A)
Join Date: Oct 2002
Posts: 66
|
Nevermind, I found the answer http://www.ootpdevelopments.com/boar...ds-tables.html
However, I will reprint in case anyone else needs this: 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;
__________________
Southerners are very strange about that war -- Shelby Foote |
|
|
|
![]() |
| Bookmarks |
|
|