Shoutcast listeners maps 3 Beta

[Fredo]

Hello Marc

I'm trying to setting up the script,
I don"t find the "tables.sql" part in the package for creating the tables

Is this .sql script embed in an other file ?
or it might possible I missed something ?

Thanks for your help
and big thank for the script
Fred

[marchost]

oups, my mistake. Will add it in a few minutes

[adrianjoheni]

Hello Marc,

I'm beta testing the new map, so far it works great, but do know why some listeners in some countries don't show a runtime (AVG time)?

Thank,


Adrian.

[marchost]

Hi, the avg time should work for all countries unless they disconnect between 2 crontab (listeners_cron.php).

Marc

[Fredo]

Hi,

I experience some problem with the new map
I'm not able to display past listeners, only realtime map is working properly :-/

Did you have any idea ?

Have a look
http://www.subflow.net/map3/

[marchost]

There is something wrong with the date.

If I do http://www.subflow.net/map3/geomarkers.php?start=0&end=1269835200000&feed=minimal-256kbs (from 1970 to today)

I can see a feed

but if I do

http://www.subflow.net/map3/geomarkers.php?start=1267419600000&end=1269835200000&feed=minimal-256kbs (from 1mars to today)

I dont see anything

Could you give me the min/max timestamp in your database?

SELECT min( `timestamp` ) FROM `listeners_info`
SELECT max( `timestamp` ) FROM `listeners_info`

Note that the timestamp in the URL is in microsecond and in it's in millisecond (divided by 1000) in the database

Using firebug (firefox addon) you can see the query sent to geomarkers.php file, it's very usefull...

Marc

[Fredo]

min( `timestamp` ) 1269690122
max( `timestamp` ) 1269939411

Last Sunday we change time (at 2am it was 3am), maybe that's why there is problem ?

[marchost]

i'm curious, did you install the package from scratch (database, files...) ?

did you made any modifications to PHP files other than map.php?

try restarting from the beginning including downloading the package. The first day I made some modifications to the file, maybe you get a "bad" version

I just retried installing the package and everything seems to work...

marc

[Fredo]

I've downloaded the package again, created a new folder "map4 ", unziped the package,
stopped cron, flush my DB, deleted all table, execute the table.sql script again, restart cron job

=> http://www.subflow.net/map4/map.php
Realtime listeners is working,
if i select date from 30March to 30 March nothing is displayed
Maybe it's to early ?

min( `timestamp` )
1269979357

max( `timestamp` )
1269980020

[Fredo]

first error from my side
my cron was not well typed :-/

* * * * * root (/usr/bin/php5 -f /bla/bla/bla/listeners_cron.php)
is the good one

maybe same user as apache is better ?