From 3c7253d6cdc23aac36208fa87dc6571c7cb7c5ff Mon Sep 17 00:00:00 2001 From: Dark1-dev Date: Wed, 1 Mar 2023 21:33:55 +0600 Subject: Add files via upload --- Maintenance/pruneserverinfo.cpp | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 Maintenance/pruneserverinfo.cpp (limited to 'Maintenance/pruneserverinfo.cpp') diff --git a/Maintenance/pruneserverinfo.cpp b/Maintenance/pruneserverinfo.cpp new file mode 100644 index 0000000..e3f2bd8 --- /dev/null +++ b/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