[vassilis]

I Guess the problem is my buyhouse function and the 1st query that i don't use "WHERE `hID` = %d"
i guess?
So i changed it
from

PHP код:

function BuyHouse(playerid)
{
    new query[400],label[150];
    new houseid = GetHouseID(playerid);
    HouseInfo[houseid][HOwned] = true;
    mysql_format(mysql,query,sizeof(query), "UPDATE `houses` SET `HOwned` = 1",HouseInfo[houseid][HOwned]);
      mysql_query(mysql, query);
    mysql_format(mysql,query,sizeof(query),"UPDATE `houses` SET `HOwnerID`= %d WHERE `hID` = '%d'",pinfo[playerid][ID],HouseInfo[houseid][HOwned],HouseInfo[houseid][hID]);
    mysql_query(mysql,query);
    format(label,sizeof(label),""COL_GREEN"HouseName"COL_WHITE":%s\n"COL_GREEN"",HouseInfo[houseid][HName]);
    UpdateDynamic3DTextLabelText(HouseInfo[houseid][H3D],COLOR_YELLOW,label);
    return 1;
} 


to

PHP код:

function BuyHouse(playerid)
{
    new query[400],label[150];
    new houseid = GetHouseID(playerid);
    HouseInfo[houseid][HOwned] = true;
    //mysql_format(mysql,query,sizeof(query), "UPDATE `houses` SET `HOwned` = 1",HouseInfo[houseid][HOwned]);
      //mysql_query(mysql, query);
    mysql_format(mysql,query,sizeof(query),"UPDATE `houses` SET `HOwnerID`= %d, SET `HOwned` = 1 WHERE `hID` = '%d'",pinfo[playerid][ID],HouseInfo[houseid][HOwned],HouseInfo[houseid][hID]);
    mysql_query(mysql,query);
    format(label,sizeof(label),""COL_GREEN"HouseName"COL_WHITE":%s\n"COL_GREEN"",HouseInfo[houseid][HName]);
    UpdateDynamic3DTextLabelText(HouseInfo[houseid][H3D],COLOR_YELLOW,label);
    return 1;
} 


And going to test it.