[FAQ] Advanced User Statistics

Frequently asked questions. Tutorials, tips and tricks.
User avatar
Madsonic
Administrator
Administrator
Posts: 984
Joined: 07 Dec 2012, 03:58
Answers: 7
Has thanked: 1201 times
Been thanked: 470 times

[FAQ] Advanced User Statistics

Unread post by Madsonic »

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
Rating: 15.38%
Post Reply