Орла
Области
Компаний
Пользователи
Галерея
Фиксированные новости
Орла
Отзывы о фирмах
Тарифы
Пользователи
Области
Банкоматы
Торговые точки
Доска объявлений
Курсы валют
Скидки
организации Орла
организации области
товары
сайты
сайты Орел
Данные
Разделы
Поиск
Поиск запросы
Статистика
Показы каталога организаций
Статистика клиенты
Пользователи
Сайты
Управление сайтом
Анкета
Аптеки
Афиша
Афиша новая
Баннеры
Бизнес >
Викторина
Голосование
Гость на сайте
Истории
Календарь событий
Каталоги >
Конкурс красоты
Конкурс аудио
Консультации
Меню
Новое на сайте
Новости >
Организации >
Программа ТВ
Публикации
Разделы сайта
Рассылка
Рестораны
Секрет фирмы >
Сервисы >
Ссылки
Тесты
Файловый менеджер
Форум
Фотогалерея
Обратная связь
Недвижимость
Новый год
Тексты
Пользователи
Юридический рейтинг
Отзывы на товары
Бан пользователей
Жалобы
Новые тесты
Коронавирус
Файловый менеджер
Имя файла
zaliv.php
Содержимое
<?php function getRestorans($r){ $restorans = array(); while ($rs = sqlget($r)) { $restoran = array(); $restoran['id'] = $rs['id']; if($restoran['id'] == 412){$restoran['kod']="";}else{$restoran['kod']="(4862)";} $restoran['name'] = $rs['name']; if ( $rs['registr'] == 1 && $rs['logo'] != '' && file_exists('../'.$rs['logo'])) { $restoran['logo'] = "<img class='img-responsive restaurant-logo-preview' src=\"../{$rs['logo']}\" align=\"\" />"; } else { $restoran['logo'] = '<img class="img-responsive restaurant-logo-preview" src="./disagn/no-logo.jpg" alt="" />'; } if ($rs['registr'] == 1 ) $name = "{$name}"; $restoran['phone'] = $rs['phone'];if($rs['in_city'] ==1){$rs['address'] = 'г. Орёл, '.$rs['address'];} $restoran['address'] = $rs['address']; $restoran['href_map'] = "<a href=\"/maps/?iz={$rs['id']}&tz=3&d=r\" target=\"_blank\" />{$rs['address']}</a>"; $tmp_type = explode(";", $rs['type']); $_tpl_vars['type']=""; if (is_array( $tmp_type )){ foreach ($tmp_type as $type) { $rs_type = sqlval("SELECT `id`, `name` FROM `restoran`.`restoran_type` WHERE `name`='{$type}'"); $_tpl_vars['type'] .= "<a class=\"black-underline-link button-filter\" href=\"index.php?sid_t={$rs_type['id']}&v=1&search=1\" >{$rs_type['name']}</a> "; } } $restoran['type'] = substr( $_tpl_vars['type'], 0, strlen( $_tpl_vars['type'] ) - 2 ); ////////////////////// if(trim($rs['kitchen'])!=''){ $tmp_kitchen = explode(";", $rs['kitchen']); $_tpl_var=""; if (is_array($tmp_kitchen)){ foreach ($tmp_kitchen as $kitchen){ $kitchen = trim($kitchen); $rs_kitchen = sqlval("SELECT `id`,`name` FROM `restoran`.`restoran_kitchen` WHERE `name`='{$kitchen}'"); if(count($rs_kitchen)>0){ $_tpl_var.= "<a class=\"black-underline-link button-filter\" href=\"index.php?sid_k={$rs_kitchen['id']}&v=2&search=1\" >{$rs_kitchen['name']}</a> "; } } $kitchen = substr( $_tpl_var, 0, strlen( $_tpl_var) - 2 ); } $restoran['kitchen'] = $kitchen;} else{$restoran['kitchen']='';} $mas_data = sqlval("SELECT COUNT(*) as count, SUM(ball) as balls FROM `restoran`.`restoran_vote_new` WHERE `id_restoran` = {$rs['id']}"); $count = $mas_data['count']; $balls = $mas_data['balls']; if($count and $balls and $count>0 and $balls>0){ $rating = round($balls/$count,1); }else{ $rating = 0; } $_tpl_vars['rating'] = $rating; $comments_plus = sqlval("SELECT count(*) as pol FROM restoran.restoran_comment WHERE `id_restoran` = {$rs['id']} and karma = 1 and status=3"); $comments_minus = sqlval("SELECT count(*) as otr FROM restoran.restoran_comment WHERE `id_restoran` = {$rs['id']} and karma = -1 and status=3"); if($comments_minus['otr']!=0 or $comments_plus['pol']!=0){ $weight_comments = ($comments_plus['pol']*5 + $comments_minus['otr']*1)/($comments_plus['pol'] + $comments_minus['otr']); } if($weight_comments){ if($_tpl_vars['rating'] > 0){ $_tpl_vars['rating'] = round(($_tpl_vars['rating'] + $weight_comments)/2,1);} else{ $_tpl_vars['rating'] = round($_tpl_vars['rating'] + $weight_comments,1); } } $restoran['rating'] = $_tpl_vars['rating']; if ( $rs['registr'] == 1 && $rs['foto_485'] != '') { $restoran['foto_485'] = $rs['foto_485']; } else { $restoran['foto_485'] = ''; } $weight_comments = null; $restorans[] = $restoran; } return $restorans; } function getRestoran(){ global $l2,$sid,$ip,$ip,$uinmd; $rs = sqlval( "SELECT `restoran`.*, `restoran_area`.`id` AS `id_area`, `restoran_area`.`name` AS `area_name`, `restoran_area`.`in_city` AS `in_city`, `x`, `y` FROM `restoran`.`restoran` LEFT JOIN `infoorel`.`map_home` ON `restoran`.`id_home`=`infoorel`.`map_home`.`id`, `restoran`.`restoran_area` WHERE `restoran`.status='3' and `restoran`.`id_area`=`restoran_area`.`id` AND `restoran`.`id`='" . intval( $_GET['id'] ) . "'", $l2 ); if ( !$rs ) { error( ); } $_tpl_vars['def_tab'] = $rs['def_tab']; $_tpl_vars['id'] = $rs['id']; $_tpl_vars['registr'] = $rs['registr']; $_tpl_vars['id_area'] = $rs['id_area']; $_tpl_vars['area_name'] = $rs['area_name']; $_tpl_vars['registr'] = $rs['registr']; $tmp_type = explode(";", $rs['type']); $_tpl_vars['type']=""; if (is_array( $tmp_type )){ foreach ($tmp_type as $type) { $rs_type = sqlval("SELECT `id`, `name` FROM `restoran`.`restoran_type` WHERE `name`='{$type}'"); $_tpl_vars['type'] .= "<a class=\"black-underline-link button-filter\" href=\"index.php?sid_t={$rs_type['id']}&v=1&search=1\" >{$rs_type['name']}</a> "; } } $_tpl_vars['type'] = substr( $_tpl_vars['type'], 0, strlen( $_tpl_vars['type'] )); $_tpl_vars['type'] = substr( $_tpl_vars['type'], 0, strlen( $_tpl_vars['type'] ) - 2 ); $tmp_kitchen = explode(";", $rs['kitchen']); if ( is_array( $tmp_kitchen ) ) { foreach ($tmp_kitchen as $kitchen) { $rs_kitchen = sqlval("SELECT `id`, `name` FROM `restoran`.`restoran_kitchen` WHERE `name`='{$kitchen}'"); $_tpl_vars['kitchen'] .= "<a class=\"black-underline-link button-filter\" href=\"index.php?sid_k={$rs_kitchen['id']}&v=2&search=1\">{$rs_kitchen['name']}</a> "; } } $_tpl_vars['kitchen'] = substr( $_tpl_vars['kitchen'], 0, strlen( $_tpl_vars['kitchen'] ) - 2 ); $_tpl_vars['children'] = str_replace(';', ', ', $rs['children']); $_tpl_vars['offer'] = str_replace(';', ', ', $rs['offer']); $_tpl_vars['entertainment'] = str_replace(';', ', ', $rs['entertainment']); $_tpl_vars['name'] = $rs['name']; $_tpl_vars['img_index'] = $rs['img_index'];if($rs['in_city'] ==1){$rs['address'] = 'г. Орёл, '.$rs['address'];} $_tpl_vars['address'] = "<a href=\"/maps/?iz={$_tpl_vars['id']}&tz=3&d=r\" target=\"_blank\" />{$rs['address']}</a>"; $_tpl_vars['phone'] = $rs['phone']; $_tpl_vars['hall'] = $rs['hall']; $_tpl_vars['work_hours'] = $rs['work_hours']; $_tpl_vars['cost'] = $rs['cost']; $_tpl_vars['site'] = $rs['site']; $_tpl_vars['email'] = $rs['email']; $_tpl_vars['logo'] = $rs['logo']; $_tpl_vars['card'] = str_replace(';', ', ', $rs['card']); $tmp_music = explode(";", $rs['music']); if ( is_array( $tmp_music ) ) { foreach ($tmp_music as $music) { $rs_music = sqlval("SELECT `id`, `name` FROM `restoran`.`restoran_music` WHERE `name`='{$music}'"); $_tpl_vars['music'] .= "<a href=\"index.php?sid_m={$rs_music['id']}&v=3&search=1\">{$rs_music['name']}</a>, "; } } $_tpl_vars['music'] = substr( $_tpl_vars['music'], 0, strlen( $_tpl_vars['music'] ) - 2 ); $tmp_place = explode(";", $rs['place']); if ( is_array( $tmp_music ) ) { foreach ($tmp_place as $place) { $rs_place = sqlval("SELECT `id`, `name` FROM `restoran`.`restoran_place` WHERE `name`='{$place}'"); $tmp_place_array[] = "<a href=\"index.php?sid_p={$rs_place['id']}&v=1&search=1\">{$rs_place['name']}</a>"; } } $_tpl_vars['place'] = implode(', ', $tmp_place_array); unset($tmp_place_array); $_tpl_vars['feature'] = str_replace(';', ', ', $rs['feature']); $_tpl_vars['parking'] = $rs['parking']; $_tpl_vars['clothes'] = $rs['clothes']; $_tpl_vars['enter'] = $rs['enter']; $_tpl_vars['info'] = $rs['info']; $sql = "SELECT COUNT(*) as count, SUM(ball) as balls FROM `restoran_vote_new` WHERE `id_restoran` = '{$rs['id']}'"; $mas_data = sqlval($sql); $count = $mas_data['count']; $balls = $mas_data['balls']; if($count and $balls and $count>0 and $balls>0){ $rating = round($balls/$count,1); }else{ $rating = 0; } $_tpl_vars['rating'] = $rating; $_tpl_vars['voters'] = $count; $r=sqlval("SELECT COUNT(*) FROM `restoran`.`restoran_vote_new` WHERE `id_restoran` = '" . $rs['id'] . "' AND (`sid`='".$sid."' OR (`ipUser`='".$ip."' AND `ipProxy`='".$ip2."'))", $l2); if (!$r) { error(); } if ($r[0] == 0) { $_tpl_vars['vote_link'] = ' <form id="vote_form"> <p><b>Оцените ресторан:</b></p> <select name="vote" id="selvote" class="form-control"> <option value="1" selected>1 балл</option> <option value="2">2 балла</option> <option value="3">3 балла</option> <option value="4">4 балла</option> <option value="5">5 баллов</option> </select> <br> <input type="submit" name="ocenka" value="Оценить" id="do_vote" class="btn btn-default comment-button btn-block"> </form>'; } else { $_tpl_vars['vote_link'] = ''; } $comments_plus = sqlval("SELECT count(*) as pol FROM restoran_comment WHERE `id_restoran` = {$rs['id']} and karma = 1 and status=3"); $comments_minus = sqlval("SELECT count(*) as otr FROM restoran_comment WHERE `id_restoran` = {$rs['id']} and karma = -1 and status=3"); if($comments_minus['otr']>0 or $comments_plus['pol']>0){ $weight_comments = ($comments_plus['pol']*5 + $comments_minus['otr']*1)/($comments_plus['pol'] + $comments_minus['otr']); } if($weight_comments){ if($_tpl_vars['rating'] > 0){ $_tpl_vars['rating'] = round(($_tpl_vars['rating'] + $weight_comments)/2,1);}else{ $_tpl_vars['rating'] = round($_tpl_vars['rating'] + $weight_comments,1); } } return $_tpl_vars; } function getComments(){ global $l2,$base_url,$ofs,$pap; $comments = array(); $r_comment = fetchAll("SELECT SQL_CALC_FOUND_ROWS `restoran_comment`.*, `infoorel`.`user`.`name` AS `name`, `avatar`, `sex` FROM `restoran`.`restoran_comment`, `infoorel`.`user` WHERE `id_restoran`='{$_GET['id']}' AND (`restoran_comment`.`status`='3' or `restoran_comment`.`status`='4') AND `id_user`=`user`.`id` ORDER BY `restoran_comment`.`date` DESC LIMIT $ofs, $pap", $l2); if (!$r_comment) { return array('comments'=>false,'kol'=>false); } $kol = sqlval("SELECT FOUND_ROWS()", $l2); foreach ($r_comment as $rs_comment){ $comment = array(); if ($rs_comment['avatar'] != '' && file_exists($base_url . $rs_comment['avatar'])) { $avatar = $base_url . $rs_comment['avatar']; } else { $avatar = 'img/noavatar.gif'; } $comment['avatar'] = $avatar; switch ($rs_comment['sex']) { case 1: $sex = 'men'; break; case 2: $sex = 'women'; break; case 0: $sex = 'it"'; break; default: $sex = 'it"'; break; } switch ( $rs_comment['karma'] ) { case -1: $class = "otr"; break; case 0: $class = "neytr"; break; case 1: $class = "pol"; break; default: $class = "neytr"; break; } $comment['class'] = $class; $comment['user'] = $rs_comment['name']; $comment['date'] = $rs_comment['date']; $my_c = 0; $comment['ident'] = $rs_comment['id']; $comment['yes'] = $rs_comment['yes']; $comment['no'] = $rs_comment['no']; if($comment['yes'] != 0){$comment['yes'] = '+'.$comment['yes'];} if($comment['no'] != 0){$comment['no'] = '-'.$comment['no'];} $comment['comment'] = BBCode2Html($rs_comment['comment']); $comment['comment_comment'] = $rs_comment['comment_comment']; $comment['date2'] = $rs_comment['date2']; $comment['ipUser'] = $rs_comment['ipUser']; $comment['id_user'] = $rs_comment['id_user']; $comment['id'] = $rs_comment['id']; $comments[] = $comment; } return array('comments'=>$comments,'kol'=>$kol[0]); } function getPanorams(){ $_GET['id'] = (int)$_GET['id']; $result = fetchAll("SELECT SQL_CALC_FOUND_ROWS * FROM restoran.restoran_panoram WHERE id_restoran='{$_GET['id']}' and status = 3 order by id desc"); if (!$result) {return array('panorams'=>false,'kol'=>false);} $count = end(sqlval("SELECT FOUND_ROWS()")); foreach($result as $key=>$row){ $info = pathinfo($row['file']); $result[$key]['ext'] = $info['extension']; } return array('panorams'=>$result,'kol'=>$count); } function getPhotos(){ $_GET['id'] = (int)$_GET['id']; $result = fetchAll("SELECT SQL_CALC_FOUND_ROWS * FROM restoran.restoran_photo WHERE id_restoran='{$_GET['id']}' and status = 3 order by position"); if (!$result or !count($result)) {return array("photos"=>false);} $albumrez = fetchAll("select id,name from restoran.restoran_albums where id_rest =".$_GET['id']." ORDER BY position"); $fotofromnoalb = fetchAll("SELECT * FROM restoran.restoran_photo WHERE id_restoran='{$_GET['id']}' and status = 3 and album=0 order by position"); if(is_array($albumrez) and count($albumrez)>0){ foreach($albumrez as $key=>$row_alb){ $albumrez[$key]['photos'] = fetchAll("SELECT * FROM restoran.restoran_photo WHERE id_restoran='{$_GET['id']}' and status = 3 and album=".$row_alb['id']." order by position"); } } return ["photos"=>$result, "noAlbum"=>$fotofromnoalb, "withAlbums"=>$albumrez]; } function getMenu(){ $_GET['id'] = (int)$_GET['id']; $r_menu = sql("SELECT SQL_CALC_FOUND_ROWS * FROM restoran.restoran_menu WHERE id_restoran='{$_GET['id']}' and status='3' order by position"); $count = end(sqlval("SELECT FOUND_ROWS()")); if ( $count == 0 ) { return false; } else{ while ( $rs_menu = sqlget($r_menu)) { $db_data[$rs_menu['news_header']] = $rs_menu['news_full']; } return $db_data; } } function getNews(){ global $l2; $_GET['id'] = (int)$_GET['id']; $result = fetchAll("SELECT SQL_CALC_FOUND_ROWS `restoran`.`name`, `id_restoran`, DATE_FORMAT(`restoran_news`.`data`, '%d.%m.%Y') AS `date`, restoran_news.id as news_id, `news_header`, `news_short`, `news_full`, restoran_news.img_index, restoran_news.pokaz_img FROM `restoran`.`restoran`, `restoran`.`restoran_news` WHERE (restoran.status='3' or restoran.status='4') and `restoran`.`id`=`restoran_news`.`id_restoran` and (restoran_news.status='3' or restoran_news.status='4') and id_restoran='{$_GET['id']}' order by `restoran_news`.`data` desc ", $l2); $count = end(sqlval("SELECT FOUND_ROWS()")); if ( $count == 0 ) { return false; }else{ return $result; } } function getVideos(){ $_GET['id'] = (int)$_GET['id']; if(isset($_GET['id']) and $_GET['id']==231){ $result = fetchAll("SELECT SQL_CALC_FOUND_ROWS * FROM restoran_video WHERE (status='3' or status='4') and id_restoran='{$_GET['id']}' and process_status='3' order by date desc"); }else{ $result = fetchAll("SELECT SQL_CALC_FOUND_ROWS * FROM restoran_video WHERE (status='3' or status='4') and id_restoran='{$_GET['id']}' and process_status='3' order by id");} $count = end(sqlval("SELECT FOUND_ROWS()")); if ( $count == 0 ) { return false; }else{ foreach($result as $key=>&$video){ $path_parts = pathinfo($video['converted_file']); $result[$key]['filename'] = $path_parts['filename']; } return $result; } }
/restoran/
Имя
Дата
Размер
..
2026-10-02
css
2013-12-04
disagn
2013-12-04
images
2017-03-03
img
2013-12-06
js
2016-03-24
panoram
2016-01-28
virtualtourdata
2014-11-28
.htaccess
2015-04-04
164 байт
Censure.php
2015-07-23
19 кб.
ChangeLog
2013-12-04
464 байт
Pagination.php
2013-12-04
5 кб.
ReflectionTypeHint.php
2013-12-23
6 кб.
UTF8.php
2013-12-23
145 кб.
_ins_comment.php
2013-12-17
2 кб.
action.php
2014-06-30
2 кб.
application.js
2013-12-04
1 кб.
bridge.swf
2013-12-04
308 байт
bridge11.swf
2013-12-04
286 байт
clip_image001.gif
2013-12-04
258 кб.
comment_form.inc.php
2016-03-28
2 кб.
comments_action.php
2016-03-25
2 кб.
del_comment.php
2016-03-28
569 байт
delete_podpiska.php
2014-03-18
716 байт
edit_comment.php
2023-12-22
1 кб.
edit_comment.php~
2013-12-04
1 кб.
evercookie.js
2013-12-04
25 кб.
food_box.php
2013-12-04
917 байт
gang_1.jpg
2013-12-04
142 кб.
gang_2.jpg
2013-12-04
267 кб.
gang_3.JPG
2013-12-04
151 кб.
index.php
2023-12-22
4 кб.
index.php~
2023-09-13
4 кб.
ins_comment.php
2016-03-29
2 кб.
insert_user_p.php
2014-03-17
1 кб.
menu.inc.php
2016-03-15
9 кб.
menu_grinn_beer.pdf
2013-12-04
3885 кб.
menu_rest_green.pdf
2013-12-04
2004 кб.
modifier.strpos.php
2016-03-29
726 байт
news.php
2023-12-22
11 кб.
news.php~
2017-08-16
11 кб.
novoe_menyu_yaponia.doc
2013-12-04
1944 кб.
novoe_menyu_yaponia.docx
2013-12-04
1905 кб.
pinthouse_accii.jpg
2013-12-04
231 кб.
pinthouse_accii_1.jpg
2013-12-04
245 кб.
preview.php
2015-09-29
7 кб.
resize.php
2013-12-09
1 кб.
rest_bottom.php
2016-03-29
1 кб.
restoran.js
2016-02-15
5 кб.
restoran_comments.php
2016-12-14
1 кб.
restoran_echo.js
2015-05-19
3 кб.
restoran_echo.php
2023-12-22
3 кб.
restoran_echo.php~
2020-07-21
3 кб.
restoran_menu.php
2016-12-15
743 байт
restoran_news.php
2016-12-14
4 кб.
restoran_news_echo.php
2013-12-04
3 кб.
restoran_photos.php
2016-12-15
775 байт
restoran_print.php
2019-02-27
8 кб.
rt_menu.pdf
2013-12-04
4810 кб.
rules.php
2023-12-22
6 кб.
rules.php~
2013-12-04
6 кб.
search_restoran.php
2013-12-04
5 кб.
send_letter_cron.php
2015-01-19
3 кб.
seo_box.php
2013-12-04
586 байт
stylerest.css
2013-12-04
2 кб.
swfobject-2.2.min.js
2013-12-04
10 кб.
t_2.jpg
2013-12-06
2 кб.
test.php
2016-12-05
6 кб.
top_best.php
2013-12-04
1 кб.
top_last.php
2013-12-04
360 байт
top_last_comment.php
2013-12-04
2 кб.
top_news.php
2013-12-06
2 кб.
top_section.php
2016-03-10
7 кб.
update_comment.php
2016-03-25
442 байт
virtualtour.swf
2014-11-28
106 кб.
yesno.php
2013-12-04
1 кб.
zaliv.php
2016-03-23
16 кб.
/restoran
Загрузить файлы
Файл 1
Файл 2
Файл 3