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

#14792
sonichouse
Participant

@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