Add files via upload

1 files changed, 15 insertions, 0 deletions

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();
+}