Add files via upload

1 files changed, 18 insertions, 0 deletions

diff --git a/Maintenance/pruneplayers.cpp b/Maintenance/pruneplayers.cpp
new file mode 100644
index 0000000..0bae4f9
--- /dev/null
+++ b/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();
+}