Home | Webstore
Latest News: OOTP 26 Available - FHM 12 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-14-2010, 12:21 PM   #1
joe_44850
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
joe_44850 is offline   Reply With Quote
Old 05-14-2010, 12:40 PM   #2
joe_44850
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
joe_44850 is offline   Reply With Quote
Reply

Bookmarks


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:38 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments