Здравствуйте. Что не так с сохранением bizz. sbizz сохраняет все хорошо, а вот bizz нет
mysql r41-4
error #1064 while executing query "UPDATE bizz SET owned=0, owner=The State, exortion=No-one, buyprice=15000000, entrancecost=100, till=0, locked=1, products=50000, maxproducts=50000, priceprod=111, 2till=0, cena=250, mafia=0, getproducts=16 ": 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 'State, exortion=No-one, buyprice=15000000, entrancecost=100, till=0, locked=1, p' at line 1PHP код:
stock OnPropUpdate() {
new query[800];
for(new idx = 0; idx < sizeof SBizzInfo; idx++) {
mysql_format(dbHandle , query, 200, "UPDATE sbizz SET owned='%d',owner='%e',buyprice='%d',till='%d',locked='%d',prod='%d',priceprod='%d',2till='%d',mafia='%d',getprod='%d' WHERE id='%d'",
SBizzInfo[idx][sbOwned],SBizzInfo[idx][sbOwner],SBizzInfo[idx][sbBuyPrice],SBizzInfo[idx][sbTill],SBizzInfo[idx][sbLocked],SBizzInfo[idx][sbProducts],SBizzInfo[idx][sbPriceProd],SBizzInfo[idx][s2bTill],SBizzInfo[idx][sbMafia],SBizzInfo[idx][sbGetProducts],SBizzInfo[idx][sbID]);
mysql_tquery(dbHandle , query);
}
for(new idx = 0; idx < sizeof BizzInfo; idx++) {
mysql_format(dbHandle , query, 400,
"\
UPDATE \
bizz \
SET \
owned=%d, \
owner=%e, \
exortion=%e, \
buyprice=%d, \
entrancecost=%d, \
till=%d, \
locked=%d, \
products=%d, \
maxproducts=%d, \
priceprod=%d, \
2till=%d, \
cena=%d, \
mafia=%d, \
getproducts=%d \
", BizzInfo[idx][bOwned],
BizzInfo[idx][bOwner],
BizzInfo[idx][bExtortion],
BizzInfo[idx][bBuyPrice],
BizzInfo[idx][bEntranceCost],
BizzInfo[idx][bTill],
BizzInfo[idx][bLocked],
BizzInfo[idx][bProducts],
BizzInfo[idx][bMaxProducts],
BizzInfo[idx][bPriceProd],
BizzInfo[idx][b2Till],
BizzInfo[idx][bCena],
BizzInfo[idx][bMafia],
BizzInfo[idx][bID]);
mysql_tquery(dbHandle,sql_str,"","");
}
print(!"OnPropUpdate() : Âñå áèçíåñû ñîõðàíåíû óñïåøíî");
return 1;
}