Орла
Области
Компаний
Пользователи
Галерея
Фиксированные новости
Орла
Отзывы о фирмах
Тарифы
Пользователи
Области
Банкоматы
Торговые точки
Доска объявлений
Курсы валют
Скидки
организации Орла
организации области
товары
сайты
сайты Орел
Данные
Разделы
Поиск
Поиск запросы
Статистика
Показы каталога организаций
Статистика клиенты
Пользователи
Сайты
Управление сайтом
Анкета
Аптеки
Афиша
Афиша новая
Баннеры
Бизнес >
Викторина
Голосование
Гость на сайте
Истории
Календарь событий
Каталоги >
Конкурс красоты
Конкурс аудио
Консультации
Меню
Новое на сайте
Новости >
Организации >
Программа ТВ
Публикации
Разделы сайта
Рассылка
Рестораны
Секрет фирмы >
Сервисы >
Ссылки
Тесты
Файловый менеджер
Форум
Фотогалерея
Обратная связь
Недвижимость
Новый год
Тексты
Пользователи
Юридический рейтинг
Отзывы на товары
Бан пользователей
Жалобы
Новые тесты
Коронавирус
Файловый менеджер
Имя файла
index.php
Содержимое
<?php require_once('top_realty.php'); if ($_GET['cat_id'] != '') { $_GET['cat_id'] = (int) $_GET['cat_id']; $cat_part_one = sqlval("select * from directory where id='{$_GET['cat_id']}'"); $title_elem[] = $cat_part_one['name']; } if ( $_SERVER['QUERY_STRING'] == '' ) { $title='Недвижимость в Орле :: снять, сдать, продать, купить, арендовать, обменять, орловскую недвижимость, продажа, покупка, аренда, обмен квартир без посредников, частные объявления, цены на жилье.'; $description='Добро пожаловать в нашу базу недвижимости города Орла. Предлагаем вам обширную частную информацию о недвижимости в Орле.'; $keywords = 'аренда жилья, аренда квартир, аренда недвижимости, база недвижимости, жилье цены, квартиры без посредников, квартиры в новостройках, купить квартиру, куплю квартиру, недвижимость, недвижимость цены, обмен квартир, объявление квартира, объявления недвижимость, однокомнатная квартира, покупка квартиры, покупка недвижимости, продажа квартир, продажа недвижимости, продать квартиру, сдать квартиру, снять квартиру, стоимость квартир, цена квартиры'; } else { $title_elem[] = "Недвижимость, Бизнес в ".$name_gorod3; $title=implode(' :: ', $title_elem); $description=implode(' :: ', $title_elem); $keywords=implode(' :: ', $title_elem); } require($base_url."inc/top.inc"); require_once('config.realty.inc.php'); $r_directory = sql("select * from `directory` order by position"); if (!$r_directory) { error(); } while ( $rs_directory = sqlget ( $r_directory ) ) { $directory_array_smarty[$rs_directory['id']] = array( 'name' => $rs_directory ['name'] ); } $r_region = sql("select * from `directory` where code='".REALTY_CITY_CODE."' order by position"); if (!$r_region) { error(); } while ( $rs_region = sqlget ( $r_region ) ) { $region_array [$rs_region['parent_id']] [$rs_region['id']] = array( 'name' => $rs_region ['name'] ); $region_array_smarty[$rs_region['id']] = array( 'name' => $rs_region ['name'] ); } $r_object = sql("select * from `directory` where code='".REALTY_OBJECT_TYPE_CODE."' order by position"); if (!$r_object) { error(); } while ( $rs_object = sqlget ( $r_object ) ) { $object_array [$rs_object['parent_id']] [$rs_object['id']] = array( 'name' => $rs_object ['name'] ); $object_array_smarty[$rs_object['id']] = array( 'name' => $rs_object ['name'] ); } $r_business = sql("select * from `directory` where code='".REALTY_BUSINESS_CODE."' order by position"); if (!$r_business) { error(); } while ( $rs_business = sqlget ( $r_business ) ) { $business_array [$rs_business['parent_id']] [$rs_business['id']] = array( 'name' => $rs_business ['name'] ); $business_array_smarty[$rs_business['id']] = array( 'name' => $rs_business ['name'] ); } $r_deal = sql("select * from `directory` where code='".REALTY_DEAL_TYPE_CODE."' order by position"); if (!$r_deal) { error(); } while ( $rs_deal = sqlget ( $r_deal ) ) { $deal_array [$rs_deal['parent_id']] [$rs_deal['id']] = array( 'name' => $rs_deal ['name'] ); $deal_array_smarty[$rs_deal['id']] = array( 'name' => $rs_deal ['name'] ); } $r_com_type = sql("select * from `directory` where code='".REALTY_TYPE_CODE."' order by position"); if (!$r_com_type) { error(); } while ( $rs_com_type = sqlget ( $r_com_type ) ) { $com_type_array [$rs_com_type['parent_id']] [$rs_com_type['id']] = array( 'name' => $rs_com_type ['name'] ); $com_type_smarty[$rs_com_type['id']] = array( 'name' => $rs_com_type ['name'] ); } $r_home_type = sql("select * from `directory` where code='".REALTY_HOME_TYPE_CODE."' order by position"); if (!$r_home_type) { error(); } while ( $rs_home_type = sqlget ( $r_home_type ) ) { $home_type_array [$rs_home_type['parent_id']] [$rs_home_type['id']] = array( 'name' => $rs_home_type ['name'] ); $home_type_smarty[$rs_home_type['id']] = array( 'name' => $rs_home_type ['name'] ); } $query = "select SQL_CALC_FOUND_ROWS t1.* from realty t1 where status='3' "; if ( isset($_GET['cat_id']) && $_GET['cat_id'] != '') { $_GET['cat_id'] = (int) $_GET['cat_id']; $query .= " and object_type_id='{$_GET['cat_id']}'"; } // это для того чтобы убрать страницы sale,buy,pass и rent if(isset($_GET['deal_type']) && $_GET['deal_type'] != '') { $query.= " and deal_type_id='{$_GET['deal_type']}' "; } // теперь index.php отвечает за вывод и этих страниц $query .= "and CURDATE() <= data_end"; if ( $_GET['search'] == 1) { if ( $_GET['region_id'] != '') { $_GET['region_id'] = (int) $_GET['region_id']; $region_ids[] = $_GET['region_id']; $result_ids = fetchAll("select id from directory where parent_id='{$_GET['region_id']}'"); foreach ( $result_ids as $id ) $region_ids[] = $id['id']; $query .= " and region_id in (".implode(',', $region_ids).")"; } if ( $_GET['price_type'] != '') { $_GET['price_type'] = (int) $_GET['price_type']; $query .= " and price_type={$_GET['price_type']}"; } if ( $_GET['deal_type_id'] != '') { $_GET['deal_type_id'] = (int) $_GET['deal_type_id']; $query .= " and deal_type_id={$_GET['deal_type_id']}"; } if ( $_GET['cat_id'] != '') { $_GET['cat_id'] = (int) $_GET['cat_id']; $query .= " and object_type_id={$_GET['cat_id']}"; } if ( $_GET['home_type_id'] != '') { $_GET['home_type_id'] = (int) $_GET['home_type_id']; $query .= " and home_type_id={$_GET['home_type_id']}"; } if ( $_GET['business_type'] != '') { $_GET['business_type'] = (int) $_GET['business_type']; $query .= " and business_type_id={$_GET['business_type']}"; } if ( $_GET['com_type'] != '') { $_GET['com_type'] = (int) $_GET['com_type']; $query .= " and com_type_id={$_GET['com_type']}"; } if ( is_array($_GET['room_count'])) { $query .= " and (room_count in (".implode(',', $_GET['room_count']).") )"; } if ( $_GET['price_from'] != '' && $_GET['price_to'] != '') { $_GET['price_from'] = (float) $_GET['price_from']; $_GET['price_to'] = (float) $_GET['price_to']; $query .= " and (price between '{$_GET['price_from']}' and '{$_GET['price_to']}')"; } elseif ($_GET['price_from']!='') { $_GET['price_from'] = (float) $_GET['price_from']; $query .= " and price>'{$_GET['price_from']}'"; } elseif ($_GET['price_to']!='') { $_GET['price_to'] = (float) $_GET['price_to']; $query .= " and price<'{$_GET['price_to']}'"; } if ( $_GET['square_from'] != '' && $_GET['square_to'] != '') { $_GET['square_from'] = (float) $_GET['square_from']; $_GET['square_to'] = (float) $_GET['square_to']; $query .= " and (square between '{$_GET['square_from']}' and '{$_GET['square_to']}')"; } elseif ($_GET['square_from']!='') { $_GET['square_from'] = (float) $_GET['square_from']; $query .= " and square>'{$_GET['square_from']}'"; } elseif ($_GET['square_to']!='') { $_GET['square_to'] = (float) $_GET['square_to']; $query .= " and square<'{$_GET['square_to']}'"; } if ( $_GET['square_all_from'] != '' && $_GET['square_all_to'] != '') { $_GET['square_all_from'] = (float) $_GET['square_all_from']; $_GET['square_all_to'] = (float) $_GET['square_all_to']; $query .= " and (square_all between '{$_GET['square_all_from']}' and '{$_GET['square_all_to']}')"; }elseif ($_GET['square_all_from']!='') { $_GET['square_all_from'] = (float) $_GET['square_all_from']; $query .= " and square_all>'{$_GET['square_all_from']}'"; } elseif ($_GET['square_all_to']!='') { $_GET['square_all_to'] = (float) $_GET['square_all_to']; $query .= " and square_all<'{$_GET['square_all_to']}'"; } if ( $_GET['floor_from'] != '' && $_GET['floor_to'] != '') { $_GET['floor_from'] = (int) $_GET['square_all_from']; $_GET['floor_to'] = (int) $_GET['floor_to']; $query .= " and (floor between '{$_GET['floor_from']}' and '{$_GET['floor_to']}')"; }elseif ($_GET['floor_from']!='') { $_GET['floor_from'] = (int) $_GET['floor_from']; $query .= " and floor>'{$_GET['floor_from']}'"; } elseif ($_GET['floor_to']!='') { $_GET['floor_to'] = (int) $_GET['floor_to']; $query .= " and floor<'{$_GET['floor_to']}'"; } if ($_GET['photo'] == 1) { $query .= " and photo_count > 0"; } } $uri = explode("&", $_SERVER['QUERY_STRING']); foreach ( $uri as $key => $param ) { if ( preg_match("/^sort=[A-z0-9_]+\.(asc|desc)+$/", $param) ) { unset($uri[$key]); } } if ( $_GET['sort'] == 'cost.asc') { $order = ',price asc'; $sort_price_uri = implode('&',array_merge($uri, array('sort=cost.desc'))); $sort_date_uri = implode('&',array_merge($uri, array('sort=date.desc'))); $class_price = 'class="sort-top"'; }elseif ( $_GET['sort'] == 'cost.desc') { $order = ',price desc'; $sort_price_uri = implode('&',array_merge($uri, array('sort=cost.asc'))); $sort_date_uri = implode('&',array_merge($uri, array('sort=date.desc'))); $class_price = 'class="sort-bottom"'; }elseif ( $_GET['sort'] == 'date.asc') { $order = ',data asc'; $sort_price_uri = implode('&',array_merge($uri, array('sort=cost.desc'))); $sort_date_uri = implode('&',array_merge($uri, array('sort=date.desc'))); $class_date = 'class="sort-top"'; }elseif ( $_GET['sort'] == 'date.desc') { $order = ',data desc'; $sort_price_uri = implode('&',array_merge($uri, array('sort=cost.desc'))); $sort_date_uri = implode('&',array_merge($uri, array('sort=date.asc'))); $class_date = 'class="sort-bottom"'; } else { $order .= ",data desc"; $sort_price_uri = implode('&',array_merge($uri, array('sort=cost.desc'))); $sort_date_uri = implode('&',array_merge($uri, array('sort=date.asc'))); $class_date = 'class="sort-bottom"'; } if($_GET['sort']==''){ $query .= ' order by data desc';} else{ $query .= ' order by'.str_replace(',',' ',$order);} if ($pap > 0) { if ( !isset( $_REQUEST['page']) ) $_REQUEST['page'] = 1; $start = ( $_REQUEST['page'] - 1 ) * $pap; $query .= " limit {$start}, {$pap}"; } $data = fetchAll($query); $kol = sqlval("select FOUND_ROWS()"); foreach ($data as &$item) if ($item['photo_count'] > 0) $item['photo'] = fetchAll("select * from realty_photo where realty_id='{$item['id']}' order by rand() limit 1"); $section_array = fetchAll("select distinct t2.id, t2.name, t2.data from directory_link t1, directory t2 where t1.parent_id in (15, 16, 26, 27) and t1.child_id=t2.id order by position"); foreach ( $section_array as &$section_item ) { $qcount = "select count(*) from realty where object_type_id='{$section_item['id']}' and status='3' and CURDATE() <= data_end"; if (isset($_GET['deal_type']) && $_GET['deal_type']!='') { $qcount .= " and deal_type_id='{$_GET['deal_type']}'"; } $section_item['count'] = sqlval($qcount); } $query = "select t1.* from realty t1 where top='1' and status='3' and CURDATE() <= data_end order by data desc"; $top_data = fetchAll($query); foreach ($top_data as &$item) if ($item['photo_count'] > 0) $item['photo'] = fetchAll("select * from realty_photo where realty_id='{$item['id']}' order by rand() limit 1"); $rs_count = sqlval("select count(*) from realty t1 where status='3' and CURDATE() <= data_end"); if ( $_GET['search'] == 1 ) { $_GET['region_id'] = (int)$_GET['region_id']; $_GET['price_type'] = (int)$_GET['price_type']; $_GET['deal_type_id'] = (int)$_GET['deal_type_id']; } if ( $parent_id != '' && $_GET['cat_id'] != '') { $form_search = 'realty/'.$forms_array[$parent_id][$_GET['cat_id']]['search-form']; } else { $form_search = 'realty/search_realty.tpl'; } $resultRubrik=fetchAll("SELECT otrasl2 . * , COUNT( id_rubrik ) AS cnt FROM otrasl2, rubrik2 WHERE id_rubrik = otrasl2.id AND otrasl2.id_parent = '647' GROUP BY id_rubrik ORDER BY name_otrsl"); $smarty->assign("admin", $admlist[$login]); $smarty->assign("parent_id", $parent_id); $smarty->assign("name_gorod3", $name_gorod3); $smarty->assign("section_array", $section_array); $smarty->assign("id_user_sess", $id_user_sess); $smarty->assign("db_data", $data); $smarty->assign("top_data", $top_data); $smarty->assign("forms_array", $forms_array); $smarty->assign("form_search", $form_search); $smarty->assign("rs_count", $rs_count); $smarty->assign("prices_array", $prices); $smarty->assign("deal_type", $deal_type); $smarty->assign("region_array", $region_array_smarty); $smarty->assign("region_array2", $region_array); $smarty->assign("deal_array", $deal_array); $smarty->assign("object_array", $object_array); $smarty->assign("home_type_array", $home_type_array); $smarty->assign("business_array", $business_array); $smarty->assign("com_type_array", $com_type_array); $smarty->assign("sort_price_uri", $sort_price_uri); $smarty->assign("class_price", $class_price); $smarty->assign("sort_date_uri", $sort_date_uri); $smarty->assign("class_date", $class_date); $smarty->assign("directory_array", $directory_array_smarty); $smarty->assign("txt_name_array", $txt_name); $smarty->assign("template", $template); $smarty->assign("resultRubrik", $resultRubrik); // echo '<pre>'; // print_r($smarty); $smarty->display('realty/realty_index.tpl'); $smarty->clear_all_assign(); if ( $kol[0] > $pap ) { PaginationHelper::display( $kol[0], $pap ); } require($base_url."inc/bottom.inc"); ?>
/realty_old/
Имя
Дата
Размер
..
2026-10-02
images
2016-04-11
.htaccess
2016-04-11
158 байт
_my_reklama.php
2016-04-11
13 кб.
add_anti_spam_form.php
2016-04-11
675 байт
add_floor.inc.php
2016-04-11
752 байт
add_house.inc.php
2016-04-11
316 байт
add_land_area.inc.php
2016-04-11
248 байт
add_note.inc.php
2016-04-11
199 байт
add_place.inc.php
2016-04-11
5 кб.
add_price_all.inc.php
2016-04-11
578 байт
add_price_all_m.inc.php
2016-04-11
528 байт
add_price_month.inc.php
2016-04-11
361 байт
add_realty.php
2016-05-05
5 кб.
add_realty2.php
2016-05-04
13 кб.
add_realty_business.php
2016-04-11
4 кб.
add_realty_business_buy.php
2016-04-11
3 кб.
add_realty_business_sale.php
2016-04-11
3 кб.
add_realty_commerce.php
2016-04-11
2 кб.
add_realty_commerce_buy.php
2016-04-11
3 кб.
add_realty_commerce_pass.php
2016-04-11
3 кб.
add_realty_commerce_rent.php
2016-04-11
3 кб.
add_realty_commerce_sale.php
2016-04-11
3 кб.
add_realty_garage.php
2016-04-11
2 кб.
add_realty_garage_buy.php
2016-04-11
3 кб.
add_realty_garage_pass.php
2016-04-11
3 кб.
add_realty_garage_rent.php
2016-04-11
3 кб.
add_realty_garage_sale.php
2016-04-11
2 кб.
add_realty_house.php
2016-04-11
2 кб.
add_realty_house_buy.php
2016-04-11
3 кб.
add_realty_house_pass.php
2016-04-11
3 кб.
add_realty_house_rent.php
2016-04-11
3 кб.
add_realty_house_sale.php
2016-04-11
3 кб.
add_realty_land.php
2016-04-11
2 кб.
add_realty_land_buy.php
2016-04-11
3 кб.
add_realty_land_pass.php
2016-04-11
3 кб.
add_realty_land_rent.php
2016-04-11
3 кб.
add_realty_land_sale.php
2016-04-11
3 кб.
add_realty_new_buy.php
2016-04-11
3 кб.
add_realty_new_sale.php
2016-04-11
3 кб.
add_realty_room_buy.php
2016-04-11
3 кб.
add_realty_room_pass.php
2016-04-11
3 кб.
add_realty_room_rent.php
2016-04-11
3 кб.
add_realty_room_sale.php
2016-04-11
3 кб.
add_realty_rooms.php
2016-04-11
2 кб.
add_realty_vtor_buy.php
2016-04-11
3 кб.
add_realty_vtor_pass.php
2016-04-11
3 кб.
add_realty_vtor_rent.php
2016-04-11
3 кб.
add_realty_vtor_sale.php
2016-04-11
3 кб.
add_room.inc.php
2016-04-11
452 байт
add_time.inc.php
2016-05-05
3 кб.
add_total_area.inc.php
2016-04-11
617 байт
add_total_area_house.inc
2016-04-11
238 байт
add_total_area_house.inc.php
2016-04-11
237 байт
add_type_biz.inc.php
2016-04-11
300 байт
add_type_com.inc.php
2016-04-11
304 байт
bottom_realty.inc
2016-04-11
1 кб.
bottom_realty.inc.php
2016-04-11
1007 байт
buy.php
2016-05-04
9 кб.
clean_realty.php
2016-04-11
1 кб.
config.realty.inc.php
2016-04-11
4 кб.
delete.php
2016-05-04
2 кб.
draw_num.php
2016-04-11
1 кб.
edit.php
2016-04-11
463 байт
form_footer.inc.php
2016-04-11
7 байт
form_header.inc.php
2016-04-11
2 кб.
index.php
2016-05-04
13 кб.
menu.inc.php
2016-04-11
4 кб.
menu_main.inc.php
2016-04-11
4 кб.
my_reklama.php
2016-04-11
13 кб.
my_reklama_fazenda.php
2016-04-11
12 кб.
my_reklama_garage.php
2016-04-11
10 кб.
my_reklama_houses.php
2016-04-11
14 кб.
my_reklama_rooms.php
2016-04-11
12 кб.
my_reklama_sn.php
2016-04-11
14 кб.
partial_agency_form.php
2016-04-11
0 байт
partial_user_form.php
2016-04-11
590 байт
pass.php
2016-05-04
9 кб.
realty_echo.php
2016-05-04
3 кб.
realty_echo1.php
2016-04-11
7 кб.
realty_exp_yandex.php
2016-04-11
3 кб.
realty_my.php
2016-04-11
3 кб.
realty_sql.php
2016-05-05
11 кб.
rent.php
2016-04-11
9 кб.
sale.php
2016-05-04
9 кб.
script.js
2016-04-11
4 кб.
search.inc.php
2016-04-12
181 байт
search_realty.php
2016-04-12
11 кб.
search_realty_business_buy.php
2016-04-11
4 кб.
search_realty_business_sale.php
2016-04-11
4 кб.
search_realty_commerce_buy.php
2016-04-11
5 кб.
search_realty_commerce_pass.php
2016-04-11
4 кб.
search_realty_commerce_rent.php
2016-04-11
4 кб.
search_realty_commerce_sale.php
2016-04-11
4 кб.
search_realty_garage_buy.php
2016-04-11
4 кб.
search_realty_garage_pass.php
2016-04-11
4 кб.
search_realty_garage_rent.php
2016-04-11
4 кб.
search_realty_garage_sale.php
2016-04-11
4 кб.
search_realty_house_buy.php
2016-04-11
6 кб.
search_realty_house_pass.php
2016-04-11
5 кб.
search_realty_house_rent.php
2016-04-11
5 кб.
search_realty_house_sale.php
2016-04-11
6 кб.
search_realty_land_buy.php
2016-04-11
4 кб.
search_realty_land_pass.php
2016-04-11
4 кб.
search_realty_land_rent.php
2016-04-11
4 кб.
search_realty_land_sale.php
2016-04-11
4 кб.
search_realty_new_buy.php
2016-04-11
6 кб.
search_realty_new_sale.php
2016-04-11
6 кб.
search_realty_room_buy.php
2016-04-11
6 кб.
search_realty_room_pass.php
2016-04-11
6 кб.
search_realty_room_rent.php
2016-04-11
6 кб.
search_realty_room_sale.php
2016-04-11
6 кб.
search_realty_vtor_buy.php
2016-04-11
6 кб.
search_realty_vtor_pass.php
2016-04-11
6 кб.
search_realty_vtor_rent.php
2016-04-11
6 кб.
search_realty_vtor_sale.php
2016-04-11
6 кб.
section.inc.php
2016-04-11
1 кб.
section_main.inc.php
2016-04-11
1 кб.
section_my.inc.php
2016-04-11
1 кб.
street_helper.php
2016-04-11
503 байт
template_realty.php
2016-04-11
8 кб.
top_realty.inc.php
2016-04-11
737 байт
top_realty.php
2016-04-11
149 байт
/realty_old
Загрузить файлы
Файл 1
Файл 2
Файл 3
..
