View file plugins/notes/search.php

<?php
require( '../../sys/inc/core.php' );
if ( isset( $user ) && db::count("SELECT COUNT(*) FROM `ban` WHERE `razdel` = 'notes' AND `id_user` = '$user[id]' AND (`time` > '$time' OR `view` = '0' OR `navsegda` = '1')") != 0 ) {
    header( 'Location: /ban.php?' . SID );
    exit;
}
$set['title'] = 'Дневники';
include_once '../../sys/inc/thead.php';
title();
aut();
echo "<div id='comments' class='menus'>";
echo "<div class='webmenu'>";
echo "<a href='index.php' >Дневники</a>";
echo "</div>";
echo "<div class='webmenu last'>";
echo "<a href='dir.php'>Категории</a>";
echo "</div>";
echo "<div class='webmenu'>";
echo "<a href='search.php' class='activ'>Поиск</a>";
echo "</div>";
echo "</div>";
$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 = db::count("SELECT COUNT(*) FROM `notes` where `name` like '%" . db::esc( $usearch ) . "%'");
    $k_page = k_page( $k_post, $set['p_str'] );
    $page   = page( $k_page );
    $start  = $set['p_str'] * $page - $set['p_str'];
    $q      = db::query("SELECT * FROM `notes` WHERE `name` like '%" . db::esc( $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 =  $q->fetch_assoc() ) {
        if ( $num == 0 ) {
            echo '<div class="nav1">';
            $num = 1;
        } elseif ( $num == 1 ) {
            echo '<div class="nav2">';
            $num = 0;
        }
        echo "<img src='/style/icons/dnev.png' alt='*'> ";
        echo "<a href='list.php?id=$post[id]'>" . text( $post['name'] ) . "</a> \n";
        echo " <span style='time'>(" . vremja( $post['time'] ) . ")</span>\n";
        $k_n = db::count("SELECT COUNT(*) FROM `notes` WHERE `id` = $post[id] AND `time` > '" . $ftime . "'");
        if ( $k_n != 0 )
            echo " <img src='/style/icons/new.gif' alt='*'>";
        echo "  </div>\n";
    }
    echo "</table>\n";
    if ( $k_page > 1 )
        str( '?go&amp;', $k_page, $page );
}
include_once '../../sys/inc/tfoot.php';
?>