<?
$k_post = $count_book;
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
//////Поиск книг
$zapros="SELECT * FROM `obmennik_files` WHERE (`ras` = 'doc' OR `ras` = 'txt' OR `ras` = 'pdf' OR `ras` = 'pptx' OR `ras` = 'docx' OR `ras` = 'fb2' OR `ras` = 'epub' OR `ras` = 'rtf')
AND ( `name` LIKE '%".$word[0]."%' OR `opis` LIKE '%".$word[0]."%'";
$zapros.=" OR `name` LIKE '%".strtolower($word[0])."' OR `opis` LIKE '%".strtolower($word[0])."%'";
$zapros.=" OR `name` LIKE '%".rasklad($word[0])."' OR `opis` LIKE '%".rasklad($word[0])."%'";
$zapros.=" OR `name` LIKE '%".trans($word[0])."' OR `opis` LIKE '%".trans($word[0])."%'";
$zapros.=" OR `name` LIKE '%".retrans($word[0])."' OR `opis` LIKE '%".retrans($word[0])."%'";
if(count($word)>1)
{
for($i=1;$i<=count($word)-1;$i++)
{
$zapros.=" OR `name` LIKE '%".$word[$i]."' OR `opis` LIKE '%".$word[$i]."%'";
$zapros.=" OR `name` LIKE '%".strtolower($word[$i])."' OR `opis` LIKE '%".strtolower($word[$i])."%'";
$zapros.=" OR `name` LIKE '%".rasklad($word[$i])."' OR `opis` LIKE '%".rasklad($word[$i])."%'";
$zapros.=" OR `name` LIKE '%".trans($word[$i])."' OR `opis` LIKE '%".trans($word[$i])."%'";
$zapros.=" OR `name` LIKE '%".retrans($word[$i])."' OR `opis` LIKE '%".retrans($word[$i])."%'";
}
}
$zapros.=') '.(isset($check) && $check===TRUE?" AND `metka` = '0' ":NULL);
$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="book" 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>
<div style="text-align:left"><input type="checkbox" name="check" value="da" '.(isset($check) && $check===TRUE?'checked':NULL).'>Не показывать файлы 18+</div>
</form>
</div>';
echo '<table class="post">';
if ($k_post == 0)
{
echo '<div class="mess">';
echo 'По вашему запросу ничего не найдено';
echo '</div>';
}
$q = mysql_query($zapros);
while ($post = mysql_fetch_assoc($q))
{
$dir_id = mysql_fetch_array(mysql_query("SELECT * FROM `obmennik_dir` WHERE `id` = '".$post['id_dir']."' LIMIT 1"));
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `obmennik_komm` WHERE `id_file` = '$post[id]'"),0);
$ras=$post['ras'];
$file=H."sys/obmen/files/$post[id].dat";
$name=$post['name'];
$size=$post['size'];
if ($num==0){
echo '<div class="nav1">';
$num=1;
}
elseif ($num==1){
echo '<div class="nav2">';
$num=0;}
include H.'obmen/inc/icon48.php';if (is_file(H.'style/themes/'.$set['set_them'].'/loads/14/'.$ras.'.png'))
echo "<img src='/style/themes/$set[set_them]/loads/14/$ras.png' alt='$ras' /> \n";
else
echo "<img src='/style/themes/$set[set_them]/loads/14/file.png' alt='file' /> \n";
if ($set['echo_rassh']==1)$ras=$post['ras'];else $ras=NULL;
echo '<a href="/obmen'.$dir_id['dir'] . $post['id'].'.'.$post['ras'].'?showinfo"><b>'.htmlspecialchars($post['name']).'.'.$ras.'</b></a> ('.size_file($post['size']).') ';
if ($post['metka'] == 1)echo '<font color=red><b>(18+)</b></font> ';
echo '<br />';
if ($post['opis'])echo rez_text(htmlspecialchars($post['opis'])).'<br />';
echo '<a href="/obmen'.$dir_id['dir'] . $post['id'].'.'.$post['ras'].'?showinfo&komm">Комментарии</a> ('.$k_p.')<br />';
echo '</div>';
}
echo '</table>';
if ($k_page>1)str("/search/?words=".$words."&book".(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';