TFS 1.X+ Console query problems

[ninolouco]

iologindata.cpp

void IOLoginData::updateOnlineStatus(uint32_t guid, bool login, bool broadcasting, const std::string& cast_password,
                                     const std::string& cast_description, uint32_t spectators)
{
    if (g_config.getBoolean(ConfigManager::ALLOW_CLONES)) {
        return;
    }

    Database* db = Database::getInstance();
    std::ostringstream query;
    if (login) {
        query << "INSERT INTO `players_online` (`player_id`, `broadcasting`, `password`, `description`, `spectators`) VALUES "
                "(" << guid << ", " << broadcasting << ", " << db->escapeString(cast_password) << ", " << db->escapeString(cast_description) << ", " << spectators << ")";
    } else {
        query << "UPDATE `players_online` SET "
                "`broadcasting` = " << broadcasting << ", "
                "`password` = " << db->escapeString(cast_password) << ", "
                "`description` = " << db->escapeString(cast_description) << ", "
                "`spectators` = " << spectators << " "
                " WHERE `player_id` = " << guid;
    }
    db->executeQuery(query.str());
}

Console errors when the player connect

[Error - mysql_real_query] Query: INSERT INTO `players_online` (`player_id`, `broadcasting`, `password`, `description`, `spectators`) VALUES (1, 0, '', '', 0)
Message: Unknown column 'broadcasting' in 'field list'

how fix?

 

[celohere]

the column 'broadcasting' is missing in your database, just add this column

 

[ninolouco]

the column 'broadcasting' is missing in your database, just add this column

I have there this column, but i added manually the column editing database file.

https://imgur.com/a/hj9Wkdy

 

[alisonbarbosa]

você

 

[Ramon Bernardo]

I have there this column, but i added manually the column editing database file.

https://imgur.com/a/hj9Wkdy

ALTER TABLE players_online
ADD COLUMN broadcasting TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER player_id;

 

[alisonbarbosa]

[Error - mysql_real_query] Query: SELECT name, level, spectators FROM players LEFT JOIN players_online on players.id = players_online.player_id WHERE broadcasting = 1
Message: Unknown column 'spectators' in 'field list'
[Error - mysql_store_result] Query: SELECT name, level, spectators FROM players LEFT JOIN players_online on players.id = players_online.player_id WHERE broadcasting = 1
Message: Unknown column 'spectators' in 'field list'

 

[Ramon Bernardo]

[Error - mysql_real_query] Query: SELECT name, level, spectators FROM players LEFT JOIN players_online on players.id = players_online.player_id WHERE broadcasting = 1
Message: Unknown column 'spectators' in 'field list'
[Error - mysql_store_result] Query: SELECT name, level, spectators FROM players LEFT JOIN players_online on players.id = players_online.player_id WHERE broadcasting = 1
Message: Unknown column 'spectators' in 'field list'

ALTER TABLE players_online
ADD COLUMN spectators TINYINT UNSIGNED NOT NULL DEFAULT '0';