random enum values ? [mysql] - Printable Version

random enum values ? [mysql] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: random enum values ? [mysql] (/showthread.php?tid=530640)

random enum values ? [mysql] - Champ - 08.08.2014

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.