Не получается сохранить данные в базу. Вот сама функция сохранения:
stock SaveCar(i)
{
new src[1500],query[1500];
format(query,sizeof(query),"UPDATE "TABLE_CARS" SET ");
format(src,sizeof(src),"cModel=%i,",CarInfo[i][cModel]);
strcat(query,src);
format(src,sizeof(src),"cX=%.2f,",CarInfo[i][cX]);
strcat(query,src);
format(src,sizeof(src),"cY=%.2f,",CarInfo[i][cY]);
strcat(query,src);
format(src,sizeof(src),"cZ=%.2f,",CarInfo[i][cZ]);
strcat(query,src);
format(src,sizeof(src),"cA=%.2f,",CarInfo[i][cA]);
strcat(query,src);
format(src,sizeof(src),"cColor1=%i,",CarInfo[i][cColor1]);
strcat(query,src);
format(src,sizeof(src),"cColor2=%i,",CarInfo[i][cColor2]);
strcat(query,src);
format(src,sizeof(src),"cPlayer=%s,",CarInfo[i][cPlayer]);
strcat(query,src);
format(src,sizeof(src),"cSpeed=%i,",CarInfo[i][cSpeed]);
strcat(query,src);
format(src,sizeof(src),"cFuel=%i,",30);
strcat(query,src);
format(src,sizeof(src),"cFuelType=%i,",CarInfo[i][cFuelType]);
strcat(query,src);
format(src,sizeof(src),"cHealth=%i,",CarInfo[i][cHealth]);
strcat(query,src);
format(src,sizeof(src),"cId=%i",CarInfo[i][cId]);
strcat(query,src,sizeof(query));
mysql_function_query(dbHandle, query, false, "", "");
}
В консоли сервера вот эта ошибка:
EID: 1064 | Error: 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 'cSpeed=134,cFuel=30,cFuelType=95,cHealth=1000,cId=0' at line 1 | Query: UPDATE cars SET cModel=466,cX=2480.00,cY=-739.09,cZ=11.97,cA=0.00,cColor1=0,cColor2=0,cPlayer=,cSpeed=134,cFuel=30,cFuelType=95,cHealth=1000,cId=0