jDynamicHouse

/*
                      Commands:
                      /createh [ create house [
                      /creatah [ create advanced house ]
                      /buyh [ buy house ]
                      /sellh [ sell house ]
                      /lockh [ lock house for no one enter it ]
                      /unlockh [ un lock house for enter it ]
                      /enterh [ enter house ]
                      /exith [ exit from house ]
_________________________¶¶¶¶¶
_______________________¶¶¶¶¶11¶¶
_____________________¶¶¶¶111111¶¶
___________________¶¶¶111111111¶¶¶¶
__________________¶¶¶11111111111¶¶¶¶¶¶
_________________¶¶111111111111111111¶¶¶
________________¶¶1111111111111111111111¶
_______________¶¶1111111111111111111111¶¶
_____________¶¶¶111111111111111111111¶¶¶
__________¶¶¶¶¶1111111111111111111111¶¶¶
_________¶¶¶111111111111111111111111111¶¶¶
_______¶¶¶1111111111111111111111111111111¶¶¶
______¶¶11111111111111111111111111111111111¶¶
_____¶¶1111111111111111111111111111111111111¶¶
____¶¶111111111111111111111111111111111111111¶¶
___¶¶11111111111111111111111111111111111111111¶¶
__¶¶1111111111111111111111111¶11111111111111111¶¶
__¶¶¶111111111111111111111¶¶¶¶11111111111111111¶¶
_¶¶¶¶¶¶¶¶1111111111111¶¶¶¶¶¶¶¶¶11111111111111111¶¶
_¶¶¶¶¶¶¶¶¶¶¶¶111111¶¶¶¶¶¶¶¶¶¶¶¶¶1111111111111111¶¶
¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶111111111111111111111¶
¶¶1111¶________¶¶¶_________¶111111111111111111111¶
¶¶111¶_____¶¶¶_¶¶____¶¶_____¶11111111111111111111¶
¶¶111¶_____¶¶¶_¶¶___¶¶¶¶____¶11111111111111111111¶
¶¶1111¶______¶¶¶¶____¶¶____¶111111111111111111111¶
_¶1111¶¶___¶¶¶___¶¶_______¶¶11111111111111111111¶¶
_¶¶11111¶¶¶¶_______¶¶¶¶¶¶¶1111111111111111111111¶¶
__¶1111¶¶¶___________¶¶¶11111111111111111111111¶¶
__¶¶1¶¶¶_______________¶¶¶¶¶¶¶¶¶¶¶1111111111111¶¶
___¶¶¶¶___$$$$$$$$$$$$$¶¶_____¶¶¶¶¶¶¶111111111¶¶
____¶¶1¶¶$$$$$$$$_____¶¶____________¶¶¶111111¶¶
_____¶¶11¶¶_________¶¶¶_______________¶¶¶111¶¶
______¶¶11¶¶¶______¶¶___________________¶11¶¶
_______¶¶1¶__¶¶¶__¶¶____________________¶¶¶¶
_________¶¶¶____¶¶_____________________¶¶¶
___________¶¶¶_______________________¶¶¶
____________¶¶¶¶_________________¶¶¶¶
________________¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶¶
*/


#include a_samp
#include a_mysql
#include streamer
#include zcmd
#define MAX_HOUSES              2000
//==========================Data Enums==========================================
enum h_info
{
    Houseid,
    Owner[128],
    Owned,
    Locked,
    Interior,
    World,
    Price,
    SPrice,
    Float:HX,
    Float:HY,
    Float:HZ,
    Float:IX,
    Float:IY,
    Float:IZ,
};
enum I_nfo
{
   hID,
   hOwned,
};
//=====================================House News===============================
new PlayerInfo[MAX_PLAYERS][I_nfo],
    HouseInfo[MAX_HOUSES][h_info],
    Text3D:hTextInfo[MAX_HOUSES],
    Text:housetext[MAX_PLAYERS],
    housemapicon[MAX_HOUSES],
    HousePickup[MAX_HOUSES],
    Float:posx[MAX_PLAYERS],
    Float:posy[MAX_PLAYERS],
    Float:posz[MAX_PLAYERS],
    pinterior[MAX_PLAYERS],
    teleporth[MAX_PLAYERS],
    inhouse[MAX_PLAYERS],
    htimer[MAX_PLAYERS],
    Menu:housemain,
    Menu:playerhm,
    Menu:adminhm,
    myhouseid,
    removeh,
    mysql
    ;
//----------====================Forwards================------------------------
forward   housedis(playerid);
forward   LoadHouses();
forward   Teleporth(playerid);
//================================Publics=======================================
public OnFilterScriptInit() {
  mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
  mysql = mysql_connect("HOST", "USERNAME", "DATABASE", "PASSWORD");
  if(mysql_errno(mysql) != 0)
  {
   print("Could not connect to database!");
  }
  else
 {
  print("  Successfully connected on DB ");
  new Query[300];
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS houses(ID INT(128), HX VARCHAR(128), HY VARCHAR(128), HZ VARCHAR(128), IX VARCHAR(128)\
  , IY VARCHAR(128), IZ VARCHAR(128), Price INT(128), SPrice INT(128), Interior INT(10), World INT(128), Locked INT(10), Owned INT(128), Owner VARCHAR(128) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query,sizeof(Query),"CREATE TABLE IF NOT EXISTS accounts(Name VARCHAR(128), hID INT(128), HOwned INT(10) )");
  mysql_tquery(mysql, Query, "", "");
  format(Query, sizeof(Query), "SELECT * FROM houses");
  mysql_tquery(mysql, Query, "LoadHouses", "");
 }
  housemain = CreateMenu("tAxI-XVM",1,440,140,150,40);
  AddMenuItem(housemain,0,"Player House Menu");
  AddMenuItem(housemain,0,"Admin House Menu");
  AddMenuItem(housemain,0,"<exit>");

  playerhm = CreateMenu("tAxI-XVM",1,440,140,150,40);
  AddMenuItem(playerhm,0,"Goto House");
  AddMenuItem(playerhm,0,"Buy House");
  AddMenuItem(playerhm,0,"Sell House");
  AddMenuItem(playerhm,0,"Enter House");
  AddMenuItem(playerhm,0,"Exit House");
  AddMenuItem(playerhm,0,"Lock House");
  AddMenuItem(playerhm,0,"UnLock House");
  AddMenuItem(playerhm,0,"<back>");

  adminhm = CreateMenu("tAxI-XVM",1,440,140,150,40);
  AddMenuItem(adminhm,0,"Sell House");
  AddMenuItem(adminhm,0,"Reset All Houses");
  AddMenuItem(adminhm,0,"Create a Small House");
  AddMenuItem(adminhm,0,"Create a Medium House");
  AddMenuItem(adminhm,0,"Create a Modern House");
  AddMenuItem(adminhm,0,"Create a Mansion House");
  AddMenuItem(adminhm,0,"<back>");
}
public OnFilterScriptExit() {
    DestroyAllDynamicPickups();
    DestroyAllDynamicMapIcons();
    DestroyAllDynamic3DTextLabels();
    mysql_close(mysql);
}
//==============================Load Houses=====================================
public LoadHouses() {
  new rows, fields;
  cache_get_data(rows, fields, mysql);
  if(rows)
  {
    removeh = cache_get_row_count()-1; myhouseid = cache_get_row_count();
    for(new i = 0; i < cache_get_row_count(); i++) {
      HouseInfo[i][Houseid] = cache_get_row_int(i, 0); new save[128]; cache_get_row(i, 13, save);
      HouseInfo[HouseInfo[i][Houseid]][Owner] = save;
      HouseInfo[HouseInfo[i][Houseid]][HX] = cache_get_row_float(i, 1); HouseInfo[HouseInfo[i][Houseid]][HY] = cache_get_row_float(i, 2);
      HouseInfo[HouseInfo[i][Houseid]][HZ] = cache_get_row_float(i, 3);  HouseInfo[HouseInfo[i][Houseid]][Owned] = cache_get_row_int(i, 12);
      HouseInfo[HouseInfo[i][Houseid]][Locked] = cache_get_row_int(i, 11); HouseInfo[HouseInfo[i][Houseid]][Price] = cache_get_row_int(i, 7);
      HouseInfo[HouseInfo[i][Houseid]][SPrice] = cache_get_row_int(i, 8); HouseInfo[HouseInfo[i][Houseid]][Interior] = cache_get_row_int(i, 9);
      HouseInfo[HouseInfo[i][Houseid]][World] = cache_get_row_int(i, 10); HouseInfo[HouseInfo[i][Houseid]][IX] = cache_get_row_float(i, 4);
      HouseInfo[HouseInfo[i][Houseid]][IY] = cache_get_row_float(i, 5); HouseInfo[HouseInfo[i][Houseid]][IZ] = cache_get_row_float(i, 6);
      if(HouseInfo[HouseInfo[i][Houseid]][Owned] == 0) {
        HousePickup[HouseInfo[i][Houseid]] = CreateDynamicPickup(1273, 23, HouseInfo[HouseInfo[i][Houseid]][HX], HouseInfo[HouseInfo[i][Houseid]][HY], HouseInfo[HouseInfo[i][Houseid]][HZ]);
        housemapicon[HouseInfo[i][Houseid]] = CreateDynamicMapIcon(HouseInfo[HouseInfo[i][Houseid]][HX], HouseInfo[HouseInfo[i][Houseid]][HY], HouseInfo[HouseInfo[i][Houseid]][HZ],31,0xFFFF00AA);
        hTextInfo[HouseInfo[i][Houseid]] = CreateDynamic3DTextLabel("Not Owned", 0x00FF00FF, HouseInfo[HouseInfo[i][Houseid]][HX], HouseInfo[HouseInfo[i][Houseid]][HY], HouseInfo[HouseInfo[i][Houseid]][HZ]+0.75, 40, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD);
      } else if(HouseInfo[HouseInfo[i][Houseid]][Owned] == 1) {
        new string[MAX_PLAYER_NAME+1];
        format(string,sizeof string,"%s",HouseInfo[HouseInfo[i][Houseid]][Owner]);
        hTextInfo[HouseInfo[i][Houseid]] = CreateDynamic3DTextLabel(string, 0xFF0000FF, HouseInfo[HouseInfo[i][Houseid]][HX], HouseInfo[HouseInfo[i][Houseid]][HY], HouseInfo[HouseInfo[i][Houseid]][HZ]+0.75, 40, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD);
        HousePickup[HouseInfo[HouseInfo[i][Houseid]][Houseid]] = CreateDynamicPickup(1272, 23, HouseInfo[HouseInfo[i][Houseid]][HX], HouseInfo[HouseInfo[i][Houseid]][HY], HouseInfo[HouseInfo[i][Houseid]][HZ]);
        housemapicon[HouseInfo[HouseInfo[i][Houseid]][Houseid]] = CreateDynamicMapIcon(HouseInfo[HouseInfo[i][Houseid]][HX], HouseInfo[HouseInfo[i][Houseid]][HY], HouseInfo[HouseInfo[i][Houseid]][HZ],32,0xFFFF00AA);
        }
     }
   }
  if(!rows) {
    myhouseid = 0;
    print("  No House Loaded On Database");
    }
  printf("  %d House has been Successfully Loaded and Created",myhouseid);
  return 1;
}
//===============================Publics Complete=============================//
public OnPlayerConnect(playerid) {
       new Query[200];
       format(Query, sizeof(Query), "SELECT * FROM accounts WHERE `Name` = '%s'",pName(playerid));
       mysql_tquery(mysql, Query, "LoadAccount", "i",playerid);
}
forward LoadAccount(playerid);
public LoadAccount(playerid) {
   new rows, fields;
   cache_get_data(rows, fields, mysql);
   if(rows) {
     PlayerInfo[playerid][hID] = cache_get_field_content_int(0, "hID");
     PlayerInfo[playerid][hOwned] = cache_get_field_content_int(0, "HOwned");
     }
   if(!rows) {
     new Query[128];
     format(Query, sizeof(Query),"INSERT INTO `accounts` (Name,hID,HOwned) VALUES ('%s','%d','%d')",pName(playerid),0,0);
     mysql_tquery(mysql, Query, "", "");
   }
}
public OnPlayerSelectedMenuRow(playerid, row)
{
  new Menu:Current = GetPlayerMenu(playerid);
  if(Current == housemain) {
      switch(row){
          case 0:ShowMenuForPlayer(playerhm, playerid);
          case 1:{ if(IsPlayerAdmin(playerid)) { ShowMenuForPlayer(adminhm, playerid); } else return SendClientMessage(playerid, 0xDC143CAA, "You need to be level four to to access");}
          case 2:{HideMenuForPlayer(Current, playerid);TogglePlayerControllable(playerid, true);}
        }
    } else if(Current == playerhm) {
      switch(row){
          case 0:{HideMenuForPlayer(Current, playerid);cmd_gotoh(playerid,"\1");TogglePlayerControllable(playerid, true);}
          case 1:{HideMenuForPlayer(Current, playerid);cmd_buyh(playerid,"\1");TogglePlayerControllable(playerid, true);}
          case 2:{HideMenuForPlayer(Current, playerid);cmd_sellh(playerid,"\1");TogglePlayerControllable(playerid, true);}
      case 3:{HideMenuForPlayer(Current, playerid);cmd_enterh(playerid,"\1");TogglePlayerControllable(playerid, true);}
      case 4:{HideMenuForPlayer(Current, playerid);cmd_exith(playerid,"\1");TogglePlayerControllable(playerid, true);}
      case 5:{HideMenuForPlayer(Current, playerid);cmd_lockh(playerid,"\1");TogglePlayerControllable(playerid, true);}
      case 6:{HideMenuForPlayer(Current, playerid);cmd_unlockh(playerid,"\1");TogglePlayerControllable(playerid, true);}
      case 10:ShowMenuForPlayer(housemain, playerid);
    }
    } else if(Current == adminhm) {
      switch(row){
      case 0:{HideMenuForPlayer(Current, playerid);cmd_asellh(playerid,"\1");TogglePlayerControllable(playerid, true);}
      case 1:{
        HideMenuForPlayer(Current, playerid);
        TogglePlayerControllable(playerid, true);
        if(IsPlayerAdmin(playerid)) {
          cmd_aresetallhs(playerid,"");
        }
        else{ SendClientMessage(playerid, 0xDC143CAA, "You are not a rcon admin and cannot use this feature!"); }
      }
      case 2:{HideMenuForPlayer(Current, playerid);cmd_createh(playerid,"50000 50000 1");TogglePlayerControllable(playerid, true);}
      case 3:{HideMenuForPlayer(Current, playerid);cmd_createh(playerid,"100000 100000 3");TogglePlayerControllable(playerid, true);}
      case 4:{HideMenuForPlayer(Current, playerid);cmd_createh(playerid,"200000 200000 5");TogglePlayerControllable(playerid, true);}
      case 5:{HideMenuForPlayer(Current, playerid);cmd_createh(playerid,"500000 500000 7");TogglePlayerControllable(playerid, true);}
      case 6:ShowMenuForPlayer(housemain, playerid);
    }
  }
  return 1;
}
public OnPlayerPickUpDynamicPickup(playerid, pickupid) {
  for(new i = 0; i < MAX_HOUSES; i++) {
    if(pickupid == HousePickup[HouseInfo[i][Houseid]]) {
      Housestatus(playerid,HouseInfo[i][Houseid]);
    }
  }
}
public housedis(playerid)
{
 TextDrawDestroy(housetext[playerid]);
 SetPVarInt(playerid, "nohtext", 0);
 return 1;
}
public Teleporth(playerid) {
  if(teleporth[playerid] == 0) {
  KillTimer(htimer[playerid]);
  GameTextForPlayer(playerid,"~g~Welcome Home!",2000,3);
  if(IsPlayerInAnyVehicle(playerid) == 1) {
  SetVehiclePos(GetPlayerVehicleID(playerid),HouseInfo[PlayerInfo[playerid][hID]][HX], HouseInfo[PlayerInfo[playerid][hID]][HY], HouseInfo[PlayerInfo[playerid][hID]][HZ]);
  } else {
  SetPlayerPos(playerid, HouseInfo[PlayerInfo[playerid][hID]][HX], HouseInfo[PlayerInfo[playerid][hID]][HY], HouseInfo[PlayerInfo[playerid][hID]][HZ]);
  teleporth[playerid] = 5;}
  } else if(teleporth[playerid] > 0) {
    new text[50]; format(text,sizeof text,"%d",teleporth[playerid]);
    GameTextForPlayer(playerid,text,1000,3);
    teleporth[playerid] --;
    }
}
public OnPlayerSpawn(playerid) {
    if(PlayerInfo[playerid][hOwned] == 1) {
    SetPlayerPos(playerid\
    ,HouseInfo[PlayerInfo[playerid][hID]][HX]\
    ,HouseInfo[PlayerInfo[playerid][hID]][HY]\
    ,HouseInfo[PlayerInfo[playerid][hID]][HZ]);
  }
}

//=============================Fuctions=========================================
PlayerToPoint(Float:radi, playerid, Float:x, Float:y, Float:z)
{
  if(IsPlayerConnected(playerid))
  {
    new Float:oldposx, Float:oldposy, Float:oldposz;
    new Float:tempposx, Float:tempposy, Float:tempposz;
    GetPlayerPos(playerid, oldposx, oldposy, oldposz);
    tempposx = (oldposx -x);
    tempposy = (oldposy -y);
    tempposz = (oldposz -z);
    if (((tempposx < radi) && (tempposx > -radi)) && ((tempposy < radi) && (tempposy > -radi)) && ((tempposz < radi) && (tempposz > -radi)))
    {
      return 1;
    }
  }
  return 0;
}
GetHouseID(playerid)
{
  for(new i=0; i<MAX_HOUSES; i++)
  {
      if(PlayerToPoint(1.5, playerid, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]))
      {
          return i;
    }
  }
  return -255;
}
pName(playerid) {
  new pname[MAX_PLAYER_NAME];
  GetPlayerName(playerid, pname, sizeof(pname));
  return pname;
}
sscanf(string[], format[], {Float,_}:...)
{
    #if defined isnull
        if (isnull(string))
    #else
        if (string[0] == 0 || (string[0] == 1 && string[1] == 0))
    #endif
        {
            return format[0];
        }
    #pragma tabsize 4
    new
        formatPos = 0,
        stringPos = 0,
        paramPos = 2,
        paramCount = numargs(),
        delim = ' ';
    while (string[stringPos] && string[stringPos] <= ' ')
    {
        stringPos++;
    }
    while (paramPos < paramCount && string[stringPos])
    {
        switch (format[formatPos++])
        {
            case '\0':
            {
                return 0;
            }
            case 'i', 'd':
            {
                new
                    neg = 1,
                    num = 0,
                    ch = string[stringPos];
                if (ch == '-')
                {
                    neg = -1;
                    ch = string[++stringPos];
                }
                do
                {
                    stringPos++;
                    if ('0' <= ch <= '9')
                    {
                        num = (num * 10) + (ch - '0');
                    }
                    else
                    {
                        return -1;
                    }
                }
                while ((ch = string[stringPos]) > ' ' && ch != delim);
                setarg(paramPos, 0, num * neg);
            }
            case 'h', 'x':
            {
                new
                    num = 0,
                    ch = string[stringPos];
                do
                {
                    stringPos++;
                    switch (ch)
                    {
                        case 'x', 'X':
                        {
                            num = 0;
                            continue;
                        }
                        case '0' .. '9':
                        {
                            num = (num << 4) | (ch - '0');
                        }
                        case 'a' .. 'f':
                        {
                            num = (num << 4) | (ch - ('a' - 10));
                        }
                        case 'A' .. 'F':
                        {
                            num = (num << 4) | (ch - ('A' - 10));
                        }
                        default:
                        {
                            return -1;
                        }
                    }
                }
                while ((ch = string[stringPos]) > ' ' && ch != delim);
                setarg(paramPos, 0, num);
            }
            case 'c':
            {
                setarg(paramPos, 0, string[stringPos++]);
            }
            case 'f':
            {

                new changestr[16], changepos = 0, strpos = stringPos;
                while(changepos < 16 && string[strpos] && string[strpos] != delim)
                {
                    changestr[changepos++] = string[strpos++];
                    }
                changestr[changepos] = '\0';
                setarg(paramPos,0,_:floatstr(changestr));
            }
            case 'p':
            {
                delim = format[formatPos++];
                continue;
            }
            case '\'':
            {
                new
                    end = formatPos - 1,
                    ch;
                while ((ch = format[++end]) && ch != '\'') {}
                if (!ch)
                {
                    return -1;
                }
                format[end] = '\0';
                if ((ch = strfind(string, format[formatPos], false, stringPos)) == -1)
                {
                    if (format[end + 1])
                    {
                        return -1;
                    }
                    return 0;
                }
                format[end] = '\'';
                stringPos = ch + (end - formatPos);
                formatPos = end + 1;
            }
            case 'u':
            {
                new
                    end = stringPos - 1,
                    id = 0,
                    bool:num = true,
                    ch;
                while ((ch = string[++end]) && ch != delim)
                {
                    if (num)
                    {
                        if ('0' <= ch <= '9')
                        {
                            id = (id * 10) + (ch - '0');
                        }
                        else
                        {
                            num = false;
                        }
                    }
                }
                if (num && IsPlayerConnected(id))
                {
                    setarg(paramPos, 0, id);
                }
                else
                {
                    #if !defined foreach
                        #define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2))
                        #define __SSCANF_FOREACH__
                    #endif
                    string[end] = '\0';
                    num = false;
                    new
                        ssname[MAX_PLAYER_NAME];
                    id = end - stringPos;
                    foreach (Player, playerid)
                    {
                        GetPlayerName(playerid, ssname, sizeof (ssname));
                        if (!strcmp(ssname, string[stringPos], true, id))
                        {
                            setarg(paramPos, 0, playerid);
                            num = true;
                            break;
                        }
                    }
                    if (!num)
                    {
                        setarg(paramPos, 0, INVALID_PLAYER_ID);
                    }
                    string[end] = ch;
                    #if defined __SSCANF_FOREACH__
                        #undef foreach
                        #undef __SSCANF_FOREACH__
                    #endif
                }
                stringPos = end;
            }
            case 's', 'z':
            {
                new
                    i = 0,
                    ch;
                if (format[formatPos])
                {
                    while ((ch = string[stringPos++]) && ch != delim)
                    {
                        setarg(paramPos, i++, ch);
                    }
                    if (!i)
                    {
                        return -1;
                    }
                }
                else
                {
                    while ((ch = string[stringPos++]))
                    {
                        setarg(paramPos, i++, ch);
                    }
                }
                stringPos--;
                setarg(paramPos, i, '\0');
            }
            default:
            {
                continue;
            }
        }
        while (string[stringPos] && string[stringPos] != delim && string[stringPos] > ' ')
        {
            stringPos++;
        }
        while (string[stringPos] && (string[stringPos] == delim || string[stringPos] <= ' '))
        {
            stringPos++;
        }
        paramPos++;
    }
    do
    {
        if ((delim = format[formatPos++]) > ' ')
        {
            if (delim == '\'')
            {
                while ((delim = format[formatPos++]) && delim != '\'') {}
            }
            else if (delim != 'z')
            {
                return delim;
            }
        }
    }
    while (delim > ' ');
    return 0;
}
Housestatus(playerid,Houseid1) {
    new howner[128],str2[128];
    if(strcmp(HouseInfo[Houseid1][Owner],"NULL",true)==0)
    {
      format(howner,128,"Not Owned");
    } else {
      format(howner,128,"%s",HouseInfo[Houseid1][Owner]);
      if(strcmp(HouseInfo[Houseid1][Owner],pName(playerid),true)==0)
       {
       SetPlayerHealth(playerid,100);
       SetPlayerArmour(playerid,100);
       }
    }
    if(GetPVarInt(playerid, "nohtext") == 1) return 0;
    else if(GetPVarInt(playerid, "nohtext") == 0) {
      format(str2, sizeof(str2), "~n~ Owner: %s ~n~~n~ Price: $%i~n~~n~~n~",howner,HouseInfo[Houseid1][Price]);
      housetext[playerid] = TextDrawCreate(215.200012, 300, "House");
      TextDrawSetString(housetext[playerid], str2);
      TextDrawUseBox(housetext[playerid], 1);
      TextDrawTextSize(housetext[playerid], 400, 2000);
      TextDrawBoxColor(housetext[playerid], 0x171717AA);
      TextDrawLetterSize(housetext[playerid], 0.449999, 1.600000);
      TextDrawFont(housetext[playerid], 1);
      TextDrawColor(housetext[playerid], 0x00FF00FF);
      TextDrawShowForPlayer(playerid, housetext[playerid]);
      SetPVarInt(playerid,"nohtext",1);
      SetTimerEx("housedis", 2500, false, "i", playerid);
      }
    return 1;
}
//====================================Commands==================================
CMD:hmenu(playerid,params[]) {
    TogglePlayerControllable(playerid, false);
    ShowMenuForPlayer(housemain, playerid);
    return 1;
}
CMD:buyh(playerid,params[]) {
  new i; i = GetHouseID(playerid);
  if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to bought it");
  if(GetPlayerMoney(playerid) - HouseInfo[i][Price] >= 0) {
    if(PlayerInfo[playerid][hOwned] == 0) {
      if(HouseInfo[i][Owned] == 0) {
        new Query[250];
        format(Query, sizeof(Query), "UPDATE `houses` SET `Owner` = '%s',`Owned` = '%d' WHERE `ID` = '%d'", pName(playerid),1,HouseInfo[i][Houseid]);
        mysql_tquery(mysql, Query, "", "");
        format(Query, sizeof(Query),"UPDATE `accounts` SET `hID` = %d,`HOwned` = 1 WHERE `Name` = '%s'",HouseInfo[i][Houseid],pName(playerid));
        mysql_tquery(mysql, Query, "", "");
        DestroyDynamicPickup(HousePickup[HouseInfo[i][Houseid]]);
        HousePickup[HouseInfo[i][Houseid]] = CreateDynamicPickup(1272, 23, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]);
        UpdateDynamic3DTextLabelText(hTextInfo[HouseInfo[i][Houseid]],0xFF0000FF,pName(playerid));
        DestroyDynamicMapIcon(housemapicon[HouseInfo[i][Houseid]]);
        housemapicon[HouseInfo[i][Houseid]] = CreateDynamicMapIcon(HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ],32,0xFFFF00AA);
        strmid(HouseInfo[i][Owner], pName(playerid), 0, strlen(pName(playerid)), 255); HouseInfo[i][Owned] = 1;
        GivePlayerMoney(playerid,-HouseInfo[i][Price]); PlayerInfo[playerid][hOwned] = 1; PlayerInfo[playerid][hID] = HouseInfo[i][Houseid];
        new string[70];
        format(string,sizeof string,"You've Successfully Buyed This house [ ID: %d ]",i);
        SendClientMessage(playerid, 0x33AA33AA, string);
        } else return SendClientMessage(playerid, 0xDC143CAA,"ERROR: This House is already owned");
       } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You can only own one house");
      } else return SendClientMessage(playerid, 0xDC143CAA,"ERROR: You Don't have enough cash to buy this house");
  return 1;
}

CMD:createh(playerid,params[]) {
  if(IsPlayerAdmin(playerid)) {
    new price,sprice,interior;
    if(sscanf(params, "ddd", price,sprice,interior)) return SendClientMessage(playerid,0xDC143CAA,"Usage /createh [Buy Price] [Sell Price] [Interior]");
    if(interior > 7 || interior < 1) return SendClientMessage(playerid,0xDC143CAA,"ERROR: Interior ID just can be between 1 and 7");
    new Query[250],string[128],Float:X,Float:Y,Float:Z; GetPlayerPos(playerid, X, Y, Z);
    format(Query, sizeof(Query),"INSERT INTO `houses`(`ID`,`HX`,`HY`,`HZ`,`Price`,`SPrice`,`Interior`,`World`,`Locked`,`Owned`,`Owner`) VALUES \
    ('%d','%f','%f','%f','%d','%d','%d','%d','%d','%d','%s')",myhouseid,X,Y,Z,price,sprice,interior,GetPlayerVirtualWorld(playerid),0,0,"NULL");
    mysql_tquery(mysql, Query, "", "");
    format(string,sizeof string,"You've Successfully Created This house [ ID:%d ]",myhouseid);
    SendClientMessage(playerid, 0x33AA33AA, string);
    HouseInfo[myhouseid][Houseid] = myhouseid; HouseInfo[myhouseid][Owned] = 0; strmid(HouseInfo[myhouseid][Owner], "NULL", 0, strlen("NULL"), 255);
    HouseInfo[myhouseid][Locked] = 0; HouseInfo[myhouseid][Interior] = interior; HouseInfo[myhouseid][World] = GetPlayerVirtualWorld(playerid);
    HouseInfo[myhouseid][Price] = price; HouseInfo[myhouseid][SPrice] = sprice; HouseInfo[myhouseid][HX] = X;
    HouseInfo[myhouseid][HY] = Y; HouseInfo[myhouseid][HZ] = Z;
    HousePickup[myhouseid] = CreateDynamicPickup(1273, 23, X, Y, Z);
    housemapicon[myhouseid] = CreateDynamicMapIcon(X, Y, Z,31,0xFFFF00AA);
    hTextInfo[myhouseid] = CreateDynamic3DTextLabel("Not Owned", 0x00FF00FF, X, Y, Z+0.75, 40, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD);
    myhouseid ++; removeh ++;
    } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be rcon to use this command");
  return 1;
}

CMD:createah(playerid,params[]) {
  if(IsPlayerAdmin(playerid)) {
    new price,sprice,Float:interiorx,Float:interiory,Float:interiorz,interior;
    if(sscanf(params, "ddfffd", price,sprice,interiorx,interiory,interiorz,interior)) return SendClientMessage(playerid,0xDC143CAA,"Usage /createh [Buy Price] [Sell Price] [Interior X] [Interior Y] [Interior Z] [Interior ID]");
    new Query[280],string[128],Float:X,Float:Y,Float:Z; GetPlayerPos(playerid, X, Y, Z);
    format(Query, sizeof(Query),"INSERT INTO `houses`(`ID`,`HX`,`HY`,`IX`,`IY`,`IZ`,`HZ`,`Price`,`SPrice`,`Interior`,`World`,`Locked`,`Owned`,`Owner`) VALUES \
    ('%d','%f','%f','%f','%f','%f','%f','%d','%d','%d','%d','%d','%d','%s')",myhouseid,X,Y,Z,interiorx,interiory,interiorz,price,sprice,interior,GetPlayerVirtualWorld(playerid),0,0,"NULL");
    mysql_tquery(mysql, Query, "", "");
    printf("%s",Query);
    format(string,sizeof string,"You've Successfully Created This house [ ID:%d ]",myhouseid);
    SendClientMessage(playerid, 0x33AA33AA, string);
    HouseInfo[myhouseid][Houseid] = myhouseid; HouseInfo[myhouseid][Owned] = 0; strmid(HouseInfo[myhouseid][Owner], "NULL", 0, strlen("NULL"), 255);
    HouseInfo[myhouseid][Locked] = 0; HouseInfo[myhouseid][Interior] = interior; HouseInfo[myhouseid][World] = GetPlayerVirtualWorld(playerid);
    HouseInfo[myhouseid][Price] = price; HouseInfo[myhouseid][SPrice] = sprice; HouseInfo[myhouseid][HX] = X;
    HouseInfo[myhouseid][HY] = Y; HouseInfo[myhouseid][HZ] = Z; HouseInfo[myhouseid][IX] = interiorx;
    HouseInfo[myhouseid][IY] = interiory;  HouseInfo[myhouseid][IZ] = interiorz;
    HousePickup[myhouseid] = CreateDynamicPickup(1273, 23, X, Y, Z);
    housemapicon[myhouseid] = CreateDynamicMapIcon(X, Y, Z,31,0xFFFF00AA);
    hTextInfo[myhouseid] = CreateDynamic3DTextLabel("Not Owned", 0x00FF00FF, X, Y, Z+0.75, 40, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD);
    myhouseid ++; removeh ++;
    } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be rcon to use this command");
  return 1;
}

CMD:removeh(playerid,params[]) {
  if(IsPlayerAdmin(playerid)) {
    new i; i = GetHouseID(playerid);
    if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to remove it");
    new Query[128],string[128];
    format(Query, 128, "DELETE FROM `houses` WHERE `ID` = '%d'", i);
    mysql_tquery(mysql, Query, "", "");
    DestroyDynamicPickup(HousePickup[i]);
    DestroyDynamic3DTextLabel(hTextInfo[i]);
    DestroyDynamicMapIcon(housemapicon[i]);
    if(HouseInfo[i][Owned] == 1) {
    format(Query, sizeof(Query),"UPDATE `accounts` SET `hID` = 0,`HOwned` = 0 WHERE `Name` = '%s'",HouseInfo[i][Owner]);
    mysql_tquery(mysql, Query, "", "");}
    if(i < removeh) {
    DestroyDynamicPickup(HousePickup[removeh]);
    DestroyDynamicMapIcon(housemapicon[removeh]);
    DestroyDynamic3DTextLabel(hTextInfo[removeh]);
    format(Query, sizeof(Query),"UPDATE `houses` SET `ID` = %d WHERE `ID` = '%d'",i,removeh);
    mysql_tquery(mysql, Query, "", "");
    strmid(HouseInfo[i][Owner],HouseInfo[removeh][Owner], 0, strlen(pName(playerid)), 255);
    HouseInfo[removeh][Houseid] = i; HouseInfo[i][Locked]= HouseInfo[removeh][Locked];
    HouseInfo[i][Owned] = HouseInfo[removeh][Owned]; HouseInfo[i][Interior] = HouseInfo[removeh][Interior];
    HouseInfo[i][Price] = HouseInfo[removeh][Price]; HouseInfo[i][World] = HouseInfo[removeh][World];
    HouseInfo[i][SPrice] = HouseInfo[removeh][SPrice];HouseInfo[i][HX]= HouseInfo[removeh][HX];
    HouseInfo[i][HY] = HouseInfo[removeh][HY];  HouseInfo[i][HZ]= HouseInfo[removeh][HZ];
    HouseInfo[i][IX] = HouseInfo[removeh][IX]; HouseInfo[i][IY] = HouseInfo[removeh][IY];
    HouseInfo[i][IZ] = HouseInfo[removeh][IZ];
    if(HouseInfo[i][Owned] == 0) {
      HousePickup[i] = CreateDynamicPickup(1273, 23, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]);
      hTextInfo[i] = CreateDynamic3DTextLabel("Not Owned", 0x00FF00FF, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]+0.75, 40, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD);
      housemapicon[i] = CreateDynamicMapIcon(HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ],31,0xFFFF00AA);
    } if(HouseInfo[i][Owned] == 1) {
        HousePickup[i] = CreateDynamicPickup(1272, 23, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]);
        new oname[MAX_PLAYER_NAME+1]; format(oname,sizeof oname,"%s",HouseInfo[i][Owner]);
        hTextInfo[i] = CreateDynamic3DTextLabel(oname, 0xFF0000FF, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]+0.75, 40, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, STREAMER_3D_TEXT_LABEL_SD);
        housemapicon[i] = CreateDynamicMapIcon(HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ],32,0xFFFF00AA);
        }
    }
    if(HouseInfo[i][Owned] == 1) {
    format(Query, sizeof(Query),"UPDATE `accounts` SET `hID` = %d WHERE `Name` = '%s'",i,HouseInfo[i][Owner]);
    mysql_tquery(mysql, Query, "", "");}
    format(string,sizeof string,"You've Successfully Removed This house [ ID: %d ]",i);
    SendClientMessage(playerid, 0x33AA33AA, string);
    for(new i2 = 0; i2 < MAX_PLAYERS; i2++) {
      if(IsPlayerConnected(i2)) {
        if(strcmp(HouseInfo[i2][Owner],pName(i2),false )== 0) {
            PlayerInfo[i2][hOwned] = 0; PlayerInfo[i2][hID] = 0;
            format(string,sizeof string,"Administrator %s Has Fully Removed Your House",pName(playerid));
            SendClientMessage(i2,0x33AA33AA,string);
             }
         }
    }
    myhouseid --; removeh --;
   } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be rcon to use this command");
  return 1;
}
CMD:deleteallhouses(playerid,params[]) {
    if(IsPlayerAdmin(playerid)) {
    new Query[128];
    format(Query, 128, "DELETE FROM `houses`");
    mysql_tquery(mysql, Query, "", "");
    SendClientMessageToAll(0x33AA33AA,"All houses has been Successfully Removed");
    return SendRconCommand("gmx");
    } else return SendClientMessage(playerid,0xFF0000AA,"ERROR: You are not a high enough level to use this command");
}
CMD:asellh(playerid,params[]) {
  if(IsPlayerAdmin(playerid)) {
    new i;
    i = GetHouseID(playerid);
    if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to remove it");
    new Query[128],string[128];
    format(Query, sizeof(Query), "UPDATE `houses` SET `Owner` = '%d', `Owned` = '%d'  WHERE `ID` = '%d'",0,0,HouseInfo[i][Houseid]);
    mysql_tquery(mysql, Query, "", "");
    if(HouseInfo[i][Owned] == 1) {
    format(Query, sizeof(Query),"UPDATE `accounts` SET `hID` = 0,`HOwned` = 0 WHERE `Name` = '%s'",pName(playerid));
    mysql_tquery(mysql, Query, "", "");
    for(new i2 = 0; i2 < MAX_PLAYERS; i2++) {
       if(IsPlayerConnected(i2)) {
         if(strcmp(HouseInfo[i2][Owner],pName(i2),false )== 0) {
             PlayerInfo[i2][hOwned] = 0; PlayerInfo[i2][hID] = 0;
             format(string,sizeof string,"Administrator %s Has Reseted Your House",pName(playerid));
             SendClientMessage(i2,0x33AA33AA,string);
             }
         }
    }
    HouseInfo[i][Owned] = 0; strmid(HouseInfo[i][Owner],"NULL", 0, strlen(pName(playerid)), 255);
    }
    DestroyDynamicPickup(HousePickup[HouseInfo[i][Houseid]]);
    HousePickup[HouseInfo[i][Houseid]] = CreateDynamicPickup(1273, 23, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]);
    UpdateDynamic3DTextLabelText(hTextInfo[HouseInfo[i][Houseid]],0x00FF00FF,"Not Owned");
    DestroyDynamicMapIcon(housemapicon[HouseInfo[i][Houseid]]);
    housemapicon[HouseInfo[i][Houseid]] = CreateDynamicMapIcon(HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ],31,0xFFFF00AA);
    format(string,sizeof string,"You've Successfully Sold This house [ ID: %d ]",i);
    SendClientMessage(playerid, 0x33AA33AA, string);
   } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be rcon to use this command");
  return 1;
}
CMD:aresetallhs(playerid,params[]) {
  if(IsPlayerAdmin(playerid)) {
    new Query[128];
    format(Query, sizeof(Query), "UPDATE `houses` SET `Owner` = '%s', `Owned` = '%d'","NULL",0);
    mysql_tquery(mysql, Query, "", "");
    for(new i = 0; i < MAX_HOUSES; i++) {
    if(HouseInfo[i][Owned] == 1) {
    format(Query, sizeof(Query),"UPDATE `accounts` SET `hID` = 0,`HOwned` = 0");
    mysql_tquery(mysql, Query, "", "");}
    HouseInfo[i][Owned] = 0; strmid(HouseInfo[i][Owner],"NULL", 0, strlen(pName(playerid)), 255);
    if(IsValidDynamicPickup(HousePickup[HouseInfo[i][Houseid]])) {
    DestroyDynamicPickup(HousePickup[HouseInfo[i][Houseid]]);}
    if(IsValidDynamic3DTextLabel(hTextInfo[HouseInfo[i][Houseid]])) {
    DestroyDynamic3DTextLabel(hTextInfo[HouseInfo[i][Houseid]]);}
    if(IsValidDynamicMapIcon(housemapicon[HouseInfo[i][Houseid]])) {
    DestroyDynamicMapIcon(housemapicon[HouseInfo[i][Houseid]]);}
    strmid(HouseInfo[i][Owner], "NULL", 0, strlen(pName(playerid)), 255);  HouseInfo[i][Owned] = 0;
    }
    SendClientMessageToAll(0x33AA33AA,"All houses has been Successfully Rested");
    SendRconCommand("gmx");
   } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be rcon to use this command");
  return 1;
}
CMD:sellh(playerid,params[]) {
  new i; i = GetHouseID(playerid);
  if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to sell it");
  if(HouseInfo[i][Owned] == 1) {
    if(strcmp(HouseInfo[i][Owner],pName(playerid),false )== 0 || IsPlayerAdmin(playerid)) {
      new Query[128];
      format(Query, sizeof(Query),"UPDATE `houses` SET `Owned` = 0,`Owner` = %s WHERE `ID` = '%d'","NULL",HouseInfo[i][Houseid]);
      mysql_tquery(mysql, Query, "", "");
      format(Query, sizeof(Query),"UPDATE `accounts` SET `hID` = 0,`HOwner` = 0 WHERE `Name` = '%d'",pName(playerid));
      mysql_tquery(mysql, Query, "", "");
      DestroyDynamicPickup(HousePickup[HouseInfo[i][Houseid]]);
      HousePickup[HouseInfo[i][Houseid]] = CreateDynamicPickup(1273, 23, HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ]);
      UpdateDynamic3DTextLabelText(hTextInfo[HouseInfo[i][Houseid]],0x00FF00FF,"Not Owned");
      DestroyDynamicMapIcon(housemapicon[HouseInfo[i][Houseid]]);
      housemapicon[HouseInfo[i][Houseid]] = CreateDynamicMapIcon(HouseInfo[i][HX], HouseInfo[i][HY], HouseInfo[i][HZ],31,0xFFFF00AA);
      strmid(HouseInfo[i][Owner], "NULL", 0, strlen(pName(playerid)), 255); GivePlayerMoney(playerid,HouseInfo[i][SPrice]); HouseInfo[i][Owned] = 0;
      PlayerInfo[playerid][hOwned] = 0; PlayerInfo[playerid][hID] = 0;
      new string[70];
      format(string,sizeof string,"You've Successfully Sold This house [ ID: %d ]",i);
      SendClientMessage(playerid, 0x33AA33AA, string);
      } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to own this house to sell it");
    } else return SendClientMessage(playerid, 0xDC143CAA,"ERROR: This House is already for sale");
  return 1;
}

CMD:lockh(playerid,params[]) {
  new i; i = GetHouseID(playerid);
  if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to lock it");
  if(strcmp(HouseInfo[i][Owner],pName(playerid),false )== 0 || IsPlayerAdmin(playerid)) {
      if(HouseInfo[i][Locked] == 0) {
         HouseInfo[i][Locked] = 1;
         new Query[128];
         format(Query, sizeof(Query),"UPDATE `houses` SET `Locked` = 1 WHERE `ID` = '%d'",HouseInfo[i][Houseid]);
         mysql_tquery(mysql, Query, "", "");
         SendClientMessage(playerid,0x33FF33AA,"You have Successfully Locked this house");
      } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: This house is already locked");
    } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to own this house to lock it");
  return 1;
}

CMD:unlockh(playerid,params[]) {
  new i; i = GetHouseID(playerid);
  if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to unlock it");
  if(strcmp(HouseInfo[i][Owner],pName(playerid),false )== 0 || IsPlayerAdmin(playerid)) {
      if(HouseInfo[i][Locked] == 1) {
         HouseInfo[i][Locked] = 0;
         new Query[128];
         format(Query, sizeof(Query),"UPDATE `houses` SET `Locked` = 0 WHERE `ID` = '%d'",HouseInfo[i][Houseid]);
         mysql_tquery(mysql, Query, "", "");
         SendClientMessage(playerid,0x33FF33AA,"You have Successfully UnLocked this house");
      } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: This house is already unlocked");
    } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to own this house to unlock it");
  return 1;
}

CMD:enterh(playerid,params[]) {
  new i; i = GetHouseID(playerid);
  if(i == -255) return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You need to be on house icon to enter it");
  if(HouseInfo[i][Locked] == 0) {
    if(HouseInfo[i][IX] != 0 && HouseInfo[i][IY] != 0 && HouseInfo[i][IZ] != 0) {
       SetPlayerInterior(playerid,HouseInfo[i][Interior]);
       SetPlayerPos(playerid,HouseInfo[i][IX],HouseInfo[i][IY],HouseInfo[i][IZ]);
    }
    if(HouseInfo[i][IX] == 0 && HouseInfo[i][IY] == 0 && HouseInfo[i][IZ] == 0) {
      if(HouseInfo[i][Interior] == 1) {
        SetPlayerInterior(playerid,1);
        SetPlayerPos(playerid, 2527.654052,-1679.388305,1015.498596);
    }
      if(HouseInfo[i][Interior] == 2) {
        SetPlayerInterior(playerid,2);
        SetPlayerPos(playerid, 2451.77,-1699.80,1013.51);

    }
      if(HouseInfo[i][Interior] == 3) {
        SetPlayerInterior(playerid,3);
        SetPlayerPos(playerid,2496.65,-1696.55,1014.74);
    }
      if(HouseInfo[i][Interior] == 4) {
        SetPlayerInterior(playerid,5);
        SetPlayerPos(playerid,1299.14,-794.77,1084.00);
    }
      if(HouseInfo[i][Interior] == 5) {
        SetPlayerInterior(playerid,6);
        SetPlayerPos(playerid,-2240.00,131.00,1035.40);
    }
      if(HouseInfo[i][Interior] == 6) {
        SetPlayerInterior(playerid,8);
        SetPlayerPos(playerid,2365.42,-1131.85,1050.88);
    }
      if(HouseInfo[i][Interior] == 7) {
        SetPlayerInterior(playerid,10);
        SetPlayerPos(playerid,2260.76,-1210.45,1049.02);
    }
   }
    pinterior[playerid] = GetPlayerInterior(playerid);
    GetPlayerPos(playerid, posx[playerid], posy[playerid], posz[playerid]);
    inhouse[playerid] = 1;
    SendClientMessage(playerid,-1,"NOTE: Please use /exith for exit from house don't use the DOOR");
  } else return SendClientMessage(playerid,0xDC143CAA,"ERROR: This house is locked and you're not able to enter it");
  return 1;
}

CMD:exith(playerid,params[]) {
    if(inhouse[playerid] == 1) {
      SetPlayerPos(playerid, posx[playerid], posy[playerid], posz[playerid]);
      SetPlayerInterior(playerid,pinterior[playerid]);
      inhouse[playerid] = 0;
    } else return SendClientMessage(playerid, 0xDC143CAA, "ERROR: You're not in house to exit");
    return 1;
}

CMD:gotoh(playerid,params[]) {
    if(PlayerInfo[playerid][hOwned] == 1) {
       teleporth[playerid] = 5;
       htimer[playerid] = SetTimerEx("Teleporth", 1000, 1, "i", playerid);
       SendClientMessage(playerid, 0x33AA33AA, "You will be teleported to your house in 5 seconds...");
     } else return SendClientMessage(playerid,0xDC143CAA,"ERROR: You don't own house to go to it");
    return 1;
}
//=============================The End==========================================