changing statistics manually

[diab0lik]

hi is there anyway i can just the user statistics manually? ie the amount downloaded, streamed per user etc thanks

[M0NG0]

Yep, with SQL you can. Go to http://[your_Subsonic_URL]:[your_port]/db.view and enter the following query to see the user table:

Code: Select all

SELECT * from user

This will show the user table. Let's say you want to set a user named diab0lik to show 0 bytes streamed. You can do that with the following query:

Code: Select all

UPDATE user
SET BYTES_STREAMED='0'
WHERE USERNAME='diab0lik'