Справочник по металлу и металлопродукции'; $templates_dir = $root_path . $templates_dir; $template->set_filenames(array('body' => $templates_dir . "inform.tpl")); /****************/ function showForm($fio, $city, $phone, $email, $site, $maintext, $err) { echo('

Добавить свой ответ:
(предложение, вопрос, отзыв...)

'); if (!empty($err) && ($err != "")) { echo("
".$err."
"); } if (!strpos($site, "http://")) { $site = "http://"; } echo('
Автор (компания, имя) *
Город
Телефон
E-mail
Сайт
Текст *



'); return 0; } /***************/ include("../my/functions.php"); $id = str_antihack_number($_GET["id"]); $catid = $id; if (empty($id)) { include($root_path . 'includes/page_header.php'); $template->pparse('body'); $query = "SELECT * FROM metalboard_inform_cat"; $result = mysql_query($query); echo(""); echo(""); echo(""); echo(""); echo(""); while ($row = mysql_fetch_array($result)) { echo(""); echo(''); echo(""); $catid = $row["id"]; $query2 = "SELECT COUNT(*) FROM metalboard_inform_comments WHERE catid={$catid}"; $result2 = mysql_query($query2); $row2 = mysql_fetch_row($result2); if ($row2["0"] == 0) { echo(""); } else { $query3 = "SELECT cdate FROM metalboard_inform_comments WHERE catid={$catid} ORDER BY cdate DESC"; $result3 = mysql_query($query3); $row3 = mysql_fetch_row($result3); $cdate = $row3["0"]; $cdate = substr($cdate, 0, strpos($cdate, " ")); echo(""); } echo(""); } echo("
Название подрубрикиОписание"); echo("Количество просмотров/предложений
'.$row["name"].'".$row["keywords"]."".$row["showcount"]."/".$row2["0"]."".$row["showcount"]."/".$row2["0"]."
Последний ответ: ".$cdate."
"); } else { $query = "SELECT showcount FROM metalboard_inform_cat WHERE id={$id}"; $result = mysql_query($query); $row = mysql_fetch_row($result); $sc = $row[0]; $query = "UPDATE metalboard_inform_cat SET showcount=({$sc}+1) WHERE id={$id}"; $result = mysql_query($query); /* Описание темы */ $query = "SELECT * FROM metalboard_inform_cat WHERE id={$id}"; $result = mysql_query($query); $row = mysql_fetch_array($result); $keywords = $row["keywords"]; $name = $row["name"]; $maintext = $row["maintext"]; $main_title = "Справочный каталог - ".$keywords; include($root_path . 'includes/page_header.php'); $template->pparse('body'); $cat_data = "

".$name."


".$maintext."
"; /* Конец Описание темы */ if (!empty($_POST["action"])) { $fio = str_antihack_simple($_POST["fio"]); $city = str_antihack_simple($_POST["city"]); $phone = str_antihack_simple($_POST["phone"]); $email = str_antihack_email($_POST["email"]); $site = str_antihack_simple($_POST["site"]); $maintext = str_antihack_simple($_POST["maintext"]); $maintext = str_replace("\r\n", "
", $maintext); // echo "

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"; $err = 0; if (strlen($maintext) > 2000) { $fio = str_antihack_out($fio); $city = str_antihack_out($city); $phone = str_antihack_out($phone); $email = str_antihack_out($email); $site = str_antihack_out($site); $maintext = str_antihack_out($maintext); $err = 1; echo($cat_data); showForm($fio, $city, $phone, $email, $site, $maintext, "Текст слишком большой"); } else { if (($err = 1) && (empty($fio) || empty($maintext))) { $fio = str_antihack_out($fio); $city = str_antihack_out($city); $phone = str_antihack_out($phone); $email = str_antihack_out($email); $site = str_antihack_out($site); $maintext = str_antihack_out($maintext); echo($cat_data); showForm($fio, $city, $phone, $email, $site, $maintext, "Вы должны заполнить обязательные поля"); } else { $query = "INSERT INTO metalboard_inform_comments VALUES( null, {$catid}, '{$fio}', '{$city}', '{$phone}', '{$email}', '{$site}', '{$maintext}', 1, NOW() )"; $result = mysql_query($query); if ($result) { echo("

Спасибо. Ваше сообщение отправлено


Перейти на страницу \"".$keywords."\"
"); } else { echo("

Ошибка добавления, пожалуйста, обратитесь к администратору

".mysql_error()); } } } } else { echo($cat_data); $showCount = 15; $page = str_antihack_number($_GET["page"]); if (empty($page)) { $page = 0; } $query = " SELECT * FROM metalboard_inform_comments WHERE access=1 AND catid={$catid} ORDER BY cdate DESC LIMIT {$page},{$showCount} "; $result = mysql_query($query); echo("

Предложения по теме


"); echo(""); while ($row = mysql_fetch_array($result)) { echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); } echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo("
"); $fio = str_antihack_out($row["fio"]); $maintext = str_antihack_out($row["maintext"]); $city = str_antihack_out($row["city"]); $phone = str_antihack_out($row["phone"]); $site = str_antihack_out($row["site"]); $email = str_antihack_out($row["email"]); $cdate = $row["cdate"]; $cdate = substr($cdate, 0, strpos($cdate, " ")); echo("Сообщение от: ".$fio); if (!empty($city) && ($city != "")) { echo(" (".$city.") "); } if (!empty($phone) && ($phone != "")) { echo(" | тел.".$phone." "); } if (!empty($site) && ($site != "") && ($site != "http://")) { strpos($site, "http://")>-1 ? $site = $site : $site = "http://".$site; echo(" | ".$site." "); } if (!empty($email) && ($email != "")) { echo(" | ".$email." "); } echo(" [".$cdate."]
"); echo("
"); echo("

".$maintext."

"); echo("
"); echo("
"); $query = "SELECT * FROM metalboard_inform_comments WHERE access=1 AND catid={$catid}"; $result = mysql_query($query); $count = mysql_num_rows($result); $count = (int) ceil($count / $showCount); $page = 0; // echo("
Страницы:  "); for ($i=1; $i<=$count; $i++) { echo("".$i."  "); $page = $i * $showCount; } echo("
"); showForm('', '', '', '', '', '', ''); echo("
"); } } include($root_path . 'includes/page_footer.php'); ?>