stock LoadHouse()
{
   new query[400],idx,time = GetTickCount();
   mysql_query("SELECT * FROM `HouseInfo`");
   mysql_store_result();
   printf("[Загрузка Домов] Всего строк - %d ",mysql_num_rows());
   if(mysql_num_rows() > 0)
   {
    while (idx < sizeof(HouseInfo))
    {
     mysql_fetch_row(query);
     sscanf(query, "p<|>iffffffs[24]s[24]iiiiiiiiiiiii",
           HouseInfo[idx][idHouse],
     HouseInfo[idx][hEntrancex],
     HouseInfo[idx][hEntrancey],
     HouseInfo[idx][hEntrancez],
     HouseInfo[idx][hExitx],
     HouseInfo[idx][hExity],
     HouseInfo[idx][hExitz],
     HouseInfo[idx][hOwner],
     HouseInfo[idx][hDiscription],
     HouseInfo[idx][hValue],
     HouseInfo[idx][hHel],
     HouseInfo[idx][hArm],
     HouseInfo[idx][hInt],
     HouseInfo[idx][hLock],
     HouseInfo[idx][hOwned],
     HouseInfo[idx][hRent],
     HouseInfo[idx][hRentabil],
     HouseInfo[idx][hTakings],
     HouseInfo[idx][hVec],
     HouseInfo[idx][hVcol1],
     HouseInfo[idx][hVcol2],
     HouseInfo[idx][hLevel]);
     idx++;
    }
   }
   printf("[Загрузка Домов]:Было загружено - %d потрачено %d (ms)", idx,GetTickCount() - time);
   return 1;
}

stock LoadProperty()
{
   new strFromFile2[256],text[512],time = GetTickCount(),idx;
   new File: file = fopen("[House]/property.cfg", io_read);
   if (file)
   {
    while (idx < sizeof(HouseInfo))
    {
     fread(file, strFromFile2);
     sscanf(strFromFile2, "p<,>ffffffiiiiiis[24]s[24]iiiiiiiiiiiiiii",
     HouseInfo[idx][hEntrancex],
     HouseInfo[idx][hEntrancey],
     HouseInfo[idx][hEntrancez],
     HouseInfo[idx][hExitx],
     HouseInfo[idx][hExity],
     HouseInfo[idx][hExitz],
     HouseInfo[idx][hHealthx],
     HouseInfo[idx][hHealthy],
     HouseInfo[idx][hHealthz],
     HouseInfo[idx][hArmourx],
     HouseInfo[idx][hArmoury],
     HouseInfo[idx][hArmourz],
     HouseInfo[idx][hOwner],
     HouseInfo[idx][hDiscription],
     HouseInfo[idx][hValue],
     HouseInfo[idx][hHel],
     HouseInfo[idx][hArm],
     HouseInfo[idx][hInt],
     HouseInfo[idx][hLock],
     HouseInfo[idx][hOwned],
     HouseInfo[idx][hRooms],
     HouseInfo[idx][hRent],
     HouseInfo[idx][hRentabil],
     HouseInfo[idx][hTakings],
     HouseInfo[idx][hVec],
     HouseInfo[idx][hVcol1],
     HouseInfo[idx][hVcol2],
     HouseInfo[idx][hDate],
     HouseInfo[idx][hLevel]);
     if(HouseInfo[idx][hOwned] == 0)
     {
      format(text,sizeof(text),"{FF0000}* {FF9000}Дом № {FFFFFF}%d {FF0000}*\n{FFFFFF}Продается\n Цена:{FF9000}[$%d] \n {FFFFFF}Описание:{FF9000}[%s] \n {FFFFFF}Уровень:{FF9000}[%d]",idx, HouseInfo[idx][hValue],HouseInfo[idx][hDiscription], HouseInfo[idx][hLevel]);
      HousePickup[idx] = CreateDynamicPickup(1273, 2, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1);
      HouseIcon[idx] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],31,0,-1,-1,-1,200.0);
     }
     else
     {
         if(HouseInfo[idx][hRentabil] == 0)
         {
       format(text,sizeof(text),"{FF0000}* {FF9000}Дом № {FFFFFF}%d {FF0000}*\n{FFFFFF}Владелец:{FF9000}[%s]\n{FFFFFF}Уровень:{FF9000}[%d]",idx,HouseInfo[idx][hOwner],HouseInfo[idx][hLevel]);
      }
      else
      {
          format(text,sizeof(text),"{FF0000}* {FF9000}Дом № {FFFFFF}%d {FF0000}*\n{FFFFFF}Владелец:{FF9000}[%s]\n{FFFFFF}Уровень:{FF9000}[%d]\n{FFFFFF}Аренда:{FF9000}[$%d]",idx,HouseInfo[idx][hOwner],HouseInfo[idx][hLevel],HouseInfo[idx][hRent]);
      }
      HouseIcon[idx] = CreateDynamicMapIcon(HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],32,0,-1,-1,-1,200.0);
      HousePickup[idx] = CreateDynamicPickup(1272, 2, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez],-1);
     }
     HouseLabel[idx] = CreateDynamic3DTextLabel(text,0xFFFFFFFF,HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez]+1,20.0);
     idx++;
    }
      
   }
   fclose(file);
                printf("[Загрузка Домов]:Было загружено - %d потрачено %d (ms)", idx,GetTickCount() - time);
   return 1;
}