Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

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

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

Reply
 
Thread Tools
Old 08-30-2006, 05:08 PM   #1
tysok
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,925
Thanks: 0
Thanked 12x in 6 posts
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
tysok
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,925
Thanks: 0
Thanked 12x in 6 posts
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
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
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.
Zubes is offline   Reply With Quote
Old 08-30-2006, 06:00 PM   #4
tysok
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,925
Thanks: 0
Thanked 12x in 6 posts
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
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
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]
Comedian2004 is offline   Reply With Quote
Old 08-30-2006, 11:18 PM   #6
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
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

Zubes is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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 06:27 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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

 

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