Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	action.php
Содержимое	<?php $base_url="../"; require_once($base_url.'func.php'); require_once('JSON.php'); $l = db_connect(); switch ( $_REQUEST['action'] ) { case 'load_map_objects_realty': $objects_array = array(); $objects_result = fetchAll("select SQL_CALC_FOUND_ROWS * from realty where status='3' and CURDATE() <= data_end"); foreach ($objects_result as &$objects) { if ($objects['lat'] && $objects['lng']) { if ($objects['photo_count'] > 0) $objects['photo'] = fetchAll("select photo from realty_photo where realty_id='{$item['id']}' order by rand() limit 1"); $objects_array["'".$objects['id']."'"] = array( 'id' => $objects['id'], 'coords' => array($objects['lat'], $objects['lng']), 'image'=>($objects['photo'][0]['photo'] != '') ? $objects['photo'][0]['photo'] : '', 'hint' => iconv("windows-1251", "UTF-8",$objects['title']), 'content' => iconv("windows-1251", "UTF-8",$objects['description']), 'address' => iconv("windows-1251", "UTF-8",$objects['street']) . ' / ' . $objects['home'], 'price' => $objects['price'] ); } } echo json_encode_cyr($objects_array); break; case 'load_map_objects_restoran': $l = db_connect_restoran(); $objects_array = array(); $objects_result = fetchAll("select * from restoran where (status='3' or status='4')"); foreach ($objects_result as $objects) { if ($objects['lat'] && $objects['lng']) { $objects_array["'".$objects['id']."'"] = array( 'id' => $objects['id'], 'coords' => array($objects['lat'], $objects['lng']), 'image'=>($objects['logo'] != '' && $objects['registr']) ? $objects['logo'] : '', 'hint' => iconv("windows-1251", "UTF-8",$objects['name']), 'content' => ($objects['registr']) ? iconv("windows-1251", "UTF-8",$objects['info']) : '', 'address' => iconv("windows-1251", "UTF-8",$objects['address']), 'registr' => $objects['registr'], 'phone' => ($objects['phone']!='') ? $objects['phone'] : '' ); } } echo json_encode_cyr($objects_array); break; case 'load_map_objects_forum': $objects_array = array(); $objects_result = fetchAll("select * from forum_map_obj where id_parent = '".intval($_REQUEST['id_parent'])."'"); //$image=sqlval("select image from forum_map_obj where image <> '' and id_parent = '".intval($_REQUEST['id_parent'])."'"); foreach ($objects_result as $objects) { if ($objects['lat'] && $objects['lng']) { if ($objects['image'] <> '') { if (file_exists("..".$objects['image'])) { $image['image']=$objects['image']; $size_x=50;$size_y=50; } } else { $image['image']='http://api.yandex.ru/maps/doc/jsapi/2.x/examples/images/myIcon.gif'; $size_x=30;$size_y=42; } $objects_array["'".$objects['id']."'"] = array( 'id' => $objects['id'], 'coords' => array($objects['lat'], $objects['lng']), 'image'=> $image['image'], 'size_x'=> $size_x, 'size_y'=> $size_y, 'id_articl' => $objects['id_articl'], 'id_forum' => $objects['id_forum'], 'note' => iconv("windows-1251", "UTF-8",prepare_post($objects['note'])), 'id_parent' => $objects['id_parent'] ); } } echo json_encode_cyr($objects_array); break; case 'load_map_objects_firma': $objects_array = array(); if (is_numeric($_GET['id'])) { $catarr = array(); $catarr[] = (int)$_GET['id']; $arrind = 0; $rezarr = array(); while(count($catarr)) { $elem = $catarr[$arrind]; $result = fetchAll("SELECT id from otrasl2 where id_parent=".$elem); unset($catarr[$arrind]); $arrind++; if ( count($result)) { foreach($result as $r) { $catarr[]= $r['id']; } } else { $rezarr[] = $elem; } } //var_dump($rezarr); $instring = ''; $instring = implode(',',$rezarr); //echo $instring; //die(); $objects_result = fetchAll("SELECT firma.id, firma.lat, firma.lng, firma.name, firma.street, firma.house, firma.house_add, firma.telefon, firma.adress, firma.registr FROM firma,rubrik2 WHERE firma.id = rubrik2.id_firm and firma.lat>0 and rubrik2.id_rubrik IN (".$instring.")"); }else { $objects_result = fetchAll("select * from firma where lat>0");} foreach ($objects_result as $objects) { $objects_array["'".$objects['id']."'"] = array ( 'id' => $objects['id'], 'coords' => array($objects['lat'], $objects['lng']), 'image'=> '', 'hint' => iconv("windows-1251", "UTF-8",$objects['name']), 'content' => iconv("windows-1251", "UTF-8",$objects['street']).', '.iconv("windows-1251", "UTF-8",$objects['house']).' '.iconv("windows-1251", "UTF-8",$objects['house_add']).'<br>'.iconv("windows-1251", "UTF-8",$objects['telefon']), 'address' => iconv("windows-1251", "UTF-8",$objects['adress']), 'registr' => $objects['registr'] ); } echo json_encode_cyr($objects_array); } function getRandomCoordinates ($maxLatitude, $minLatitude, $maxLongitude, $minLongitude) { $left = (rand() /getrandmax()) * ($maxLatitude - $minLatitude) + $minLatitude; $right = (rand() /getrandmax()) * ($maxLongitude - $minLongitude) + $minLongitude; return array($left, $right); }

/maps/

Имя	Дата	Размер
..	2026-10-02
0.png	2014-04-01	120 кб.
action.php	2016-01-19	6 кб.
firma.php	2021-01-14	8 кб.
forum.php	2021-01-14	8 кб.
index.php	2023-12-21	1 кб.
index.php~	2017-04-04	1023 байт
realty.php	2021-01-14	8 кб.
restoran.php	2021-01-14	8 кб.

/maps