Jump to content

Recommended Posts

Posted (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 by daedalus
PenkethBoy
Posted

it does just not at the episode level

 

series have playcounts as do movies

 

not by episode in the interface

Posted

you eventually know any other way i could find that out?

PenkethBoy
Posted

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

Posted (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 by daedalus
PenkethBoy
Posted

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

5e5534f4ed825_Annotation20200225145223.j

 

@@daedalus

  • Like 1
Posted

thx for pointing me in the right direction

got the basic thing running

  • Like 1
PenkethBoy
Posted

No Problem

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...