[waz_here]

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.

[Martijn]

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.

use the "W" on a tvshow/season/episode/movie to mark it watched/unwatched.
No sure how it works with a remote

[grywnn]

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.

[waz_here]

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.

[grywnn]

That would be playcount in the files table.
But since setting that to something > 0 for all entries would affect all your movies too, you'll need to do a join with the episodes table - which surpasses my sql knowledge

[waz_here]

thanks!

[waz_here]

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'
)