Reset user stats

[kapz]

hi sindre,

I would like to reset the user stats (the view that shows how much MB each user streamed/downloaded, etc). What file do I need to edit to start the stats out clean for all the users?

Thanks.

-kapz

[kdid]

And when that heve been mentioned.

Could you make the bar graph in home->users logarithmic?

That way one power user would not blow the scale for all the other users.

Adding some vertical lines too would help.

[sindre_mehus]

I would like to reset the user stats (the view that shows how much MB each user streamed/downloaded, etc). What file do I need to edit to start the stats out clean for all the users?
-kapz

Log on with admin rights, go to http://localhost/subsonic/db.view and run the following query:

Code: Select all

update user set bytes_streamed=0, bytes_downloaded=0, bytes_uploaded = 0

Note: This will reset the usage data for all users.

Cheers,
Sindre

[sindre_mehus]

Could you make the bar graph in home->users logarithmic?

Yeah, that's a good idea. I'll see what I can do about it.

Sindre

[kapz]

Many Thanks Sindre for your help. Maybe an Admin button to do this action. Standard SQL is easy enough though.

Could you make the bar graph in home->users logarithmic?

I agree with kdid suggestion

[pha9992001]

I am a little confused on reading the usage charts. They are in (MB), but are they using decimal commas? (I'm in the US, where we use decimal points)

[3R3]

the points are the "thousands separator" (sp?) i believe. just noticed that my stats are unreasonably high, even conssidering heavy usage...probably the stats for "streaming" are what is fed into the transcoder, so its not what is actually transmitted...thats just a guess though, someone can confirm this?