Hallo liebe Community,
MySQL macht erneut Probleme..
[19:13:09] [ERROR] CMySQLQuery::Execute[CarSavedToDB] - (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 ''268.9042' at line 1
[19:14:57] [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 'SET x='1062.766723', y='-1760.815429', z='13.182973', r='90.395103' WHERE id='0'' at line 1
SaveCarToDB:
public SaveCarToDB(playerid, carid)
{
new query[128];
format(query, sizeof(query), "INSERT INTO cars (owner, model, x, y, z, r, color1, color2) VALUES ('%i','%i','%f','%f','%f','%f','%i','%i')", UserInfo[playerid][uID],CarInfo[carid][cModelID], CarInfo[carid][c_x], CarInfo[carid][c_y], CarInfo[carid][c_z], CarInfo[carid][c_r], CarInfo[carid][cFarbe1], CarInfo[carid][cFarbe2]);
mysql_tquery(sqlHandle,query,"CarSavedToDB","i",carid);
return 1;
}
CarSavedToDB:
public CarSavedToDB(carid)
{
CarInfo[carid][dbID] = cache_insert_id(sqlHandle);
return 1;
}
Ich finde keine Syntax-Fehler, aber vielleicht einer von euch..
mfg
Ace'X