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

FireFly Media Server (formerly mt-daapd) Firefly Media Server Forums Firefly Media Server Add-on Software FireStats – Top 40 php script (now with added charts)

Viewing 15 posts - 16 through 30 (of 176 total)
  • Author
    Posts
  • #14704
    blamm
    Participant

    @sonichouse wrote:

    In functions.php change the path of the database if required.

    Ta. What is the syntax for the path? Mine us at “C:Program FilesFirefly Media Server”

    #14705
    sonichouse
    Participant

    @blamm wrote:

    @sonichouse wrote:

    In functions.php change the path of the database if required.

    Ta. What is the syntax for the path? Mine us at “C:Program FilesFirefly Media Server”

    Not used on windows before, but looking on the web you could use

    sqlite://C://Program Files/Firefly Media Server/songs.db

    or

    sqlite:./songs.db

    if the database is in the same directory.

    #14706
    blamm
    Participant

    Ta.

    Now I get “Error!: could not find driver”

    #14707
    sonichouse
    Participant

    I think your php install needs the pdo_sqlite package.
    http://uk2.php.net/sqlite

    /Steve

    #14708
    blamm
    Participant

    @sonichouse wrote:

    I think your php install needs the pdo_sqlite package.
    http://uk2.php.net/sqlite

    /Steve

    ‘fraid this is all a bit beyond me. What do I do with it?

    #14709
    sonichouse
    Participant

    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

    #14710
    blamm
    Participant

    @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

    #14711
    blamm
    Participant

    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

    #14712
    fizze
    Participant

    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.

    #14713
    blamm
    Participant

    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

    #14714
    sonichouse
    Participant

    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

    #14715
    blamm
    Participant

    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.

    #14716
    sonichouse
    Participant

    @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.

    #14717
    blamm
    Participant

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

    #14718
    sonichouse
    Participant

    @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

Viewing 15 posts - 16 through 30 (of 176 total)
  • The forum ‘Add-on Software’ is closed to new topics and replies.