Home | Webstore
Latest News: OOTP 26 Available - FHM 12 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > 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-28-2006, 02:49 AM   #1
fearofmimes
Minors (Rookie Ball)
 
Join Date: Dec 2002
Location: Minneapolis, MN
Posts: 31
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
YoVivoPorSPORTS
Bat Boy
 
Join Date: Jul 2003
Location: Los Angeles, CA but currently in Putney, VT
Posts: 6
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
fearofmimes
Minors (Rookie Ball)
 
Join Date: Dec 2002
Location: Minneapolis, MN
Posts: 31
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


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 10:28 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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

 

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