Андрей:3
Ученик
Помогите пожалуйста исправить, буду очень благодарен.
Ошибка:
Появляется эта ошибка, при вызова паблика SaveHouse
Код:
stock SaveHouse(houseid)
{
new update[600],stringer[64];
update = "UPDATE `house` SET ";
acc_float_strcat(update, sizeof(update), "hEntrance0 ", HomeInfo[houseid][hEntrance][0]);
acc_float_strcat(update, sizeof(update), "hEntrance1 ", HomeInfo[houseid][hEntrance][1]);
acc_float_strcat(update, sizeof(update), "hEntrance2 ", HomeInfo[houseid][hEntrance][2]);
acc_float_strcat(update, sizeof(update), "hExit0 ", HomeInfo[houseid][hExit][0]);
acc_float_strcat(update, sizeof(update), "hExit1 ", HomeInfo[houseid][hExit][1]);
acc_float_strcat(update, sizeof(update), "hExit2 ", HomeInfo[houseid][hExit][2]);
acc_str_strcat(update, sizeof(update), "hOwner ", HomeInfo[houseid][hOwner]);
acc_int_strcat(update, sizeof(update), "hValue ", HomeInfo[houseid][hValue]);
acc_int_strcat(update, sizeof(update), "hHel ", HomeInfo[houseid][hHel]);
acc_int_strcat(update, sizeof(update), "hInt ", HomeInfo[houseid][hInt]);
acc_int_strcat(update, sizeof(update), "hLock ", HomeInfo[houseid][hLock]);
acc_int_strcat(update, sizeof(update), "hOwned ", HomeInfo[houseid][hOwned]);
acc_int_strcat(update, sizeof(update), "hTakings ", HomeInfo[houseid][hTakings]);
acc_int_strcat(update, sizeof(update), "hOnline ", HomeInfo[houseid][hOnline]);
acc_int_strcat(update, sizeof(update), "hNarko ", HomeInfo[houseid][hNarko]);
acc_int_strcat(update, sizeof(update), "hOgrablen ", HomeInfo[houseid][hOgrablen]);
acc_float_strcat(update, sizeof(update), "hKlass ", HomeInfo[houseid][hKlass]);
acc_float_strcat(update, sizeof(update), "hSafe", HomeInfo[houseid][hSafe]);
acc_float_strcat(update, sizeof(update), "hCarPoc0 ", HomeInfo[houseid][hCarPoc][0]);
acc_float_strcat(update, sizeof(update), "hCarPoc1 ", HomeInfo[houseid][hCarPoc][1]);
acc_float_strcat(update, sizeof(update), "hCarPoc2 ", HomeInfo[houseid][hCarPoc][2]);
acc_float_strcat(update, sizeof(update), "hCarPoc3 ", HomeInfo[houseid][hCarPoc][3]);
acc_int_strcat(update, sizeof(update), "hCar ", HomeInfo[houseid][hCar]);
acc_int_strcat(update, sizeof(update), "hGun0 ", HomeInfo[houseid][hGun][0]);
acc_int_strcat(update, sizeof(update), "hGun1 ", HomeInfo[houseid][hGun][1]);
acc_int_strcat(update, sizeof(update), "hGun2 ", HomeInfo[houseid][hGun][2]);
acc_int_strcat(update, sizeof(update), "hGun3 ", HomeInfo[houseid][hGun][3]);
acc_int_strcat(update, sizeof(update), "hGun4 ", HomeInfo[houseid][hGun][4]);
acc_int_strcat(update, sizeof(update), "hGunAmmo0 ", HomeInfo[houseid][hGunAmmo][0]);
acc_int_strcat(update, sizeof(update), "hGunAmmo1 ", HomeInfo[houseid][hGunAmmo][1]);
acc_int_strcat(update, sizeof(update), "hGunAmmo2 ", HomeInfo[houseid][hGunAmmo][2]);
acc_int_strcat(update, sizeof(update), "hGunAmmo3 ", HomeInfo[houseid][hGunAmmo][3]);
acc_int_strcat(update, sizeof(update), "hGunAmmo4 ", HomeInfo[houseid][hGunAmmo][4]);
strdel(update, strlen(update)-1, strlen(update));
format(stringer,sizeof(stringer),"WHERE `hID` = '%d'",HomeInfo[houseid][hID]);
strcat(update, stringer);
mysql_function_query(connects, update, false, "", "");
}
Код:
[17:10:08] [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 ''0' at line 1
