Jump to content

Determine last viewed episode for show that has no current media


xe`

Recommended Posts

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

CBers

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.
 

  • Like 2
Link to comment
Share on other sites

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

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...