View file ä󿪫¬/modules/news/news.php

File size: 28.57Kb
<?php


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

$doc->Title('Новости');

require_once H . 'sys/inc/thead.php';

?>
<style>
.comm-in {
background-color: #E4EDF1;
border: 0.5px #C0CED5 solid;
border-radius: 3px;
padding: 3px;
color: #87ADC0;
margin-top: 2px;
}

.like-in {
background-color: #E4EDF1;
border: 0.5px #C0CED5 solid;
border-radius: 3px 0px 0px 3px;
padding: 3px;
color: #87ADC0;
margin-top: 2px;
}

.like-in-red {
background-color: white;
border: 0.5px #FA766D solid;
border-radius: 3px 0px 0px 3px;
padding: 3px;
color: #FA766D;
margin-top: 2px;
}



.like-in-o {
background-color: white;
border-top: 0.5px #C0CED5 solid;
border-right: 0.5px #C0CED5 solid;
border-bottom: 0.5px #C0CED5 solid;
border-radius: 0px 3px 3px 0px;
padding: 3px;
color: #87ADC0;
margin-top: 2px;
}

.like-in-o-red {
background-color: white;
border-top: 0.5px #FA766D solid;
border-right: 0.5px #FA766D solid;
border-bottom: 0.5px #FA766D solid;
border-radius: 0px 3px 3px 0px;
padding: 3px;
color: #FA766D;
margin-top: 2px;
}

</style>
<?    



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

 // Закладки
$markinfo = $pdo->query(("SELECT COUNT(*) FROM `mark_news` WHERE `id_list` = '".$news['id']."'"),0)->fetchColumn();
$count = $pdo->query(("SELECT COUNT(*) FROM `news_count` WHERE `id_news` = '".$news['id']."' LIMIT 1"),0)->fetchColumn();
if ($pdo->query(("SELECT COUNT(*) FROM `news` WHERE `id` = '$news[id]' LIMIT 1"), 0)->fetchColumn() == 0) {
    header("Location: ?" . SID);
    exit;
}
// Запись просмотра
if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `news_count` WHERE `id_user` = '".$user['id']."' AND `id_news` = '".$news['id']."' LIMIT 1"),0)->fetchColumn()==0){
$pdo->query("INSERT INTO `news_count` (`id_news`, `id_user`) VALUES ('$news[id]', '$user[id]')")->fetchColumn();

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

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `news` = '10'"), 0)->fetchColumn()==0)
{
$pdo->query("UPDATE `dlist` SET `news` = '" . ($dlist['news'] + 1) . "' WHERE `id_user` = '".intval($user['id'])."' LIMIT 1");
} 

if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `dlist` WHERE `id_user` = '$user[id]' AND `news` = '10' AND `news_ok` = '0'"), 0)->fetchColumn())
{
$pdo->query("UPDATE `user` SET `activity` = '" . ($user['activity'] + $dlist['news_v']) . "' WHERE `id` = '".$user['id']."' LIMIT 1");
$pdo->query("UPDATE `dlist` SET `news_ok` = '1' WHERE `id_user` = '".intval($user['id'])."' LIMIT 1");
$pdo->query("INSERT INTO `jurnal_balls` (`time`, `msg`, `id_user`, `balls`, `type`, `type_post`) values('$time', 'Выполнение достижения', '".intval($user['id'])."', '".intval($dlist['news_v'])."', 'plus', 'games')");
}    
    
    
    
}

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` = 'news' 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', 'news')");
$_SESSION['message'] = 'Ваш голос засчитан';
header("Location: ?news=".intval($_GET['news'])."");
exit;
}}

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


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

#Список тех, кому понравилась новость
if (isset($_GET['like_all'])) {
    $k_post = $pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '" . intval($_GET['news']) . "'"), 0)->fetchColumn();
    $k_page = k_page($k_post, $set['p_str']);
    $page = page($k_page);
    $start = $set['p_str'] * $page - $set['p_str'];
    $k_sisa = $k_post - 1;
    $q = $pdo->query("SELECT * FROM `news_like` WHERE `id_news` = '" . intval($_GET['news']) . "' ORDER BY `id` DESC LIMIT $start, $set[p_str]");

    #Навигация
    echo "<div class='card-header'>";
    echo "<a href='/' data-toggle='tooltip' 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='" . DIR_NEWS . "'>" . lang('Новости') . "</a> <i class='fa fa-angle-right fa-fw'></i> ";
    echo "<a href='" . DIR_NEWS . "?news=$news[id]'>" . cutStr($news['title'], 30) . "</a> <i class='fa fa-angle-right fa-fw'></i> ";
    echo lang('Им это нравится');
    echo "</div>";

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

    while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
        $ank = get_user($post['id_user']);
        echo "<table class='list-group-item-komm'><tr><td class='icon14'>";
        avatar($ank['id'], '30', 'border-radius: 2px;');
        echo "</td><td class='null'>";
        user($ank['id']);
        echo "</td></tr></table>";
    }

    if ($k_page > 1) {
        echo "<div class='list-group-item'>";
        echo $k_sisa;
        echo "</div>";
    }

    require_once H . 'sys/inc/tfoot.php';
}




if (isset($_GET['like']) && isset($user)) {
if ($pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '" . intval($_GET['news']) . "' AND `id_user` = '$user[id]' LIMIT 1"), 0)->fetchColumn() != 0) {
} else {
$pdo->query("INSERT INTO `news_like` (`id_user`, `id_news`) values('$user[id]', '" . intval($_GET['news']) . "')");
}
header("Location: ?news=" . intval($_GET['news']) . "" . SID);
}

if (isset($_GET['likes']) && isset($user)) {
if ($pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '" . intval($_GET['news']) . "' AND `id_user` = '$user[id]' LIMIT 1"), 0)->fetchColumn() != 0) {
} else {
$pdo->query("INSERT INTO `news_like` (`id_user`, `id_news`) values('$user[id]', '" . intval($_GET['news']) . "')");
}
header("Location: index.php?" . SID);
}


if (isset($_POST['msg']) && isset($user) && $news['close'] == 0) {
$msg = htmlspecialchars($_POST['msg']);
if (utf8_strlen($msg) > 10024) {
        $err = lang('Сообщение слишком длинное');
    } elseif (utf8_strlen($msg) < 2) {
        $err = lang('Короткое сообщение');
    } elseif ($pdo->query(("SELECT COUNT(*) FROM `news_komm` WHERE `id_news` = '" . intval($_GET['news']) . "' AND `id_user` = '$user[id]' AND `msg` = '" .$msg. "' LIMIT 1"), 0)->fetchColumn() != 0) {
        $err = lang('Ваше сообщение повторяет предыдущее');
    }
$file_p = $pdo->query(("SELECT COUNT(*) FROM `files_post` WHERE `type` = 'news' AND `id_user` = '$user[id]' AND `active` = '1' LIMIT 1"),0)->fetchColumn();
if ($file_p){
$id_file = 1;
}else{
$id_file = 0;    
}   

    if (!isset($err)) {
$pdo->query("INSERT INTO `news_komm` (`id_user`, `time`, `msg`, `id_news`, `id_file`) values('$user[id]', '$time', '" .$msg. "', '" . intval($_GET['news']) . "', '" .$id_file. "')");
$post_id = $pdo->lastInsertId();
$pdo->query("UPDATE `files_post` SET `id_post` = '$post_id' WHERE `id_user` = '$user[id]' AND `type` = 'news' AND `active` = '1'");
$pdo->query("UPDATE `files_post` SET `active` = '0' WHERE `id_user` = '$user[id]' AND `type` = 'news' AND `active` = '1'");

if (isset($user)){
if ($ank7['id']==$user['id']){    
}else{ 
$pdo->query("UPDATE `audio_count` SET `count` = '1' WHERE `id_user`='".intval($ank7['id'])."'");       
/////////////////////////журнал///////////////
$name2="$user[nick] прокомментировал(а) вашу новость";
$msg2="[url=/modules/news/?news=$news[id]] ".mb_substr($news['title'],0,20,'UTF-8')."... [/url]";
$pdo->query("INSERT INTO `jurnal` (`avtor`, `id_user`, `id_kont`, `msg`, `name`, `type`, `time`) values('$user[id]', '0', '".intval($ank7['id'])."', '".htmlspecialchars($msg2)."', '".htmlspecialchars($name2)."', 'news_comm', '$time')");
/////////////////////////////////////////////////     
}        
}        
    }
$_SESSION['message'] = lang('Сообщение успешно добавлено');
header("Location: ?news=" . intval($_GET['news']) . "" . SID);
exit;
}    


#Удаление комментария
if (isset($_GET['del']) && $pdo->query(("SELECT COUNT(*) FROM `news_komm` WHERE `id` = '" . intval($_GET['del']) . "'"), 0)->fetchColumn() && isset($user) && $user['level'] > 2) {
$pdo->query("DELETE FROM `news_komm` WHERE `id` = '" . intval($_GET['del']) . "'");
$pdo->query("DELETE FROM `files_post` WHERE `id_post` = '" . intval($_GET['del']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'news'");
$_SESSION['message'] = lang('Сообщение успешно удалено');
header("Location: ?news=" . intval($_GET['news']) . "" . SID);
exit;
}
if (isset($_GET['del_file'])){
$q1 = $pdo->query("SELECT * FROM `files_post` WHERE `id_post` = '" . intval($_GET['del_file']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'news'");
while ($d = $q1->fetch(PDO::FETCH_ASSOC)) {
unlink(htmlspecialchars($_SERVER['DOCUMENT_ROOT']).'/sys/files_post/'.$d['id'].'.jpg');
}
header("Location: ?news=" . intval($_GET['news']) . "&del=" . intval($_GET['del_file']) . "");
}

if (isset($_GET['delf'])){
$q1 = $pdo->query("SELECT * FROM `files_post` WHERE `id` = '" . intval($_GET['delf']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'news'");
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['delf']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'news'");
$_SESSION['message'] = lang('Вложение успешно удалено');
header("Location: ?news=" . intval($_GET['news']) . "");
}
err();



$like = $pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '" . $news['id'] . "'"), 0)->fetchColumn();

#Навигация
echo "<div class='card-header'>";
echo "<a href='/' data-toggle='tooltip' 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='" . DIR_NEWS . "'>" . lang('Новости') . "</a> <i class='fa fa-angle-right fa-fw'></i> ";
echo 'запись';
echo "</div>";

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

echo "<i class='fa fa-bullhorn fa-fw'></i> ";
echo "".user($ank7['id'])." : <a href='?news=$news[id]'><b>" . text($news['title']) . "</b></a>";

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

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

while ($post = $files->fetch(PDO::FETCH_ASSOC))
{
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 />";
}
}
if($post['type']=='files'){
if(is_file(H.'modules/news/img/'.$post['id'].'.jpg')){
echo '<a href="/modules/news/img/'.$post['id'].'.jpg">';

if (IS_WEB == 1) {
echo'<br /><img src="/modules/news/img/'.$post['id'].'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;max-width: 220px;"/><br />';
}else{
echo'<br /><img src="/modules/news/img/'.$post['id'].'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;max-width: 200px;"/><br />';
}
echo"</a>";				
}
}

}



echo "<br />";


#Текст новости
echo output_text($news['msg']) . "";

if ($news['tematika']==0){
echo "<br><hr><br>";
echo "<font color=gray>О том что планируется сделать читайте в <a href='/modules/news/journal/'>журнале обновлений.</font></a><br>";

echo "<font color=gray>По вопросам обращайтесь в службу <a href='/modules/support/'>технической поддержки.</a><br><br>С уважением, администрация FaceFree.Ru!</font>";
}



echo "</div>";    


if (isset($user) && 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=$news[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='?delete=$news[id]'><font color='#E24135'><i class='fa fa-trash fa-lg'></i> <b>Удалить</b></font></a></center></td>";
echo "</table>";
echo "</div>";
}



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

$l = $pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '$news[id]'"), 0)->fetchColumn();

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

if (isset($user) && access('adm_mysql')){
echo "<a href='laiki.php?id=".$news['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>$l</font></b></span></a>";
echo "<a href='prosmotry.php?id=".$news['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>$count</font></b></span></a>";
echo "<a href='zakladki.php?id=".$news['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=".$news['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>";

    
}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>$l</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>$count</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>";

}





if (isset($user)) {

echo "<br><br>";
if ($pdo->query(("SELECT COUNT(*) FROM `news_like` WHERE `id_news` = '$news[id]' AND `id_user` = '$user[id]' LIMIT 1"), 0)->fetchColumn() == 0) {
echo "<a style='margin-top: 3px;' href='?news=$news[id]&amp;like' class='btn btn-info-outline btn-sm' title='" . lang('Мне нравится') . "' data-toggle='tooltip' data-placement='right'><i class='fa fa-heart-o fa-fw'></i> Мне нравится</a> ";
} else {
echo "<a style='margin-top: 3px;' href='?news=$news[id]&amp;unlike' class='btn btn-info-outline btn-sm' title='" . lang('Вам понравилась новость') . "' data-toggle='tooltip' data-placement='right'><i class='fa fa-heart fa-fw'></i></a> ";
}

if ($pdo->query(("SELECT COUNT(*) FROM `mark_news` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$news['id']."' LIMIT 1"),0)->fetchColumn()==0)
echo "<a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='?news=$news[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='?news=$news[id]&amp;fav=0'><i class='fa fa-star fa-fw'></i> Удалить из закладок</a> \n";

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

    
}
echo "</div>";


if ($news['close'] == 1) {
    echo "<div class='list-group-item'>";
      echo "<div class='err'>";
    echo "<i class='fa fa-lock fa-fw'></i> " . lang('Новость закрыта для обсуждения');
    echo "</div>";
    echo "</div>";
}

$comm=$pdo->query(("SELECT COUNT(*) FROM `news_komm` WHERE `id_news`=" . intval($_GET['news']) . ""),0)->fetchColumn();

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


$k_post = $pdo->query(("SELECT COUNT(*) FROM `news_komm` WHERE `id_news` = '" . intval($_GET['news']) . "'"), 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 `news_komm` WHERE `id_news` = '" . intval($_GET['news']) . "' ORDER BY `id` $sort LIMIT $start, $set[p_str]");

if ($k_post == 0) {
    $doc->NoResult();
} else {
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='?news=" . intval($_GET['news']) . "&amp;page=$page&amp;sort=1'><font color=white>Внизу</font></a></td>
<td class='g10'><a style='padding: 5px' href='?news=" . intval($_GET['news']) . "&amp;page=$page&amp;sort=0'><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='?news=" . intval($_GET['news']) . "&amp;page=$page&amp;sort=1'><font color=#72A5CE>Внизу</font></a></td>
<td class='g10' style='background-color: #BFC7CE;'><a style='padding: 5px' href='?news=" . intval($_GET['news']) . "&amp;page=$page&amp;sort=0'><font color=white>Вверху</font></a></td></tr></table>";
echo "</div>";    
} 
}
}


while ($post = $q->fetch(PDO::FETCH_ASSOC)) {
$ank = get_user($post['id_user']);
    
    
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 `news_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 `news_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` = 'news' 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 (isset($user) && $news['close'] == 0 && $user['id'] != $ank['id']) {
echo " <a class='comm-in' href='?new_komm=$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` = 'news'"),0)->fetchColumn();    

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

echo " <span style='float: right; position: relative; left: 8px;'><a class='like-in-o' href='/user/like_post/?id=".$news['id']."&type=news&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='?news=".$news['id']."&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=".$news['id']."&type=news&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=".$news['id']."&type=news&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=".$news['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=".$news['id']."&edit=$post[id]'><i class='fa fa-pencil fa-fw'></i></a></span> ";            
} }
    
if (access('adm_news_delete_comments')) {
echo "<span style='float: right;'><a class='comm-in' href='?news=".$news['id']."&del_file=".$post['id']."'><i class='fa fa-trash fa-fw'></i></a></span>";   
}    
    
    
}

echo "</div>";    

}


if (isset($user)) {
    if (isset($user) && $news['close'] == 0) {
        echo "<form class='list-group-item' name='form' method='POST' action='?news=" . intval($_GET['news']) . "&amp;page=$page'>";
        echo auto_bb("form", "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=$news[id]&type=news", 'file'); 
echo "</span><br>"; 


$files = $pdo->query("SELECT * FROM `files_post` WHERE `id_user` = '$user[id]' AND `type` = 'news' 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="?news='.$news['id'].'&delf='.$post['id'].'"><font color=#F56257><i class="fa fa-trash fa-lg"></i></font></a>';

echo '</span> ';
}


        echo "</form>";
        
        
        
        
        
        
        
        
        
        
    }
} else {
    echo "<div class='list-group-item'>";
      echo "<div class='err'>";
    echo lang('Вам необходимо авторизоваться или зарегистрироваться для комментирования');
    echo "</div>";echo "</div>";
}
















if ($k_page > 1) {
    echo "<div class='list-group-item'>";
    str("?news=" . intval($_GET['news']) . '&amp;', $k_page, $page);
    echo "</div>";
}

require_once H . 'sys/inc/tfoot.php';