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. --- Maintenance/pruneplayers.cpp | 18 ------------------ 1 file changed, 18 deletions(-) delete mode 100644 Maintenance/pruneplayers.cpp (limited to 'Maintenance/pruneplayers.cpp') diff --git a/Maintenance/pruneplayers.cpp b/Maintenance/pruneplayers.cpp deleted file mode 100644 index 0bae4f9..0000000 --- a/Maintenance/pruneplayers.cpp +++ /dev/null @@ -1,18 +0,0 @@ -#include "maintenance.h" - -int Maintenance::prunePlayers() -{ - QString deleteString = "DELETE FROM playerinfo " - "WHERE playerinfo.sid NOT IN ( " - "SELECT serverinfo.sid FROM serverinfo) " - "OR dt_player < :timestamp"; - QSqlQuery deleteQuery; - deleteQuery.prepare(deleteString); - deleteQuery.bindValue(":timestamp", QDateTime::currentDateTime() - .addSecs(-7200).toSecsSinceEpoch()); // 2 hours - - if ( ! deleteQuery.exec() ) - return reportQuery(deleteQuery); - - return deleteQuery.numRowsAffected(); -} -- cgit v1.2.3