diff options
Diffstat (limited to 'Database/Common/selectserverlist.cpp')
| -rw-r--r-- | Database/Common/selectserverlist.cpp | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/Database/Common/selectserverlist.cpp b/Database/Common/selectserverlist.cpp deleted file mode 100644 index c4797ed..0000000 --- a/Database/Common/selectserverlist.cpp +++ /dev/null @@ -1,31 +0,0 @@ -#include "commonactions.h" - -QSqlQuery selectServerList(const QString &gamename, - const int &serverAge_s, - const bool &withSyncData) -{ - // retrieve servers from database - QSqlQuery q; - QString selectString = "SELECT ip, queryport FROM serverlist " - "WHERE gamename = :gamename "; - - if ( withSyncData ) - { - // relies on sync data to be accurate (if checker is not enabled) - selectString += "AND (dt_updated > :timestamp OR dt_sync > :timestamp)"; - } - else - { - // sync data may not be (sufficiently) accurate, only use data that we verified directly - selectString += "AND dt_updated > :timestamp"; - } - - // bind values and execute - q.prepare(selectString); - q.bindValue(":gamename", gamename); - q.bindValue(":timestamp", QDateTime::currentDateTime().addSecs(-serverAge_s ).toSecsSinceEpoch()); - if ( ! q.exec() ) - reportQuery(q); - - return q; -} |
