StatsLab SQL Utilities for OOTPX

[Stu]

Feature Request for Next Version:

Add the ability to vote for custom awards. My league has additional awards for best reliever and best GM that we handle outside the game.

Thanks. Loving this utility so far!

[fhomess]

Originally Posted by Stu

Feature Request for Next Version:

Add the ability to vote for custom awards. My league has additional awards for best reliever and best GM that we handle outside the game.

Thanks. Loving this utility so far!

Patch 2.1 is now available with the ability to vote for a custom award as well as a GM of the Year award.

Also, miscellaneous fixes to some minor issues.

Use the same download link as for Patch 2.

[Stu]

Originally Posted by fhomess

Patch 2.1 is now available with the ability to vote for a custom award as well as a GM of the Year award.

Also, miscellaneous fixes to some minor issues.

Use the same download link as for Patch 2.

Wow, that was quick.

[gollum65]

Great additions, especially with the HoF voting module. Question: What are the "Hall of Fame Standards" categories for hitters and pitchers in the module? Standards for what? Hits? Homers? SBs? For pitchers is it Wins? Saves? Ks? I don't understand what I'm supposed to put for either of those options.

[Stu]

Originally Posted by gollum65

Great additions, especially with the HoF voting module. Question: What are the "Hall of Fame Standards" categories for hitters and pitchers in the module? Standards for what? Hits? Homers? SBs? For pitchers is it Wins? Saves? Ks? I don't understand what I'm supposed to put for either of those options.

There's a HOF standards stat in the Career Metrics utility. You'll find it at the bottom of each player's page and I believe you can sort by it as well.

According to baseball-reference the average HOFer should be around 50.

[gollum65]

Thanks Stu. Never heard of that before.

[fhomess]

You can find detail on how HOF Standards is calculated here: Baseball Reference Glossary

The metric was designed to reflect major league baseball and its HOF voting history, so it's likely that your league will have a slightly different scale of what's good and what's not.

[gollum65]

Thanks. Would our scale be lower or higher then 50? One problem we had at the start of the league in 2008 season was that somehow all the hall of famers vanished from the game file. So I ended up importing about 25 of the biggest names in the game (Ruth, Gehrig, Mays, etc) so the most revered stats in the game would have a benchmark in our league. But we still have a lot of hall of famers who were never added back to the league. Plus, we've of course inducted our own guys as the league has progressed.

[fhomess]

Originally Posted by gollum65

Thanks. Would our scale be lower or higher then 50? One problem we had at the start of the league in 2008 season was that somehow all the hall of famers vanished from the game file. So I ended up importing about 25 of the biggest names in the game (Ruth, Gehrig, Mays, etc) so the most revered stats in the game would have a benchmark in our league. But we still have a lot of hall of famers who were never added back to the league. Plus, we've of course inducted our own guys as the league has progressed.

It really depends on your league settings. If you're playing a league based on the real major leagues, then it's probably a good fit for your league. If your teams only play 100 games a year, then something a little lower than 50 might be a good bench mark. I think it makes more sense to look at the values relative to other players in your league rather than thinking of a specific number as a cutoff. That's probably true for all stats.

[Stu]

And keep in mind that 50 is the "average" HOFer so you might want to go with something lower to make sure those borderline guys appear on the ballot.

[snnort]

Does using this StatsLab patch require you to be on OOTP 10.4.29 (or the coming 10.4.30)?

Meaning if you are still using 10.2.16 or 10.2.18 can you use this new patched version of StatsLab?

[Alan T]

Originally Posted by snnort

Does using this StatsLab patch require you to be on OOTP 10.4.29 (or the coming 10.4.30)?

Meaning if you are still using 10.2.16 or 10.2.18 can you use this new patched version of StatsLab?

Using this patch on 10.2.16 I think will break some stuff but not everything. I don't remember exactly what it is that breaks, fhomess will have to provide more in the way of specifics I fear!

[fhomess]

Originally Posted by Alan T

Using this patch on 10.2.16 I think will break some stuff but not everything. I don't remember exactly what it is that breaks, fhomess will have to provide more in the way of specifics I fear!

Correct. There were some changes to the data dump that require the latest patch. Specifically:
1. Player ratings are reported differently - affecting development, ratings, and the draft util.
2. The players_league_leaders table had a fix made to it, which affects the HOF Metrics calculations (Black/Gray Ink), and the StatsLab player pages that display this information.

[gollum65]

I'm fairly certain I mentioned this issue before, and I assume others have as well. Is there anything that can be done about how slow the draft war room is to load? It typically takes more then 2 minutes for me, and I've had other GMs in my league report it not loading after 15 minutes. I assume this problem is due to having a full 900 player draft class like the real MLB, but it shouldn't take that long to load every time should it?

[snnort]

Is this not a reflection of the speed of the server that StatsLab is on AND the internet connection of the user to the server?

[gollum65]

The rest of the modules in the utility load in less then a second. And slow internet connections for 30 different people all over the world?

[Recte44]

Widgets admin isn't able to find the folder....problem is that everytime I type it in, when I click save the utility adds extra "/" every time.

[fhomess]

Originally Posted by gollum65

The rest of the modules in the utility load in less then a second. And slow internet connections for 30 different people all over the world?

This page can take a while to load, which is part of why the setting to limit the number of players displayed is there. I had not heard of any queries taking quite this long to load, however. I'm happy to look at making this page more efficient if you can provide me (via PM) with a GM login that you don't mind me using to watch the page load. I don't need to change/save any team settings, but do need to determine if there's certain behavior going on. My test leagues never took much more than 5 seconds to load.

Originally Posted by Recte44

Widgets admin isn't able to find the folder....problem is that everytime I type it in, when I click save the utility adds extra "/" every time.

Can you PM me an example of the following:
1. Your HTML root directory setting
2. Your widget directory setting as you enter it
3. Your widget directory setting as it looks afterward.
4. The "Folder XXX not found" message you're getting.

Thanks!

[gollum65]

PM sent. Thanks.

[mikev]

Is it possible for this utility to import existing development information from Getch's utility?