[Ripster]

Quote:

[23:10:01 02/03/18] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'Lock = 0, State = 0 WHERE DoorDBID = 2' at line 1 (Query: "UPDATE door SET OwnerDBID = 1, FactionDBID = 0, Model = 1537, Lock = 0, State = 0 WHERE DoorDBID = 2")

Код:

mysql_format(ourConnection, threadSave, sizeof(threadSave), "UPDATE door SET OwnerDBID = %i, FactionDBID = %i, Model = %i, Lock = %i, State = %i WHERE DoorDBID = %i",
		DoorInfo[id][OwnerID],
		DoorInfo[id][FactionID],
		DoorInfo[id][Model],
		DoorInfo[id][Lock],
		DoorInfo[id][State],
		DoorInfo[id][DoorID]);
	mysql_tquery(ourConnection, threadSave);