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

<?php

/* Mixanza
 * Дата последнего редактирования 03.12.2017
 * Модифицировал Mixanza
 */

$time_blogs = time()-432000;
$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:5px; background-color: #FAFDFF;'>";       
 echo "<a href='/modules/blogs/?sort=c'><div class='link_p' style='padding: 5px;'><font color=#6E8394><b>ПОПУЛЯРНЫЕ БЛОГИ <span class='count_p' style=' color: #D0DFEB;'>$blogs</span> <span style='float: right;'><i class='fa fa-book'></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 ' : ';
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";
}
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/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";
echo utf8_substr(text($post['msg']),50)."\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>";


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

while ($posti22 = $files22->fetch(PDO::FETCH_ASSOC))
{

	
	if($posti22['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$posti22[id_user]' AND `id` = '".$posti22['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($posti22['type']=='foto_upload'){
if(is_file(H.'sys/groups/foto/' . $posti22['id'] . '.jpg')){
if (IS_WEB == 1) {
echo "<img class='avatar' src='/sys/groups/foto/" . $posti22['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/" . $posti22['id'] . ".jpg' style='border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;width: 70px; height: 70px;'>\n";
} 
}			



	}

}











echo "<br />\n";

echo utf8_substr(text($post['msg']),50)."\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 `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";}