[CraftMan]

Using translate.******.ru as the British do not know much! in the general problem

log

Quote:

[02:03:52] CMySQLHandler::Query(UPDATE `house` SET EnterX=-329.548034,EnterY=-329.548034,EnterZ=-329.548034,ExitX=2350.339843,ExitY=-1181.649902,ExitZ=1027.976562,Owner=Sa[]e,Owned=97,Price=101,Inter=5 WHERE id='1') - An error has occured. (Error ID: 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 '[]e,Owned=97,Price=101,Inter=5 WHERE id='1'' at line 1)

code

PHP Code:

strmid(HouseInfo[home][hOwner], pname, 0, strlen(pname), 255); 


PHP Code:

stock HouseUpdate(idx)
{
    new src[MAX_STRING],query[MAX_QUERY];
    format(query,sizeof(query),"UPDATE `"HouseTable"` SET ");
    format(src,sizeof(src),"EnterX=%f,",HouseInfo[idx][hEnterX]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"EnterY=%f,",HouseInfo[idx][hEnterY]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"EnterZ=%f,",HouseInfo[idx][hEnterZ]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"ExitX=%f,",HouseInfo[idx][hExitX]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"ExitY=%f,",HouseInfo[idx][hExitY]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"ExitZ=%f,",HouseInfo[idx][hExitZ]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"Owner=%s,",HouseInfo[idx][hOwner]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"Owned=%d,",HouseInfo[idx][hOwned]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"Price=%d,",HouseInfo[idx][hPrice]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src),"Inter=%d",HouseInfo[idx][hInt]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," WHERE id='%d'",idx);
    strcat(query,src,sizeof(query));
    mysql_query(query);
    return 1;
} 


Here's a character turns on the screenshot
http://s010.radikal.ru/i312/1109/af/2a152c7fed78.bmp
encoding utf8