From d53d8ed8f07978fa414c045852280deb243305ad Mon Sep 17 00:00:00 2001 From: APTX Date: Thu, 21 Jun 2012 18:06:30 +0200 Subject: [PATCH] Update play-next to current schema --- play-next/main.cpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/play-next/main.cpp b/play-next/main.cpp index 3d98f80..2aec6ad 100644 --- a/play-next/main.cpp +++ b/play-next/main.cpp @@ -40,7 +40,7 @@ int main(int argc, char *argv[]) { QSqlQuery q(MyList::instance()->database()->connection()); q.prepare( - "SELECT fl.path, e.epno, a.title_romaji, e.title FROM file f " + "SELECT fl.path, e.epno, a.title_romaji, e.title_english FROM file f " " LEFT JOIN anime a ON f.aid = a.aid " " LEFT JOIN anime_title at ON f.aid = at.aid " " LEFT JOIN episode e ON f.eid = e.eid " @@ -49,7 +49,7 @@ int main(int argc, char *argv[]) " AND lower(at.title) = :title " " AND fl.path IS NOT NULL " "UNION " - "SELECT fl.path, e.epno, a.title_romaji, e.title FROM file f " + "SELECT fl.path, e.epno, a.title_romaji, e.title_english FROM file f " " LEFT JOIN anime a ON f.aid = a.aid " " LEFT JOIN anime_title at ON f.aid = at.aid " " LEFT JOIN episode e ON f.eid = e.eid " @@ -57,7 +57,7 @@ int main(int argc, char *argv[]) " WHERE f.my_watched IS NULL " " AND at.title ILIKE :title " " AND fl.path IS NOT NULL " - "GROUP BY fl.path, a.title_romaji, e.epno, e.title " + "GROUP BY fl.path, a.title_romaji, e.epno, e.title_english " "ORDER BY title_romaji ASC, epno ASC "); q.bindValue(":title", title); -- 2.52.0