View file search.php

<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
/* Бан пользователя */ 
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `ban` WHERE `razdel` = 'notes' AND `id_user` = '$user[id]' AND (`time` > '$time' OR `view` = '0' OR `navsegda` = '1')"), 0)!=0)
{
header('Location: /ban.php?'.SID);exit;
}
$set['title']='Поиск кодов';
include_once '../sys/inc/thead.php';

title();
aut(); // форма авторизации





$usearch=NULL;
if (isset($_SESSION['usearch']))$usearch=$_SESSION['usearch'];
if (isset($_POST['usearch']))$usearch=$_POST['usearch'];

if ($usearch==NULL)
unset($_SESSION['usearch']);
else
$_SESSION['usearch']=$usearch;
$usearch=preg_replace("#( ){1,}#","",$usearch);

$order='order by `time` desc';echo "<form method=\"post\" action=\"search.php?go\">Поиск по кодам<br />";
$usearch=stripcslashes(htmlspecialchars($usearch));
echo "<input type=\"text\" name=\"usearch\" maxlength=\"16\" value=\"$usearch\" /><br />\n";
echo "<input type=\"submit\" value=\"Искать\" />";
echo "</form>\n";


if (isset($_GET['go']))
{
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `codes` where `name` like '%".mysql_escape_string($usearch)."%'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=mysql_query("SELECT * FROM `codes` WHERE `name` like '%".mysql_escape_string($usearch)."%' $order LIMIT $start, $set[p_str]");
echo "<table class='post'>\n";
if ($k_post==0)
{
echo "<div class='mess'>\n";
echo "Нет кодов\n";
echo "</div>\n";
}
$num=0;
while ($res = mysql_fetch_assoc($q))
{
/*-----------зебра-----------*/ 
	if ($num==0){
		echo '<div class="nav1">';
		$num=1;
	}
	elseif ($num==1){
		echo '<div class="nav2">';
		$num=0;
	}
/*---------------------------*/

$us=get_user($res['id_user']);

echo '<div class="main_menu">';
echo '<img src="img/user.png"><a href="/info.php?id='.$res['id_user'].'"><font color="black"> <b>'.$us['nick'].'</b></font> <a/>: <a href="code.php?id='.$res['id'].'"> '.$res['name'].'</a> [<font color="green"><b>'.$res['rating'].'</b></font>]<br/>';
echo '</div>';
}
echo "</table>\n";

if ($k_page>1)str('?go&amp;',$k_page,$page); // Вывод страниц

}
echo '<div class="foot"><img src="/style/icons/str2.gif"> <a href="index.php?">Назад</a></div>';

include_once '../sys/inc/tfoot.php';
?>