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/pruneserverinfo.cpp | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 src/Maintenance/pruneserverinfo.cpp (limited to 'src/Maintenance/pruneserverinfo.cpp') diff --git a/src/Maintenance/pruneserverinfo.cpp b/src/Maintenance/pruneserverinfo.cpp new file mode 100644 index 0000000..e3f2bd8 --- /dev/null +++ b/src/Maintenance/pruneserverinfo.cpp @@ -0,0 +1,15 @@ +#include "maintenance.h" + +int Maintenance::pruneServerInfo() +{ + QString deleteString = "DELETE FROM serverinfo " + "WHERE sid NOT IN ( " + "SELECT id FROM serverlist)"; + QSqlQuery deleteQuery; + deleteQuery.prepare(deleteString); + + if ( ! deleteQuery.exec() ) + return reportQuery(deleteQuery); + + return deleteQuery.numRowsAffected(); +} -- cgit v1.2.3