src/UdpTasks/StatusChecker/serverinfoupdate.cpp


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

#include "statuschecker.h"

bool StatusChecker::updateServerInfo(const QString                 &serverAddress,
                                     const unsigned short          &serverPort,
                                     const QHash<QString, QString> &serverInfo)
{
    // start query string and query
    QString updateString = "UPDATE serverinfo SET ";

    { // add parameter placeholders
        QStringListIterator updateField(_updateFields);
        while ( updateField.hasNext() )
        {
            QString field = updateField.next();
            if ( ! serverInfo.value(field).isEmpty() )
                updateString += QStringLiteral("%1 = :%1, ").arg( field );
        }
    }

    // complete update string
    updateString += "mutators = :mutators, "
                    "dt_serverinfo = :dt_serverinfo "
                    "WHERE sid IN ("
                    "SELECT id FROM serverlist "
                    "WHERE ip = :ip AND queryport = :queryport"
                    ")";

    // bind parameters
    QSqlQuery q;
    q.prepare(updateString);

    { // add parameter bindings
        QStringListIterator updateField(_updateFields);
        while ( updateField.hasNext() )
        {
            QString field = updateField.next();
            if ( ! serverInfo.value(field).isEmpty() )
                q.bindValue( QStringLiteral(":%1").arg(field),
                             serverInfo.value(field));
        }
    }

    // bind remaining values and execute
    q.bindValue(":mutators",      serverInfo.value("mutators", "None"));
    q.bindValue(":dt_serverinfo", QDateTime::currentSecsSinceEpoch() );
    q.bindValue(":ip",        serverAddress);
    q.bindValue(":queryport", serverPort);

    if ( ! q.exec() )
        return reportQuery(q);

    // was a row updated?
    return (q.numRowsAffected() > 0);
}