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

[sonichouse]

You need to edit php.ini and add

extension=pdo.so
extension=sqlite.so

to the list of extensions installed.

Download the sqlite.dll from the link.

I’m not sure on the correct path for windows, but the directory is defined in your extension_dir in the php.ini

[blamm]

@sonichouse wrote:

You need to edit php.ini and add

extension=pdo.so
extension=sqlite.so

to the list of extensions installed.

Download the sqlite.dll from the link.

I’m not sure on the correct path for windows, but the directory is defined in your extension_dir in the php.ini

Hi, it allready has

extension=php_sqlite.dll
extension=php_pdo.dll

and

php_sqlite.dll

in the “ext” folder

[blamm]

Hi. I seem to have got past that by enabling php_pdo.dll

Now I get

Warning: Invalid argument supplied for foreach() in C:wampwwwFireStatssummary.php on line 56

Last 10 Albums Played

Warning: Invalid argument supplied for foreach() in C:wampwwwFireStatsfunctions.php on line 54

[fizze]

Thats because you are not using a sqlite3 database, but sqlite2.

Just change the line, and the db filename also is songs.db as opposed to songs3.db.
Also see my previous post.

[blamm]

Ta.

Firefly tells me I am using sqlite3 so I left it and fiddled with the path to the db. Now I get

Error!: SQLSTATE[HY000] [14] unable to open database file

[sonichouse]

So near …

You might try using the old non8dot3 format.

If you do a dir /X of the directory you will get something like C:/PROGRA~1/FIREFL~1

Try copying the songs3.db to a directory without whitespace e.g. C:TEMP

Which web server are you using ?

I will try and reproduce on my windows machine.

/Steve

[blamm]

Cracked it.

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

Now I get charts but with nothing in them. Playing with smart playlists suggest my DB has no playcounts.

[sonichouse]

@blamm wrote:

Cracked it.

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

Now I get charts but with nothing in them. Playing with smart playlists suggest my DB has no playcounts.

Good news.

Check the path to libchart in functions.php.

Try changing

include "./libchart-1.2/libchart/classes/libchart.php";

to

require_once "./libchart-1.2/libchart/classes/libchart.php";

this will then error if not found.

[blamm]

Makes no difference. Only the decades chart populates. All the rest are empty.. 🙁

[sonichouse]

@blamm wrote:

Makes no difference. Only the decades chart populates. All the rest are empty.. 🙁

Strange 👿
Do you get the correct headers on the table that is printed out ?

Also, just noticed that the decade query does not check for play_count > 0.

Is this a new database?, have you played any tracks ?

/Steve

[Author]

Posts