<?
$k_post = $count_forum;
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
/////Поиск по форуму
$zapros="SELECT * FROM `forum_t` WHERE `name` LIKE '%".$word[0]."%' OR `text` LIKE '%".$word[0]."%'";
$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `text` LIKE '%".strtolower($word[0])."%'";
$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `text` LIKE '%".rasklad($word[0])."%'";
$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `text` LIKE '%".trans($word[0])."%'";
$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `text` LIKE '%".retrans($word[0])."%'";
if(count($word)>1)
{
for($i=1;$i<=count($word)-1;$i++)
{
$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `text` LIKE '%".$word[$i]."%'";
$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `text` LIKE '%".strtolower($word[$i])."%'";
$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `text` LIKE '%".rasklad($word[$i])."%'";
$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `text` LIKE '%".trans($word[$i])."%'";
$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `text` LIKE '%".retrans($word[$i])."%'";
}
}
$zapros.= " LIMIT ".$start.", ".$set['p_str'];
////Форма поиска
echo'<div class="main_menu" style="text-align:center;">Поиск по форуму<br>
<form method="GET" action="/search/">
<table style="width:100%" border="0" cellspacing="0" cellpadding="0"><tr>
<td style="width:"90%">
<input style="padding:8px;display:block;width:100%;border-radius:5px 0px 0px 5px;border:1px solid #BEBEBE" type="text" name="words" value="'.(isset($words)?stripcslashes($words):NULL).'">
<input type="hidden" name="forum" value="">
</td>
<td style="width:"30px">
<input accesskey="enter" style="opacity:1;moz-opacity:1;filter: alpha(opacity=100) black;cursor:pointer;cursor: hand; padding:8px 15px 8px 15px;background-color:#000000;background: transparent url(/search.png) no-repeat right 35% center;border:0;display:block;width:100%;border-radius:0px 5px 5px 0px;border-left:0px solid #BEBEBE;border-top:1px solid #BEBEBE;border-bottom:1px solid #BEBEBE;border-right:1px solid #BEBEBE" type="submit" value=""></td>
</tr></table>
</form>
</div>';
echo '<table class="post">';
if ($k_post == 0)
{
echo '<div class="mess">';
echo 'По вашему запросу ничего не найдено';
echo '</div>';
}
$q = mysql_query($zapros);
while ($them = mysql_fetch_assoc($q))
{
$forum = mysql_fetch_array(mysql_query("SELECT * FROM `forum_f` WHERE `id` = '$them[id_forum]' LIMIT 1"));
$razdel = mysql_fetch_array(mysql_query("SELECT * FROM `forum_r` WHERE `id` = '$them[id_razdel]' LIMIT 1"));
if ($num == 0)
{
echo '<div class="nav1">';
$num = 1;
}
elseif ($num == 1)
{
echo '<div class="nav2">';
$num = 0;
}
echo '<img src="/style/themes/' . $set['set_them'] . '/forum/14/them_' . $them['up'] . $them['close'] . '.png" alt="" /> ';
echo '<a href="/forum/' . $forum['id'] . '/' . $razdel['id'] . '/' . $them['id'] . '/">' . text($them['name']) . '</a>
<a href="/forum/' . $forum['id'] . '/' . $razdel['id'] . '/' . $them['id'] . '/?page=' . $pageEnd . '">
(' . mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = '$forum[id]' AND `id_razdel` = '$razdel[id]' AND `id_them` = '$them[id]'"),0) . ')</a><br/>';
$ank = get_user($them['id_user']);
echo 'Автор: <a href="/info.php?id=' . $ank['id'] . '">' . $ank['nick'] . '</a> (' . vremja($them['time_create']) . ')
';
$post = mysql_fetch_array(mysql_query("SELECT * FROM `forum_p` WHERE `id_them` = '$them[id]' AND `id_razdel` = '$razdel[id]' AND `id_forum` = '$forum[id]' ORDER BY `time` DESC LIMIT 1"));
if (isset($post['id_user']))
{
$ank2 = get_user($post['id_user']);
echo 'Посл.: <a href="/info.php?id=' . $ank2['id'] . '">' . $ank2['nick'] . '</a> (' . vremja($post['time']) . ')
';
}
echo '</div>';
}
echo '</table>';
if ($k_page>1)str("/search/?words=".$words."&forum".(isset($check) && $check===TRUE?'&check=da':NULL)."&",$k_page,$page);
echo'<div class="foot">← <a href="/search/?words='.$words.'">К результатам поиска</a></div>';
include_once '../sys/inc/tfoot.php';