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

[sonichouse]

Ok finally tracked down the reason for the missing title headers on the Added detail table.

Version 1.28 has the following changes

** 01-01-2008 1.28 Added debug trace function.

**                 Abstract config load routine to loadConfig().

**                 Fix missing column headers on some tables.

If you want some help debugging, you can add the following to your firestats.ini

[General]

Debug=1

Happy New Year – Steve

[Osik]

Hi Steve,

good work.

Happy new year

Oh and upgrading was totally easy 😀

Osik

[Anonymous]

how can i install ff-stats?
my media server (mt-daapd_0.9-svn-1696) works with ubuntu, apache2 and php5.
i have this error on the firefly.php:

getMessage() . “
“; die(); } loadTime($title); ?>

my db is on /usr/var/cache/mt-daapd/songs.db

[sonichouse]

@wynni wrote:

how can i install ff-stats?
my media server (mt-daapd_0.9-svn-1696) works with ubuntu, apache2 and php5.
i have this error on the firefly.php:

getMessage() . “
“; die(); } loadTime($title); ?>

my db is on /usr/var/cache/mt-daapd/songs.db

Your php needs support for SQLite and PDO.

unzip the firestats.zip file into a folder you want to run the stats from.

You can either edit functions.php and change the DSN or create a firestats.ini with the DSN entry.

Which version of firestats are you trying to run ?

[Anonymous]

hey,

i use the last version of firestats (1.28) and i have modified the function.php.

$DSN=”sqlite:/usr/var/cache/mt-daapd/songs.db”;
I am sure i have sqlite2 !! also i have installed the packet for php-sqlite, but i don´t no what is POD. Witch packet i need?

[sonichouse]

@wynni wrote:

hey,

i use the last version of firestats (1.28) and i have modified the function.php.

$DSN=”sqlite:/usr/var/cache/mt-daapd/songs.db”;
I am sure i have sqlite2 !! also i have installed the packet for php-sqlite, but i don´t no what is POD. Witch packet i need?

Hi there,

i am not an expert with Apache, but you need support for PDO to be compiled.

You also need to add

extension=pdo.so

to your php.ini file.

[revjoe]

I see that the demo site is running 1.28. Is this the same version that is in the zip?

Thanks

revjoe

[sonichouse]

@revjoe wrote:

I see that the demo site is running 1.28. Is this the same version that is in the zip?

Thanks

revjoe

Yes, 1.28 is the latest (not so recent now) release.
See the link to the zip file in my signature below.

[Anonymous]

Ok, I’m stumped. I’m not exactly a PHP noob, but I just can’t make this work.

I’m running WHS, and I’ve done all of the installs to get PHP up and running. I’ve made a PHP test script and also tested PHPINFO and I know that PHP is working correctly.

I’ve set my getDatabase() function as below:

function getDatabase()

{

global $config;

$DSN="sqlite:C:/Program Files/Firefly Media Server/songs3.db";

trace($DSN, __FILE__, __LINE__);

$dbh = new PDO($DSN);

$dbh->exec('SET CHARACTER SET UTF8');



return $dbh;

}

My FireStats files are located in C:Inetpubwwwroot, and FireFly and the songs3.db file are in C:Program FilesFirefly Media Server.

PHP extensions are enabled for pod, sqlite, among others, and I’ve put the libchart-1.2.1 folder in C:Inetpubwwwroot, and updated line 77 in functions.php to show libchart-1.2.1 as opposed to libchart-1.2.

I’ve also confirmed that the host and port are set right in getFirefly() by going to the xmlDoc location directly which gives me a valid XML output:

200

2.0.0

3.0.0

1800

Music Server

2

0

0

0

0

0

1

When I go to any of the FireStats files, for example firefly.php, it just sits there thinking for about 15-20 seconds, then stops and the screen is just blank. No errors, no reporting, no nothing. Any ideas on what I can try to make this work?

Edit: Forgot to mention, I’m on FireFly Version svn-1586

[sonichouse]

Hi there,

not sure why it should bail out like that ?

Is there any errors reported in your php log ?

You can turn on debug by editing your firestats.ini

e.g.

[FIREFLY]

port=3689

host=localhost

DSN = sqlite:/opt/var/mt-daapd/songs3.db



[API]

Lib=2



[General]

Debug=1

this will dump relevant states and sql statements out for you.

/Steve

[Author]

Posts