[Champ]

when player disconnects. the system sets random values to its enum data (e.g: admin=46, money=53, vip=23)

mysql_log.txt

Код:

[13:26:49] [DEBUG] mysql_tquery - scheduling query "UPDATE `players` SET `Admin` = 49, `VIP` = 51, `Money` = 51 WHERE `ID` = 5"..

code for updating data.

pawn Код:

public OnPlayerDisconnect(playerid, reason)
{
    new Query[128];
    
    mysql_format(mysql, Query, sizeof(Query), "UPDATE `players` SET `Admin` = %i, `VIP` = %i, `Money` = %i WHERE `ID` = %i",
    PlayerInfo[playerid][Admin],
    PlayerInfo[playerid][VIP],
    PlayerInfo[playerid][Money],
    PlayerInfo[playerid][ID]
    );
    
    mysql_tquery(mysql, Query, "", "");
    
    return 1;
}

enums

pawn Код:

enum pData
{
    ID,
    Password,
    Admin,
    VIP,
    Money
}

new PlayerInfo[MAX_PLAYERS][pData];

thanks in advance.