18.02.2013, 17:57
Heey all,
I have this error in my server log:
My code:
How to fix this?
I am using Mysql R14.
Admigo
I have this error in my server log:
Code:
EID: 1064 | Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serverversion for the right syntax to use near ''users' SET 'Money' = 5000, 'Score' = 0, 'Admin' = 0, 'Kills' = 0, 'Deaths' = 0 ' at line 1 | Query: UPDATE 'users' SET 'Money' = 5000, 'Score' = 0, 'Admin' = 0, 'Kills' = 0, 'Deaths' = 0 WHERE Username 'Admigo'
pawn Code:
public OnPlayerConnect(playerid)
{
mysql_format(gConnectionHandle,Query, "SELECT * FROM `users` WHERE 'Username' = '%s'", GetName(playerid));
mysql_function_query(gConnectionHandle, Query, false , "CheckPlayer", "d", playerid);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
mysql_format(gConnectionHandle, Query, "UPDATE 'users' SET 'Money' = %d, 'Score' = %d, 'Admin' = %d, 'Kills' = %d, 'Deaths' = %d WHERE Username '%e'",GetPlayerMoney(playerid),GetPlayerScore(playerid),PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],GetName(playerid));
mysql_function_query(gConnectionHandle, Query, false , "OnQueryFinish", "s", Query);
return 1;
}
I am using Mysql R14.
Admigo