StatsLab SQL Utilities for OOTPX

[Alan T]

Originally Posted by mikev

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

Yes, I had this same issue with a long running ootp9 league, and he added in as of I think patch 2 the ability to import ootpou development reports into statslab

[mikev]

Originally Posted by Alan T

Yes, I had this same issue with a long running ootp9 league, and he added in as of I think patch 2 the ability to import ootpou development reports into statslab

Are there instructions in the readme?

(edit)

What's the steps to install this on the latest version of OOTPX? Install 1.0, then install both patches in succession, or upload all the patched files and then run install.php?

[fhomess]

Originally Posted by mikev

Are there instructions in the readme?

(edit)

What's the steps to install this on the latest version of OOTPX? Install 1.0, then install both patches in succession, or upload all the patched files and then run install.php?

Yes to your first question. In the Patch 2 readme.

The latter, to your second question. Install all the code, then run install.php. You can actually do it either way, but it's easier just to install it all first, since some of the enhancements help get the util up and running.

[mikev]

Getting this error after uploading everything and entering the data into install.php

Warning:  mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'mikev_ootpsql'@'1a.7.364a.static.theplanet.com' (using password: YES) in /home/mikev/public_html/cgi-bin/sql/dbopen.php on line 2
Could not connect: Access denied for user 'mikev_ootpsql'@'1a.7.364a.static.theplanet.com' (using password: YES)

Ideas?

[mikev]

I verified the user/password via shell, and that's not the issue. Dunno what the access denied message is being caused by.

[fhomess]

Your SQL user/password combo is not correct.

[PotatoPeeler]

Couple of quick questions.

1. When I try the Run Career Metrics after loading the SQL files, I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <path to StatsLab>/career.php on line 43

Warning: Cannot modify header information - headers already sent by (output started at <path to StatsLab>/career.php:43) in <path to StatsLab>/career.php on line 218

2. After loading the SQL files, I keep seeing a message on the Admin page that reads "LOADING: players_batting.mysql.sql" (see the first attached image).

3. After loading the SQL files, I'm not seeing anything in the Top Players section on the Top Performances page (see the second attached image).

Any idea what's causing these issues?

Thanks for the help.

[mikev]

Originally Posted by fhomess

Your SQL user/password combo is not correct.

It is, I verified it by logging into the SQL DB via shell, and I also deleted and recreated the user/password for the SQL DB.

[snnort]

Has anyone used the widgets feature that can point to a website in which they've used them? I'm hoping to get some time myself to mess with them and see if I can't get something set up on my league frontpage. I thought it'd be nice to see a few examples of what others are doing with them.

[fhomess]

Originally Posted by PotatoPeeler

Couple of quick questions.

1. When I try the Run Career Metrics after loading the SQL files, I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <path to StatsLab>/career.php on line 43

Warning: Cannot modify header information - headers already sent by (output started at <path to StatsLab>/career.php:43) in <path to StatsLab>/career.php on line 218

The players_league_leader file isn't getting loaded into your database.

Originally Posted by PotatoPeeler

2. After loading the SQL files, I keep seeing a message on the Admin page that reads "LOADING: players_batting.mysql.sql" (see the first attached image).

Any time you see the "LOADING: filename" message, it means that file isn't getting fully loaded into your database. Usually, this is caused by your server timing out on the script while it's still trying to load. Servers have a limited amount of time they allow php scripts to run for before they kill the process. StatsLab requests additional time regularly for long running scripts, but not all servers allow scripts to override their settings for that timeout. If you're running into this, try loading the larger files individually, or possibly splitting them first.

Originally Posted by PotatoPeeler

3. After loading the SQL files, I'm not seeing anything in the Top Players section on the Top Performances page (see the second attached image).

Any idea what's causing these issues?

This would be related to the fact that you're not getting all your data into the database.

Originally Posted by mikev

It is, I verified it by logging into the SQL DB via shell, and I also deleted and recreated the user/password for the SQL DB.

Perhaps your SQL server isn't configured to permit connections from where you have StatsLab running? You might also check dbopen.php in your SQL load folder to make sure StatsLab was able to generate it correctly.

Originally Posted by snnort

Has anyone used the widgets feature that can point to a website in which they've used them? I'm hoping to get some time myself to mess with them and see if I can't get something set up on my league frontpage. I thought it'd be nice to see a few examples of what others are doing with them.

I know the PEBA is using them on their front page to display standings, and Corsairs has even contacted me to say he's willing to share the CSS that they've employed to display them in their format. I'm not sure if he's posted in this thread, but I do know he posted in the OOTP9 StatsLab thread.

[PotatoPeeler]

Yeah, my players_game_batting and players_game_pitching_stats sql files are very large and end up timing out. Once I split those and loaded everything manually, things work just fine.

Thanks for the help!

[mikev]

Originally Posted by fhomess

Perhaps your SQL server isn't configured to permit connections from where you have StatsLab running? You might also check dbopen.php in your SQL load folder to make sure StatsLab was able to generate it correctly.

They're the same server.

I checked, and the dbopen.php file was created, but I dunno what's supposed to be in there.

[Corsairs]

Originally Posted by fhomess

I know the PEBA is using them on their front page to display standings, and Corsairs has even contacted me to say he's willing to share the CSS that they've employed to display them in their format. I'm not sure if he's posted in this thread, but I do know he posted in the OOTP9 StatsLab thread.

Indeed the PEBA is using StatsLab's widgets feature, and I highly recommend it to all online commissioners. Right now we're only using the League Standings widgets; we'll be adding in the Player Leaderboard widets once the regular season rolls around.

Have a look at the PEBA homepage to see how they look. Note that one of our league members did a little touch-up work to get the columns to line up neatly. I've submitted his code to fhomess so there's a chance it might end up in a future StatsLab patch. Even in their current implementation, though, StatsLab's widgets are a great addition to a league website.

[fhomess]

Originally Posted by mikev

They're the same server.

I checked, and the dbopen.php file was created, but I dunno what's supposed to be in there.

You should see your SQL host, user, and password in a mysql_pconnect function call, followed by a line calling a function to select the appropriate database. Your SQL user needs access to MySQL, as well as permissions for that specific database. If you think you've got all that, and are willing to share access with me, I'm willing to take a look myself and see if anything is odd. Just shoot me a PM.

[mikev]

Originally Posted by fhomess

You should see your SQL host, user, and password in a mysql_pconnect function call, followed by a line calling a function to select the appropriate database. Your SQL user needs access to MySQL, as well as permissions for that specific database. If you think you've got all that, and are willing to share access with me, I'm willing to take a look myself and see if anything is odd. Just shoot me a PM.

It seems like, for some reason, @'1a.7.364a.static.theplanet.com is being added to the username I'm putting in, but I don't know how or why.

[fhomess]

Originally Posted by mikev

It seems like, for some reason, @'1a.7.364a.static.theplanet.com is being added to the username I'm putting in, but I don't know how or why.

In dbopen.php? Odd. You can edit that file manually and remove that piece.

[snnort]

Originally Posted by Corsairs

Indeed the PEBA is using StatsLab's widgets feature, and I highly recommend it to all online commissioners. Right now we're only using the League Standings widgets; we'll be adding in the Player Leaderboard widets once the regular season rolls around.

Have a look at the PEBA homepage to see how they look. Note that one of our league members did a little touch-up work to get the columns to line up neatly. I've submitted his code to fhomess so there's a chance it might end up in a future StatsLab patch. Even in their current implementation, though, StatsLab's widgets are a great addition to a league website.

Is this touch up work done to a CSS file OR is it manually edited in the widget files each time they are created?

[mikev]

Originally Posted by fhomess

In dbopen.php? Odd. You can edit that file manually and remove that piece.

Not sure where -- but the issue is fixed, had to change the SQL host to "localhost" instead of "theguba.net" in the install.php, and then it worked.

[Corsairs]

Originally Posted by snnort

Is this touch up work done to a CSS file OR is it manually edited in the widget files each time they are created?

It was done in a CSS file.

[snnort]

Originally Posted by snnort

Is this touch up work done to a CSS file OR is it manually edited in the widget files each time they are created?

Originally Posted by Corsairs

It was done in a CSS file.

If you could make the CSS file available, that would be handy, just in case there is some reason I can't get things right. BUT I'm glad to hear that CSS fixed that since it can be fixed once and once only.