|
CrashDavis -> RE: table award ids and milestone ids (3/20/2007 10:55:31 PM)
|
Info below provided by Shaun "The Man" Sullivan!!!
Here is the enum of possible values for the AwardID field taken directly from the code:
Public Enum Awards
ps_CY = 1
ps_MVP = 2
ps_ROY_NOT_USED = 3
ps_BattingTitle = 4
ps_OBP = 5
ps_SLG = 6
ps_OPS = 7
ps_HomeRunKing = 8
ps_SB = 9
ps_Hits = 10
ps_RunsScored = 11
ps_2B = 12
ps_3B = 13
ps_BB = 14
ps_RBI = 15
ps_ERA = 16
ps_Wins = 17
ps_Saves = 18
ps_K = 19
ps_CG = 20
ps_SHO = 21
ps_IP = 22
ps_Appearances = 23
ps_GamesStarted = 24
ps_BestRookieBatter = 25
ps_BestRookiePitcher = 26
ps_AllStarTeam = 30
ps_AllStarTeamStarter = 31
ps_Gold_Glove_Base = 32 ‘ Not an award, just an offset
ps_Gold_Glove_1 = 33
ps_Gold_Glove_2 = 34
ps_Gold_Glove_3 = 35
ps_Gold_Glove_4 = 36
ps_Gold_Glove_5 = 37
ps_Gold_Glove_6 = 38
ps_Gold_Glove_7 = 39
ps_Gold_Glove_8 = 40
ps_Gold_Glove_9 = 41
ps_SilverSlugger_Base = 42 ‘ Not an award, just an offset
ps_SilverSlugger_1 = 43
ps_SilverSlugger_2 = 44
ps_SilverSlugger_3 = 45
ps_SilverSlugger_4 = 46
ps_SilverSlugger_5 = 47
ps_SilverSlugger_6 = 48
ps_SilverSlugger_7 = 49
ps_SilverSlugger_8 = 50
ps_SilverSlugger_9 = 51
ps_SilverSlugger_10 = 52
ps_Awards_Last = 53 ‘ Not an award, just an offset
end enum
Here are the milestones. Note the milestones are added each time a player crosses the threshold for example, a player with 300 HR will have 3 milestone records with a value of 1 (msb_100HR)
Public Enum Milestones
msb_1000Hits = 0
msb_100HR = 1
msb_1000Games = 2
msp_100wins = 3
msp_1000K = 4
msp_NoHitter = 5
End Enum
Hope that helps!
Shaun
|
|
|
|
