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

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




$notes = $pdo->query("SELECT * FROM `notes` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if (!isset($notes['id']))
{
	header('Location: index.php');
	exit;
}

$avtor=get_user($notes['id_user']);









if (isset($user))
$count = $pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_user` = '".intval($user['id'])."' AND `id_notes` = '".intval($notes['id'])."' LIMIT 1"),0)->fetchColumn();

 // Закладки
$markinfo = $pdo->query(("SELECT COUNT(*) FROM `mark_notes` WHERE `id_list` = '".intval($notes['id'])."'"),0)->fetchColumn();


// Запись просмотра
if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_user` = '".intval($user['id'])."' AND `id_notes` = '".intval($notes['id'])."' LIMIT 1"),0)->fetchColumn()==0){
$pdo->query("INSERT INTO `notes_count` (`id_notes`, `id_user`) VALUES ('".intval($notes['id'])."', '".intval($user['id'])."')")->fetchColumn();
$pdo->query("UPDATE `notes` SET `count` = '".($notes['count']+1)."' WHERE `id` = '".intval($notes['id'])."' LIMIT 1")->fetchColumn();
}




$set['title']='Запись - ' . text($notes['name']) . '';
$set['meta_description'] = text($notes['msg']);

include_once '../../sys/inc/thead.php';





if (isset($_POST['msg']) && isset($user))
{
$msg = stripslashes(htmlspecialchars($_POST['msg']));
if (utf8_strlen($msg)>1024){$err='Сообщение слишком длинное';}

elseif (utf8_strlen($msg)<2){$err='Короткое сообщение';}

elseif ($pdo->query(("SELECT COUNT(*) FROM `notes_komm` WHERE `id_notes` = '".intval($_GET['id'])."' AND `id_user` = '".intval($user['id'])."' AND `msg` = '".htmlspecialchars($msg)."' LIMIT 1"),0)->fetchColumn()!=0){$err='Ваше сообщение повторяет предыдущее';}

$file_p = $pdo->query(("SELECT COUNT(*) FROM `files_post` WHERE `type` = 'blogs' AND `id_user` = '$user[id]' AND `active` = '1' LIMIT 1"),0)->fetchColumn();
if ($file_p){
$id_file = 1;
}else{
$id_file = 0;    
}
$pdo->query("INSERT INTO `notes_komm` (`id_user`, `time`, `msg`, `id_notes`, `id_file`) values('".intval($user['id'])."', '$time', '".$msg."', '".intval($_GET['id'])."', '$id_file')");
$post_id = $pdo->lastInsertId();
$pdo->query("UPDATE `files_post` SET `id_post` = '$post_id' WHERE `id_user` = '$user[id]' AND `type` = 'blogs' AND `active` = '1'");
$pdo->query("UPDATE `files_post` SET `active` = '0' WHERE `id_user` = '$user[id]' AND `type` = 'blogs' AND `active` = '1'");

if ($notes['id_user']!=$user['id']){
if ($avtor['jurnal_blogs_comm']==1){
$pdo->query("UPDATE `audio_count` SET `count` = '1' WHERE `id_user`='".intval($notes['id_user'])."'");     
/////////////////////////журнал///////////////
$name2="$user[nick] прокомментировал(а) вашу запись";
$msg2="[url=/modules/blogs/list.php?id=$notes[id] ] ".mb_substr($notes['name'],0,20,'UTF-8')."... [/url]";
$pdo->query("INSERT INTO `jurnal` (`avtor`, `id_user`, `id_kont`, `msg`, `name`, `type`, `time`) values('$user[id]', '0', '".intval($notes['id_user'])."', '".htmlspecialchars($msg2)."', '".htmlspecialchars($name2)."', 'notes_komm', '$time')");
/////////////////////////////////////////////////     
}
}



$q = $pdo->query("SELECT * FROM `notes_eye` WHERE `type` = 'blogs' AND `id_post` = '".intval($notes['id'])."'");

while ($eye = $q->fetch(PDO::FETCH_ASSOC)) {
if ($eye['id_user']!=$user['id']){ 
$pdo->query("UPDATE `audio_count` SET `count` = '1' WHERE `id_user`='".intval($eye['id_user'])."'");    
/////////////////////////журнал слежка///////////////
$name2="$user[nick] прокомментировал(а) запись";
$msg2="[url=/modules/blogs/list.php?id=$notes[id] ] ".mb_substr($notes['name'],0,20,'UTF-8')." [/url]";
$pdo->query("INSERT INTO `jurnal` (`avtor`, `id_user`, `id_kont`, `msg`, `name`, `type`, `time`) values('$user[id]', '0', '".intval($eye['id_user'])."', '".htmlspecialchars($msg2)."', '".htmlspecialchars($name2)."', 'notes_komm', '$time')");
/////////////////////////////////////////////////     
}
}






$_SESSION['message'] = 'Комментарий успешно добавлен';
header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
exit;

}

if (isset($_GET['del_file'])){
$q1 = $pdo->query("SELECT * FROM `files_post` WHERE `id` = '" . intval($_GET['del_file']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'blogs'");
while ($d = $q1->fetch(PDO::FETCH_ASSOC)) {
unlink(htmlspecialchars($_SERVER['DOCUMENT_ROOT']).'/sys/files_post/'.$d['id'].'.jpg');
}
$pdo->query("DELETE FROM `files_post` WHERE `id` = '" . intval($_GET['del_file']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'blogs'");
$_SESSION['message'] = lang('Вложение успешно удалено');
header("Location: list.php?id=$notes[id]");
}


if (isset($user))
$frend = $pdo->query(("SELECT COUNT(*) FROM `friendsi` WHERE (`user` = '$user[id]' AND `friendsi` = '$avtor[id]') OR (`user` = '$avtor[id]' AND `friendsi` = '$user[id]') LIMIT 1"),0)->fetchColumn();

aut(); // форма авторизации
err();

if ($user['level'] > 3){}else{
if ($notes['private']==1 && $user['id']!=$avtor['id'] && $frend!=2)
{
#Навигация
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='/info.php?$avtor[id]'>$avtor[nick]</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='user.php?id=$avtor[id]'>";
echo lang('Блог');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> Запись</div>";    
    
    
    
    
 echo '<div class="list-group-item">';   
	echo '<center><img src="/style/info/7.png" style="width: 120px; height: 120px;"><br><br><b>Запись доступна только для друзей автора</b></center>';
echo '</div>';	
	include_once '../../sys/inc/tfoot.php';
	exit;
}}









if ($user['level'] > 3){}else{


if ($notes['private']==2 && $user['id']!=$avtor['id'])
{
#Навигация
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='/info.php?$avtor[id]'>$avtor[nick]</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='user.php?id=$avtor[id]'>";
echo lang('Блог');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> Запись</div>";    
    
    
    
    
 echo '<div class="list-group-item">';   
	echo '<center><img src="/style/info/12.png" style="width: 120px; height: 120px;"><br><br><b>Автор запретил всем просмотр этой записи</b></center>';
echo '</div>';	
	include_once '../../sys/inc/tfoot.php';
exit;	
}

}







if (isset($user))
{
if ($notes['id_user']!=$user['id']){
if (isset($_GET['eye_ok']))
{
if ($pdo->query(("SELECT COUNT(*) FROM `notes_eye` WHERE `id_user` = '".$user['id']."' AND `id_post` = '".intval($notes['id'])."' AND `type` = 'blogs' LIMIT 1"),0)->fetchColumn()==0){
$pdo->query("INSERT INTO `notes_eye` (`id_post`, `id_user`, `type`) VALUES ('".intval($notes['id'])."', '$user[id]', 'blogs')");
$_SESSION['message'] = 'Слежка за записью включена. Теперь уведомления о новых комментариях будут приходить к вам в журнал';
	header("Location: list.php?id=$notes[id]");
exit;
}}

if (isset($_GET['eye_no']))
{
$pdo->query("DELETE FROM `notes_eye` WHERE `id_user` = '" .$user['id']. "' AND `type` = 'blogs' AND `id_post` = '" .$notes['id']. "'");
$_SESSION['message'] = 'Слежка за записью отключена';
	header("Location: list.php?id=$notes[id]");
exit;
} 
}

if (isset($_GET['like_post']))
{if ($pdo->query(("SELECT COUNT(*) FROM `like_post` WHERE `id_user` = '".$user['id']."' AND `id_post` = '".intval($_GET['like_post'])."' AND `type` = 'blogs' LIMIT 1"),0)->fetchColumn()==0){
$pdo->query("INSERT INTO `like_post` (`id_post`, `id_user`, `like`, `time`, `type`) VALUES ('".intval($_GET['like_post'])."', '$user[id]', '1', '$time', 'blogs')");
$_SESSION['message'] = 'Ваш голос засчитан';
	header("Location: list.php?id=$notes[id]");
exit;
}}    
    
    
    
    
    
    
	if (isset($_GET['like']) && $_GET['like'] == 1)
	{
		if ($pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0)
		{
			$pdo->query("INSERT INTO `notes_like` (`id_notes`, `id_user`, `like`) VALUES ('$notes[id]', '$user[id]', '1')");
			$pdo->query("UPDATE `notes` SET `count` = '".($notes['count']+1)."' WHERE `id` = '$notes[id]' LIMIT 1");
			
			
			
			
			if ($notes['id_user']!=$user['id']){

/////////////////////////журнал///////////////
if ($avtor['jurnal_blogs_like']==1){
$pdo->query("UPDATE `audio_count` SET `count` = '1' WHERE `id_user`='".intval($notes['id_user'])."'");
$name2="$user[nick] понравилась ваша запись";

$msg2="[url=/modules/blogs/list.php?id=$notes[id]] ".mb_substr($notes['name'],0,20,'UTF-8')."... [/url]";

$pdo->query("INSERT INTO `jurnal` (`avtor`, `id_user`, `id_kont`, `msg`, `name`, `type`, `time`) values('$user[id]', '0', '".intval($notes['id_user'])."', '".htmlspecialchars($msg2)."', '".htmlspecialchars($name2)."', 'notes_like', '$time')");

/////////////////////////////////////////////////    
}

}
			
			
			
			
			
			$_SESSION['message'] = 'Ваш голос засчитан';
			header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
			exit;
		}
	}


	if (isset($_GET['like']) && $_GET['like'] == 0)
	{
		if ($pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0)
		{
			$pdo->query("INSERT INTO `notes_like` (`id_notes`, `id_user`, `like`) VALUES ('$notes[id]', '$user[id]', '0')");
			$pdo->query("UPDATE `notes` SET `count` = '".($notes['count']-1)."' WHERE `id` = '$notes[id]' LIMIT 1");
			$_SESSION['message'] = 'Ваш голос засчитан';
			header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
			exit;
		}
	}


	if (isset($_GET['fav']) && $_GET['fav']==1)
	{
		if ($pdo->query(("SELECT COUNT(*) FROM `mark_notes` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0)
		{
			$pdo->query("INSERT INTO `mark_notes` (`id_list`, `id_user`, `time`) VALUES ('$notes[id]', '$user[id]', '$time')");
			$_SESSION['message'] = 'Запись добавлена в закладки';
			header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
			exit;
		}
	}


	if (isset($_GET['fav']) && $_GET['fav']==0)
	{
		if ($pdo->query(("SELECT COUNT(*) FROM `mark_notes` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==1)
		{
			$pdo->query("DELETE FROM `mark_notes` WHERE `id_user` = '$user[id]' AND  `id_list` = '$notes[id]' ");
			$_SESSION['message'] = 'Запись удалена из закладок';
			header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
			exit;
		}
	}

}

if ($user['level'] > 3){}else{
if(!isset($_SESSION['notes_pass']))$_SESSION['notes_pass']=NULL;


if($avtor['id']!=$user['id'] && $_SESSION['notes_pass']!=$notes['pass'] && $notes['pass']!=NULL){
	

if (isset($_POST['password']))
{
$_SESSION['notes_pass']=htmlspecialchars($_POST['password']);
if ($_SESSION['notes_pass']!=$notes['pass'])
{
$_SESSION['message'] = 'Неверный пароль'; 
$_SESSION['notes_pass']=NULL;
}
header("Location: ?id=$notes[id]");


}

#Навигация
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='/info.php?$avtor[id]'>$avtor[nick]</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='user.php?id=$avtor[id]'>";
echo lang('Блог');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> Запись</div>";    
    
    
    
    
 echo '<div class="list-group-item">';   
	echo '<center><img src="/style/info/22.png" style="width: 120px; height: 120px;"><br><br><b>Доступ к записи доступен только по паролю</b></center>';
echo '<form action="?id='.$notes['id'].'" method="POST"><br /><br /><b>Пароль:</b> <br /><input class="form-control" type="pass" name="password" value="" />	
<input class="btn btn-primary btn-sm" type="submit" value="Готово"/></form>';
echo '</div>';


	include_once '../../sys/inc/tfoot.php';
exit;


}
}























#Навигация
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='/info.php?$avtor[id]'>$avtor[nick]</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo "<a href='user.php?id=$avtor[id]'>";
echo lang('Блог');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> Запись</div>";
echo "<div style='background-color: white; padding: 10px;'>";






if (isset($user))


aut(); // форма авторизации
err();
















$frend = $pdo->query("SELECT COUNT(*) FROM `friendsi` WHERE (`user` = '$user[id]' AND `friendsi` = '$avtor[id]') OR (`user` = '$avtor[id]' AND `friendsi` = '$user[id]') LIMIT 1")->fetchColumn();





echo '<i class="fa fa-book fa-fw"></i> ';
echo user($avtor['id']);
echo ' : ';
 
 
if ($notes['block']==0)
{}else{
echo "<s>";    
}    
if($notes['share']==1){
echo "<font color=#4694D1><b>Поделился(-ась)</b></font>\n";  
 
    
}else{ 
  
echo '<font color=#4694D1><b>' .$notes['name'] . '</b></font>';
}
if ($notes['block']==0)
{}else{
echo "</s>";    
}

if ($notes['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;'>";
if ($notes['private']==1 && $avtor['id'] && $frend!=2)
{
echo "<i class='fa fa-users fa-fw'></i> ";}
if ($notes['private']==2 && $avtor['id'])
{
 echo "<i class='fa fa-lock fa-fw'></i> ";}   
echo "<font color=gray><small>".date::times($notes['time'])."</small></font>";
echo "</span><br>";

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


if ($pdo->query(("SELECT COUNT(*) FROM `posters` WHERE `id_post` = '".intval($notes['id'])."'"),0)->fetchColumn())
{
$posters = $pdo->query("SELECT * FROM `posters` WHERE `id_post` = '".intval($notes['id'])."'")->fetch(PDO::FETCH_ASSOC);
echo '<br><table style="width: 100%;"><tr><td><center>';
if (IS_WEB == 1) {
echo "<div style='position: relative; width: 95%; height: 350px; border-radius: 5px; border: 7px #595E63 solid;'>";
echo "<img src='/modules/blogs/posters_img/$posters[id_img].jpg' style='width: 100%; height: 350px;'>";
echo '<div style="position: absolute; top: 100px; color: white; background:rgba(0,0,0,0.5); width: 100%; height: 150px;">';
echo "<span style='position: relative; top: 25px; font-family: tahoma; font-size: 20px;'>".text($posters['msg'])."</span>";
echo '</div>';
echo '</div>';
}else{
echo "<div style='position: relative; width: 95%; height: 240px; border-radius: 5px; border: 7px #595E63 solid;'>";
echo "<img src='/modules/blogs/posters_img/$posters[id_img].jpg' style='width: 100%; height: 240px;'>";
echo '<div style="position: absolute; top: 56px; color: white; background:rgba(0,0,0,0.5); width: 100%; height: 130px;">';
echo "<span style='position: relative; top: 25px; font-family: tahoma; font-size: 20px;'>".text($posters['msg'])."</span>";
echo '</div>';
echo '</div>';   
}
echo '</center></td></tr></table>';
}

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

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

if ($post['type'] == 'files_file') { 

   
echo "<br /><b>Файл:</b> <small><a href='/user/file/file.php?id=".$post['id_f']."'><i class='fa fa-file fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post['name'],0,25))) . "</a></small><br>";
    
    
}






if ($post['type'] == 'files_music') { 

echo '<br /><br /><audio style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$music77.''.$post['id_f'].'.mp3" width="100%" height="300px" poster="/site/files/video_f.png" controls /></audio>';    

    
echo "<br /><small><a href='/user/music/file.php?id=".$post['id_f']."'><i class='fa fa-music fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post['name'],0,25))) . "</a></small><br>";
    
    
} 






if ($post['type'] == 'files_video') { 
if (IS_WEB == 1) {
echo '<br /><br /><video style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$video77.''.$post['id_f'].'.mp4" width="100%" height="300px" poster="/site/files/video_f.png" controls /></video>';    
                        }else{
echo '<br /><br /><video style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$video77.''.$post['id_f'].'.mp4" width="93%" height="200px" poster="/site/files/video_f.png" controls /></video>';    
 }
    
echo "<br /><small><a href='/user/video/file.php?id=".$post['id_f']."'><i class='fa fa-film fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post['name'],0,25))) . "</a></small><br>";
    
    
} 









	
	if($post['type']=='foto'){
		$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$post[id_user]' AND `id` = '".intval($post['id_file'])."'")->fetch(PDO::FETCH_BOTH);
		
		if(isset($file_id['id'])){
		$ras = htmlspecialchars(text($file_id['ras']));
		echo "<br /><a href='/modules/foto/foto0/$file_id[id].$file_id[ras]'>";
		echo'<img src="/modules/foto/foto640/'.$file_id['id'].'.'.$file_id['ras'].'" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px; max-width: 220px;"/><br />';
        echo"</a><br />";
		}
		
		
		
	}elseif($post['type']=='files'){
		$ras = htmlspecialchars(text($post['ras']));

	if(is_file(H.'sys/blogs/files/'.$post['id'].'.jpg')){
echo '<a href="/sys/blogs/files/'.$post['id'].'.jpg">';

echo'<br /><img src="/sys/blogs/files/'.$post['id'].'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;max-width: 220px;"/><br />';
echo"</a>";				

	}


	}

}

echo "<br>";


$stat1 = output_text($notes['msg']);


$mn=35;


$stat=explode(' ', $stat1); // деление статьи на отдельные слова

$k_page=k_page(count($stat),$set['p_str']*$mn);
$page=page($k_page);
$start=$set['p_str']*$mn*($page-1);
$stat_1=NULL;

for ($i=$start;$i<$set['p_str']*$mn*$page && $i<count($stat);$i++){

$stat_1.=$stat[$i].' ';

}

echo '' . $stat_1 . ''; // вывод статьи со всем форматированием




notes_share(htmlspecialchars($notes['id']));


include_once'votes.php';






if ($k_page>1)str("?id=$notes[id]&amp;",$k_page,$page); // Вывод страниц
echo "<br><br>";
$cat = $pdo->query(("SELECT * FROM `notes_dir` WHERE `id` = '$notes[id_dir]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);

if($cat['id']==0){
}else{
echo "<div style='text-align: left; padding: 1px;'><i class='fa fa-feed'></i> Категория: <a href='/modules/blogs/dir.php?id=$cat[id]'><font color=#297EA5> $cat[name]</font></a></div>";
}

if($notes['href']==null){}else{
echo "<div style='text-align: left; padding: 1px;'><i class='fa fa-link'></i> Источник: ".output_text($notes['href'])."</div>";
}

}else{
echo "<br><div class='mess'>";
echo "<b>Запись заблокирована модератором</b> ";

echo user($notes['id_ban']);

echo "<br><br>";
echo "Причина: ";
if ($notes['block']==1){
echo "Грубость и оскорбления";
}
if ($notes['block']==2){
echo "Разжигание ненависти";
}
if ($notes['block']==3){
echo "Мошенничество";
}
if ($notes['block']==4){
echo "Нецензурная лексика";
}
if ($notes['block']==5){
echo "Педофилия";
}
if ($notes['block']==6){
echo "Спам, реклама или мошенничество ";
}

if ($notes['block']==7){
echo "Иная ";
}
echo "<br><br>";
echo "Комментарий: $notes[block_comm]";


echo "</div><br>";
}

?>
<style>
.adm {
background-color: #F8EDEA; 
padding: 5px;
color: #B99488;
border: 1px #E0BCB1 solid;
border-radius: 3px;
}   
</style>
<? 


if (access('loads_file_upload')){
echo "<br>"; 

if (access('adm_mysql')){
   
if($notes['type']==1){    
echo " <a href='admin/top_delete.php?id=$notes[id]&delete'><button class='adm'>Удл. из ТОПа</button></a> ";
}else{
echo " <a href='admin/top_delete.php?id=$notes[id]&v'><button class='adm'>В ТОП</button></a> ";
}

}


if ($notes['block']==0)
{
echo " <a href='admin/block.php?id=$notes[id]'><button class='adm'>В блок</button></a> ";
}else{
echo " <a href='admin/block.php?id=$notes[id]&r'><button class='adm'>Разблокировать</button></a> ";    
}
if($notes['cat_alt']==0){}else{
if($notes['id_dir']==0){
echo " <a href='admin/cat_delete.php?id=$notes[id]&v'><button class='adm'>Вернуть в категорию</button></a> ";     
    
}else{ 
echo " <a href='admin/cat_delete.php?id=$notes[id]&delete'><button class='adm'>Удл. из категории</button></a> ";     
}
}

$ban_blogs = $pdo->query(("SELECT * FROM `ban_blogs` WHERE `id_notes` = '$notes[id]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);


if ($ban_blogs['status']==0)
{
echo " <a href='admin/ban.php?id=$notes[id]&ank=$notes[id_user]'><button class='adm'>Выдать бан</button></a> ";
}else{
echo " <a href='admin/ban.php?id=$notes[id]&ank=$notes[id_user]&r'><button class='adm'>Снять бан</button></a> ";    
}

}

echo '</div>';









echo '<div class="list-group-item">';
/*----------------------листинг-------------------*/
$listr = $pdo->query("SELECT * FROM `notes` WHERE `id` < '$notes[id]' ORDER BY `id` DESC LIMIT 1")->fetch(PDO::FETCH_ASSOC);
$list = $pdo->query("SELECT * FROM `notes` WHERE `id` > '$notes[id]' ORDER BY `id`  ASC LIMIT 1")->fetch(PDO::FETCH_ASSOC);
echo '<div class="c2" style="text-align: center;">';
echo '<span class="page">'.($list['id']?'<a href="list.php?id='.$list['id'].'">&laquo; Пред.</a> ':'&laquo; Пред. ').'</span>';

$k_1=$pdo->query(("SELECT COUNT(*) FROM `notes` WHERE `id` > '$notes[id]'"),0)->fetchColumn()+1;
$k_2=$pdo->query(("SELECT COUNT(*) FROM `notes`"),0)->fetchColumn();
echo ' ('.$k_1.' из '.$k_2.') ';

echo '<span class="page">' . ($listr['id'] ? '<a href="list.php?id=' . $listr['id'] . '">След. &raquo;</a>' : ' След. &raquo;') . '</span>';
echo '</div>';
echo '</div>';




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



if (isset($user) && $user['id']==$avtor['id'] || access('adm_mysql')){
echo "<div class='list-group-item' style='background-color: #E8EBEE;'>";
echo '<table style="width:100%" cellspacing="0" cellpadding="0"><tr>';
echo "<td style='display: inline-block; border-radius: 10px 0px 0px 10px; background-color: white; padding: 9px;width: 50%;border-top: 1px #d0d0d0 solid;border-left: 1px #d0d0d0 solid; border-bottom: 1px #d0d0d0 solid;border-right: 1px #d0d0d0 solid;'><center><a href='edit.php?id=$notes[id]'><font color='#1B767E'><i class='fa fa-edit fa-lg'></i> <b>Редактировать</b></font></a><center></td>";
echo "<td style='display: inline-block; border-radius: 0px 10px 10px 0px; background-color: white; padding: 9px;width: 50%;border-top: 1px #d0d0d0 solid; border-bottom: 1px #d0d0d0 solid;border-right: 1px #d0d0d0 solid;'><center><a href='?id=$notes[id]&amp;delete'><font color='#E24135'><i class='fa fa-trash fa-lg'></i> <b>Удалить</b></font></a></center></td>";
echo "</table>";
echo "</div>";
}


if (isset($_GET['delete']) && $user['id']==$avtor['id'] || isset($_GET['delete']) && access('adm_mysql'))
{
	echo "<div class='list-group-item'>";
	echo "Вы действительно хотите удалить запись <b>" . toOutput($notes['name']) . "</b>?<br />";
	echo "<a class='btn btn-primary btn-sm' href='delete.php?id=$notes[id]'>Удалить</a> <a class='btn btn-secondary btn-sm' href='list.php?id=$notes[id]'>Отмена</a> \n";
	echo "</div>";

}


	$markinfo = $pdo->query(("SELECT COUNT(*) FROM `mark_notes` WHERE `id_list` = '".$notes['id']."'"),0)->fetchColumn();
    $share = $pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='".$notes['id']."' AND `share_type`='notes'"),0)->fetchColumn();
$pr=$pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_notes`='$notes[id]'"),0)->fetchColumn();

echo "<div class='list-group-item'>";
if (isset($user) && $user['id']==$avtor['id'] || access('adm_mysql')){
echo "<a href='laiki.php?id=".$notes['id']."'><span style='padding: 4px;margin-right: 5px; border: 1px #FC9373 solid; border-radius: 16%; color: #FC9373'><i class='fa fa-heart fa-fw'></i> <b><font color=#E9432C>".$pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '1' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()."</font></b></span></a>";
echo "<a href='prosmotry.php?id=".$notes['id']."'><span style='padding: 4px;margin-right: 5px; border: 1px #6CCA70 solid; border-radius: 16%; color: #6CCA70'><i class='fa fa-eye fa-fw'></i> <b><font color=#49994C>$pr</font></b></span></a>";
echo "<a href='zakladki.php?id=".$notes['id']."'><span style='padding: 4px;margin-right: 5px; border: 1px #CFBD19 solid; border-radius: 16%; color: #CFBD19'><i class='fa fa-star fa-fw'></i> <b><font color=#978C2B>$markinfo</font></b></span></a>";
echo "<a href='reposty.php?id=".$notes['id']."'><span style='padding: 4px;margin-right: 5px; border: 1px #63BAFF solid; border-radius: 16%; color: #63BAFF'><i class='fa fa-mail-forward fa-fw'></i> <font color=#659CC7><b>$share</b></font></span></a><br><br>";

    
}else{
echo "<span style='padding: 4px;margin-right: 5px; border: 1px #FC9373 solid; border-radius: 16%; color: #FC9373'><i class='fa fa-heart fa-fw'></i> <b>".$pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '1' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()."</b></span>";
echo "<span style='padding: 4px;margin-right: 5px; border: 1px #6CCA70 solid; border-radius: 16%; color: #6CCA70'><i class='fa fa-eye fa-fw'></i> <b>$pr</b></span>";
echo "<span style='padding: 4px;margin-right: 5px; border: 1px #CFBD19 solid; border-radius: 16%; color: #CFBD19'><i class='fa fa-star fa-fw'></i> <b>$markinfo</b></span>";
echo "<span style='padding: 4px;margin-right: 5px; border: 1px #63BAFF solid; border-radius: 16%; color: #63BAFF'><i class='fa fa-mail-forward fa-fw'></i> <b>$share</b></span><br><br>";
}


if (isset($user)){

if ($pdo->query(("SELECT COUNT(*) FROM `mark_notes` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0)
echo "<a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='list.php?id=$notes[id]&amp;fav=1'><i class='fa fa-star-o fa-fw'></i> Добавить в закладки</a> \n";
else
echo "<a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='list.php?id=$notes[id]&amp;fav=0'><i class='fa fa-star fa-fw'></i> Удалить из закладок</a> \n";
}



if ($pdo->query(("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0)
echo "<a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='list.php?id=$notes[id]&amp;like=1'><i class='fa fa-heart-o fa-fw'></i> Мне нравится</a>\n";
else
echo "<span style='margin-top: 3px;' class='btn btn-info-outline btn-sm'><i class='fa fa-heart fa-fw'></i></span>\n";


if($pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `id_user`='".$user['id']."' AND `share_type`='notes' AND `share_id`='".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0 && isset($user) && $user['id']!=$notes['id_user']) {
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='share.php?id=".$notes['id']."'><i class='fa fa-mail-forward fa-fw'></i> Поделиться</a>"; 
}


if ($notes['id_user']!=$user['id']){
if($pdo->query(("SELECT COUNT(*)FROM `notes_eye` WHERE `id_user`='".$user['id']."' AND `id_post` = '".$notes['id']."' AND `type`='blogs' LIMIT 1"),0)->fetchColumn()==0) {
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='?id=".$notes['id']."&eye_ok'><i class='fa fa-eye fa-fw'></i> Следить</a>"; 
}else{
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='?id=".$notes['id']."&eye_no'><i class='fa fa-eye fa-fw'></i> Слежу</a>";     
}
}else{
echo " <span style='margin-top: 3px;' class='btn btn-info-outline btn-sm'><i class='fa fa-eye fa-fw'></i> Слежу</span>";     
}









echo "</div>";





/*
===================================
Комментарии дневников
===================================
*/

$k_post=$pdo->query(("SELECT COUNT(*) FROM `notes_komm` WHERE `id_notes` = '".intval($_GET['id'])."'"),0)->fetchColumn();
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

echo '<div class="list-group-item-komm list-group-item-info" style="padding: 10px;">';
echo "<i class='fa fa-comments fa-fw'></i> Комментарии \n";
echo "<span class='badgei'>$k_post</span>\n";
echo '</div>';

if ($k_post==0)
{
$doc->NoResult();
}
else if (isset($user))
{
/*------------сортировка по времени--------------*/
if (isset($user)){
    

if ($user['sort'] == 1) {    
echo "<div class='list-group-item'>";
echo "<table style='width: 100%;'><tr>
<td class='g10' style='background-color: #BFC7CE;'><a style='padding: 5px' href='list.php?id=$notes[id]&amp;page=$page&amp;sort=1'><font color=white>Внизу</font></a></td>
<td class='g10'><a style='padding: 5px' href='list.php?id=$notes[id]&amp;page=$page&amp;sort=0' class='".($user['sort']==0?'activ':'')."'><font color=#72A5CE>Вверху</font></a></td></tr></table>";
echo "</div>";    
}
if ($user['sort'] == 0) {    
echo "<div class='list-group-item'>";
echo "<table style='width: 100%;'><tr>
<td class='g10'><a style='padding: 5px' href='list.php?id=$notes[id]&amp;page=$page&amp;sort=1'><font color=#72A5CE>Внизу</font></a></td>
<td class='g10' style='background-color: #BFC7CE;'><a style='padding: 5px' href='list.php?id=$notes[id]&amp;page=$page&amp;sort=0' class='".($user['sort']==0?'activ':'')."'><font color=white>Вверху</font></a></td></tr></table>";
echo "</div>";    
}    
}
/*---------------alex-borisi---------------------*/
}

$q = $pdo->query("SELECT * FROM `notes_komm` WHERE `id_notes` = '".intval($_GET['id'])."' ORDER BY `time` $sort LIMIT $start, $set[p_str]");



while ($post = $q->fetch(PDO::FETCH_ASSOC))
{
$ank=$pdo->query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1")->fetch(PDO::FETCH_ASSOC);

if ($post['otvet'] != 0 && $pdo->query(("SELECT COUNT(*) FROM `user` WHERE `id`='$post[otvet]'"), 0)->fetchColumn() != 0) {
$otvet = $pdo->query(("SELECT * FROM `user` WHERE `id` = '$post[otvet]'"))->fetch(PDO::FETCH_ASSOC);
}
    
    
echo "<div class='list-group-item'>"; 
if ($user['mobile_themes']==1) {
avatarz($ank['id']);
echo "<span style='position: relative; bottom: 25px; left: 5px;'>"; }
echo user($ank['id']) . " ";
if ($user['mobile_themes']==1) {echo "</span>";}

echo "<span style = 'float:right;color: grey;'><small title='" . date::timek($post['time']) . "'>" . date::timek($post['time']) . "</small></span>";
echo "<br />\n";

if (isset($otvet)) {
echo '<a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#otv'.$post['id'].'" aria-expanded="false" aria-controls="otv'.$post['id'].'">';
echo "<small><font color=gray>ответил ";
echo "<u><b>$otvet[nick]</b></u></font></small></a>";
echo '<div id="otv'.$post['id'].'" class="panel-collapse collapse" role="tabpanel" aria-labelledby="otv'.$post['id'].'">';
echo "<div style = 'border: 1px #AFC3D3 solid; padding: 3px; border-radius: 3px; background-color: #D2DEE7;'>";
$otv = $pdo->query(("SELECT * FROM `notes_komm` WHERE `id` = '$post[id_otvet]'"))->fetch(PDO::FETCH_ASSOC);

echo "".output_text($otv['msg'])."</div>";
echo "</div><br /><br />";
} 
if (isset($otvet)) {
unset($otvet);
}    
echo output_text($post['msg'])."<br />\n";



$file_ok = $pdo->query(("SELECT COUNT(*) FROM `notes_komm` WHERE `id` = '$post[id]' AND `id_user` = '$post[id_user]' AND `id_file` = '1' LIMIT 1"),0)->fetchColumn();
if ($file_ok){    

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

while ($post1 = $files->fetch(PDO::FETCH_ASSOC))
{
if($post1['type_files']=='foto'){
$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$post1[id_user]' AND `id` = '$post1[id_file]'")->fetch(PDO::FETCH_ASSOC);
if(isset($file_id['id'])){
$ras = htmlspecialchars(text($file_id['ras']));
echo "<a href='/modules/foto/foto0/$file_id[id].$file_id[ras]'>";
echo'<img src="/modules/foto/foto128/'.$file_id['id'].'.'.$file_id['ras'].'" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px; width: 70px; height: 70px;"/>';
echo"</a>";
}
}
if($post1['type_files']=='foto_download'){
if(is_file(H.'sys/files_post/'.$post1['id'].'.jpg')){
echo '<a href="/sys/files_post/'.$post1['id'].'.jpg">';
echo'<img src="/sys/files_post/'.$post1['id'].'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px; width: 70px; height: 70px;"/>';
echo" </a>";				
}
}
if($post1['type_files']=='video'){
if (IS_WEB == 1) {
echo '<br /><br /><video style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$video77.''.$post1['id_file'].'.mp4" width="100%" height="300px" poster="/site/files/video_f.png" controls /></video>';    
}else{
echo '<br /><br /><video style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$video77.''.$post1['id_file'].'.mp4" width="93%" height="200px" poster="/site/files/video_f.png" controls /></video>';    
}
    
echo "<br /><small><a href='/user/video/file.php?id=".$post1['id_file']."'><i class='fa fa-film fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post1['name'],0,25))) . "</a></small><br>";
}
if ($post1['type_files'] == 'files') { 
echo "<br /><b>Файл:</b> <small><a href='/user/file/file.php?id=".$post1['id_file']."'><i class='fa fa-file fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post1['name'],0,25))) . "</a></small><br>";
}

if ($post1['type_files'] == 'music') { 
echo '<br /><br /><audio style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$music77.''.$post1['id_file'].'.mp3" width="100%" height="300px" poster="/site/files/video_f.png" controls /></audio>';    
echo "<br /><small><a href='/user/music/file.php?id=".$post1['id_file']."'><i class='fa fa-music fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post1['name'],0,25))) . "</a></small><br>";
}

}
echo "<br>";
}    

echo "<br>";

if ($post['sys'] == 0)
{
    
if (isset($user) && $user['id'] != $ank['id']) {
echo " <a class='comm-in' href='komm.php?id=$post[id]'><i class='fa fa-comment fa-fw'></i> Ответ</a> ";              
}


if (isset($user))
{

    

    
$like = $pdo->query(("SELECT COUNT(*) FROM `like_post` WHERE `id_post` = '".$post['id']."' AND `type` = 'blogs'"),0)->fetchColumn();    

if ($pdo->query(("SELECT COUNT(*) FROM `like_post` WHERE `id_user` = '".$user['id']."' AND `id_post` = '".$post['id']."' AND `type` = 'blogs' LIMIT 1"),0)->fetchColumn()==0){    

echo " <span style='float: right; position: relative; left: 8px;'><a class='like-in-o' href='/user/like_post/?id=".$notes['id']."&type=blogs&id_post=$post[id]'> <b>$like</b> </a></span> ";            
echo " <span id='like' style='float: right; position: relative; left: 8px;'><a class='like-in' href='?id=".$notes['id']."&type=blogs&like_post=$post[id]'><i class='fa fa-heart-o fa-fw'></i></a></span> ";            
}else{    
echo " <span style='float: right; position: relative; left: 8px;'><a class='like-in-o-red' href='/user/like_post/?id=".$notes['id']."&type=blogs&id_post=$post[id]'> <b>$like</b> </a></span> ";            
echo " <span style='float: right; position: relative; left: 8px;'><a class='like-in-red' href='/user/like_post/?id=".$notes['id']."&type=blogs&id_post=$post[id]'><i class='fa fa-heart fa-fw'></i></a></span> ";            
    
}    

if (access('adm_news_delete_comments')){
echo " <span style='float: right; position: relative; left: 4px;'><a class='comm-in' href='edit_post.php?id=".$notes['id']."&edit=$post[id]'><i class='fa fa-pencil fa-fw'></i></a></span> ";            
}else{ 
if (isset($user) && $post['id_user']==$user['id'] && $post['time']>time()-280){
echo " <span style='float: right; position: relative; left: 4px;'><a class='comm-in' href='edit_post.php?id=".$notes['id']."&edit=$post[id]'><i class='fa fa-pencil fa-fw'></i></a></span> ";            
} }


if (isset($user) && access('adm_mysql') || $user['id']==$notes['id_user']){    
echo "<span style='float: right;'><a class='comm-in' href='delete.php?komm=".$post['id']."'><i class='fa fa-trash fa-fw'></i></a></span>";   
}    
    
    
}
}
echo "</div>";    
}   

/////////////////////




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

$avtor=get_user($notes['id_user']);
$ank= $pdo->query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1");  
$sql = $pdo->query("SELECT * FROM `user_blacklist` WHERE `id_user` = '" . htmlspecialchars($avtor['id']) . "' AND `id_ank` = '" . htmlspecialchars($user['id']) . "';")->fetch(PDO::FETCH_NUM);
if (($sql) != 0 AND $user['level'] < 3) {


echo "  <div class='list-group-item'>\n";
echo "  <div class='err'>\n";
echo "Вы не можете комментировать эту запись, так как находитесь в черном списке у автора\n";
echo "   </div>\n";
echo "   </div>\n";




  include_once '../../sys/inc/tfoot.php';
    exit;
}






if ($notes['private_komm']==1 && $user['id']!=$avtor['id'] && $frend!=2  && !access('adm_show_adm')){
echo "  <div class='list-group-item'>\n";
echo "  <div class='err'>\n";
echo "Комментировать эту запись могут только друзья автора\n";
echo "   </div>\n";
echo "   </div>\n";
include_once '../../sys/inc/tfoot.php';
exit;
}

if ($notes['private_komm']==2 && $user['id']!=$avtor['id'] && !access('adm_show_adm')){

echo "  <div class='list-group-item'>\n";
echo "  <div class='err'>\n";
echo "Автор запретил комментирование этой записи\n";
echo "   </div>\n";
echo "   </div>\n";


include_once '../../sys/inc/tfoot.php';
exit;
}


if (isset($user)) {
        echo "<form class='list-group-item' name='message' method='POST' action='?id=".intval($_GET['id'])."&amp;page=$page'>";
        echo auto_bb("message", "msg");
        echo "<textarea placeholder='" . lang('Напишите что-нибудь') . "...' name='msg' class='form-control'></textarea>";

        echo "<br />";
$doc->Button('knopka', 'ok', 'pencil', 'Опубликовать');



echo "<span style='float: right;'>";
$doc->Link('btn btn-secondary btn-sm', "/user/files_post/foto.php?id=$notes[id]&type=blogs", 'file'); 
echo "</span><br>"; 


$files = $pdo->query("SELECT * FROM `files_post` WHERE `id_user` = '$user[id]' AND `type` = 'blogs' AND `active` = '1' LIMIT 3");
while ($post = $files->fetch(PDO::FETCH_ASSOC))
{

if($post['type_files']=='foto'){
$file_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$user[id]' AND `id` = '".intval($post['id_file'])."'")->fetch(PDO::FETCH_BOTH);
	if(isset($file_id['id'])){
echo "<br><span class='btn btn-secondary btn-sm' style='margin: 1px;'><i class='fa fa-camera fa-fw'></i> ";
echo toOutput(htmlspecialchars($file_id['name']));
}		
}

if($post['type_files']=='foto_download'){
echo '<br><span class="btn btn-secondary btn-sm" style="margin: 1px;">';
echo"<i class='fa fa-camera fa-fw'></i> ";
echo htmlspecialchars($post['name']);
}

if($post['type_files']=='video'){
echo '<br><span class="btn btn-secondary btn-sm" style="margin: 1px;">';
echo"<i class='fa fa-film fa-fw'></i> ";
echo htmlspecialchars($post['name']);
}

if($post['type_files']=='music'){
echo '<br><span class="btn btn-secondary btn-sm" style="margin: 1px;">';
echo"<i class='fa fa-music fa-fw'></i> ";
echo htmlspecialchars($post['name']);
}

if($post['type_files']=='files'){
echo '<br><span class="btn btn-secondary btn-sm" style="margin: 1px;">';
echo"<i class='fa fa-file fa-fw'></i> ";
echo htmlspecialchars($post['name']);
}
	
echo' <a href="?id='.$notes['id'].'&del_file='.$post['id'].'"><font color=#F56257><i class="fa fa-trash fa-lg"></i></font></a>';

echo '</span> ';
}

echo "</form>";
}
}







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