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

[mas]

Decades also looking nice now.

All seems to work.

[sonichouse]

Glad you like it.

Version 1.12 now up on my site.

Changes are

** History:

** 09-12-2007 1.12 Fix up all charts to .png format.

**                 Revisit normalise function.

**                 Set Chart title font Blue 16pt.

This now looks very nice when integrated with Firefly IMHO. My Blog entry for this

[mas]

Iiieeeek VISTA. Harharhar. 😎

Well or a Vista scheme. 8-P

[sonichouse]

Well Vista can pre-installed on my Flybook v33i laptop.
Great machine for the road warrior in me 😀

Anyway, new version 1.13 fixes the bar charts so that the y axis always gets the correct axis label range.

>           // v1.13 - Fix up Max Scale so chart is not clipped

>           // Round up to nearest 100 or 10 whole number

>             if(BAR==$graph)

>             {

>               if($maxScale > 1000)

>                  $maxScale += (100 - ($maxScale % 100));

>               elseif($maxScale > 100)

>                  $maxScale += (10 - ($maxScale % 10));

>             }

>

/Steve

[sonichouse]

Version 1.14 with new line chart that plots the number of tracks added in the last 14 days.

Fixed up rounding errors that cause charts not to render in google.

Hopefully the last major addition for a while.

Changelog …

** 10-12-2007 1.14 Changed Summary SQL in summary.php

**                 Normalise function fixed to 4 decimal places.

**                 Line Chart 'Added last 14 days'.

[mas]

The Chart for the Last added 14 days is empty despite the fact that it lists several tracks that were added last 14 days.

So something doesnt work with that chart.

Is simply a chart with no line, as if tehre were 0 added. But list proves its >0 last 14 days.

[sonichouse]

@mas wrote:

The Chart for the Last added 14 days is empty despite the fact that it lists several tracks that were added last 14 days.

So something doesnt work with that chart.

Is simply a chart with no line, as if tehre were 0 added. But list proves its >0 last 14 days.

Strange worked here 😯

http://www.steveforster.co.uk/firefly.php

I wonder if it is a locale issue ?

[sonichouse]

I think it might be that you have no additions in the last 14 days ?

There are now two tables for that page.

i have fixed it up to return the dates with 0 additions as well.

Version 1.15 changes are

** History:

** 11-12-2007 1.15 Added shape markers to line graph.

**                 Highlight highest points with vertical line.

**                 Fixed up last 14 days added sql for empty dates.

[Anonymous]

This is very, very cool, Steve. Nice work. I’ve been a big fan of Firefly for some time running it on several different platforms to see which I like best. I’ve settled on an old Dell that I’ve installed Ubuntu Server 6.06 LTS (Dapper Drake) that I’ve installed the LAMP option (pre-configured Linux, Apache, MySQL & PHP). I really like the visualization you’ve given to the library meta-data and would love to be able to see this for my library, but I’m having a problem.

I’ve copied the files to my apache2-default folder. When I hit the page, (http://SERVERIP/apache2-default/firefly.php). I get the name of the server at the top, the row of buttons (Tracks, Albums, Genre…), but then I get the following message:

Fatal error: Class ‘PDO’ not found in /var/www/apache2-default/functions.php on line 73.

Line 73 reads $dbh = new PDO ($DSN);
$DSN is “sqlite2:/usr/var/cache/mt-daapd2/songs.db”

It appears that my version of Apache PHP doesn’t know anything about SQLite. I’ve taken a look at PHP.INI for Apache, but don’t see anything obvious.

Any idea what I need to do to make this work? Any help would be appreciated.

[sonichouse]

@pmorris wrote:

This is very, very cool, Steve. Nice work.

Thanks for that, I find it very enlightening to see what has been played/added recently.

@pmorris wrote:

It appears that my version of Apache PHP doesn’t know anything about SQLite. I’ve taken a look at PHP.INI for Apache, but don’t see anything obvious. Any idea what I need to do to make this work? Any help would be appreciated.

I’m sorry, but I know absolutely nothing about configuring apache I’m afraid.

normally you require to add pdo.so to your extensions in php.ini

Perhaps someone more knowledgeable will chime in.

/Steve

[Author]

Posts