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)
16/12/2007 at 9:01 PM
#14793
Iris
Participant
@sonichouse wrote:
@Iris wrote:
Steve,
Bug?? I noticed that the time played for my tracks was the UTC time not my actual. I checked the time on my MSS, in the firefly log, etc. and they’re all correct – it’s just this. Is that the way you programmed it or is this a bug?
Iris
hi Iris,
I use the localtime in the datetime format, is your locale set correctly ?try
sqlite dummy.db "select datetime('now', 'localtime');"
to see if that returns the correct time.
/Steve
I’m not even sure of I’m executing that command right – I get a SIGSEGV error.
# /opt/bin/sqlite /tmp/dummy.db "select datetime('now', 'localtime');"