pozicijos nesaugoja

[Karutis]

prieš kažkiek laiko buvau panašią temą įkėlęs, bet dabar vėl nesaugo pozicijos ir niekaip nesuprantu kaip sutvarkyti

	GetPlayerPos(playerid, playerDB[playerid][X], playerDB[playerid][Y], playerDB[playerid][Z]);
	
	mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `vartotojai` SET `XP` = %d, `Pinigai` = %d, `Teises` = %d, `Teorija` = %d , `X` = %f, `Y` = %f, `Z` = %f, WHERE `ID` = %d LIMIT 1", GetPlayerScore(playerid), GetPlayerMoney(playerid), playerDB[playerid][Teises], playerDB[playerid][Teorija], playerDB[playerid][X], playerDB[playerid][Y], playerDB[playerid][Z], playerDB[playerid][ID]);

kodas po OnPlayerDisconnect eilute

Dar meta errorą mysql loge
 

[ERROR] error #1064 while executing query "UPDATE `vartotojai` SET `XP` = 50, `Pinigai` = 6000, `Teises` = 0, `Teorija` = 0, `X` = 123.994102, `Y` = -104.822090, `Z` = 1.578125, WHERE `ID` = 1 LIMIT 1": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `ID` = 1 LIMIT 1' at line 1

 

galit rankiti temą, susitvarkiau

Redaguota Rugpjūčio 14, 2017, nario Keviukas_Drifteriukas

[liight]

	mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `vartotojai` SET `XP` = %d, `Pinigai` = %d, `Teises` = %d, `Teorija` = %d , `X` = %f, `Y` = %f, `Z` = %f WHERE `ID` = %d LIMIT 1", GetPlayerScore(playerid), GetPlayerMoney(playerid), playerDB[playerid][Teises], playerDB[playerid][Teorija], playerDB[playerid][X], playerDB[playerid][Y], playerDB[playerid][Z], playerDB[playerid][ID]);

check this