From de57bc38217c09a0ae4a143f631896652368ecc3 Mon Sep 17 00:00:00 2001 From: Dark1-dev Date: Wed, 1 Mar 2023 21:32:53 +0600 Subject: Add files via upload --- src/Maintenance/pruneplayers.cpp | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 src/Maintenance/pruneplayers.cpp (limited to 'src/Maintenance/pruneplayers.cpp') diff --git a/src/Maintenance/pruneplayers.cpp b/src/Maintenance/pruneplayers.cpp new file mode 100644 index 0000000..0bae4f9 --- /dev/null +++ b/src/Maintenance/pruneplayers.cpp @@ -0,0 +1,18 @@ +#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