Add files via upload

1 files changed, 28 insertions, 0 deletions

diff --git a/Database/Common/getgamenames.cpp b/Database/Common/getgamenames.cpp
new file mode 100644
index 0000000..8093f7c
--- /dev/null
+++ b/Database/Common/getgamenames.cpp
@@ -0,0 +1,28 @@
+#include "commonactions.h"
+
+QStringList getGamenames(const int &serverAge_s)
+{
+    // init output
+    QStringList gamenameList;
+
+    // retrieve active gamenames from database
+    QSqlQuery q;
+    QString selectString = "SELECT DISTINCT gamename FROM serverlist "
+                           "WHERE dt_updated > :timestamp "
+                           "ORDER BY gamename ASC";
+
+    // bind and execute
+    q.prepare(selectString);
+    q.bindValue(":timestamp", QDateTime::currentDateTime().addSecs(-serverAge_s ).toSecsSinceEpoch());
+
+    if ( ! q.exec() )
+        reportQuery(q);
+
+    // parse to stringlist
+    while ( q.next() )
+    {
+         gamenameList.append( q.value(0).toString() );
+    }
+
+    return gamenameList;
+}