summaryrefslogtreecommitdiffstats
path: root/filestreemodel.cpp
diff options
context:
space:
mode:
authorArno <am@disconnect.de>2013-02-07 14:46:43 +0100
committerArno <am@disconnect.de>2013-02-07 14:46:43 +0100
commit91750c1a4247ab436ffff5a518efd7004c01b98d (patch)
tree2fb12dc9d72345e84d67003cef0f0af8f0ee5180 /filestreemodel.cpp
parent9fbf13241d8a2aa0698f23c8e8f0626f3f237fb3 (diff)
downloadSheMov-91750c1a4247ab436ffff5a518efd7004c01b98d.tar.gz
SheMov-91750c1a4247ab436ffff5a518efd7004c01b98d.tar.bz2
SheMov-91750c1a4247ab436ffff5a518efd7004c01b98d.zip
Change sort order
Change sort order when selecting files for burning... Alphabetically is not very useful here...
Diffstat (limited to 'filestreemodel.cpp')
-rw-r--r--filestreemodel.cpp2
1 files changed, 1 insertions, 1 deletions
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<int> &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);