View file sots-syet-livebook/plugins/notes/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(); // форма авторизации

?>
<style>
* {box-sizing: border-box;}
form {
  position: relative;
  margin: 0 auto;
}
button {
position: absolute;
    top: 3px;
    right: 0px;
    width: 42px;
    height: 37px;
    border: none;
    background: #ffffff;
    border-radius: 0 5px 5px 0;
    cursor: pointer;
    border: 1px solid #d0d0d0;
}
button:before {
  content: "\f002";
  font-family: FontAwesome;
  font-size: 16px;
  color: #d0d0d0;
}
</style>
<?

$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 '<div class="mess">';
echo "<form method=\"post\" action=\"search.php?go\">";
$usearch=stripcslashes(htmlspecialchars($usearch));
echo "<input style='background: white; border: 1px solid #d0d0d0;width: 91%;border-radius: 3px 0px 0px 3px;' placeholder='Введите текст для поиска...' type=\"text\" name=\"usearch\" maxlength=\"16\" value=\"$usearch\" /><br />\n";
echo '<button type="submit"></button>';
echo "</form>\n";
echo '</div>';

if (isset($_GET['go']))
{
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes` where `name` like '%".mysql_real_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 `notes` WHERE `name` like '%".mysql_real_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 ($post = mysql_fetch_assoc($q))
{

echo '<div style="margin-top:10px;border-radius: 3px 3px 0px 0px;border-bottom: 0;" class="mess">';

echo '<span style="float: left; margin: -3px 5px 0px 0px;">' .avatar($post['id']).'</span>';
echo group($post['id']);
echo " ".user::nick($post['id'])."";
echo '' . online($post['id']) . '</br>';
echo "Добавлено ".vremja($post['time'])."</br></br>";

echo "<a href='/plugins/notes/list.php?id=".$post['id']."'><font color='#757577'>".text($post['name'])."</font></a></br>";
echo rez_text($post['msg'],80)." <br/>\n";
notes_sh($post['id']);
echo '</br>';

echo "<span style='font-size: 9px; color: #bbbbbb;'><img src='/style/icons/smotr.png'> ".$post['count']."</span>";
echo '<span style="float:right;">';
echo "<span style='font-size: 9px; color: #bbbbbb;'><img src='/style/icons/kom.png'> ".mysql_result(mysql_query("SELECT COUNT(`id`)FROM `notes_komm` WHERE `id_notes`='$post[id]'"),0)."</span> ";
$l1=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '0' AND `id_notes` = '".$post['id']."' LIMIT 1"),0);
$l2=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '1' AND `id_notes` = '".$post['id']."' LIMIT 1"),0);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)==0)
echo "<span style='font-size: 9px; color: #bbbbbb;'><img src='/style/icons/like2.png'>  ".($l2-$l1)."</span>";
echo '</div>';

}
echo "</table>\n";

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

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