[FAQ] Advanced User Statistics

Frequently asked questions. Tutorials, tips and tricks.

[FAQ] Advanced User Statistics

Unread postby Madevil » 13 Mar 2013, 02:08

Hi there,

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'


this query should show you all information's about played entries incl. the username.

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'


or drill down the Results.

Image

best regards
User avatar
Madevil
Administrator
Administrator
 
Posts: 911
Joined: 07 Dec 2012, 03:58
Has thanked: 1323 times
Been thanked: 951 times

Return to Info

Who is online

Users browsing this forum: No registered users and 2 guests