Файл: vsime.com/search/inc/act_comms.php
Строк: 40
<?
$title .= ' - Поиск сообществ';
ex_head();
$query = NULL;
if (isset($_GET['query']))$query = esc(stripcslashes(hsc(search_str($_GET['query']))));
if (isset($_POST['query']))$query = esc(stripcslashes(hsc(search_str($_POST['query']))));
if (trim($query)) {
$count_results = mysqli_result("SELECT COUNT(*) FROM `comm` WHERE `name` LIKE '%".my_esc($query)."%'");
$count_pages = navi :: count_pages($count_results);
$page = navi :: page();
$start = navi :: start_pages();
$query_db = mysqli_query($dbi, "SELECT * FROM `comm` WHERE `name` LIKE '%".my_esc($query)."%' ORDER BY `id` DESC LIMIT $start, $config[rop]");
while ($post = mysqli_fetch_array($query_db)) {
echo "<div class='list'>n";
echo "<img src='/i/site/comm.png' /> <a href='/comm/?act=comm&id=$post[id]'".title_link('Открыть сообщество').">".htmlspecialchars($post['name'])."</a> (".mysqli_result("SELECT COUNT(*) FROM `comm_users` WHERE `id_comm` = '$post[id]' AND `invite` = '0' AND `activate` = '1'").") <img src='/i/site/comm_".($post['read_rule']==1?"open":"closed").".png' /><br/>".($post['desc']!=NULL?output_text($post['desc'], $post['id_user']).'<br/>':NULL);
echo "</div>n";
}
navi :: pages_show("?act=comms&query=$query&"); // Вывод страниц
} else {
$show_word = true;
}
echo "<div class=list><form method='POST' action='?act=comms'>n";
if (isset($show_word))echo "Что будем искать?<br />n";
else {
echo "<b>Поиск:</b> «".($query)."»<br />";
}
echo "<input type='text' style='width: 65%; margin: 0px; padding: 4px 0px; vertical-align: middle;line-height: 100%;border: 1px solid #ccc;' name='query' value='' />n";
echo "<input type='submit' name='submited' style='line-height: 19px; margin-top: 0;' value='Найти'/>n";
echo "</div>n";
echo "</form>n";
echo "<div class='foot'>n";
echo image_back()."<a href='?query=$query'>Назад</a>n";
echo "</div>n";
ex_foot();
?>