Quote:
Originally Posted by yvoms
pawn Code:
public OnPlayerDisconnect(playerid, reason)
{
if(Logged[playerid] == 1)
{
new score = GetPlayerScore(playerid);
new money = GetPlayerMoney(playerid);
new query[300], pname[24]; new nquery[300];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "UPDATE `playerdata` SET score='%d', money='%d' WHERE user='%s'",
mysql_query(query);
}
return 1;
}
Thats what i used, worked without any bugs. |
You formatted the query, but you haven't inserted the values. Plus, there's a useless array.
OT :
You're having problems with your MySQL query. There have to be commas while updating each column. What the above user done is fine, except no insertion of values while formatting the query which makes things wrong.
