FireStats – Top 40 php script (now with added charts)

[EVILRipper]

I guess that means you need the pdo.so extension for PHP.
I found the following website which should help you.
http://www.qwesz.com/php-manual/ref.pdo.html
(Scroll down to Linux and Unix.)

Hope this helps.

[sonichouse]

New version with the following

** History:

** 13-12-2007 1.16 Summary screen chart sizes now 50%

**                 Added songs played last 14 days chart.

The summary screen now shows the charts like this

(reduced image size for this post)

As usual clicking on the chart will take you to the page for that report with the full size chart.

[sonichouse]

Version 1.17 – change line charts – added solid fill below the line.

See screenshot in previous post.

[Iris]

It taken me a little while because I had to set-up lightTPD, etc. on my NAS (see sig) but I now have FF stats working. 🙂 Since Google charts was added I first tried v1.15 and was getting the charts but at the top of most charts ther e was an error message for “invalid argument…” that for the most part has gone away with v1.17 but a few remain which I’ll detail here.

Refreshing charts progresses to 100% but then message:

Warning: Invalid argument supplied for foreach() in /shares/mss-hdd/Public/Our Sites/stats/functions.php on line 138

I then get the summary screen with tables and graph but right above the title Last 10 Albums Played the above error is present but for line 72.

Now for each stat:

Tracks, Albums, Genres, Decades appear OK.

Added and Played show error for line 138. Added shows table but no actual graph – the graph window is there. Played only shows graph window.

I was getting more of this with v1.15 but has been cleaned up quite a bit with v1.17. Any suggestions?

Iris

[sonichouse]

Looks like an invalid query returned for the added_14days.

I have added some error handling around the SQL execution.

Version 1.18 uploaded.

Is this sqlite2 or sqlite3 ?

[Iris]

@sonichouse wrote:

Is this sqlite2 or sqlite3 ?

TWO.

I’ll test the new version right away.

[Iris]

@sonichouse wrote:

Looks like an invalid query returned for the added_14days.

I have added some error handling around the SQL execution.

Same error with the same line number.

Did you update the version number cause it still says 1.17?

Iris

[sonichouse]

Should be 1.18, the only changed file was functions.php

I’ll check the zip uploaded — yep 1.18.

/Steve

[Iris]

FWIW

[sonichouse]

If you were running 1.18, it should show an error message rather than the one displayed.

Can you check the first few lines of QuerytoTable (line 100)

It should say

function QueryToTable($dbh, $query, $output=1, $title=null, $mode=null,$graph=0)

{

$imgDir="img/";

$minScale=0;

$maxScale=10;



// Execute Query

$result=$dbh->query($query);



// Check for valid result set

if(!$result)

{

print("
Unable to execute: $query
");

return;

}

[Author]

Posts