From 3c7253d6cdc23aac36208fa87dc6571c7cb7c5ff Mon Sep 17 00:00:00 2001 From: Dark1-dev Date: Wed, 1 Mar 2023 21:33:55 +0600 Subject: Add files via upload --- Database/Common/getnumgames.cpp | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 Database/Common/getnumgames.cpp (limited to 'Database/Common/getnumgames.cpp') diff --git a/Database/Common/getnumgames.cpp b/Database/Common/getnumgames.cpp new file mode 100644 index 0000000..1425427 --- /dev/null +++ b/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