Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 08-28-2006, 02:49 AM   #1 (permalink)
Minors (Rookie Ball)
 
Join Date: Dec 2002
Location: Minneapolis, MN
Posts: 31
Thanks: 0
Thanked 0x in 0 posts
Fielding ratings

It does not appear that the fielding ratings included in CSV and SQL dumps are related directly to data in the database files. I am referring specifically to the following fields in the CSV dumps:

fielding_rating_pos1
fielding_rating_pos2
fielding_rating_pos3
fielding_rating_pos4
fielding_rating_pos5
fielding_rating_pos6
fielding_rating_pos7
fielding_rating_pos8
fielding_rating_pos9

Are these calculated fields? I have figured out how the values that show up in the CSV dumps are mapped from the players.dat file, but I can't find a logical place in the record structure for these rating fields. It seems to me like there must be some kind of calculatons for each position where the component ratings are combined in some way and then scaled based on the experience value. For example, every non-zero value for fielding_rating_pos is accompanied by a positive falue for the corresponding experience field.

I'm wondering if I'm on the right track. I don't have anything against doing a little modeling to derive these values if I need to, but I would hate to travel too far down the wrong path if my assumptions are incorrect.
fearofmimes is offline   Reply With Quote
Old 09-05-2006, 05:56 PM   #2 (permalink)
Bat Boy
 
Join Date: Jul 2003
Location: Los Angeles, CA but currently in Putney, VT
Posts: 6
Thanks: 0
Thanked 0x in 0 posts
In the game there are two things shown, range and % so shouldn't there be another field (or maybe both are encoded in the field you have there, but that would then make me wonder where the catcher and outfielder arm ratings are). Also I haven't looked at the structure or fields but maybe it is related to speed and stealing ability which are two seperate entitites when displayed in game.
__________________
It's called baseball not foosball!
YoVivoPorSPORTS is offline   Reply With Quote
Old 09-14-2006, 03:32 PM   #3 (permalink)
Minors (Rookie Ball)
 
Join Date: Dec 2002
Location: Minneapolis, MN
Posts: 31
Thanks: 0
Thanked 0x in 0 posts
Not much progress

What I have been able to figure out so far is that experience has a linear relationship to the calculated fielding ratings. Beyond that, I'm at a loss. This is probably a result of my poor statistical analysis skills. What I have observed is that for a particular rating, if you vary one of the component ratings (infield arm, infield range, etc.) while holding all others constant, the resulting variation in the fielding rating is proportional linearly. However, the amount of variation for any given increase depends on the values for the other component ratings. I am experimenting with some other analysis techniques to see if I can isolate the relationships that I believe to exist.

I'm wondering if anyone has any insight or ideas about how these ratings are calculated.
fearofmimes is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
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

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



All times are GMT -4. The time now is 09:01 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments