[Florin48]

try this but I do not know exactly how your home system is


CMD:buyhouse(playerid, params[])
{
new id;
if(sscanf(params, "i", id)) return Error(playerid, "Invalid house ID.");
if(hInfo[id][HouseOwned] == 1) Error(playerid, "This house is already owned by someone else");
else BuyHouse(playerid, id);
return 1;
}

BuyHouse(playerid, id)
{
hInfo[id][HouseOwned] = 1;
new pqname[24];
GetPlayerName(playerid, pqname, sizeof(pqname));
new queryq[96];
format(queryq, sizeof(queryq), "UPDATE `houses` SET `HouseOwner` = '%s', `HouseOwned` = '1' WHERE `HouseID` = '%d' ", pqname, id);
mysql_tquery(dbHandle, queryq);
}