- Регистрация
- 6 Июн 2011
- Сообщения
- 522
- Лучшие ответы
- 15
- Репутация
- 201
Здравствуйте.Столкнулся с такой проблемой запроса к базе для обновления дома после покупки или например после как его продадут государству.
Вот сток обновления:
Вот из лога:
Вот сток обновления:
PHP:
stock UpdateHouse(hid)
{
new query[1024];
format(query, sizeof(query), "UPDATE `Houses` SET Entrancex='%f', Entrancey='%f', Entrancez='%f', Exitx='%f', Exity='%f', Exitz='%f', Owner='%s', Value='%d', Hel='%d', Int='%d', Lock='%d', Owned='%d', Takings='%d', Vec='%d', Vcol1='%d', Vcol2='%d', Klass='%d', VehSost='%d', Carx='%f', Cary='%f', Carz='%f', Carc='%f', Mats='%d', Style='%d', Sost='%d' WHERE `Id` = '%d'",
HouseInfo[hid][hEntrancex],
HouseInfo[hid][hEntrancey],
HouseInfo[hid][hEntrancez],
HouseInfo[hid][hExitx],
HouseInfo[hid][hExity],
HouseInfo[hid][hExitz],
HouseInfo[hid][hOwner],
HouseInfo[hid][hValue],
HouseInfo[hid][hHel],
HouseInfo[hid][hInt],
HouseInfo[hid][hLock],
HouseInfo[hid][hOwned],
HouseInfo[hid][hTakings],
HouseInfo[hid][hVec],
HouseInfo[hid][hVcol1],
HouseInfo[hid][hVcol2],
HouseInfo[hid][hKlass],
HouseInfo[hid][hVehSost],
HouseInfo[hid][hCarx],
HouseInfo[hid][hCary],
HouseInfo[hid][hCarz],
HouseInfo[hid][hCarc],
HouseInfo[hid][hMats],
HouseInfo[hid][hStyle],
HouseInfo[hid][hSost],
hid);
print("Update house");
print(query);
mysql_query(query);
}
HTML:
[23:40:38] CMySQLHandler::Query(UPDATE `Houses` SET Entrancex='2192.437011', Entrancey='-1815.223266', Entrancez='13.546875', Exitx='2261.310302', Exity='-1136.446655', Exitz='1050.632812', Owner='The State', Value='150000', Hel='0', Int='10', Lock='1', Owned='0', Takings='-100', Vec='0', Vcol1='0', Vcol2='0', Klass='0', VehSost='0', Carx='2188.306640', Cary='-1811.627929', Carz='13.551726', Carc='40.783054', Mats='0', Style='0', Sost='0' WHERE `Id` = '719') - An error has occured. (Error I 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 'Int='10', Lock='1', Owned='0', Takings='-100', Vec='0', Vcol1='0', Vcol2='0', Kl' at line 1)