LoadHouses()
{
    new
        DBResult:result,
        owner[24],
        name[32],
        password[32],
        housex[11],
        housey[11],
        housez[11],
        interior[11],
        exitx[11],
        exity[11],
        exitz[11],
        exitr[11],
        price[11],
        model[11],
        vehx[11],
        vehy[11],
        vehz[11],
        vehr[11]
    ;

    result = db_query(Global, "SELECT `owner`, `name`, `password`, `housex`, `housey`, `housez`, `interior`, `exitx`, `exity`, `exitz`, `exitr`, `price`, `model`, `vehx`, `vehy`, `vehz`, `vehr`  FROM `DomyGraczy` WHERE `id` = 0");

    do
    {
        db_get_field(result, 0, owner, sizeof owner);
        db_get_field(result, 1, name, sizeof name);
        db_get_field(result, 2, password, sizeof password);
        db_get_field(result, 3, housex, sizeof housex);
        db_get_field(result, 4, housey, sizeof housey);
        db_get_field(result, 5, housez, sizeof housez);
        db_get_field(result, 6, interior, sizeof interior);
        db_get_field(result, 7, exitx, sizeof exitx);
        db_get_field(result, 8, exity, sizeof exity);
        db_get_field(result, 9, exitz, sizeof exitz);
        db_get_field(result, 10, exitr, sizeof exitr);
        db_get_field(result, 11, price, sizeof price);
        db_get_field(result, 12, model, sizeof model);
        db_get_field(result, 13, vehx, sizeof vehx);
        db_get_field(result, 14, vehy, sizeof vehy);
        db_get_field(result, 15, vehz, sizeof vehz);
        db_get_field(result, 16, vehr, sizeof vehr);

        format(HouseInfo[i][hOwner], 24, owner);
            format(HouseInfo[i][hName], 32, name);
            format(HouseInfo[i][hPassword], 32, password);
            HouseInfo[i][hPos][0] = floatstr(housex);
            HouseInfo[i][hPos][1] = floatstr(housey);
            HouseInfo[i][hPos][2] = floatstr(housez);
            HouseInfo[i][hInterior] = strval(interior);
            HouseInfo[i][hExit][0] = floatstr(exitx);
            HouseInfo[i][hExit][1] = floatstr(exity);
            HouseInfo[i][hExit][2] = floatstr(exitz);
            HouseInfo[i][hExit][3] = floatround((180.0 + floatstr(exitr)));
            HouseInfo[i][hPrice] = strval(price);
            HouseInfo[i][vModel] = strval(model);
            HouseInfo[i][vSpawn][0] = floatstr(vehx);
            HouseInfo[i][vSpawn][1] = floatstr(vehy);
            HouseInfo[i][vSpawn][2] = floatstr(vehz);
            HouseInfo[i][vSpawn][3] = floatstr(vehr);

            switch(HouseInfo[i][hInterior])
            {
                case 0: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2196.84, -1204.36, 1049.02, (i + 1000));
                case 1: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2259.38, -1135.89, 1050.64, (i + 1000));
                case 2: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2282.99, -1140.28, 1050.89, (i + 1000));
                case 3: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2233.69, -1115.26, 1050.88, (i + 1000));
                case 4: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2218.39, -1076.21, 1050.48, (i + 1000));
                case 5: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2496.00, -1692.08, 1014.74, (i + 1000));
                case 6: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2365.25, -1135.58, 1050.88, (i + 1000));
                case 7: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2317.77, -1026.76, 1050.21, (i + 1000));
                case 8: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 2324.41, -1149.54, 1050.71, (i + 1000));
                case 9: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 140.28, 1365.92, 1083.85, (i + 1000));
                case 10: HouseInfo[i][HousePickupInt] = CreatePickup(1273, -1, 1260.6603, -785.4005, 1091.9063, (i + 1000));
            }

            HouseInfo[i][HousePickupOut] = CreatePickup(1273, 1, HouseInfo[i][hPos][0], HouseInfo[i][hPos][1], HouseInfo[i][hPos][2]);
            HouseInfo[i][HouseCar] = CreateVehicle(HouseInfo[i][vModel], HouseInfo[i][vSpawn][0], HouseInfo[i][vSpawn][1], HouseInfo[i][vSpawn][2], HouseInfo[i][vSpawn][3], -1, -1, -1);
            HouseInfo[i][HouseCP] = CreateDynamicCP(HouseInfo[i][hPos][0], HouseInfo[i][hPos][1], HouseInfo[i][hPos][2], 1.0);

            if(!strcmp(HouseInfo[i][hOwner], "INVALID_OWNER", true))
            {
                format(StrGLOBAL, sizeof StrGLOBAL, "Nazwa: %s\nWłaściciel: Brak\nKoszt: $%d\nID: %d", HouseInfo[i][hName], HouseInfo[i][hPrice], i);
                HouseInfo[i][HouseIcon] = CreateDynamicMapIcon(HouseInfo[i][hPos][0], HouseInfo[i][hPos][1], HouseInfo[i][hPos][2], 31, -1, -1, -1, -1, 150.0);
            }
            if(strcmp(HouseInfo[i][hOwner], "INVALID_OWNER", true))
            {
                format(StrGLOBAL, sizeof StrGLOBAL, "Nazwa: %s\nWłaściciel: %s\nKoszt: $%d\nID: %d", HouseInfo[i][hName], HouseInfo[i][hOwner], HouseInfo[i][hPrice], i);
                HouseInfo[i][HouseIcon] = CreateDynamicMapIcon(HouseInfo[i][hPos][0], HouseInfo[i][hPos][1], HouseInfo[i][hPos][2], 32, -1, -1, -1, -1, 150.0);
            }

            HouseInfo[i][HouseLabel] = Create3DTextLabel(StrGLOBAL, GREEN, HouseInfo[i][hPos][0], HouseInfo[i][hPos][1], HouseInfo[i][hPos][2]+0.7, 25, 0, 1);
    }

    while(db_next_row(result));
        db_free_result(result);

    return 1;
}