SA-MP Forums Archive
mysql weapon position save error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql weapon position save error (/showthread.php?tid=657336)


mysql weapon position save error - reddoxx - 05.08.2018

i got this error
Код:
[18:42:19] [Admin Ьzenet] [MYSQL ERROR]: ID: 1064

[18:42:19] [Admin Ьzenet] [MYSQL ERROR]: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB se

[18:42:19] [Admin Ьzenet] [MYSQL ERROR]: Query: INSERT INTO weaponsettings (Name, WeaponID, PosX, PosY, PosZ, RotX, RotY, RotZ) VALUES ('H
when i use this code
Код:
            mysql_format(SQL_CONNECTION, string, sizeof(string), "INSERT INTO weaponsettings (Name, WeaponID, PosX, PosY, PosZ, RotX, RotY, RotZ) VALUES ('%s', %d, %.3f, %.3f, %.3f, %.3f, %.3f, %.3f) ON DUPLICATE KEY UPDATE PosX = VALUES(PosX), PosY = VALUES(PosY), PosZ = VALUES(PosZ), RotX = VALUES(RotX), RotY = VALUES(RotY), RotZ = VALUES(RotZ)", name, weaponid, fOffsetX, fOffsetY, fOffsetZ, fRotX, fRotY, fRotZ);
            mysql_tquery(SQL_CONNECTION, string);


Re: mysql weapon position save error - reddoxx - 06.08.2018

bump

Re: mysql weapon position save error - KinderClans - 06.08.2018

You forgot the ' ' in the VALUES.

Re: mysql weapon position save error - reddoxx - 06.08.2018

so you think that?
Код:
mysql_format(SQL_CONNECTION, string, sizeof(string), "INSERT INTO weaponsettings (Name, WeaponID, PosX, PosY, PosZ, RotX, RotY, RotZ) VALUES ('%s', %d, %.3f, %.3f, %.3f, %.3f, %.3f, %.3f) ON DUPLICATE KEY UPDATE PosX = VALUES('PosX'), PosY = VALUES('PosY'), PosZ = VALUES('PosZ'), RotX = VALUES('RotX'), RotY = VALUES('RotY'), RotZ = VALUES('RotZ')", name, weaponid, fOffsetX, fOffsetY, fOffsetZ, fRotX, fRotY, fRotZ);
mysql_tquery(SQL_CONNECTION, string);