From 91750c1a4247ab436ffff5a518efd7004c01b98d Mon Sep 17 00:00:00 2001 From: Arno Date: Thu, 7 Feb 2013 14:46:43 +0100 Subject: Change sort order Change sort order when selecting files for burning... Alphabetically is not very useful here... --- filestreemodel.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'filestreemodel.cpp') diff --git a/filestreemodel.cpp b/filestreemodel.cpp index 96f1ba4..729a4fc 100644 --- a/filestreemodel.cpp +++ b/filestreemodel.cpp @@ -95,7 +95,7 @@ void FilesTreeModel::setIds(const QList &seriesPartIds){ void FilesTreeModel::setForBurn(){ mDisplayMode = Burn; - QString query = QString("SELECT iseriespart_id, tfilename, cmd5sum, bisize, idvd, sifiletype, sifileno, siquality, ifiles_id, series.tseries_name, seriesparts.iseriespart, seriesparts.bfavorite FROM files, seriesparts, series WHERE iseriespart_id IN (SELECT iseriesparts_id from seriesparts where bfavorite = false) AND files.iseriespart_id = seriesparts.iseriesparts_id AND seriesparts.iseries_id = series.iseries_id AND sifiletype = 1 AND idvd < 0 ORDER BY tfilename, sifileno ASC"); + QString query = QString("SELECT iseriespart_id, tfilename, cmd5sum, bisize, idvd, sifiletype, sifileno, siquality, ifiles_id, series.tseries_name, seriesparts.iseriespart, seriesparts.bfavorite FROM files, seriesparts, series WHERE iseriespart_id IN (SELECT iseriesparts_id from seriesparts where bfavorite = false) AND files.iseriespart_id = seriesparts.iseriesparts_id AND seriesparts.iseries_id = series.iseries_id AND sifiletype = 1 AND idvd < 0 ORDER BY iseriespart_id"); QSqlQuery filesQuery(mDb); filesQuery.prepare(query); populate(filesQuery); -- cgit v1.2.3-70-g09d2