xe` 42 Posted October 25, 2022 Share Posted October 25, 2022 Just by the confusing wording of this title you can see I am having a hard time googling this. I wish to resume watching a show that currently has no media and as such Emby has no show entry to determine where I stopped viewing it. How can I determine where to continue from? Link to comment Share on other sites More sharing options...
CBers 6742 Posted October 25, 2022 Share Posted October 25, 2022 You could try using DB Browser for SQLite to access the database and check for the show and episodes that weren't marked as WATCHED. I'm no expert, but as long as you don't change anything, you should be OK. Take a copy of the database (library.db) first (shut down Emby beforehand) in case you change something accidently, then you can always copy it back. 2 Link to comment Share on other sites More sharing options...
xe` 42 Posted October 25, 2022 Author Share Posted October 25, 2022 The information is definitely there but its a little tricky (for me at least) to get at. So far I have: SELECT MediaItems.SeriesName AS series, MediaItems.ParentIndexNumber AS season, MediaItems.IndexNumber AS episode FROM MediaItems WHERE Type = 8 GROUP BY series, season, episode which will limit the data to just TV. I can also identify userid and played fields from the userdata table as likely candidate for watch status but as yet I have not located a unique field to correlate the two tables. Would appreciate any tips. 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