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 07-13-2006, 07:18 PM   #1
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Anderson Utilities - AUHOFpoints

Released:

http://www.sim2005.com/AUHOF/default.htm

A point system that rates the players on everything possible, except how good their wife looks.

Will be 100 percent editable:

For instance:

For career hits, you may get points like this:

>1999 5
>2499 5
>2999 7
>3499 9
>3999 11
>4490 15

So, someone with 3218 hits would get 17 points (5+5+7). Then it would check the HR chart, then 2B chart, etc. You could even lose points if your career average was below a certain point.

In the above example, you can change any of the values and save the configuration, so different leagues could have different point systems and we can share the point systems.

The program would then give 4 reports:

1. All time HOF points leaders (with active players included if enough at bats)
2. Active HOF points leaders
3. HOF players that SHOULD NOT be in the HOF
4. HOF players that SHOULD be in the HOF and are not.

Coming to your computer soon....
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 09-14-2006 at 03:10 PM.
Comedian2004 is offline   Reply With Quote
Old 07-13-2006, 09:23 PM   #2
gbmoore121
All Star Reserve
 
gbmoore121's Avatar
 
Join Date: Feb 2002
Location: Arizona
Posts: 602
Sounds Great! Thank you!
__________________
WWPF- via DDS Pro Football
gbmoore121 is offline   Reply With Quote
Old 07-20-2006, 01:05 PM   #3
Operation Shutdown
All Star Reserve
 
Operation Shutdown's Avatar
 
Join Date: Jun 2002
Location: Pittsburgh PA
Posts: 912
Any way you can set it up with the same ratings as the HOF Monitor as the default.
__________________
"And Shepherds we shall be, For thee, my Lord, for thee.
Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands.
So we shall flow a river forth to Thee, And teeming with souls shall it ever be.
In Nomeni Patri Et Fili Spiritus Sancti."
Operation Shutdown is offline   Reply With Quote
Old 07-21-2006, 11:16 PM   #4
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I really did not like those ratings, as a lot of them are based on league average. I can go round and round about that.

The league average, IMHO, is a crock. First, you have pitchers batting in the NL. So, you would have to break it down between leagues.

2nd. The league average should just be based on the guy that started the game. Your team gets a lead, in the 7th inning, they start making defensive subs. Better fields, lousy hitters. This lowers the league aveage for hitting.

My HOF points for 6.x was very nice, as it truely showed the value of the hitter or pitcher.

Another thing, they give more points in the BR one based on your position played. In OOTP, position does not affect your hitting, at least it is not documented. So, a catcher is not going to be more fatigued in the 8th inning, compared to a right fielder, who handled 4 balls all game.
__________________
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 07-22-2006, 12:03 AM   #5
gbmoore121
All Star Reserve
 
gbmoore121's Avatar
 
Join Date: Feb 2002
Location: Arizona
Posts: 602
Hey Comedian,

I agree with a lot of what you say above, but the game does take some sort of fatigue into play. When I look at my leaders for games, all positions besides catcher have a leader with between 157 and 162 games played. The leader for catchers is usually in the 135 to 140 range. This might not effect the per 162 average like a real wear and tear would, but it will lessen career totals.

That being said, I really like the flexility you put into your HOF program.
__________________
WWPF- via DDS Pro Football

Last edited by gbmoore121; 07-22-2006 at 12:04 AM.
gbmoore121 is offline   Reply With Quote
Old 07-28-2006, 02:46 AM   #6
fantom1979
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,498
any update on this? looks very useful
__________________

fantom1979 is offline   Reply With Quote
Old 07-28-2006, 03:20 AM   #7
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Not really, still in the works. I got sided tracked with the Autologo program.

This one is a pretty complicated one, so to break up the 'ho hum' of it, I write other ones and then go back to this one later.
__________________
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 07-28-2006, 06:38 AM   #8
Syd Thrift
Hall Of Famer
 
Syd Thrift's Avatar
 
Join Date: May 2004
Posts: 10,618
FWIW, HOF Monitor points aren't based on how good a player is but whether or not he's a viable candidate according to the other people who've gotten into the Hall. IRL, there are too many pitchers from the deadball era and *way* too many hitters from the 20s and 30s due in large part because voters later on went gaga over stats without looking at the context (also because of Frankie Frisch, but that's a whole 'nother ballgame). To contrast, pitchers who would be borderline HOFers if they played as well relative to their league in the 50s and 60s as they did in the Depression era stay out because statistically they look like average guys with a good number of wins (example: Wes Ferrell, whose brother, ironically enough, is in the Hall as a catcher and probably shouldn't be).

So it's a neat idea, what you've got, but I for one would prefer something that reflected the fallibility of American sportswriters.
__________________
Quote:
Originally Posted by Markus Heinsohn
You bastard....
The Great American Baseball Thrift Book - Like reading the Sporting News from back in the day, only with fake players. REAL LIFE DRAMA THOUGH maybe not
Syd Thrift is offline   Reply With Quote
Old 09-01-2006, 04:01 PM   #9
tysok
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,925
Quote:
Originally Posted by Comedian2004
I really did not like those ratings, as a lot of them are based on league average. I can go round and round about that.

The league average, IMHO, is a crock. First, you have pitchers batting in the NL. So, you would have to break it down between leagues.

2nd. The league average should just be based on the guy that started the game. Your team gets a lead, in the 7th inning, they start making defensive subs. Better fields, lousy hitters. This lowers the league aveage for hitting.

My HOF points for 6.x was very nice, as it truely showed the value of the hitter or pitcher.

Another thing, they give more points in the BR one based on your position played. In OOTP, position does not affect your hitting, at least it is not documented. So, a catcher is not going to be more fatigued in the 8th inning, compared to a right fielder, who handled 4 balls all game.
Actually, HOF Monitor doesn't deal with league average information... but it does add for some positions. While it's not entirely a good thing for OOTP, it doesn't seem to skew the numbers as badly as it might.
HOF Standards does add something for all positions... which is definately not needed in the game I think.
tysok is offline   Reply With Quote
Old 09-02-2006, 10:45 PM   #10
YoVivoPorSPORTS
Bat Boy
 
Join Date: Jul 2003
Location: Los Angeles, CA but currently in Putney, VT
Posts: 6
Just wondering if you are going to make it so that there can be qualifers. Here is an example.

Player A ends his career with a .240 career batting average and 3600 hits.

Player B ends his career with a .320 career batting average and 3000 hits.

Without qualifiers Player A ends up with more points based on his hits stats.

With qualifiers, depending on how they are set up, A and B end up with the same amount of poitns or B ends up with more points for hits than B because he accumulated a much better average even though he did not have as many hits.

If the program lacked qualifiers I think there would be many more players racking up many HOF points based solely on longevity while with qualifiers it could be set up so that players like Roberto Clemente would get a bunch of HOF points (or think Gale Sayers in football, he'd never be in if the length of work was not consdiered, he played under 100 games). And to avoid qualifiers allowing inferior players with just a few years with a hiugher average or something getting tons of points a minimum number of At bats or other stat could be implemented. It could also be implemented as it is in the MLB rulebook which I have in my hands which talks about how to determine the batting champ. This would obviously have to be modified so maybe a certain number of at-bats for am inimum number of years (basicalyl just multiply the number by one fewer than the number of years the player played [in case they missed a season for injury or something]) Anyways here's waht it says for Batting average and it is very similiar in terms of fielding title.

Here is the MLB Rulebook rule that I'm referring to. BTW Leauge Championship games basically refer to regular season games.

10.23a
The individual batting champion or slugging champion shall be the player with the highest batting average or slugging percentage, provided he is credited with as many or more total appearances at the plate in League Championship games as the number of games scheduled for each club in his league that season, multiplied by 3.1 in the case of a major league player. EXCEPTION: However, if there is any player with fewer than the required number of plate appearances whose average would be the highest, if he were charged with the required number of plate appearances or official at-bats, then the player shall be awarded the batting championship or slugging championship.

if you would like the example given in the rulebook I can post that on request and it also says the definition of total plate appearances.


I also have some other ideas like adding extra points for milestones like 3500 ks and 500 hr and then also for receiving awards (maybe that could be set up so that it can be set to add poiints for all awards or any number, like only give points for 3 or more of a specific award.)

-Andrew


PS. If you like my idea and want me to set up options or map out hte idea I'd be glad to do it.
__________________
It's called baseball not foosball!
YoVivoPorSPORTS is offline   Reply With Quote
Old 09-03-2006, 02:07 AM   #11
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Actually, it is already in the program.

The player with a .320 average got extra points for the average. The higher your lifetime average, the more points. Big bonus at .400 also! And the other way also, if your average is below a certain amount, you lose points, the lower the average, the more points.

In fact, you hit 500 homeruns and average .220, you will have some lousy points!

Same thing with the K's, OBP, SLG, etc.
__________________
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 09-05-2006, 05:49 PM   #12
YoVivoPorSPORTS
Bat Boy
 
Join Date: Jul 2003
Location: Los Angeles, CA but currently in Putney, VT
Posts: 6
Okay, but have you also made it so that someone with a high average, but only, say 2000 is not rewarded. Also are you going to include OPS as a stat in calculating points?
__________________
It's called baseball not foosball!
YoVivoPorSPORTS is offline   Reply With Quote
Old 09-05-2006, 07:47 PM   #13
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Someone with a high average, but only 2000 hits is given bonuses for his high average. But, the hit points don't start until 2500.

I did not include this, as I think that is made up of two other stats that I already award points for.

Quote:
Originally Posted by YoVivoPorSPORTS
Okay, but have you also made it so that someone with a high average, but only, say 2000 is not rewarded. Also are you going to include OPS as a stat in calculating points?
__________________
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 09-11-2006, 10:04 PM   #14
rasnell
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Location: Frankfort, Kentucky
Posts: 3,746
You're missing a left and right scrollbar to see all of the pitching stats. Also, is there any way that clicking on a column will default to the descending view instead of ascending? You have to double-click to get the column going the descending way.
rasnell is offline   Reply With Quote
Old 09-14-2006, 03:10 PM   #15
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I raised up the grid, so you should be able to see the sroll bars. If not, then hide the windows taskbar.

As far as the sort default, I have not found a way to get it to sort decending by default.


http://www.sim2005.com/AUHOF/default.htm
__________________
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
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 09:28 PM.

 

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 - 2026, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments