21.02.2011, 13:16
You're passing it as a string in the format function, when it's supposed to be an integer, you need to use a function like strval. Additionally I would change the SQL syntax slightly, like so:
pawn Код:
stock SetPlayerInfo(playerid, info[], newinfo[], vartype)
{
if(vartype){
format(query, sizeof(query), "UPDATE `users` SET %s = '%s' WHERE username = '%s'", info, newinfo,PlayerName[playerid]);
}else{
format(query, sizeof(query), "UPDATE `users` SET %s = %d WHERE username = '%s'", info, strval(newinfo),PlayerName[playerid]);
}
printf("SetPlayerInfo %s", query);
mysql_query(query);
}