[Lucleonhart]

Hey there.
I am developing an windows application which accesses the XBMC database file.
I want to get all episodes which has been watched. The wiki says, that in the "episode" table, key c08 stands for "watched" .. but it never changes. In fact, the whole db entry for an episode does not change when i mark it watched in XBMC. But(!), the database file was changed (new filetime), so where in the world is this information placed?
Thanks in advance!

[spiff]

old info. what matters these days is the 'playCount' column in the 'files table'.

select playCount from files join episode on episode.idfile=files.idfile where episode.idepisode=%u

[jmarshall]

files table. It's a playcount now.

[Lucleonhart]

Jeha! Saved my day, folks! Thanks!