[thimo]

So i got a buyhouse CMD but when i buy a house it should delete the green house icon and show blue one but it shows them both.
Anyone sees a problem here?

pawn Код:

format(string3, sizeof(string3), "UPDATE Houses SET Houseowner = '%s' WHERE HouseID = '%d'", pName, i);
                        mysql_query(string3);
                        SendClientMessage(playerid, 0xFF0000, "You have succesfully bought the house");
                        GivePlayerMoney(playerid, - AHouseData[i][price]);
                        format(string4, sizeof(string4), "UPDATE Users SET Houses = '%d' WHERE Name = '%s'", APlayerData[playerid][Houses]++, APlayerData[playerid][Name]);
                        mysql_query(string4);
                        DestroyDynamicPickup(AHouseData[i][PickupID]);
                        AHouseData[i][PickupID] = CreatePickup(1272, 1, AHouseData[i][HouseX], AHouseData[i][HouseY], AHouseData[i][HouseZ], -1);
                        format(string5, sizeof(string5), "House owned by:\n%s", pName);
                        UpdateDynamic3DTextLabelText(AHouseData[i][HouseName], COLOR_GREY, string5);