Page 1 of 1

Reset some data

PostPosted: Mon Jul 14, 2008 10:41 pm
by 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

PostPosted: Tue Jul 15, 2008 7:52 am
by sindre_mehus
The relevant tables for that are music_file_info and and user_rating.

PostPosted: Wed Jul 16, 2008 3:37 am
by dimaraja
Thank you Sindre for everything.
Cheers!