18.11.2010, 14:32
That string is fine, however that query is not. That query will set the Money column of ALL rows in the table, you need to specify who you're setting it for, for example:
Obviously you'll need to sort out getting the name of the player yourself, what I gave is only an example if you were storing the name of players in an array.
pawn Код:
new query[200];
format(query,200,"UPDATE `Test` SET Money = %i WHERE Username = '%s'",GetPlayerMoney(playerid),name[playerid]);
return mysql_query(query);