Latest News: OOTP PATCH 9.2.2 released - buy before Oct. 17th and save $10! - OOTP 9 RELEASED! - Title Bout Championship Boxing 2.5 released! - OOTP 2007 receives Editors Choice Award from PC Gamer - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 9!

Go Back   OOTP Developments Forums > OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

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

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 08-30-2006, 05:08 PM   #1 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,460
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.
tysok is offline   Reply With Quote
Old 08-30-2006, 05:14 PM   #2 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,460
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?
tysok is offline   Reply With Quote
Old 08-30-2006, 05:27 PM   #3 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 329
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

Last edited by Zubes : 08-30-2006 at 05:29 PM.
Zubes is offline   Reply With Quote
Old 08-30-2006, 06:00 PM   #4 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,460
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.
tysok is offline   Reply With Quote
Old 08-30-2006, 06:58 PM   #5 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
0,1 is not really AL/NL, but instead you have to look up in the sub_leagues file and see what it is.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 08-30-2006, 11:18 PM   #6 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 329
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
Zubes is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:20 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 Out of the Park Developments