2017-07-02, 13:56
(2017-07-01, 11:36)Boyzie Wrote: Could I use the MyVideos107.db file instead of watchedlist.db to export last watched movies?You could try to open the MyVideos107.db with the sqlite tool and get the data from the view 'movieview'. This should be the same data (playcount, timestamp of last watching) as of the WatchedList addon.
(2017-07-01, 11:36)Boyzie Wrote: How could I check, if they are available in Kodi under last watched movies? With a playlist? "Playcount is not "0"? Or "Last watched"?I am not sure, if there is a filter/sorting option in the normal Kodi skins. I think you have to go through the library manually with external tools. If you want the watched movies in the order you watched them, this query works for the mySQL database MyVideos107:
Code:
SELECT `c00` , `playCount` , `lastPlayed` FROM `movie_view` WHERE `playCount` NOT LIKE 0 ORDER BY `lastPlayed` DESC
The query for SQLite should be similar or the same.