StatsLab SQL Utilities for OOTPX

[Killebrew]

Originally Posted by fhomess

Updated the download file with some fixes and enhancements:
1. Player pictures should appear correctly
2. There's now a sql_file_load.php page where you can load SQL files individually if your load button is causing timeout errors.
3. Leaderboards page now has a bottom 100 option so you can see who was the biggest waste of roster space in your league.
4. Leaderboards page now has additional draft round and draft team options.
5. Fixed date issue with dates prior to 1969 and post 2039 (php limitation).
6. Fixed a team record issue on Team Index page related to data from certain older versions of OOTP.
7. Other miscelaneous fixes.

Just an FYI: You removed the function datediff from gen_functions.php in the updated version of this app, and as a result new users won't be able to complete the initial SQL load.

[MrWorkrate]

Is there a way to show human managers who don't control a team in the awAdmin.php voting status page? I've allowed non-GMs to login in and therefore vote for year end awards, but I can't see whether or not they've voted or who they voted for.

[PotatoPeeler]

I think I've pretty much got this set up. However, I do have one question. On the Exports and Draft pages, it's displaying the server time in MST. I'd prefer to have this set to CST.

The readme PDF states the following:

Time Zone for Time Display: If your server is utilizing PHP version 5.0 or higher, you will see this option to specify the time zone you wish to have times displayed in. The time zone setting here affects display on the Export Tracker and in the Draft Utility. All draft time slots will be based on times matching this setting. The web server that hosts your website will have a predefined time zone, typically based on the physical location of the server, so this setting can be useful if most of your GM's are located elsewhere.

I'm using a MySQL 5.0 database but I'm not seeing that option. Did I do something wrong or is this just a mistake with the readme?

Attached is what I'm seeing on the Admin page.

[PotatoPeeler]

Here's another thing I've run into.

After I change some stuff on the draft admin screen and then click the Save button, I get this error: Fatal error: Cannot instantiate non-existent class: date in <sql util path>/save_sub_admin.php on line 92

Any ideas what's causing this?

Thanks.

[udbacker58]

One thing I would like to see is that on the managers page, the Messenger tags be displayed, rather than it just saying AIM (Add). People not using AIM cannot add a person by clicking the link. I know that you can see the screen name in the status bar on the bottom of your browser, but not all people may know this.

[satchel]

Frank, my Jamaica League offers you our most sincere thanks. When we were using Getch's Utilities, you de-bugged the "talent-only" errors, which enabled us to employ the utility to its fullest; and then you answered our requests for even further customization. And now you've given the community an invaluable tool for the new game version. You have done a noble service for us all. We are taking up a collection this week, and will be sending you a donation, to express our appreciation.

Originally Posted by dangarion

Talking about security, I've been forced to move our league exports to a separate UNIX user on the server, and unfortunately that makes it impossible for the script to see the folders that user has access to (the commish user is the web access account, and the export user only has access to it's own folders, unsure if there is a way to work around that with the export tracker or not, don't worry about it, just thought I would mention it.) I'm guessing there wouldn't be a way for me to resolve this unless if I did it on my own by like running a cron job or something, but even that would be a PITA.

I use the same technique to safeguard the security of my league, and am in this exact position.

Originally Posted by PotatoPeeler

After I change some stuff on the draft admin screen and then click the Save button, I get this error: Fatal error: Cannot instantiate non-existent class: date in <sql util path>/save_sub_admin.php on line 92

I'm getting a similar error, trying to configure the draft utility. When I set the draft order, and hit "Save," I'm taken to an error screen which says

Fatal error: Class 'Date' not found in /home/[path continued]/ootpsqlou/save_sub_admin.php on line 92

[hank9481]

I have Dreamhost and am having MAJOR problems with this utility, namely a 500 internal server error everytime I try to import the files. Can someone help me understand what the hell I am doing?

[fhomess]

Apologies to all for my silence. My first daughter was born Wednesday night, so my mind has been elsewhere. I'll try to review all the posts and PM's with recent issues in the next couple of days.

[Alan T]

Originally Posted by fhomess

Apologies to all for my silence. My first daughter was born Wednesday night, so my mind has been elsewhere. I'll try to review all the posts and PM's with recent issues in the next couple of days.

Congratulations!

[Recte44]

Changes won't save in Draft Admin.

[Raidergoo]

Babies are cool!

[Recte44]

Originally Posted by Recte44

Changes won't save in Draft Admin.

At this point my league is on hold trying to figure out why I can't save any changes in draft order.

[PotatoPeeler]

Here's one more minor issue I've noticed. When I click on the leagues logo in the upper left hand corner of the utility page, it links to http://<league html address>/leagues/league__home.html when it should be linking to http://<league html address>/leagues/league_100_home.html. It seems to be forgetting the 100 part of the address, even though I have that set properly on the admin screen.

Thanks for the cool utility, fhomess and congrats on the new addition!

[Killebrew]

Originally Posted by fhomess

Apologies to all for my silence. My first daughter was born Wednesday night, so my mind has been elsewhere. I'll try to review all the posts and PM's with recent issues in the next couple of days.

Grats!!

[jdettbarn]

Originally Posted by hank9481

I have Dreamhost and am having MAJOR problems with this utility, namely a 500 internal server error everytime I try to import the files. Can someone help me understand what the hell I am doing?

Try this...

On the Admin tab, click on the SQL Files link and try importing each file individually. Try the smaller file sizes first, in order to make sure things are functioning properly.

[fhomess]

Originally Posted by hank9481

I have Dreamhost and am having MAJOR problems with this utility, namely a 500 internal server error everytime I try to import the files. Can someone help me understand what the hell I am doing?

Originally Posted by jdettbarn

Try this...

On the Admin tab, click on the SQL Files link and try importing each file individually. Try the smaller file sizes first, in order to make sure things are functioning properly.

I actually use Dreamhost, too, so it definitely can work with Dreamhost. Jason's suggestion will help you determine if it's a timeout issue with the full load of some of the larger files or if the load itself simply isn't working. If you do load the files individually, I recommend loading human_managers.mysql.sql last - as this will create the util's user table and require you to login to the util. If you're having any SQL issues, it's better to find and fix those before being required to login.

Originally Posted by udbacker58

One thing I would like to see is that on the managers page, the Messenger tags be displayed, rather than it just saying AIM (Add). People not using AIM cannot add a person by clicking the link. I know that you can see the screen name in the status bar on the bottom of your browser, but not all people may know this.

In beta testing, this was explicitly removed because the managers page can get very cluttered if the variuos IM links are all included. Some IM handles are rather long.

I've re-uploaded the util code with some fixes to issues found in this thread and PM's recieved since I've been gone. Please let me know if there are new issues or these don't fix what they're supposed to:
1. Users without a team should now show voting stats in the awards voting admin page
2. date issue in save_sub_admin.php should now be fixed
3. Sim length issue with datediff function in dbUpdate.php should now be fixed
4. Link to league HTML page from league logo in header should now include the league ID

[satchel]

Originally Posted by fhomess

I actually use Dreamhost, too, so it definitely can work with Dreamhost.

I can second (third?) this—StatsLab works fine on our Jamaica League's Dreamhost account.

Originally Posted by fhomess

I've re-uploaded the util code with some fixes to issues found in this thread and PM's recieved since I've been gone...
2. date issue in save_sub_admin.php should now be fixed

Thank you!

[dangarion]

Originally Posted by hank9481

I have Dreamhost and am having MAJOR problems with this utility, namely a 500 internal server error everytime I try to import the files. Can someone help me understand what the hell I am doing?

I'm using Dreamhost and have no such problems.

[satchel]

I suppose that our Hall of Fame needs to have some members, to establish a baseine, before Black Ink and Gray Ink scores can show up on the "Career Metrics" reports?

[fhomess]

Originally Posted by satchel

I suppose that our Hall of Fame needs to have some members, to establish a baseine, before Black Ink and Gray Ink scores can show up on the "Career Metrics" reports?

No, in the utility, they have nothing to do with who's in the HOF. It's merely a calculation based on leaderboard appearances. That said, you do need to run the code to calculate them from the career metrics admin page. They'll also only show up on the pages of players who have appeared on the appropriate leaderboards. If you've run them and aren't seeing them, please shoot me a PM with details and I'll help you investigate.