Posts: 4
Joined: Mar 2012
Reputation:
0
Which field in the episode table should I change - and to what value in order to update all episodes to watched? Or is there is quicker/easier way? I don't want to have to mark them individually using my remote.
Posts: 379
Joined: Mar 2010
Reputation:
0
As far as i remember you can simply highlight the show / season in xbmc, open the context menu and select "mark as watched". That should do the trick.
Posts: 4
Joined: Mar 2012
Reputation:
0
I have a lot of shows. I don't want to have to use the interface. I am using Sqlite to see the tables that make the database. So I just need to know which table and field in the database I need to update. I will then write a sql statement to update all episodes to watched.
Posts: 4
Joined: Mar 2012
Reputation:
0
This is what I used to set all episodes that aired after 03/23/2012 to watched:
update files set playCount = 1
where idFile in (
select files.idFile from files
inner join episode
on files.idFile = episode.idFile
where episode.c05 < '2012-03-23'
)