I cant find the mysql error
#4

Thanks! When I seted it to 256 it's ok. But now i get the following error...
Код:
[14:09:10] Number of vehicle models: 0
[14:09:28] Incoming connection: IP:PORT
[14:09:29] [join] Kemal3 has joined the server (0:IP)
[14:09:39] [MySQL] Error (0): Failed to exeute query. Unknown column 'Kemal3' in 'where clause'.
[14:09:39] Player ID 0 has been saved
[14:09:39] [part] Kemal3 has left the server (0:1)
Код:
stock SavePlayer(playerid){
	new query[256], pName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pName, sizeof(pName));
	
	GetPlayerPos(playerid, Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2]);
	
	format(query, sizeof(query), "UPDATE `players` SET Username = '%s', Password = '%s', PlayerX = %f, PlayerY = %f, PlayerZ = %f WHERE Username = `%s`", pName, Player[playerid][Password], Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2], pName);
	mysql_query(query);
	printf("Player ID %d has been saved", playerid, pName);

}
Reply


Messages In This Thread
I cant find the mysql error - by Zloto - 01.05.2015, 23:36
Re: I cant find the mysql error - by DRCharlie - 02.05.2015, 00:53
Re: I cant find the mysql error - by MP2 - 02.05.2015, 01:15
Re: I cant find the mysql error - by Zloto - 02.05.2015, 11:06
Re: I cant find the mysql error - by Konstantinos - 02.05.2015, 11:12
Re: I cant find the mysql error - by Zloto - 02.05.2015, 11:23
Re: I cant find the mysql error - by joedyjoe - 02.05.2015, 13:45
Re: I cant find the mysql error - by Konstantinos - 02.05.2015, 13:58

Forum Jump:


Users browsing this thread: 1 Guest(s)