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

#14827
Anonymous
Inactive

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