Размер файла: 11.51Kb
<?php
#-----------------------------------------------------#
# ********* ROTORCMS ********* #
# Made by : VANTUZ #
# E-mail : [email protected] #
# Site : http://pizdec.ru #
# WAP-Site : http://visavi.net #
# ICQ : 36-44-66 #
# Вы не имеете право вносить изменения в код скрипта #
# для его дальнейшего распространения #
#-----------------------------------------------------#
require_once ('../includes/start.php');
require_once ('../includes/functions.php');
require_once ('../includes/header.php');
include_once ('../themes/' . $config['themes'] . '/index.php');
$config['blogpost'] = 10;
if (isset($_GET['act'])) {
$act = check($_GET['act']);
} else {
$act = 'index';
}
if (isset($_GET['start'])) {
$start = abs(intval($_GET['start']));
} else {
$start = 0;
}
show_title('site.png', 'Поиск в блогах');
if (is_user()) {
switch ($act):
# ###########################################################################################
# # Главная поиска ##
# ###########################################################################################
case "index":
$config['newtitle'] = 'Поиск в скриптах';
echo '<div class="form"><form action="search.php?act=search&' . SID . '" method="post">';
echo 'Запрос:<br />';
echo '<input type="text" name="find" /><br />';
echo 'Искать:<br />';
echo '<input name="where" type="radio" value="0" checked="checked" /> В заголовке<br />';
echo '<input name="where" type="radio" value="1" /> В тексте<br /><br />';
echo 'Тип запроса:<br />';
echo '<input name="type" type="radio" value="0" checked="checked" /> И<br />';
echo '<input name="type" type="radio" value="1" /> Или<br />';
echo '<input name="type" type="radio" value="2" /> Полный<br /><br />';
echo '<input type="submit" value="Поиск" /></form></div><br />';
break;
# ###########################################################################################
# # Поиск ##
# ###########################################################################################
case "search":
if (isset($_POST['find'])) {
$_SESSION['find'] = check(trim($_POST['find']));
$_SESSION['findresult'] = '';
}
if (isset($_POST['type'])) {
$type = abs(intval($_POST['type']));
} else {
$type = abs(intval($_GET['type']));
}
if (isset($_POST['where'])) {
$where = abs(intval($_POST['where']));
} else {
$where = abs(intval($_GET['where']));
}
if (utf_strlen($_SESSION['find']) < 50) {
$findme = rus_utf_tolower($_SESSION['find']);
$findmewords = explode(" ", $findme);
$find = array();
foreach ($findmewords as $valfind) {
if (utf_strlen($valfind) >= 3) {
$find[] = $valfind;
}
}
array_splice($find, 3);
if (count($find) > 0) {
$config['newtitle'] = $_SESSION['find'] . ' - Результаты поиска';
$types = (empty($type)) ? 'AND' : 'OR';
$wheres = (empty($where)) ? 'title' : 'text';
// ----------------------------- Поиск в названии -------------------------------//
if ($wheres == 'title') {
echo 'Поиск запроса <b>"' . $_SESSION['find'] . '"</b> в заголовке<br />';
if ($type == 2) {
$find[0] = $findme;
}
$search1 = (isset($find[1]) && $type != 2) ? $types . " `blogs_title` LIKE '%" . $find[1] . "%'" : '';
$search2 = (isset($find[2]) && $type != 2) ? $types . " `blogs_title` LIKE '%" . $find[2] . "%'" : '';
if (empty($_SESSION['findresult'])) {
$querysearch = DB :: $dbh -> query("SELECT `blogs_id` FROM `blogs` WHERE `blogs_title` LIKE '%" . $find[0] . "%' " . $search1 . " " . $search2 . " LIMIT 500;");
$result = $querysearch -> fetchAll(PDO :: FETCH_COLUMN);
$_SESSION['findresult'] = $result;
}
$total = count($_SESSION['findresult']);
if ($total > 0) {
if ($start >= $total) {
$start = 0;
}
echo 'Найдено совпадений: <b>' . $total . '</b><br /><br />';
$result = implode(',', $_SESSION['findresult']);
$queryblog = DB :: $dbh -> query("SELECT `blogs`.*, `cats_id`, `cats_name` FROM `blogs` LEFT JOIN `catsblog` ON `blogs`.`blogs_cats_id`=`catsblog`.`cats_id` WHERE `blogs_id` IN (" . $result . ") ORDER BY `blogs_time` DESC LIMIT " . $start . ", " . $config['blogpost'] . ";");
while ($data = $queryblog -> fetch()) {
if ($data['blogs_rating'] > 0) {
$data['blogs_rating'] = '<span style="color:#00aa00">+' . $data['blogs_rating'] . '</span>';
}
if ($data['blogs_rating'] < 0) {
$data['blogs_rating'] = '<span style="color:#ff0000">' . $data['blogs_rating'] . '</span>';
}
echo '<div class="b"><img src="../images/img/edit.gif" alt="image" /> ';
echo '<b><a href="blog.php?act=view&id=' . $data['blogs_id'] . '&' . SID . '">' . $data['blogs_title'] . '</a></b> (' . $data['blogs_rating'] . ')</div>';
echo '<div>Категория: <a href="blog.php?cid=' . $data['cats_id'] . '&' . SID . '">' . $data['cats_name'] . '</a><br />';
echo 'Просмотров: ' . $data['blogs_read'] . '<br />';
echo 'Автор: <a href="../pages/anketa.php?uz=' . $data['blogs_user'] . '&' . SID . '">' . nickname($data['blogs_user']) . '</a> (' . date_fixed($data['blogs_time']) . ')</div>';
}
page_strnavigation('search.php?act=search&type=' . $type . '&where=' . $where . '&', $config['blogpost'], $start, $total);
} else {
show_error('По вашему запросу ничего не найдено!');
}
}
// --------------------------- Поиск в текте -------------------------------//
if ($wheres == 'text') {
echo 'Поиск запроса <b>"' . $_SESSION['find'] . '"</b> в тексте<br />';
if ($type == 2) {
$find[0] = $findme;
}
$search1 = (isset($find[1]) && $type != 2) ? $types . " `blogs_text` LIKE '%" . $find[1] . "%'" : '';
$search2 = (isset($find[2]) && $type != 2) ? $types . " `blogs_text` LIKE '%" . $find[2] . "%'" : '';
if (empty($_SESSION['findresult'])) {
$querysearch = DB :: $dbh -> query("SELECT `blogs_id` FROM `blogs` WHERE `blogs_text` LIKE '%" . $find[0] . "%' " . $search1 . " " . $search2 . " LIMIT 500;");
$result = $querysearch -> fetchAll(PDO :: FETCH_COLUMN);
$_SESSION['findresult'] = $result;
}
$total = count($_SESSION['findresult']);
if ($total > 0) {
if ($start >= $total) {
$start = 0;
}
echo 'Найдено совпадений: <b>' . $total . '</b><br /><br />';
$result = implode(',', $_SESSION['findresult']);
$queryblog = DB :: $dbh -> query("SELECT `blogs`.*, `cats_id`, `cats_name` FROM `blogs` LEFT JOIN `catsblog` ON `blogs`.`blogs_cats_id`=`catsblog`.`cats_id` WHERE `blogs_id` IN (" . $result . ") ORDER BY `blogs_time` DESC LIMIT " . $start . ", " . $config['blogpost'] . ";");
while ($data = $queryblog -> fetch()) {
if ($data['blogs_rating'] > 0) {
$data['blogs_rating'] = '<span style="color:#00aa00">+' . $data['blogs_rating'] . '</span>';
}
if ($data['blogs_rating'] < 0) {
$data['blogs_rating'] = '<span style="color:#ff0000">' . $data['blogs_rating'] . '</span>';
}
echo '<div class="b"><img src="../images/img/edit.gif" alt="image" /> ';
echo '<b><a href="blog.php?act=view&id=' . $data['blogs_id'] . '&' . SID . '">' . $data['blogs_title'] . '</a></b> (' . $data['blogs_rating'] . ')</div>';
if (utf_strlen($data['blogs_text']) > 200) {
$data['blogs_text'] = strip_tags(bb_code($data['blogs_text']), '<br>');
$data['blogs_text'] = utf_substr($data['blogs_text'], 0, 200) . '...';
}
echo '<div>' . $data['blogs_text'] . '<br />';
echo 'Категория: <a href="blog.php?cid=' . $data['cats_id'] . '&' . SID . '">' . $data['cats_name'] . '</a><br />';
echo 'Автор: <a href="../pages/anketa.php?uz=' . $data['blogs_user'] . '&' . SID . '">' . nickname($data['blogs_user']) . '</a> (' . date_fixed($data['blogs_time']) . ')</div>';
}
page_strnavigation('search.php?act=search&type=' . $type . '&where=' . $where . '&', $config['blogpost'], $start, $total);
} else {
show_error('По вашему запросу ничего не найдено!');
}
}
} else {
show_error('Ошибка! Необходимо не менее 3-х символов в слове!');
}
} else {
show_error('Ошибка! Запрос должен содержать не более 50 символов!');
}
echo '<img src="../images/img/back.gif" alt="image" /> <a href="search.php?' . SID . '">Вернуться</a><br />';
break;
default:
header("location: search.php?" . SID);
exit;
endswitch;
} else {
show_login('Вы не авторизованы, чтобы использовать поиск, необходимо');
}
echo '<img src="../images/img/reload.gif" alt="image" /> <a href="index.php?' . SID . '">К блогам</a><br />';
echo '<img src="../images/img/homepage.gif" alt="image" /> <a href="../index.php?' . SID . '">На главную</a>';
include_once ('../themes/' . $config['themes'] . '/foot.php');
?>