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/insertserver.cpp | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 src/Database/Common/insertserver.cpp (limited to 'src/Database/Common/insertserver.cpp') diff --git a/src/Database/Common/insertserver.cpp b/src/Database/Common/insertserver.cpp new file mode 100644 index 0000000..05b2eaa --- /dev/null +++ b/src/Database/Common/insertserver.cpp @@ -0,0 +1,26 @@ +#include "commonactions.h" + +// insert a server into the list +bool insertServer(const QString &serverAddress, + const unsigned short &serverPort, + const QString &gamename, + const bool &directBeacon) +{ + // insert query string + QSqlQuery q; + QString insertString = "INSERT INTO serverlist (ip, queryport, gamename, f_direct) " + "VALUES (:ip, :queryport, :gamename, :directbeacon)"; + + // bind values and execute + q.prepare(insertString); + q.bindValue(":ip", serverAddress); + q.bindValue(":queryport", serverPort); + q.bindValue(":gamename", gamename); + q.bindValue(":directbeacon", ( directBeacon ? 1 : 0 ) ); // bool to int + + if ( ! q.exec() ) + return reportQuery(q); + + // was a row inserted? + return (q.numRowsAffected() > 0); +} -- cgit v1.2.3