daedalus 430 Posted February 25, 2020 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
PenkethBoy 2066 Posted February 25, 2020 Posted February 25, 2020 it does just not at the episode level series have playcounts as do movies not by episode in the interface
daedalus 430 Posted February 25, 2020 Author Posted February 25, 2020 you eventually know any other way i could find that out?
PenkethBoy 2066 Posted February 25, 2020 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
daedalus 430 Posted February 25, 2020 Author 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
PenkethBoy 2066 Posted February 25, 2020 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
daedalus 430 Posted February 25, 2020 Author Posted February 25, 2020 thx for pointing me in the right direction got the basic thing running 1
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