[FAQ] Advanced User Statistics

Frequently asked questions. Tutorials, tips and tricks.
User avatar
Madsonic
Administrator
Administrator
Posts: 960
Joined: 07 Dec 2012, 03:58
Has thanked: 1146 times
Been thanked: 447 times

[FAQ] Advanced User Statistics

Unread post by Madsonic » 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
These users thanked the author Madsonic for the post (total 2):
ForSSuxMatt Zornig

Post Reply