From de57bc38217c09a0ae4a143f631896652368ecc3 Mon Sep 17 00:00:00 2001 From: Dark1-dev Date: Wed, 1 Mar 2023 21:32:53 +0600 Subject: Add files via upload --- src/Database/Common/getnumgames.cpp | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 src/Database/Common/getnumgames.cpp (limited to 'src/Database/Common/getnumgames.cpp') diff --git a/src/Database/Common/getnumgames.cpp b/src/Database/Common/getnumgames.cpp new file mode 100644 index 0000000..1425427 --- /dev/null +++ b/src/Database/Common/getnumgames.cpp @@ -0,0 +1,30 @@ +#include "commonactions.h" + +QHash getNumGames(const int &serverAge_s) +{ + QSqlQuery q; + QHash numGames; + + // number of games + q.prepare("SELECT count(gamename) FROM gameinfo"); + if ( ! q.exec() ) + reportQuery(q); + if (q.next()) + numGames["numTotal"] = q.value(0).toInt(); + + // number of active games + QString selectString = "SELECT count(gamename) FROM gameinfo " + "WHERE num_direct > 0 " + "OR num_total > 0 "; + q.prepare(selectString); + q.bindValue(":timestamp", QDateTime::currentDateTime().addSecs(-serverAge_s ).toSecsSinceEpoch()); + if ( ! q.exec() ) + reportQuery(q); + if (q.next()) + numGames["numActive"] = q.value(0).toInt(); + + + // TODO: get more relevant stats + + return numGames; +} -- cgit v1.2.3