daedalus 430 Posted February 25, 2020 Share Posted February 25, 2020 (edited) i'm trying to figure out, what episodes of a specific series got played the most i thought this could be achieved by the playback reporting plugin, but i can't even find any way to show any playcounts at all could someone please help out here how this could be done? Edited February 25, 2020 by daedalus Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted February 25, 2020 Share Posted February 25, 2020 it does just not at the episode level series have playcounts as do movies not by episode in the interface Link to comment Share on other sites More sharing options...
daedalus 430 Posted February 25, 2020 Author Share Posted February 25, 2020 you eventually know any other way i could find that out? Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted February 25, 2020 Share Posted February 25, 2020 its in the db userdatas table - has all played counts from db start or look at the backup of the playback plugin its a tab delimited csv and do a count from that - although its only going to show what you have watched since you added it Link to comment Share on other sites More sharing options...
daedalus 430 Posted February 25, 2020 Author Share Posted February 25, 2020 (edited) db userdatas table only has them "encrypted" behind some ids, no easy task if not being familiar with db handling urgh so playback reporting is collecting its "own" data, thought it would read that from the db too bad there is no easy way Edited February 25, 2020 by daedalus Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted February 25, 2020 Share Posted February 25, 2020 This will give you a start - use the Execute SQL Tab in Db browser for sqlite - after you open the library.db Select MediaItems.Id, MediaItems.type, MediaItems.name, MediaItems.UserDataKeyId, MediaItems.SeriesName, MediaItems.ParentIndexNumber, MediaItems.IndexNumber, UserDatas.playCount from MediaItems, UserDatas where MediaItems.UserDataKeyId = UserDatas.UserDataKeyId order by MediaItems.SeriesName, MediaItems.ParentIndexNumber, MediaItems.IndexNumber @@daedalus 1 Link to comment Share on other sites More sharing options...
daedalus 430 Posted February 25, 2020 Author Share Posted February 25, 2020 thx for pointing me in the right direction got the basic thing running 1 Link to comment Share on other sites More sharing options...
PenkethBoy 2063 Posted February 25, 2020 Share Posted February 25, 2020 No Problem Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now