From 070c7b580f09768efbf6b472d2cc7b90d0d1ec12 Mon Sep 17 00:00:00 2001 From: Arno Date: Fri, 7 Feb 2014 06:52:21 +0100 Subject: Don't show favorites in ArchiveBrowser --- archivebrowsermodel.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/archivebrowsermodel.cpp b/archivebrowsermodel.cpp index 222a243..6e5d17c 100644 --- a/archivebrowsermodel.cpp +++ b/archivebrowsermodel.cpp @@ -102,7 +102,7 @@ void ArchiveBrowserModel::populate(){ mAvailableQualities.clear(); QSqlQuery localFilesQ(mDb); localFilesQ.prepare("SELECT tfilename, bisize, sifiletype, siquality, cmd5sum FROM files WHERE iseriespart_id = :sid ORDER BY sifiletype"); - QSqlQuery localQ = QSqlQuery("SELECT DISTINCT(series.iseries_id), tseries_name, seriesparts.iseriespart, seriesparts.tsubtitle, seriesparts.iseriesparts_id FROM series LEFT JOIN seriesparts ON series.iseries_id = seriesparts.iseries_id LEFT JOIN files ON seriesparts.iseriesparts_id = files.iseriespart_id WHERE files.sifiletype = 1 AND files.idvd < 1 ORDER BY tseries_name ASC", mDb); + QSqlQuery localQ = QSqlQuery("SELECT DISTINCT(series.iseries_id), tseries_name, seriesparts.iseriespart, seriesparts.tsubtitle, seriesparts.iseriesparts_id FROM series LEFT JOIN seriesparts ON series.iseries_id = seriesparts.iseries_id LEFT JOIN files ON seriesparts.iseriesparts_id = files.iseriespart_id WHERE files.sifiletype = 1 AND files.idvd < 1 AND seriesparts.bfavorite = false ORDER BY tseries_name ASC", mDb); while(localQ.next()){ QList serPartData; QString name; -- cgit v1.2.3-70-g09d2