"; if($c['board_works']=="only_admin"){ if(@$_SESSION['login']&& @$_SESSION['password']){ $admins=mysql_query("SELECT * FROM jb_admin");cq(); $adminsdata=mysql_fetch_assoc($admins); if($_SESSION['login']!=$adminsdata['login'] || md5($_SESSION['password'])!=$adminsdata['password']) die(require_once("inc/db_error.php")); }else die(require_once("inc/db_error.php")); } elseif(@$_GET['op']=="error"){ require_once("inc/error.inc.php"); } elseif(@$_GET['op']=="search"){ define("USTITLE","Поиск по сайту «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/search.inc.php"); } elseif(@$_GET['op']=="account"){ define("USTITLE",$lang[841]); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/login.inc.php"); } elseif(@$_GET['op']=="unsubscribe"){ define("USTITLE","Управление подриской"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/unsubscribe.inc.php"); } elseif(@$_GET['op']=="activate"){ define("USTITLE","Подтверждение регистрации"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/activate.inc.php"); } elseif(@$_GET['op']=="cpanel"){ define("USTITLE","Личный кабинет"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/user.inc.php"); } elseif(@$_GET['op']=="allusers"){ define("USTITLE","Пользователи «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/allusers.inc.php"); } elseif(@$_GET['op']=="weather"){ define("USTITLE","Прогноз погоды ".$c['city_gde']." на сегодня"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/weather.inc.php"); } elseif(@$_GET['op']=="raspisanie"){ if(@$_GET['act']=="bus") define("USTITLE","Расписание автобусов ".$c['city_gde'].""); if(@$_GET['act']=="aero") define("USTITLE","Расписание авиарейсов ".$c['city_gde'].""); if(@$_GET['act']=="poezd") define("USTITLE","Расписание поездов ".$c['city_gde'].""); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/raspisanie.inc.php"); } /////////////////////////////////КОММЕНТАРИИ///////////////////////////////// elseif(@$_GET['op']=="comments"){ if (@$_GET['type']=="l") {$p_type=" в разделе Лента";$print_type_l="class=\"label label-info\""; $sql_plus_type=" type='news' AND "; $sql_odder=" ORDER by id DESC";$print_type_t="";$print_type_v="";$print_type_p="";$print_type_s="";$print_type_u="";$print_type_d="";} elseif (@$_GET['type']=="q") {$p_type=" в разделе Статьи";$print_type_q="class=\"label label-info\""; $sql_plus_type=" type='posts' AND "; $sql_odder=" ORDER by id DESC";$print_type_t="";$print_type_v="";$print_type_p="";$print_type_s="";$print_type_u="";$print_type_d="";} elseif (@$_GET['type']=="v") {$p_type=" в разделе Видео";$print_type_v="class=\"label label-info\""; $sql_plus_type=" type='video' AND "; $sql_odder=" ORDER by id DESC";$print_type_t="";$print_type_l="";$print_type_p="";$print_type_s="";$print_type_u="";$print_type_d="";} elseif (@$_GET['type']=="p") {$p_type=" в разделе Проблемы";$print_type_p="class=\"label label-info\""; $sql_plus_type=" type='problem' AND "; $sql_odder=" ORDER by id DESC";$print_type_t="";$print_type_v="";$print_type_l="";$print_type_s="";$print_type_u="";$print_type_d="";} elseif (@$_GET['type']=="s") {$p_type=" в разделе Справочник";$print_type_s="class=\"label label-info\""; $sql_plus_type=" type='book' AND "; $sql_odder=" ORDER by id DESC";$print_type_t="";$print_type_v="";$print_type_p="";$print_type_l="";$print_type_u="";$print_type_d="";} elseif (@$_GET['type']=="t") {$p_type=" в разделе Сплетни";$print_type_t="class=\"label label-info\""; $sql_plus_type=" type='tattle' AND "; $sql_odder=" ORDER by id DESC";$print_type_s="";$print_type_v="";$print_type_p="";$print_type_l="";$print_type_u="";$print_type_d="";} elseif (@$_GET['type']=="u") {$p_type=" с позитивным рейтингом";$print_type_u="class=\"label label-info\""; $sql_plus_type=""; $sql_odder=" ORDER by up DESC";$print_type_v="";$print_type_t="";$print_type_p="";$print_type_s="";$print_type_l="";$print_type_d="";} elseif (@$_GET['type']=="d") {$p_type=" негативным рейтингом";$print_type_d="class=\"label label-info\""; $sql_plus_type=""; $sql_odder=" ORDER by down DESC";$print_type_v="";$print_type_t="";$print_type_p="";$print_type_s="";$print_type_u="";$print_type_l="";} elseif (ctype_digit(@$_GET['type'])) {$p_type=", автор - ";$sql_plus_type=" user_id='".$_GET['type']."' AND "; $sql_odder=" ORDER by id DESC";$print_type_t="";$print_type_v="";$print_type_p="";$print_type_s="";$print_type_u="";$print_type_l="";$print_type_d=""; } else {$p_type="";$print_type_t="";$print_type_l="";$print_type_v="";$print_type_p="";$print_type_s="";$print_type_u="";$print_type_d="";$sql_plus_type=""; $sql_odder=" ORDER by id DESC";} $result=mysql_query("SELECT * FROM jb_comments WHERE ".$sql_plus_type." old_mess='old'");cq(); $commtitle=mysql_fetch_assoc($result); if (@$_GET['page']) { if (ctype_digit(@$_GET['type'])) define("USTITLE","Комментарии «".$c['sitename']."»".$p_type." ".$commtitle['autor'].", страница ".@$_GET['page'].""); else define("USTITLE","Комментарии пользователей «".$c['sitename']."» ".$p_type.", страница ".@$_GET['page'].""); } else { if (ctype_digit(@$_GET['type'])) define("USTITLE","Комментарии «".$c['sitename']."»".$p_type." ".$commtitle['autor'].""); else define("USTITLE","Комментарии пользователей «".$c['sitename']."» ".$p_type.""); } require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/comments.inc.php"); } elseif(@$_GET['op']=="addcomments"){ define("USTITLE","Добавление комментария"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/addcomments.inc.php"); } /////////////////////////////////End КОММЕНТАРИИ///////////////////////////////// elseif(@$_GET['op']=="userpage"){ if(ctype_digit(@$_GET['id_user'])){ $query_userpage=mysql_query("SELECT *, DATE_FORMAT(reg_date,'%d.%m.%Y') as reg_date, DATE_FORMAT(last_visit,'%d.%m.%Y %H:%i') as last_visit FROM jb_user WHERE id_user='".$_GET['id_user']."'");cq(); $userpage_arr=mysql_fetch_assoc($query_userpage); define("USTITLE","Профиль пользователя ".$userpage_arr['name']); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if ($userpage_arr['activ']=="yes" || $userpage_arr['public']=="yes") $usname=$userpage_arr["name"]; else $usname="User"; echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/userpage.inc.php"); } else {header("location: ".$h."error.html");} } elseif(@$_GET['op']=="mailto"){ $err=0; $ustitle="Отправка письма на деревню дедушке"; if(ctype_digit(@$_GET['id_post'])){ if (@$_GET['type']=="a") { $query_mail=mysql_query("SELECT id, id_category, title, city FROM jb_book WHERE id='".$_GET['id_post']."'");cq(); if ($mail_arr=mysql_fetch_assoc($query_mail)) { $ustitle="Отправка письма администратору сайта."; $mail_arr['name']="Администратор"; $mail_arr['email']=$c['admin_mail']; } else $err=1; } elseif (@$_GET['type']=="p") { $query_mail=mysql_query("SELECT id, id_category, title, city FROM jb_problem WHERE id='".$_GET['id_post']."'");cq(); if ($mail_arr=mysql_fetch_assoc($query_mail)) { $ustitle="Отправка письма администратору сайта."; $mail_arr['name']="Администратор"; $mail_arr['email']=$c['admin_mail']; } else $err=1; } elseif (@$_GET['type']=="u") { $query_mail=mysql_query("SELECT id_user, name, email, activ, public FROM jb_user WHERE id_user='".$_GET['id_post']."'");cq(); if ($mail_arr=mysql_fetch_assoc($query_mail)) { $ustitle="Отправка письма пользователю \"".$mail_arr['name']."\""; } else $err=1; } elseif (@$_GET['type']=="f") { $query_mail=mysql_query("SELECT id, id_category, title, city, email FROM jb_book WHERE id='".$_GET['id_post']."'");cq(); if ($mail_arr=mysql_fetch_assoc($query_mail)) { $ustitle="Отправка письма для \"".$mail_arr['title']."\""; } else $err=1; } else $err=1; define("USTITLE",$ustitle); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/mailto.inc.php"); } else {header("location: ".$h."error.html");} } elseif(@$_GET['op']=="contacts"){ define("USTITLE",$lang[254]); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/contacts.inc.php"); } /////////////////////////////////КОНТЕНТ///////////////////////////////// elseif(@$_GET['op']=="content"){ if(ctype_digit(@$_GET['id'])){ $query_content=mysql_query("SELECT * FROM jb_page WHERE id='".$_GET['id']."' AND checked='yes'");cq(); if($content_arr=mysql_fetch_assoc($query_content)) { define("USTITLE",$content_arr['title']); if(@$content_arr['keywords'])define("USKEYWORDS",$content_arr['keywords']); else define("USKEYWORDS",$content_arr['title']); if(@$content_arr['descr'])define("USDESCRIPTION",$content_arr['descr']); else define("USDESCRIPTION",$content_arr['title']); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/content.inc.php"); } else {header("location: ".$h."error.html");} } else {header("location: ".$h."error.html");} } /////////////////////////////////End КОНТЕНТ///////////////////////////////// /////////////////////////////////НОВОСТИ///////////////////////////////// elseif(@$_GET['op']=="news"){ if(ctype_digit(@$_GET['id'])){ $query_news=mysql_query("SELECT DATE_FORMAT(jb_news.date,'%d.%m.%Y') as dat, DATE_FORMAT(jb_news.date,'%H-%i') as tim, jb_news.* FROM jb_news WHERE old_mess='old' AND id='".$_GET['id']."'");cq(); $news_arr=mysql_fetch_assoc($query_news); define("USTITLE",$news_arr['title']); if(@$news_arr['keywords'])define("USKEYWORDS",$news_arr['keywords']); else define("USKEYWORDS",$news_arr['title']); if(@$news_arr['descr'])define("USDESCRIPTION",$news_arr['descr']); else define("USDESCRIPTION",$news_arr['short']); } elseif(ctype_digit(@$_GET['id_cat_news'])) { $q_tit=mysql_query("SELECT name_cat, description FROM jb_news_cat WHERE id='".$_GET['id_cat_news']."'");cq(); $cat_tit=mysql_fetch_assoc($q_tit); define("USTITLE", $cat_tit['name_cat']); define("USKEYWORDS",$cat_tit['description']); define("USDESCRIPTION",$cat_tit['name_cat'].": ".$cat_tit['description']); } else define("USTITLE","Лента новостей «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/news.inc.php"); } elseif(@$_GET['op']=="addnews"){ define("USTITLE",$lang[292]); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if(defined('USER') && @$user_data['activ'] == "no"){ header("location: ".$h."login.html"); die();} echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/addnews.inc.php"); } /////////////////////////////////End НОВОСТИ///////////////////////////////// /////////////////////////////////СТАТЬИ///////////////////////////////// elseif(@$_GET['op']=="posts"){ if(ctype_digit(@$_GET['id'])){ $query_posts=mysql_query("SELECT DATE_FORMAT(jb_posts.date,'%d.%m.%Y') as dat, DATE_FORMAT(jb_posts.date,'%H-%i') as tim, jb_posts.* FROM jb_posts WHERE old_mess='old' AND id='".$_GET['id']."'");cq(); $posts_arr=mysql_fetch_assoc($query_posts); define("USTITLE",$posts_arr['title']); if(@$posts_arr['keywords'])define("USKEYWORDS",$posts_arr['keywords']); else define("USKEYWORDS",$posts_arr['title']); if(@$posts_arr['descr'])define("USDESCRIPTION",$posts_arr['descr']); else define("USDESCRIPTION",$posts_arr['short']); } elseif(ctype_digit(@$_GET['id_cat_posts'])) { $q_tit=mysql_query("SELECT name_cat, description FROM jb_posts_cat WHERE id='".$_GET['id_cat_posts']."'");cq(); $cat_tit=mysql_fetch_assoc($q_tit); define("USTITLE", $cat_tit['name_cat']); define("USKEYWORDS",$cat_tit['description']); define("USDESCRIPTION",$cat_tit['name_cat'].": ".$cat_tit['description']); } else define("USTITLE","Лента Статей «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/posts.inc.php"); } elseif(@$_GET['op']=="addposts"){ define("USTITLE",$lang[292]); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if(defined('USER') && @$user_data['activ'] == "no"){ header("location: ".$h."login.html"); die();} echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/addposts.inc.php"); } /////////////////////////////////End СТАТЬИ///////////////////////////////// /////////////////////////////////ВИДЕО///////////////////////////////// elseif(@$_GET['op']=="video"){ if(ctype_digit(@$_GET['id'])){ $query_video=mysql_query("SELECT DATE_FORMAT(jb_video.date,'%d.%m.%Y') as dat, DATE_FORMAT(jb_video.date,'%H-%i') as tim, jb_video.* FROM jb_video WHERE id='".$_GET['id']."'");cq(); $video_arr=mysql_fetch_assoc($query_video); define("USTITLE",$video_arr['title']); if(@$video_arr['keywords'])define("USKEYWORDS",$video_arr['keywords']); else define("USKEYWORDS",$video_arr['descr']); if(@$video_arr['descr'])define("USDESCRIPTION",$video_arr['descr']); else define("USDESCRIPTION",$video_arr['full']); } else define("USTITLE","Лента видео «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/video.inc.php"); } elseif(@$_GET['op']=="addvideo"){ define("USTITLE","Добавление ссылки на видеоролик"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/addvideo.inc.php"); } elseif(@$_GET['op']=="promovideo"){ define("USTITLE","Рейтинг видеороликов «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/promovideo.inc.php"); } /////////////////////////////////End ВИДЕО///////////////////////////////// /////////////////////////////////СПЛЕТНИ///////////////////////////////// elseif(@$_GET['op']=="tattle"){ if(ctype_digit(@$_GET['id'])){ $query_tattle=mysql_query("SELECT DATE_FORMAT(jb_tattle.date,'%d.%m.%Y') as dat, jb_tattle.* FROM jb_tattle WHERE id='".$_GET['id']."'");cq(); $tattle_arr=mysql_fetch_assoc($query_tattle); define("USTITLE",$tattle_arr['title']); if(@$tattle_arr['keywords'])define("USKEYWORDS",$tattle_arr['keywords']); else define("USKEYWORDS",$tattle_arr['descr']); if(@$tattle_arr['descr'])define("USDESCRIPTION",$tattle_arr['descr']); else define("USDESCRIPTION",$tattle_arr['full']); } else define("USTITLE","Сплетни нашего города «".$c['sitename']."»"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/tattle.inc.php"); } elseif(@$_GET['op']=="addtattle"){ define("USTITLE","А вы слышали, что..."); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/addtattle.inc.php"); } /////////////////////////////////End СПЛЕТНИ///////////////////////////////// ////////////////////////////////////ПРОБЛЕМЫ/////////////////////////////////// elseif(@$_GET['op']=="addproblem"){ if(@$_GET['act']=="upd") define("USTITLE","Изменение статуса проблемы на карте ".$c['city_kto'].""); else define("USTITLE","Добавить метку на карту ".$c['city_kto'].""); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if(defined('USER') && @$user_data['activ'] == "no"){header("location: ".$h."login.html"); die();} echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/add_problem.inc.php"); } elseif((@$_GET['op']=="problem") && ctype_digit(@$_GET['id_cat_problem']) && ctype_digit(@$_GET['id_problem'])){ $query_problem=mysql_query("SELECT jb_problem.id AS problem_id, DATE_FORMAT(jb_problem.date_add,'%H-%i') as tim, DATE_FORMAT(jb_problem.date_add,'%d.%m.%Y') as dat, jb_problem.*, jb_problem_cat.id, jb_problem_cat.root_category, jb_problem_cat.name_cat, jb_user.name, jb_user.logo FROM jb_problem LEFT JOIN jb_problem_cat ON jb_problem.id_category=jb_problem_cat.id LEFT JOIN jb_user ON jb_problem.user_id = jb_user.id_user WHERE jb_problem.id=".$_GET['id_problem']." AND jb_problem.old_mess='old' LIMIT 1"); cq(); if(mysql_num_rows($query_problem)){ $ads=mysql_fetch_assoc($query_problem); define("USTITLE",$ads['title'].", ".$ads['city']); define("USKEYWORDS",$ads['keywords'].", ".$ads['city']); define("USDESCRIPTION",utf8_substr($ads['descr'],0,240)); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/problempage.inc.php"); } else {header("location: ".$h."error.html");} } elseif((@$_GET['op']=="problem") && ctype_digit(@$_GET['id_cat_problem']) && !@$_GET['id_problem']){ $querycattitle=mysql_query("SELECT id, root_category, child_category, name_cat, description FROM jb_problem_cat WHERE id='".$_GET['id_cat_problem']."'"); cq(); if(@mysql_num_rows($querycattitle)){ $cattitle=mysql_fetch_assoc($querycattitle); define("USTITLE", "Карта ".$c['city_kto'].": ".$cattitle['name_cat']); define("USKEYWORDS",$cattitle['description']); define("USDESCRIPTION",$cattitle['name_cat'].": ".$cattitle['description']); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if(ctype_digit(@$_GET['page']) && @$_GET['page']>0) $page=$_GET['page'];else $page=1; echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/list_problem.inc.php"); } else {header("location: ".$h."error.html");} } elseif(ctype_digit(@$_GET['id_cat_problem']) && ctype_digit(@$_GET['id_problem']) && @$_GET['op']=="printpoint"){ $query_mess=mysql_query("SELECT jb_problem.id AS problem_id, DATE_FORMAT(jb_problem.date_add,'%H-%i') as tim, DATE_FORMAT(jb_problem.date_add,'%d.%m.%Y') as dat, jb_problem.*, jb_problem_cat.id, jb_problem_cat.root_category, jb_problem_cat.name_cat, jb_city.city_name FROM jb_problem LEFT JOIN jb_problem_cat ON jb_problem.id_category=jb_problem_cat.id LEFT JOIN jb_city ON jb_problem.city_id=jb_city.id WHERE jb_problem.id=".$_GET['id_problem']." AND jb_problem.old_mess='old' LIMIT 1"); cq(); if(mysql_num_rows($query_mess)){ $ads=mysql_fetch_assoc($query_mess); define("USTITLE",$ads['title']); define("USKEYWORDS",$ads['keywords']); define("USDESCRIPTION",utf8_substr($ads['descr'],0,240)); require_once("inc/print_problem.inc.php"); } else require_once("inc/error.inc.php"); } elseif(@$_GET['op']=="problem" && !ctype_digit(@$_GET['id_cat_problem']) && !@$_GET['id_problem']){ define("USTITLE","Карта ".$c['city_kto'].": Проблемы и Решения"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/problem.inc.php"); } elseif(@$_GET['op']=="problems"){ define("USTITLE","Проблемы и Решения ".$c['city_kto']." - общая лента"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/problems.inc.php"); } elseif(@$_GET['op']=="fullscreenmap"){ define("USTITLE","Карта ".$c['city_kto'].": Проблемы и Решения"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); require_once("inc/fullscreenmap.inc.php"); } /////////////////////////end ПРОБЛЕМЫ////////////////////////////////////////////////// ////////////////////////////////////ФИРМЫ/////////////////////////////////// elseif(@$_GET['op']=="addbook"){ define("USTITLE",$lang[8001]); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if(defined('USER') && @$user_data['activ'] == "no"){header("location: ".$h."login.html"); die();} echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/add_firm.inc.php"); } elseif((@$_GET['op']=="book") && ctype_digit(@$_GET['id_book'])){ $query_book=mysql_query("SELECT jb_book.id AS book_id, jb_book.*, DATE_FORMAT(jb_book.date_add,'%d.%m.%Y') as dat FROM jb_book WHERE id=".$_GET['id_book']." AND old_mess='old' AND hide = '0' LIMIT 1"); cq(); if(mysql_num_rows($query_book)){ $ads=mysql_fetch_assoc($query_book); define("USTITLE",$ads['title'].", ".$ads['city']); define("USKEYWORDS",$ads['keywords'].", ".$ads['city']); define("USDESCRIPTION",utf8_substr($ads['descr'],0,240)); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/firmpage.inc.php"); } else {header("location: ".$h."error.html");} } elseif((@$_GET['op']=="book") && ctype_digit(@$_GET['id_cat_book'])){ $querycattitle=mysql_query("SELECT id, root_category, child_category, name_cat, description FROM jb_book_cat WHERE id='".$_GET['id_cat_book']."'"); cq(); if(@mysql_num_rows($querycattitle)){ $cattitle=mysql_fetch_assoc($querycattitle); define("USTITLE", $cattitle['name_cat']); define("USKEYWORDS",$cattitle['description']); define("USDESCRIPTION",$cattitle['name_cat'].": ".$cattitle['description']); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); if(ctype_digit(@$_GET['page']) && @$_GET['page']>0) $page=$_GET['page'];else $page=1; echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/list_book.inc.php"); } else {header("location: ".$h."error.html");} } elseif(@$_GET['op']=="book" && !ctype_digit(@$_GET['id_cat_book']) && !@$_GET['id_book']){ define("USTITLE","Телефонно-адресный справочник ".$c['city_kto'].""); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/book.inc.php"); } /////////////////////////end ФИРМЫ////////////////////////////////////////////////// /////////////////////////////ЭКСПЕРТЫ///////////////////////////// elseif(@$_GET['op']=="addquestion"){ define("USTITLE","Добавление вопроса"); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/addquestion.inc.php"); } elseif(@$_GET['op']=="reception" && !@$_GET['id_cat_reception'] && !@$_GET['id_reception']){ if(ctype_digit(@$_GET['page']) && @$_GET['page']>0) $page=$_GET['page'];else $page=1; define("USTITLE", "Общественная приемная ".$c['sitename'].""); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/reception.inc.php"); } elseif ((@$_GET['op']=="reception") && ctype_digit(@$_GET['id_cat_reception'])){ $name_cat=(defined('JBLANG') && constant('JBLANG')=='en')?'en_name_cat':'name_cat'; $querycattitle=mysql_query("SELECT id, root_category, child_category, ".$name_cat.", description FROM jb_reception_cat WHERE id='".$_GET['id_cat_reception']."'"); cq(); if(@mysql_num_rows($querycattitle)){ $cattitle=mysql_fetch_assoc($querycattitle); if(defined('USER_CITY_TITLE')){ define("USTITLE",$lang[5000]." - ".$cattitle[$name_cat].", ".USER_CITY_TITLE); define("USKEYWORDS",$lang[5000]." ".$cattitle['description']); define("USDESCRIPTION", USER_CITY_TITLE.", ".$cattitle[$name_cat].": ".$cattitle['description']); }else{ define("USTITLE", $lang[5000]." - ".$cattitle[$name_cat]); define("USKEYWORDS",$lang[5000]." ".$cattitle['description']); define("USDESCRIPTION",$lang[5000]." - ".$cattitle[$name_cat].": ".$cattitle['description']); } require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); if(ctype_digit(@$_GET['page']) && @$_GET['page']>0) $page=$_GET['page'];else $page=1; require_once("inc/list_cat_expert.inc.php"); } else {header("location: ".$h."error.html");} } elseif((@$_GET['op']=="reception") && @$_GET['id_reception']){ $query_expert=mysql_query("SELECT *, DATE_FORMAT(reg_date,'%d.%m.%Y') as reg_date, DATE_FORMAT(last_visit,'%d.%m.%Y %H:%i') as last_visit FROM jb_user WHERE id_user=".$_GET['id_reception']." AND type='expert' AND activ='yes' AND public='yes' LIMIT 1"); cq(); if(mysql_num_rows($query_expert)){ $expert_arr=mysql_fetch_assoc($query_expert); define("USTITLE","На вопросы отвечает ".$expert_arr['name']); if(@$expert_arr['job'])define("USKEYWORDS",$expert_arr['job']); else define("USKEYWORDS",$expert_arr['review']); define("USDESCRIPTION",$expert_arr['review']); require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div; require_once("inc/breadcrumbs.inc.php"); require_once("inc/expert.inc.php"); } else {header("location: ".$h."error.html");} } /////////////////////////////END ЭКСПЕРТЫ///////////////////////////// elseif (!@$_GET['op']) { require_once("inc/head.inc.php"); require_once("inc/top.inc.php"); echo $design_div_m; require_once("inc/index.inc.php"); } if(@$_GET['op']=="printpoint"||@$_GET['op']=="error")die(); ?>