[FAQ] Advanced User Statistics
Posted: 13 Mar 2013, 02:08
Hi there,
if you have simple SQL knowledge you can go to db.view and use this query
this query should show you all information's about played entries incl. the username.
or drill down the Results.
best regards
if you have simple SQL knowledge you can go to db.view and use this query
Code: Select all
SELECT * from statistic_user, media_file where statistic_user.media_file_id = media_file.id and username = 'admin'
Code: Select all
SELECT * from statistic_user, media_file where statistic_user.media_file_id = media_file.id and username = 'guest' and played < '2013-03-13 01:25'
best regards