diff -r 78d1b03a94ff -r 2e626f5a52c8 engine/src/ShowEngine.cpp --- a/engine/src/ShowEngine.cpp Thu Jun 03 15:59:28 2010 +0100 +++ b/engine/src/ShowEngine.cpp Thu Jun 03 22:18:04 2010 +0100 @@ -540,6 +540,23 @@ _LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror from shows where feeduid=%u"); iSqlBuffer.Format(KSqlStatement, aFeedUid); + if (iShowFilter == ENewShows) + { + _LIT(KSqlStatementNewShows, " and playstate = 0"); // ENeverPlayed + iSqlBuffer.Append(KSqlStatementNewShows); + } + else if (iShowFilter == EDownloadedShows) + { + _LIT(KSqlStatementDownloadedShows, " and downloadstate = 4"); // EDownloaded + iSqlBuffer.Append(KSqlStatementDownloadedShows); + } + else if (iShowFilter == ENewAndDownloadedShows) + { + _LIT(KSqlStatementDownloadedAndNewShows, " and (downloadstate = 4 or playstate = 0)"); // EDownloaded or ENeverPlayed + iSqlBuffer.Append(KSqlStatementDownloadedAndNewShows); + + } + #ifndef DONT_SORT_SQL _LIT(KSqlOrderByDate, " order by pubdate desc"); iSqlBuffer.Append(KSqlOrderByDate);