Reset some data

[dimaraja]

Hello All,

What is the code as it is not available through the web admin, to reset to zero:
- Newest
- Highest rated
- Most frequently played
- Most recently played

According to this topic
http://forum.subsonic.org/forum/viewtopic.php?t=1127&highlight=reset some stats can be set to zero through:
http://localhost/subsonic/db.view by running the following code:

Code: Select all

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

Kind regards

[sindre_mehus]

The relevant tables for that are music_file_info and and user_rating.

[dimaraja]

Thank you Sindre for everything.
Cheers!