[vassilis]

Quote:

Originally Posted by CmZxC Replace HouseInfo[houseid][hID] with houseid on BuyHouse mysql format.

I did and now it updates the text label from the other Post LMAO
still got the same problem
i noticed that it updates the howned column and set it to 1 but hownerid and hname remains the same as there is an sql syntax error?
Also even it says it updates hname to test it doesnt set the hname at the house id since it says HID= 0 and i don't get why?

pawn Код:

[01:52:15] [DEBUG] mysql_format - connection: 1, len: 400, format: "UPDATE `houses` SET `HOwnerID`= '%d', SET `HOwned` = 1 WHERE `hID` = '%d'"
[01:52:15] [DEBUG] mysql_query - connection: 1, query: "UPDATE `houses` SET `HOwnerID`= '1', SET `HOwned` = 1 WHERE `hID", use_cache: true
[01:52:15] [DEBUG] CMySQLQuery::Execute - starting query execution
[01:52:15] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET `HOwned` = 1 WHERE `hID` = '0'' at line 1
[01:52:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:52:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.640 milliseconds

Do i need to change something at createhouse function?