#2

Oh boy your code is quite a mess.

PHP код:
new sqlQuery[700], desc[64]; mysql_real_escape_string(HouseInfo[houseid][hDiscription],desc);
    
format(sqlQuerysizeof(sqlQuery), "UPDATE `samp_houses` SET `Entrance_X`='%f', `Entrance_Y`='%f', `Entrance_Z`='%f', `Exit_X`='%f', `Exit_Y`='%f', `Exit_Z`='%f'"HouseInfo[houseid][hEntrancex],HouseInfo[houseid][hEntrancey],HouseInfo[houseid][hEntrancez],HouseInfo[houseid][hExitx],HouseInfo[houseid][hExity], HouseInfo[houseid][hExitz]);
    
format(sqlQuerysizeof(sqlQuery), "%s, `Owner`='%s', `Description`='%s', `Price`='%d', `Health`='%d', `Armour`='%d', `Interior`='%d', `Locked`='%d'"sqlQueryHouseInfo[houseid][hOwner],desc,HouseInfo[houseid][hValue],HouseInfo[houseid][hHel],HouseInfo[houseid][hArm],HouseInfo[houseid][hInt], HouseInfo[houseid][hLock]);
    
format(sqlQuerysizeof(sqlQuery), "%s, `Owned`='%d', `RentPrice`='%d', `Rentable`='%d', `Takings`='%d', `LevelNeeded`='%d', `World`='%d', `Setted`='%d', `ExVW`='%d', `ExINT`='%d' WHERE HouseID='%d'"sqlQueryHouseInfo[houseid][hOwned],HouseInfo[houseid][hRent],HouseInfo[houseid][hRentabil],HouseInfo[houseid][hTakings],HouseInfo[houseid][hLevel],HouseInfo[houseid][hWorld],HouseInfo[houseid][hSetted], HouseInfo[houseid][hExVW], HouseInfo[houseid][hExINT], houseid);
    
mysql_query(sqlQueryTHREAD_SAVEHOUSEShouseid); 
Useless 2 formats, when you format, you are setting the value for that string, you need to execute queries too. Also for mysql you'd need to use mysql_format instead of regular format.

PHP код:
mysql_query(sqlQueryTHREAD_SAVEHOUSEShouseid); 
Invalid mysql_query usage. Correct:
PHP код:
mysql_query(connectionhandlequery[]) 
PHP код:
return mysql_query("SELECT * FROM `samp_houses`"THREAD_LOADHOUSES); 
Once again, misuse of mysql_query.

There is most likely alot more broken with your code, but there's no point in looking further.
Reply


Messages In This Thread
help - by Infinity001 - 04.12.2015, 14:06
Re: help - by CmZxC - 04.12.2015, 23:34

Forum Jump:


Users browsing this thread: 1 Guest(s)