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

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

(limited to 'src/Maintenance/prunebeacons.cpp')

diff --git a/src/Maintenance/prunebeacons.cpp b/src/Maintenance/prunebeacons.cpp
new file mode 100644
index 0000000..10e4630
--- /dev/null
+++ b/src/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