[Eddage]

I have a few widgets that show last played movies/tv shows, based on the last played sort option. However, if I add a new movie that I have watched in the past, or a better version of an old movie/tv show I want to be able to mark them as watched but not change the last played date (because I didn't actually watch it).

Is there any way to separate the two?

[Klojum]

Applying the watched status will always use the system's current timestamp. The only other option I can see is to directly hack into the video database's "files" table, and manually set a different timestamp if that is what you're after.

[KidKiwi]

Applying the watched status will always use the system's current timestamp. The only other option I can see is to directly hack into the video database's "files" table, and manually set a different timestamp if that is what you're after.

This is what I've always done.

[Eddage]

Applying the watched status will always use the system's current timestamp. The only other option I can see is to directly hack into the video database's "files" table, and manually set a different timestamp if that is what you're after.

How would I go about doing this? Is it reasonably straightforward?

[izprtxqkft]

1. open myvideos*.db
   
2. goto the files table
   
3. change date in the column lastPlayed
   

however, if you're not already familiar with editing sqlite databases this is probably not recommendable for you

[Klojum]

How would I go about doing this? Is it reasonably straightforward?

A "reasonably" amount of knowledge of how to use SQL statements would help.


With the query below (for unwatched videos) you can edit the watched timestamp, using the filename. Better would be if you know the correct idFile value, otherwise entries with the same filename would be altered. (I have to imgur this, because Kodi's Cloudflare cousin is going bananas when I use certain SQL statements in the forum...)

[Eddage]

Thanks for the replies guys. Turns out though that if I update the watched status by syncing with Trakt it also syncs the last played date! Should probably have tried that first