08.04.2018, 11:45
I think you should see this: https://dev.mysql.com/doc/refman/5.7/en/update.html
You aren't using any "WHERE" in your code, so it sets it for every record in the table... The correct query is:
You will need to change `name` and `player_name`to whatever you use to identify your users...
You aren't using any "WHERE" in your code, so it sets it for every record in the table... The correct query is:
PHP код:
mysql_format(connectionID, queryBuffer, sizeof(queryBuffer), "UPDATE users SET tester = %i WHERE name = %s", PlayerInfo[playerid][pTester], player_name);
mysql_tquery(connectionID, queryBuffer);