View file ä󿪫¬/modules/blogs/search.php

<?
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
    require_once "../../sys/inc/$inc.php";
}



$set['title']='Поиск по блогам';
include_once '../../sys/inc/thead.php';
$ank=get_user($user['id']);
aut(); // форма авторизации

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltipecho' data-placement='right' title='" . lang('На главную') . "'><i class='fa fa-home fa-lg'></i></a> <i class='fa fa-angle-right fa-fw'></i> ";

echo "<a href='/modules/blogs/'>";
echo lang('Блоги');
echo "</a>";
echo " <i class='fa fa-angle-right fa-fw'></i> Поиск по блогам</div>";







$usearch=NULL;
if (isset($_SESSION['usearch']))$usearch=stripslashes(htmlspecialchars($_SESSION['usearch']));
if (isset($_POST['usearch']))$usearch=stripslashes(htmlspecialchars($_POST['usearch']));

if ($usearch==NULL)
unset($_SESSION['usearch']);
else
$_SESSION['usearch']=$usearch;
$usearch2=preg_replace("#( ){1,}#"," ",$usearch);
$order='order by `time` desc';

echo "<div class='list-group-item'>";
echo "<form action='search.php?go' method='post'>";
echo "<div class='input-group'>
<input type='text' name='usearch' class='form-control' placeholder='" . lang('Поиск записей') . "'>
<span class='input-group-btn'>
<button class='btn btn-secondary' type='submit'><i class='fa fa-search fa-fw'></i></button>
</span></div>";
echo "</form>";
echo "</div>";






if (isset($_GET['go']))
{
$usearch=preg_replace("#( ){1,}#","%",$usearch);
$k_post=$pdo->query(("SELECT COUNT(*) FROM `notes` where `name` like '%".stripslashes(htmlspecialchars($usearch))."%'"),0)->fetchColumn();
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=$pdo->query("SELECT * FROM `notes` WHERE `name` like '%".stripslashes(htmlspecialchars($usearch))."%' $order LIMIT $start, $set[p_str]");

if ($k_post==0)
{
$doc->NoResult();
}

while ($post = $q->fetch(PDO::FETCH_ASSOC))
{
$notes_type = $post['notes_type'];










if($notes_type=='user'){

echo '<div class="list-group-item">';
$ank = get_user($post['id_user']);
$frend = $pdo->query(("SELECT COUNT(*) FROM `friendsi` WHERE (`user` = '$user[id]' AND `friendsi` = '$ank[id]') OR (`user` = '$ank[id]' AND `friendsi` = '$user[id]') LIMIT 1"),0)->fetchColumn();


echo '<i class="fa fa-book fa-fw"></i> ';
echo user($post['id_user']);
echo ' : ';

if ($post['private']==1 && $user['id']!=$ank['id'] && $frend!=2)
{
 echo "<a href='/modules/blogs/list.php?id=$post[id]'>Запись доступна только друзьям автора</a>\n";   
}elseif ($post['private']==2 && $user['id']!=$ank['id'])
{ 
echo "<a href='/modules/blogs/list.php?id=$post[id]'>Автор закрыл запись от всех</a>\n";     
}else{  
if ($post['block']==0)
{
}else{
echo "<s>";   
}    
if($post['share']==1){
echo "<a href='/modules/blogs/list.php?id=$post[id]'>Поделился(-ась)</a>\n";    
    
}else{     
    
    
echo "<a href='/modules/blogs/list.php?id=$post[id]'>" . text($post['name']) . "</a>\n";}
if ($post['block']==0)
{
}else{
echo "</s>";   
}
}

echo "<span style='float: right;'>";
if ($post['private']==1 && $ank['id'] && $frend!=2)
{
echo "<i class='fa fa-users fa-fw'></i> ";}
if ($post['private']==2 && $ank['id'])
{
 echo "<i class='fa fa-lock fa-fw'></i> ";}   
echo "<font color=gray><small>".date::times($post['time'])."</small></font>";
echo "</span><br>";

if ($post['block']==0)
{

$files = $pdo->query("SELECT * FROM `notes_files` WHERE `id_post` = '$post[id]' LIMIT 3");

while ($posti = $files->fetch(PDO::FETCH_ASSOC))
{

	
	if($posti['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti[id_user]' AND `id` = '".$posti['id_file']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		
		
if (IS_WEB == 1) {

	echo "<img class='avatar' src='/modules/foto/foto50/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 85px; height:85px;'>\n";
}else{
	echo "<img class='avatar' src='/modules/foto/foto50/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
     
 }	}
		
		
		
	}elseif($posti['type']=='files'){
		$ras = htmlspecialchars(text($posti['ras']));

	if(is_file(H.'sys/blogs/files/'.$posti['id'].'.jpg')){

 if (IS_WEB == 1) {

	echo "<img class='avatar' src='/sys/blogs/files/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 85px; height:85px;'>\n";
}else{
	echo "<img class='avatar' src='/sys/blogs/files/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
     
 } 

			

	}


	}

}
}











echo "<br />\n";
if ($post['private']==1 && $user['id']!=$ank['id'] && $frend!=2)
{
echo "...\n";  
}elseif ($post['private']==2 && $user['id']!=$ank['id'])
{ 
echo "...\n";    
}else{    
if ($post['block']==0)
{
echo substr(text($post['msg']),0,80)." ...\n";    
}else{
echo "<div class='err'>Запись заблокирована</div>";   
}}
notes_sh($post['id']);

echo "<br />\n";

$cat = $pdo->query(("SELECT * FROM `notes_dir` WHERE `id` = '$post[id_dir]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

if($cat['id']==0){}else{
echo "<div style='text-align: right; padding: 0px;'><a href='/modules/blogs/dir.php?id=$cat[id]'><font color=#85A0AC><small><i class='fa fa-feed'></i> $cat[name]</small></font></a></div>";
}


echo "<br />\n";

if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$post['id']."' LIMIT 1"),0)->fetchColumn()==0){
$like=$pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<a href='list.php?id=$post[id]&amp;like=1'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Нравится') . "'>";
echo "<i class='fa fa-heart-o fa-fw'></i> $like</span></a> ";
}else{
$like=$pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<a href='list.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Понравилось') . "'>";
echo "<i class='fa fa-heart fa-fw'></i> $like</span></a> ";    
}
}

$pod=$pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='".$post['id']."' AND `share_type`='notes'"),0)->fetchColumn();

echo "<a href='/modules/blogs/share.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Поделиться') . "'>";
echo "<i class='fa fa-mail-forward fa-fw'></i> $pod</span></a> ";

$comm=$pdo->query(("SELECT COUNT(*) FROM `notes_komm` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<a href='/modules/blogs/list.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Комментарии') . "'>";
echo "<i class='fa fa-comments fa-fw'></i> $comm</span></a>";

$pr=$pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_notes`='$post[id]'"),0)->fetchColumn();
echo "<span style='float: right;'><a href='/modules/blogs/list.php?id=$post[id]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Просмотры') . "'>";
echo "<i class='fa fa-eye fa-fw'></i> $pr</span></a></span>";
echo "   </div>\n";

}

if($notes_type=='soo'){

echo '<div class="list-group-item">';

$ank = get_user($post['id_user']);
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$post[id_soo]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$news = $pdo->query(("SELECT * FROM `soo_news` WHERE `id` = '$post[id_news]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

echo '<i class="fa fa-book fa-fw"></i> ';
echo "<a href='/modules/groups/group.php?id=$post[id_soo]'><font color='#4B8085'><i class='fa fa-users fa-fw'></i></font> <font color='black'><b>$soo[name]</b></font></a>";
echo ' : ';


if ($post['block']==0)
{
}else{
echo "<s>";   
}    
echo "<a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]'>" . text($post['name']) . "</a>\n";

if ($post['block']==0)
{
}else{
echo "</s>";   
}



echo "<span style='float: right;'>";
if ($post['private']==1 && $ank['id'] && $frend!=2)
{
echo "<i class='fa fa-users fa-fw'></i> ";}
if ($post['private']==2 && $ank['id'])
{
 echo "<i class='fa fa-lock fa-fw'></i> ";}   
echo "<font color=gray><small>".date::times($post['time'])."</small></font>";
echo "</span><br>";









if ($post['block']==0)
{

$files = $pdo->query("SELECT * FROM `soo_news_foto` WHERE `id_news` = '$post[id_news]' LIMIT 3");

while ($posti = $files->fetch(PDO::FETCH_ASSOC))
{

	
	if($posti['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti[id_user]' AND `id` = '".$posti['id_foto']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		
		
if (IS_WEB == 1) {

	echo "<img class='avatar' src='/modules/foto/foto50/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 85px; height:85px;'>\n";
}else{
	echo "<img class='avatar' src='/modules/foto/foto50/".$file_id['id'].".".$file_id['ras']."' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
     
 }	}
		
		
		
	}elseif($posti['type']=='foto_upload'){
		$ras = htmlspecialchars(text($posti['ras']));

	if(is_file(H.'sys/groups/foto/' . $posti['id'] . '.jpg')){


 if (IS_WEB == 1) {

	echo "<img class='avatar' src='/sys/groups/foto/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 85px; height:85px;'>\n";
}else{
	echo "<img class='avatar' src='/sys/groups/foto/" . $posti['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
     
 } 

			

	}


	}

}

}











echo "<br />\n";
if ($post['private']==1 && $user['id']!=$ank['id'] && $frend!=2)
{
echo "...\n";  
}elseif ($post['private']==2 && $user['id']!=$ank['id'])
{ 
echo "...\n";    
}else{    

if ($post['block']==0)
{
echo substr(text($post['msg']),0,80)." ...\n";    
}else{
echo "<div class='err'>Запись заблокирована</div>";   
}    
    
}
notes_sh($post['id']);

echo "<br />\n";

$cat = $pdo->query(("SELECT * FROM `notes_dir` WHERE `id` = '$post[id_dir]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

if($cat['id']==0){}else{
echo "<div style='text-align: right; padding: 0px;'><a href='/modules/blogs/dir.php?id=$cat[id]'><font color=#85A0AC><small><i class='fa fa-feed'></i> $cat[name]</small></font></a></div>";
}


echo "<br />\n";

if (isset($user)){
if ($pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$post[id_news]' AND `type` = 'soo_newsl' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0){
echo "<a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]&like=1'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Нравится') . "'>";
echo "<i class='fa fa-heart-o fa-fw'></i> ".$pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$post[id_news]' AND `type` = 'soo_newsl' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";
}else{
echo "<a href='/modules/groups/news/list.php?id=".htmlspecialchars($soo['id'])."&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Понравилось') . "'>";
echo "<i class='fa fa-heart fa-fw'></i> ".$pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$post[id_news]' AND `type` = 'soo_newsl' AND `like` = '1'"),0)->fetchColumn()."</span></a> ";    
}
}

$pod=$pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='$post[id_news]' AND `share_type`='soo_news'"),0)->fetchColumn();

echo "<a href='/modules/groups/news/share.php?id=$post[id_soo]&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Поделиться') . "'>";
echo "<i class='fa fa-mail-forward fa-fw'></i> $pod</span></a> ";

$comm=$pdo->query(("SELECT COUNT(*) FROM `soo_news_komm` WHERE `id_news`='$post[id_news]'"),0)->fetchColumn();
echo "<a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Комментарии') . "'>";
echo "<i class='fa fa-comments fa-fw'></i> $comm</span></a>";

echo "<span style='float: right;'><a href='/modules/groups/news/list.php?id=$post[id_soo]&id_news=$post[id_news]'><span class='btn btn-info-outline btn-sm hint--top' data-hint='" . lang('Просмотры') . "'>";
echo "<i class='fa fa-eye fa-fw'></i> $post[count]</span></a></span>";
echo "   </div>\n";

}






}















if ($k_page>1){
echo '<div class="list-group-item">';    
    echo str('?go&amp;',$k_page,$page); // Вывод страниц
echo '</div>';    
}

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