From 3c7253d6cdc23aac36208fa87dc6571c7cb7c5ff Mon Sep 17 00:00:00 2001
From: Dark1-dev <shansarkar272@gmail.com>
Date: Wed, 1 Mar 2023 21:33:55 +0600
Subject: Add files via upload

---
 Maintenance/prunebeacons.cpp | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 Maintenance/prunebeacons.cpp

(limited to 'Maintenance/prunebeacons.cpp')

diff --git a/Maintenance/prunebeacons.cpp b/Maintenance/prunebeacons.cpp
new file mode 100644
index 0000000..10e4630
--- /dev/null
+++ b/Maintenance/prunebeacons.cpp
@@ -0,0 +1,16 @@
+#include "maintenance.h"
+
+int Maintenance::pruneBeacons()
+{
+    QString updateString = "UPDATE serverlist "
+                           "SET f_direct = 0 "
+                           "WHERE f_direct = 1 AND dt_beacon < :timestamp";
+    QSqlQuery updateQuery;
+    updateQuery.prepare(updateString);
+    updateQuery.bindValue(":timestamp", QDateTime::currentDateTime().addSecs(-600).toSecsSinceEpoch());
+
+    if ( ! updateQuery.exec() )
+        return reportQuery(updateQuery);
+
+    return updateQuery.numRowsAffected();
+}
-- 
cgit v1.2.3