SA-MP Forums Archive
Not saving on OnPlayerDisconnect[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: Not saving on OnPlayerDisconnect[MYSQL] (/showthread.php?tid=376176)


Not saving on OnPlayerDisconnect[MYSQL] - SomebodyAndMe - 09.09.2012

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?

Re: Not saving on OnPlayerDisconnect[MYSQL] - Misiur - 09.09.2012

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);