From 74ff50c5ca343b5829287f6e7ee2b916aa29720e Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sat, 8 Mar 2025 15:11:53 +0100 Subject: reorganise files Sort out code/source files that were mixed with other repository files. No new functional changes. --- Database/Common/selectserverlist.cpp | 31 ------------------------------- 1 file changed, 31 deletions(-) delete mode 100644 Database/Common/selectserverlist.cpp (limited to 'Database/Common/selectserverlist.cpp') 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; -} -- cgit v1.2.3