diff options
Diffstat (limited to 'movieinfopage.cpp')
-rw-r--r-- | movieinfopage.cpp | 12 |
1 files changed, 1 insertions, 11 deletions
diff --git a/movieinfopage.cpp b/movieinfopage.cpp index 55a5075..425a252 100644 --- a/movieinfopage.cpp +++ b/movieinfopage.cpp @@ -321,17 +321,7 @@ void MovieInfoPage::toLower(){ } void MovieInfoPage::fuzzyCheck(){ - QString subtitle = mSubtitle->text(); - QStringList res; - QSqlDatabase db = QSqlDatabase::database("treedb"); - db.open(); - QSqlQuery fuzzyQ(db); - fuzzyQ.prepare("SELECT tsubtitle FROM seriesparts WHERE regexp_replace(tsubtitle, '[ .,''!-]', '', 'g') = lower(regexp_replace(:st, '[ .,''!-]', '', 'g'))"); - fuzzyQ.bindValue(":st", subtitle); - fuzzyQ.exec(); - while(fuzzyQ.next()){ - res << fuzzyQ.value(0).toString(); - } + QStringList res = Helper::fuzzyCheck(mSubtitle->text()); if(!res.isEmpty()){ QString msg = QString(tr("Already have:<ul>")); for(int i = 0; i < res.count() && i < 5; ++i){ |