Add files via upload

1 files changed, 22 insertions, 0 deletions

diff --git a/src/UdpTasks/StatusChecker/serverinfoinsert.cpp b/src/UdpTasks/StatusChecker/serverinfoinsert.cpp
new file mode 100644
index 0000000..e2e1f55
--- /dev/null
+++ b/src/UdpTasks/StatusChecker/serverinfoinsert.cpp
@@ -0,0 +1,22 @@
+#include "statuschecker.h"
+
+bool StatusChecker::insertServerInfo(const QString        &serverAddress,
+                                     const unsigned short &serverPort)
+{
+    // insert query string
+    QSqlQuery q;
+    QString insertString = "INSERT INTO serverinfo (sid) "
+                           "SELECT id FROM serverlist "
+                           "WHERE ip = :ip AND queryport = :queryport";
+
+    // bind values and execute
+    q.prepare(insertString);
+    q.bindValue(":ip",        serverAddress);
+    q.bindValue(":queryport", serverPort);
+
+    if ( ! q.exec() )
+        return reportQuery(q);
+
+    // was a row updated?
+    return (q.numRowsAffected() > 0);
+}