public LoadSQLProperty()
{
   new arrCoords[33][64];
   new sql[125], row[512];
   format(sql, sizeof(sql), "SELECT COUNT(*) FROM property");
   samp_mysql_query(sql);
   samp_mysql_store_result();
   samp_mysql_fetch_row(row);
   totalhouses = strval(row);
   samp_mysql_free_result();
     
   for (new idx=0; idx<totalhouses; idx++)
   {
       format(sql, sizeof(sql), "SELECT * FROM property WHERE id=%d", idx+1);
       samp_mysql_query(sql);
       samp_mysql_store_result();
       if (samp_mysql_num_rows() > 0)
    {
           samp_mysql_fetch_row(row);
     split(row, arrCoords, '|');
     samp_mysql_free_result();
     HouseInfo[idx][hEntrancex] = floatstr(arrCoords[1]);
     HouseInfo[idx][hEntrancey] = floatstr(arrCoords[2]);
     HouseInfo[idx][hEntrancez] = floatstr(arrCoords[3]);
     HouseInfo[idx][hExitx] = floatstr(arrCoords[4]);
     HouseInfo[idx][hExity] = floatstr(arrCoords[5]);
     HouseInfo[idx][hExitz] = floatstr(arrCoords[6]);
     HouseInfo[idx][hHealthx] = strval(arrCoords[7]);
     HouseInfo[idx][hHealthy] = strval(arrCoords[8]);
     HouseInfo[idx][hHealthz] = strval(arrCoords[9]);
     HouseInfo[idx][hArmourx] = strval(arrCoords[10]);
     HouseInfo[idx][hArmoury] = strval(arrCoords[11]);
     HouseInfo[idx][hArmourz] = strval(arrCoords[12]);
     strmid(HouseInfo[idx][hOwner], arrCoords[13], 0, strlen(arrCoords[13]), 255);
     strmid(HouseInfo[idx][hDiscription], arrCoords[14], 0, strlen(arrCoords[14]), 255);
     HouseInfo[idx][hValue] = strval(arrCoords[15]);
     HouseInfo[idx][hHel] = strval(arrCoords[16]);
     HouseInfo[idx][hArm] = strval(arrCoords[17]);
     HouseInfo[idx][hInt] = strval(arrCoords[18]);
     HouseInfo[idx][hLock] = strval(arrCoords[19]);
     HouseInfo[idx][hOwned] = strval(arrCoords[20]);
     HouseInfo[idx][hRooms] = strval(arrCoords[21]);
     HouseInfo[idx][hRent] = strval(arrCoords[22]);
     HouseInfo[idx][hRentabil] = strval(arrCoords[23]);
     HouseInfo[idx][hTakings] = strval(arrCoords[24]);
     HouseInfo[idx][hVec] = strval(arrCoords[25]);
             if(HouseInfo[idx][hVec] == 457)
     {
      HouseInfo[idx][hVec] = 411;
     }
     HouseInfo[idx][hVcol1] = strval(arrCoords[26]);
     HouseInfo[idx][hVcol2] = strval(arrCoords[27]);
     HouseInfo[idx][hDate] = strval(arrCoords[28]);
     HouseInfo[idx][hLevel] = strval(arrCoords[29]);
                          HouseInfo[idx][hWorld] = strval(arrCoords[30]);
                          HouseInfo[idx][hSafeDrugs] = strval(arrCoords[31]);
                          HouseInfo[idx][hSafeMats] = strval(arrCoords[32]);   
     printf("HouseInfo:%d Owner:%s hTakings %d hVec %d",idx,HouseInfo[idx][hOwner],HouseInfo[idx][hTakings],HouseInfo[idx][hVec]);
    }
   }
   return 1;
}