View file ä󿪫¬/modules/blogs/vse.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';
if (isset($user))$ank['id']=$user['id'];
if (isset($_GET['id']))$ank['id']=intval($_GET['id']);
$ank=get_user($ank['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/'>все Блоги</a>";
echo "</div>";



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>";










echo'<div style="padding: 4px; background-color: white;">';
echo'<table cellspacing="0" cellpadding="0" width="100%">';



echo "<table style='width: 100%; text-align: center;'><tr>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='index.php?sort=t'><font color=#587C94><b>НОВЫЕ</b></font></a></td>
<td class='fn-centeri'><a style='display: block;padding: 10px;' href='index.php?sort=c'><b><font color=#587C94>ТОП</font></b></a></td>
<td class='fn-lefti'><a style='display: block;padding: 10px;' href='dir.php'><b><font color=#587C94>КАТЕГОРИИ</font></b></a></td>
<td class='fn-righti-o'><a style='display: block;padding: 10px;' href='vse.php'><b><font color=#587C94>ВСЕ</font></b></a></td>

</tr></table>";

echo'</table></div>';


if(isset($user) && $user['id']==$ank['id'])
{
echo "<div class='list-group-item'>";    
 $doc->Link('btn btn-primary btn-sm', "add.php", 'plus', 'Создать запись');  
 $doc->Link('btn btn-secondary btn-sm', "user.php", 'book', 'Мои записи'); 
echo "</div>";      
}

$order='order by `time` desc';



$k_post=$pdo->query(("SELECT COUNT(*) FROM `notes` WHERE `block` = '0' AND `private` = '0'"),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 `block` = '0' AND `private` = '0' $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['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]&cat=$post[id_dir]'>" . text($post['name']) . "</a>\n";}

if ($post['metka'] == 1)echo ' <span style="border: 1px #AEB6BD solid; border-radius: 3px; color: red;"><small><b>18+</b></small></span> ';

echo "<span style='float: right;'>";
echo "<font color=gray><small>".date::times($post['time'])."</small></font>";
echo "</span><br>";






$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/foto128/".$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/foto128/".$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";

echo mb_substr($post['msg'],0,50,'UTF-8')."...\n";     

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){
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 ' : ';

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




echo "<span style='float: right;'>";
echo "<font color=gray><small>".date::times($post['time'])."</small></font>";
echo "</span><br>";




$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/foto128/".$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/foto128/".$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";
  

echo mb_substr($post['msg'],0,50,'UTF-8')."...\n";    

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 (isset($_GET['sort'])) $dop="sort=$_GET[sort]&amp;";
else $dop='';

if ($k_page>1){
echo '<div class="list-group-item">';    
str('?'.$dop.'',$k_page,$page); // Вывод страниц
echo "</div>";    
}
include_once '../../sys/inc/tfoot.php';
?>