+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Video Support (https://forum.kodi.tv/forumdisplay.php?fid=264)
+--- Thread: Manually mark as watched without updating last played date (/showthread.php?tid=373636)
Manually mark as watched without updating last played date - Eddage - 2023-07-01
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?
RE: Manually mark as watched without updating last played date - Klojum - 2023-07-01
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.
RE: Manually mark as watched without updating last played date - KidKiwi - 2023-07-01
(2023-07-01, 20:34)Klojum Wrote: 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.
RE: Manually mark as watched without updating last played date - Eddage - 2023-07-02
(2023-07-01, 20:34)Klojum Wrote: 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?
RE: Manually mark as watched without updating last played date - izprtxqkft - 2023-07-02
- open myvideos*.db
- goto the files table
- change date in the column lastPlayed
however, if you're not already familiar with editing sqlite databases this is probably not recommendable for you
RE: Manually mark as watched without updating last played date - Klojum - 2023-07-02
(2023-07-02, 00:22)Eddage Wrote: 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...)
RE: Manually mark as watched without updating last played date - Eddage - 2023-07-02
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
