FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Add-on Software › FireStats – Top 40 php script (now with added charts) › Reply To: FireStats – Top 40 php script (now with added charts)
Correct version now. Error reads:
Unable to execute: select Date, sum(Added) as Added from ( select date(time_added, ‘unixepoch’, ‘localtime’) as “Date”, count(*) as Added from songs where date(time_added, ‘unixepoch’, ‘localtime’) between date(‘now’ , ‘-14 day’, ‘localtime’) and date(‘now’ , ‘localtime’) group by 1 union all select date(‘now’ , ‘-00 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-01 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-02 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-03 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-04 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-05 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-06 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-07 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-08 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-09 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-10 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-11 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-12 day’, ‘localtime’), 0 union all select date(‘now’ , ‘-13 day’, ‘localtime’), 0 ) group by 1 order by 1 desc;
Iris