|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
08-30-2006, 05:08 PM | #1 |
Hall Of Famer
Join Date: Aug 2003
Posts: 4,925
|
What is this field
I'm playing with a csv dump... I'm looking at players career batting stats (or career pitching stats) there's a field split id. Makes sense that this might be left/right/total for number 1/2/3 but I have a lot of number 21s. What is 21?
Also the position field, what is 0? Is that DH? Thanks. |
08-30-2006, 05:14 PM | #2 |
Hall Of Famer
Join Date: Aug 2003
Posts: 4,925
|
I knew there was another one...
In the league leaders csv... is that keeping track of only ML level? Apparently, so 0 is like the NL, 1 is the AL? |
08-30-2006, 05:27 PM | #3 |
Major Leagues
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
|
no one is going to help you here, as i havent gotten any myself...
the split_id from what i have gathered is: 1 = total stats for the year 2 = vs L 3 = vs R 21 = postseason stats for league leaders in regards to sub_league_id: 0 = AL 1 = NL we should try to help each other
__________________
Phil Zuber Beyond the Ivy - Commish, Twins GM Stars and Stripes Baseball League - Cubs GM Bricks and Ivy - Orioles GM Sim Coalition - co-founder Last edited by Zubes; 08-30-2006 at 05:29 PM. |
08-30-2006, 06:00 PM | #4 |
Hall Of Famer
Join Date: Aug 2003
Posts: 4,925
|
Thank ya Zubes, I didn't even think of postseason.
I'm an idiot on the 0... every one shows 0 there. There is position 10 in the fielding stats that's obviously the DH. I'm happy to help with anything I can, but I rarely come into this section. Just trying to come up with a HOF stat I can look at right now and ran into those questions. |
08-30-2006, 06:58 PM | #5 |
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
|
0,1 is not really AL/NL, but instead you have to look up in the sub_leagues file and see what it is.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT] |
08-30-2006, 11:18 PM | #6 |
Major Leagues
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
|
in a basic ML setup though, it is, and i assumed that is what he had.
__________________
Phil Zuber Beyond the Ivy - Commish, Twins GM Stars and Stripes Baseball League - Cubs GM Bricks and Ivy - Orioles GM Sim Coalition - co-founder |
Bookmarks |
|
|