View file äó¿ª«¬/modules/blogs/include.php

World Fastest and Cheapest Hosting
File size: 10.19Kb
<?php

/* Mixanza
 * Дата последнего редактирования 03.12.2017
 * Модифицировал Mixanza
 */
$time_blogs = time()-604800;
$k_post=$pdo->query(("SELECT COUNT(*) FROM `notes` WHERE `type` = '1' AND `metka` = '0' AND `block` = '0' AND `private` = '0' AND `time` > '".$time_blogs."'"),0)->fetchColumn();

$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$order='order by `count` desc';
$q = $pdo->query("SELECT * FROM `notes` WHERE `type` = '1' AND `metka` = '0' AND `block` = '0' AND `private` = '0' AND `time` > '".$time_blogs."' $order LIMIT 3");

$blogs = $pdo->query(("SELECT COUNT(*) FROM `notes`"),0)->fetchColumn();
if ($k_post != 0) {
    
echo "<div style='padding:7px; background-color: #FAFDFF;'>";       
 echo "<a href='/modules/blogs/?sort=c'><div class='link_info'><font color=#6E8394><b>ПОПУЛЯРНЫЕ БЛОГИ <span class='count_p' style=' color: #D0DFEB;'>$blogs</span> <span style='float: right;'><i class='fa fa-book fa-lg'></i></span></font></b></div></a>";
    
    
    
    
    
    
   while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
        $ank = get_user($post['id_user']);
        
       
$notes_type = $post['notes_type'];        
        
if($notes_type=='user'){        
        
        
        echo "<div class='list-group-item'>";

$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 ' : ';


echo "<a href='/modules/blogs/list.php?id=$post[id]'>" . 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 `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";    

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='/modules/blogs/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='/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-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>";





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

while ($posti2 = $files2->fetch(PDO::FETCH_ASSOC))
{

	

		
	if($posti2['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti2[id_user]' AND `id` = '".$posti2['id_foto']."'")->fetch(PDO::FETCH_BOTH);	
		if(isset($file_id['id'])){
		
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($posti2['type']=='foto_upload'){
	
	if(is_file(H.'sys/groups/foto/' . $posti2['id'] . '.jpg')){


if (IS_WEB == 1) {

	echo "<img class='avatar' src='/sys/groups/foto/" . $posti2['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/' . $posti2['id'] .'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;">';
     
 } 
   
			

	}


	}



}








echo "<br />\n";

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

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




}

}














echo "   </div>\n";}