Reply to thread

Message

Ah, thanks. Unfortunately I ran into a show-stopper.
The online_episodes table was fine - I found and reset all episode watched flags to 0.
However, the 'season' table contains two columns that hold info about watched status - 'UnwatchedItems' and 'EpisodesUnwatched'. There's also 'EpisodeCount' which contains the # of episodes in the season.

UnwatchedItems is a binary value, so I assume it indicates whether there are any unwatched episodes in that season. That's easy enough to reset.
'EpisodesUnwatched' however is harder - it needs to be reset back to the same value as 'EpisodeCount'. In other words:

Season 3 of Bewitched:
UnwatchedItems = 1
EpisodeCount = 23
EpisodesUnwatched = 4

Somehow I need to be able to set 'EpisodeUnwatched' to "23". Undoubtedly its possible using advanced SQL syntax but its beyond my simple grasp!

I assume the same sort of columns exist at the Series level as well.

<blockquote data-quote="dir" data-source="post: 1005550" data-attributes="member: 24485">Ah, thanks.&nbsp; Unfortunately I ran into a show-stopper.The online_episodes table was fine - I found and reset all episode watched flags to 0. However, the 'season' table contains two columns that hold info about watched status - 'UnwatchedItems' and 'EpisodesUnwatched'.&nbsp; There's also 'EpisodeCount' which contains the # of episodes in the season.&nbsp;UnwatchedItems is a binary value, so I assume it indicates whether there are any unwatched episodes in that season.&nbsp; That's easy enough to reset.'EpisodesUnwatched' however is harder - it needs to be reset back to the same value as 'EpisodeCount'.&nbsp; In other words:&nbsp;Season 3 of Bewitched:UnwatchedItems = 1EpisodeCount = 23EpisodesUnwatched = 4&nbsp;Somehow I need to be able to set 'EpisodeUnwatched' to &quot;23&quot;.&nbsp; Undoubtedly its possible using advanced SQL syntax but its beyond my simple grasp!&nbsp;I assume the same sort of columns exist at the Series level as well.</blockquote>

[QUOTE="dir, post: 1005550, member: 24485"] Ah, thanks. Unfortunately I ran into a show-stopper. The online_episodes table was fine - I found and reset all episode watched flags to 0. However, the 'season' table contains two columns that hold info about watched status - 'UnwatchedItems' and 'EpisodesUnwatched'. There's also 'EpisodeCount' which contains the # of episodes in the season. UnwatchedItems is a binary value, so I assume it indicates whether there are any unwatched episodes in that season. That's easy enough to reset. 'EpisodesUnwatched' however is harder - it needs to be reset back to the same value as 'EpisodeCount'. In other words: Season 3 of Bewitched: UnwatchedItems = 1 EpisodeCount = 23 EpisodesUnwatched = 4 Somehow I need to be able to set 'EpisodeUnwatched' to "23". Undoubtedly its possible using advanced SQL syntax but its beyond my simple grasp! I assume the same sort of columns exist at the Series level as well. [/QUOTE]