diff options
Diffstat (limited to 'Maintenance/pruneplayers.cpp')
| -rw-r--r-- | Maintenance/pruneplayers.cpp | 18 |
1 files changed, 0 insertions, 18 deletions
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(); -} |
