Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Ошибка при сохранение Mysql

Статус
В этой теме нельзя размещать новые ответы.

kinggang7

Дебютант
Сделал в мод систему фермы.Загружаються хорошо,все работает.Версия mysql r39-2.Ну когда идет сохранение вот что пишет:

[16:21:41] [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 '' at line 1
[16:21:41] [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 '' at line 1

Код сохранение:

public SaveFarm()
{
new query[600];
new string[128];
for(new i = 1; i <= 2;i++)
{
query = "UPDATE `farm` SET ";
acc_int_strcat(query, sizeof(query), "ID",gFarm[ID]);
acc_int_strcat(query, sizeof(query), "Owned",gFarm[fOwned]);
acc_str_strcat(query, sizeof(query), "Owner",gFarm[fOwner]);
acc_int_strcat(query, sizeof(query), "Roff",gFarm[fRoff]);
acc_int_strcat(query, sizeof(query), "Bank",gFarm[fBank]);
acc_int_strcat(query, sizeof(query), "LandTax",gFarm[fLandTax]);
acc_int_strcat(query, sizeof(query), "WorkMoney",gFarm[fWorkMoney]);
acc_int_strcat(query, sizeof(query), "ZernoPrice",gFarm[fZernoPrice]);
acc_int_strcat(query, sizeof(query), "ZernoSklad",gFarm[fZernoSklad]);
acc_int_strcat(query, sizeof(query), "ZernoPole",gFarm[fZernoPole]);
acc_int_strcat(query, sizeof(query), "Prod",gFarm[fProd]);
acc_int_strcat(query, sizeof(query), "Sklad",gFarm[fSklad]);
acc_int_strcat(query, sizeof(query), "ProdPrice",gFarm[fProdPrice]);
acc_str_strcat(query, sizeof(query), "Zam1",gFarm[fZam1]);
acc_str_strcat(query, sizeof(query), "Zam2",gFarm[fZam2]);
acc_str_strcat(query, sizeof(query), "Zam3",gFarm[fZam3]);
acc_str_strcat(query, sizeof(query), "Farmer1",gFarm[fFarmer1]);
acc_str_strcat(query, sizeof(query), "Farmer2",gFarm[fFarmer2]);
acc_str_strcat(query, sizeof(query), "Farmer3",gFarm[fFarmer3]);
acc_str_strcat(query, sizeof(query), "Farmer4",gFarm[fFarmer4]);
acc_str_strcat(query, sizeof(query), "Farmer5",gFarm[fFarmer5]);
acc_float_strcat(query, sizeof(query), "ClothesPosX",gFarm[fClothesPos][0]);
acc_float_strcat(query, sizeof(query), "ClothesPosY",gFarm[fClothesPos][1]);
acc_float_strcat(query, sizeof(query), "ClothesPosZ",gFarm[fClothesPos][2]);
acc_float_strcat(query, sizeof(query), "FarmPosX",gFarm[fFarmPos][0]);
acc_float_strcat(query, sizeof(query), "FarmPosY",gFarm[fFarmPos][1]);
acc_float_strcat(query, sizeof(query), "FarmPosZ",gFarm[fFarmPos][2]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton1_X",gFarm[fVehicleWalton1][0]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton1_Y",gFarm[fVehicleWalton1][1]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton1_Z",gFarm[fVehicleWalton1][2]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton1_A",gFarm[fVehicleWalton1][3]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton2_X",gFarm[fVehicleWalton2][0]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton2_Y",gFarm[fVehicleWalton2][1]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton2_Z",gFarm[fVehicleWalton2][2]);
acc_float_strcat(query, sizeof(query), "fVehicleWalton2_A",gFarm[fVehicleWalton2][3]);
acc_float_strcat(query, sizeof(query), "fVehicleCombineX",gFarm[fVehicleCombine][0]);
acc_float_strcat(query, sizeof(query), "fVehicleCombineY",gFarm[fVehicleCombine][1]);
acc_float_strcat(query, sizeof(query), "fVehicleCombineZ",gFarm[fVehicleCombine][2]);
acc_float_strcat(query, sizeof(query), "fVehicleCombineA",gFarm[fVehicleCombine][3]);
strdel(query, strlen(query)-1, strlen(query));
mysql_function_query(mMysql,query,false,"","");
}
return true;
}
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу