[Tanush123]

Код:

[15:01:28] CMySQLHandler::Query(UPDATE `House` SET `Owner` = 'No Owner',`HasOwner` = 0 WHERE ID = 3) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now)
[15:01:28] >> mysql_query( Connection handle: 1 )

pawn Код:

CMD:sellhouse(playerid,params[])
{
    if(PlayerData[playerid][HasHouse] == 0) return SCM(playerid,red,"ERROR: You don't have a house");
    GetPlayerName(playerid,Nam,sizeof(Nam));
    format(str,sizeof(str),"SELECT * FROM House WHERE ID = %d",PlayerData[playerid][HouseID]);
    mysql_query(str);
    format(str,sizeof(str),"UPDATE `House` SET `Owner` = 'No Owner',`HasOwner` = 0 WHERE ID = %d",PlayerData[playerid][HouseID]);
    mysql_query(str);
    format(query, sizeof(query), "{FF0000}Cost: {FFFFFF}%d\n{FF0000}Owner: {FFFFFF}No Owner",HouseInfo[PlayerData[playerid][HouseID]][Cost]);
    UpdateDynamic3DTextLabelText(HouseInfo[PlayerData[playerid][HouseID]][hlabel],-1,query);
    format(HouseInfo[PlayerData[playerid][HouseID]][Owner],24,"No Owner");
    HouseInfo[PlayerData[playerid][HouseID]][HasOwner] = 0;
    GivePlayerMoney(playerid,HouseInfo[PlayerData[playerid][HouseID]][Cost]/2);
    HouseInfo[PlayerData[playerid][HouseID]][Mapicon] = CreateDynamicMapIcon(X,Y,Z,31,0,-1,-1,-1,100);
    SCM(playerid,lightgreen,"You have sold your house and got 50 percent back");
    PlayerData[playerid][HasHouse] = 0;
    PlayerData[playerid][HouseID] = 0;
    return 1;
}