Not saving on OnPlayerDisconnect[MYSQL]
#1

Hey, I'm busy with a filterscript, but the problem is that it doesn't save it.

Logs from Debug:

Код:
[14:09:38] CMySQLHandler::Query(UPDATE users SET Score = '1092', Money = '1209', AdminLevel = '5', VIPLevel = '1', House1 = '75', House2 = '0' WHERE Name = '') - Successfully executed.
It doesn't set the name.

Script:
pawn Код:
new Msg[128], Naam[24];
    GetPlayerName(playerid, Naam, sizeof(Naam));
    format(Msg, sizeof(Msg), "%s(%i) has logged off!", Naam, playerid);
    SendClientMessageToAll(0xFFFFFFFF, Msg);
    new SaveQuery[400];
    format(SaveQuery, sizeof(SaveQuery), "UPDATE users SET Score = '%i', Money = '%i', AdminLevel = '%i', VIPLevel = '%d', House1 = '%d', House2 = '%d' WHERE Name = '%s'", kPlayerInfo[playerid][Score],kPlayerInfo[playerid][Money],kPlayerInfo[playerid][AdminLevel],kPlayerInfo[playerid][VIPLevel], kPlayerInfo[playerid][Name], kPlayerInfo[playerid][House1],kPlayerInfo[playerid][House2], Naam);
    mysql_query(SaveQuery);
So what's the problem?
Reply
#2

pawn Код:
format(SaveQuery, sizeof(SaveQuery), "UPDATE users SET Score = '%i', Money = '%i', AdminLevel = '%i', VIPLevel = '%d', House1 = '%d', House2 = '%d' WHERE Name = '%s'", kPlayerInfo[playerid][Score],kPlayerInfo[playerid][Money],kPlayerInfo[playerid][AdminLevel],kPlayerInfo[playerid][VIPLevel], kPlayerInfo[playerid][Name], kPlayerInfo[playerid][House1],kPlayerInfo[playerid][House2], Naam);
//Changes to
format(SaveQuery, sizeof(SaveQuery), "UPDATE users SET Score = '%d', Money = '%d', AdminLevel = '%d', VIPLevel = '%d', House1 = '%d', House2 = '%d' WHERE Name = '%s'", kPlayerInfo[playerid][Score],kPlayerInfo[playerid][Money],kPlayerInfo[playerid][AdminLevel],kPlayerInfo[playerid][VIPLevel], kPlayerInfo[playerid][House1],kPlayerInfo[playerid][House2], Naam);
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)