sdsd

CMD:deletehouse(playerid,params[])
{
	if(IsPlayerFondator(playerid))
	{
		new id,string[256];
		if(sscanf(params,"i",id)) return SCM(playerid,COLOR_GREEN,"/deletehouse [HouseID]");

		mysql_format(SQL, string,sizeof(string), "DELETE FROM `houses` WHERE `ID`='%i'",id);
		mysql_tquery(SQL, string, "", "");

		HouseInfo[id][hID]	= INVALID_HOUSE_ID;
   	    HouseInfo[id][hEntrancex]	= 0;
    	HouseInfo[id][hEntrancey]	= 0;
        HouseInfo[id][hEntrancez]	= 0;
		HouseInfo[id][hInterior]	= 0;
		HouseInfo[id][hExitx]	= 0;
        HouseInfo[id][hExity]	= 0;
        HouseInfo[id][hExitz]	= 0;
		format(HouseInfo[id][hOwner],0,"");
		format(HouseInfo[id][hDiscription],0,"");
        HouseInfo[id][hValue]	= 0;
        HouseInfo[id][hHel] 	= 0;
        HouseInfo[id][hArm]		= 0;
        HouseInfo[id][hLock] 	= 0;
        HouseInfo[id][hOwned]	= 0;
        HouseInfo[id][hRent]	= 0;
        HouseInfo[id][hRentabil]= 0;
        HouseInfo[id][hTakings]	= 0;
        HouseInfo[id][hLevel]	= 0;
        HouseInfo[id][hVirtual]	= 0;

		housess--;

		DestroyDynamic3DTextLabel(HouseLabel[id]);
		DestroyDynamicPickup(HousePickup[id]);

		format(string,sizeof(string),"Casa ID: %i a fost stearsa cu succes !",id); SCM(playerid,COLOR_GREEN,string);
		return 1;
	}
	return 0; // la cei care nu sunt fondatori, le va arata Unknow command, ca si cum nu ar exista :))
}

stock IsValidHouse(houseid)
{
	if(houseid == INVALID_HOUSE_ID) return 1;
	return 0;
}
CMD:findhouse(playerid, params[])
{
	if(IsPlayerConnected(playerid))
	{
	    new houseID;
		if(sscanf(params, "d", houseID)) return SCM(playerid,COLOR_WHITE,"{FFFFFF}Syntax: {FFFFFF}/findhouse <House ID>");
  		if(IsValidHouse(houseID)) return SCM(playerid,COLOR_WHITE,"Invalid houseID");
		new i = sizeof(HouseInfo) - 1;
		if(houseID > i || houseID < 0) return SendClientMessage(playerid, COLOR_GREY, "Invalid House ID.");
		if(houseID >= 101) return SendClientMessage(playerid, COLOR_GREY, "Invalid House ID.");
		if(houseID == 0) return SendClientMessage(playerid, COLOR_GREY, "Invalid House ID.");
		if(BusinessRob[playerid] > 0) return SendClientMessage(playerid,COLOR_WHITE,"You can't use this while robbing the bank.");
        if(CP[playerid] < 1 && IsCollectingRubbish[playerid] < 1 && !IsATruck(GetPlayerVehicleID(playerid)) && MechanicCallTime[playerid] < 1 && CheckBus[playerid] < 1 && GotoMats[playerid] < 1 && CarJacker[playerid] < 1)
		{
			SetPlayerCheckpoint(playerid, HouseInfo[houseID][hEntrancex], HouseInfo[houseID][hEntrancey], HouseInfo[houseID][hEntrancez], 4.0);
			CP[playerid] = 43;
			SCM(playerid,COLOR_LIGHTBLUE,"I have placed a checkpoint at that location. Please follow it.");
        }
        else
        {
            ShowPlayerDialog(playerid, DIALOG_JOBULETES, DIALOG_STYLE_MSGBOX, "Anulare Checkpoint", "Esti sigur ca vrei sa anulezi checkpoint-ul curent?", "Da", "Nu");
		}
	}
	return 1;
}

CMD:gotohouse(playerid,params[])
{
	if(PinLogged[playerid] == 0)return SCM(playerid, COLOR_LIGHTRED,"Trebuie sa  introduci pin-ul mai intai.(/pin)");
    if(IsPlayerConnected(playerid))
	{
	    if(PlayerInfo[playerid][pAdmin] >= 5)
	    {
			new housenum,string[128],name[30];
			if(sscanf(params, "d",housenum)) return SendClientMessage(playerid, COLOR_WHITE, "{FFFFFF}Syntax: {FFFFFF}/house <House ID>");
			if(IsValidHouse(housenum)) return SCM(playerid,COLOR_WHITE,"Invalid houseID");
			GetPlayerName(playerid, name, sizeof(name));
			format(string,sizeof(string),"%s used /gotohouse %d.",name,housenum);
			ABroadCast(COLOR_ADMCOMMANDS,string,1);
			SetPlayerInterior(playerid,HouseInfo[housenum][hInterior]);
			SetPlayerPosEx(playerid,HouseInfo[housenum][hExitx],HouseInfo[housenum][hExity],HouseInfo[housenum][hExitz]);
			PlayerInfo[playerid][pInt] = HouseInfo[housenum][hInterior];
			PlayerInfo[playerid][pLocal] = housenum;
			InHouse[playerid] = housenum;
			SetPlayerVirtualWorld(playerid,HouseInfo[housenum][hVirtual]);
			if(strlen(housestring[InHouse[playerid]]) > 0)
			{
   				StopAudioStreamForPlayer(playerid);
				PlayAudioStreamForPlayer(playerid, housestring[InHouse[playerid]]);
			}
		}
		else return SCM(playerid,COLOR_ERROR, AdminOnly);
	}
	return 1;
}
CMD:houseo(playerid,params[])
{
	if(PinLogged[playerid] == 0)return SCM(playerid, COLOR_LIGHTRED,"Trebuie sa  introduci pin-ul mai intai.(/pin)");
    if(IsPlayerConnected(playerid))
	{
	    if(PlayerInfo[playerid][pAdmin] >= 5)
	    {
			new housenum;
			if(sscanf(params, "d",housenum)) return SendClientMessage(playerid, COLOR_WHITE, "{FFFFFF}Syntax: {FFFFFF}/houseo <House ID>");
			if(IsValidHouse(housenum)) return SCM(playerid,COLOR_WHITE,"Invalid houseID");
			SetPlayerPosEx(playerid,HouseInfo[housenum][hEntrancex],HouseInfo[housenum][hEntrancey],HouseInfo[housenum][hEntrancez]);
		}
		else return SCM(playerid,COLOR_ERROR, AdminOnly);
	}
	return 1;
}
CMD:houseo(playerid,params[])
{
	if(PinLogged[playerid] == 0)return SCM(playerid, COLOR_LIGHTRED,"Trebuie sa  introduci pin-ul mai intai.(/pin)");
    if(IsPlayerConnected(playerid))
	{
	    if(PlayerInfo[playerid][pAdmin] >= 5)
	    {
			new housenum;
			if(sscanf(params, "d",housenum)) return SendClientMessage(playerid, COLOR_WHITE, "{FFFFFF}Syntax: {FFFFFF}/houseo <House ID>");
			if(IsValidHouse(housenum)) return SCM(playerid,COLOR_WHITE,"Invalid houseID");
			SetPlayerPosEx(playerid,HouseInfo[housenum][hEntrancex],HouseInfo[housenum][hEntrancey],HouseInfo[housenum][hEntrancez]);
		}
		else return SCM(playerid,COLOR_ERROR, AdminOnly);
	}
	return 1;
}