<?
foreach (array('start', 'compress', 'sess', 'settings', 'db_connect', 'ipua', 'fnc', 'user') as $inc) {
require_once "../../../sys/inc/$inc.php";
}
only_reg('/reg.php');
$s=intval($_GET['id']);
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$s' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$news = $pdo->query("SELECT * FROM `soo_news` WHERE `id_soo`='$soo[id]' AND `id`='".intval($_GET['id_news'])."'")->fetch(PDO::FETCH_ASSOC);
$notes = $pdo->query(("SELECT * FROM `notes` WHERE `id_news` = '$news[id]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$set['title']='Запись - ' . text($notes['name']) . '';
$set['meta_description'] = text($notes['msg']);
include_once '../../../sys/inc/thead.php';
$num=1;
if(isset($_GET['id']) && $pdo->query(("SELECT COUNT(*) FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"),0)->fetchColumn()==1)
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$s' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if($pdo->query(("SELECT COUNT(*) FROM `soo_bl` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()!=0)
{
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$s' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
#Навигация
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='/modules/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/news/news.php?id=$soo[id]'>";
echo lang('Блог группы');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> запись</div>";
echo '<div class="list-group-item">';
echo '<div class="err">Вы добавлены в черный список группы и не можете просмотреть данный объект</div>';
echo '</div>';
}else{
if (isset($user))
{
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` = 'soo_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', 'soo_news')");
$_SESSION['message'] = 'Ваш голос засчитан';
header("Location: list.php?id=$soo[id]&id_news=".intval($_GET['id_news'])."");
exit;
}}
}
if(isset($_GET['id_news']) && $pdo->query(("SELECT COUNT(*) FROM `soo_news` WHERE `id` = '".intval($_GET['id_news'])."' AND `id_soo`='$soo[id]' LIMIT 1"),0)->fetchColumn()==1)
{
$id = intval($_GET['id_news']);
}else{
$set['title']='Ошибка 404'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
err404();
include_once '../../../sys/inc/tfoot.php';
exit();
}
$news = $pdo->query("SELECT * FROM `soo_news` WHERE `id_soo`='$soo[id]' AND `id`='".intval($_GET['id_news'])."'")->fetch(PDO::FETCH_ASSOC);
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '".intval($_GET['id'])."' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
include_once '../../../modules/groups/inc/ban.php';
$notes = $pdo->query(("SELECT * FROM `notes` WHERE `id_news` = '$news[id]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if (isset($user))
$count = $pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '$notes[id]' LIMIT 1"),0)->fetchColumn();
// Запись просмотра
if (isset($user) && $pdo->query(("SELECT COUNT(*) FROM `notes_count` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)->fetchColumn()==0){
$pdo->query("INSERT INTO `notes_count` (`id_notes`, `id_user`) VALUES ('$notes[id]', '$user[id]')")->fetchColumn();
$pdo->query("UPDATE `notes` SET `count` = '".($notes['count']+1)."' WHERE `id` = '$notes[id]' LIMIT 1")->fetchColumn();
}
/*------------------------Мне нравится------------------------*/
if (isset($user))
{
if (isset($_GET['like']) && $_GET['like'] == 1)
{
if ($pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_user` = '".$user['id']."' AND `id_object` = '".$news['id']."' LIMIT 1"),0)->fetchColumn()==0)
{
$pdo->query("INSERT INTO `like_object_soo_news` (`id_user`, `id_object`, `type`, `like`) VALUES ('$user[id]', '$news[id]', 'soo_newsl', '".intval($_GET['like'])."')");
$avtor=get_user($news['avtor']);
///////////////////////////журнал///////////////
if ($news['avtor']!=$user['id']){
if ($avtor['jurnal_news_soo_like']==1){
$pdo->query("UPDATE `audio_count` SET `count` = '1' WHERE `id_user`='".intval($news['avtor'])."'");
$name2="$user[nick] понравилась ваша запись в группе $soo[name]";
$msg2="[url=/modules/groups/news/list.php?id=$soo[id]&id_news=$news[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', '$news[avtor]', '".mysql_real_escape_string($msg2)."', '".htmlspecialchars($name2)."', 'lnews_komm', '$time')");
}
}
//////////////////////////////////////////////
$_SESSION['message'] = 'Ваш голос засчитан';
header("Location: list.php?id=$soo[id]&id_news=$news[id]");
exit;
}
}
}
if ($news['avtor']!=$user['id']){
if (isset($_GET['eye_ok']))
{
if ($pdo->query(("SELECT COUNT(*) FROM `notes_eye` WHERE `id_user` = '".$user['id']."' AND `id_post` = '".intval($news['id'])."' AND `type` = 'soo' LIMIT 1"),0)->fetchColumn()==0){
$pdo->query("INSERT INTO `notes_eye` (`id_post`, `id_user`, `type`) VALUES ('".intval($news['id'])."', '$user[id]', 'soo')");
$_SESSION['message'] = 'Слежка за записью включена. Теперь уведомления о новых комментариях будут приходить к вам в журнал';
header("Location: list.php?id=$soo[id]&id_news=$news[id]");
exit;
}}
if (isset($_GET['eye_no']))
{
$pdo->query("DELETE FROM `notes_eye` WHERE `id_user` = '" .$user['id']. "' AND `type` = 'soo' AND `id_post` = '" .$news['id']. "'");
$_SESSION['message'] = 'Слежка за записью отключена';
header("Location: list.php?id=$soo[id]&id_news=$news[id]");
exit;
}
}
/*------------------------Сохранить в закладки------------------------*/
if (isset($_GET['fav']) && $_GET['fav']==1)
{
if ($pdo->query(("SELECT COUNT(*) FROM `mark_soo_news` WHERE `id_user` = '".$user['id']."' AND `id_news` = '".htmlspecialchars($news['id'])."' LIMIT 1"),0)->fetchColumn()==0)
{
$pdo->query("INSERT INTO `mark_soo_news` (`id_news`, `id_user`, `time`) VALUES ('$news[id]', '$user[id]', '$time')");
$_SESSION['message'] = 'Запись добавлена в ваши закладки';
header("Location: list.php?id=$soo[id]&id_news=$news[id]");
exit;
}
}
if (isset($_GET['fav']) && $_GET['fav']==0)
{
if ($pdo->query(("SELECT COUNT(*) FROM `mark_soo_news` WHERE `id_user` = '".htmlspecialchars($user['id'])."' AND `id_news` = '".htmlspecialchars($news['id'])."' LIMIT 1"),0)->fetchColumn()==1)
{
$pdo->query("DELETE FROM `mark_soo_news` WHERE `id_user` = '$user[id]' AND `id_news` = '$news[id]' ");
$_SESSION['message'] = 'Запись удалена из ваших закладок';
header("Location: list.php?id=$soo[id]&id_news=$news[id]");
exit;
}
}
$set['title']=$news['name']; // заголовок страницы
include_once '../../../sys/inc/thead.php';
$soo = $pdo->query(("SELECT * FROM `soo` WHERE `id` = '$s' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if (isset($_POST['msg']) && isset($user))
{
$msg = htmlspecialchars($_POST['msg']);
if (utf8_strlen($msg)>1024){$err='Сообщение слишком длинное';}
elseif (utf8_strlen($msg)<2){$err='Короткое сообщение';}
elseif ($pdo->query(("SELECT COUNT(*) FROM `soo_news_komm` WHERE `id_news` = '".intval($_GET['id_news'])."' AND `id_user` = '$user[id]' AND `msg` = '".htmlspecialchars($msg)."' LIMIT 1"),0)->fetchColumn()!=0){$err='Ваше сообщение повторяет предыдущее';}
$file_p = $pdo->query(("SELECT COUNT(*) FROM `files_post` WHERE `type` = 'soo_news' 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 `soo_news_komm` (`id_user`, `time`, `msg`, `id_news`, `id_file`) values('$user[id]', '$time', '".$msg."', '".intval($_GET['id_news'])."', '$id_file')");
$post_id = $pdo->lastInsertId();
$pdo->query("UPDATE `files_post` SET `id_post` = '$post_id' WHERE `id_user` = '$user[id]' AND `type` = 'soo_news' AND `active` = '1'");
$pdo->query("UPDATE `files_post` SET `active` = '0' WHERE `id_user` = '$user[id]' AND `type` = 'soo_news' AND `active` = '1'");
$avtor=get_user($news['avtor']);
///////////////////////////журнал///////////////
if ($news['avtor']!=$user['id']){
if ($avtor['jurnal_news_soo_comm']==1){
$pdo->query("UPDATE `audio_count` SET `count` = '1' WHERE `id_user`='".intval($news['avtor'])."'");
$name2="$user[nick] прокомментировал(а) вашу запись в группе $soo[name]";
$msg2="[url=/modules/groups/news/list.php?id=$soo[id]&id_news=$news[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', '$news[avtor]', '".mysql_real_escape_string($msg2)."', '".htmlspecialchars($name2)."', 'snews_komm', '$time')");
}
}
//////////////////////////////////////////////
$q = $pdo->query("SELECT * FROM `notes_eye` WHERE `type` = 'soo' AND `id_post` = '".intval($news['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] прокомментировал(а) запись в группе $soo[name]";
$msg2="[url=/modules/groups/news/list.php?id=$soo[id]&id_news=$news[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', '$eye[id_user]', '".mysql_real_escape_string($msg2)."', '".htmlspecialchars($name2)."', 'snews_komm', '$time')");
/////////////////////////////////////////////////
}
}
$_SESSION['message'] = 'Комментарий успешно добавлен';
header('Location: /modules/groups/news/list.php?id='.$soo['id'].'&id_news='.intval($_GET['id_news']).'');
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` = 'soo_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['del_file']) . "' AND `id_user` = '" .$user['id']. "' AND `type` = 'soo_news'");
$_SESSION['message'] = lang('Вложение успешно удалено');
header('Location: /modules/groups/news/list.php?id='.$soo['id'].'&id_news='.intval($_GET['id_news']).'');
}
#Навигация
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='/modules/groups/group.php?id=$soo[id]'>$soo[name]</a> <i class='fa fa-angle-right fa-fw'></i> <a href='/modules/groups/news/news.php?id=$soo[id]'>";
echo lang('Блог группы');
echo "</a> <i class='fa fa-angle-right fa-fw'></i> запись</div>";
$news = $pdo->query("SELECT * FROM `soo_news` WHERE `id_soo`='$soo[id]' AND `id`='$id'")->fetch(PDO::FETCH_ASSOC);
$notes = $pdo->query(("SELECT * FROM `notes` WHERE `id_news` = '$news[id]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
if($soo['private_news']==1 && $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' LIMIT 1"),0)->fetchColumn()==0 && $user['id']!=$soo['admid'])
{
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>';
}else{
$news = $pdo->query("SELECT * FROM `soo_news` WHERE `id_soo`='$soo[id]' AND `id`='$id' ORDER BY `time`")->fetch(PDO::FETCH_ASSOC);
echo "<div class='list-group-item'>\n";
echo '<i class="fa fa-book fa-fw"></i> ';
$avtor=get_user($news['avtor']);
echo user($avtor['id']);
echo ' : ';
if ($notes['block']==0)
{}else{
echo "<s>";
}
echo '<b><font color=#4694D1>'.$news['name_blog'].'</font></b> <span style="float:right;"><font color=gray><small>'.date::timek($news['time']).'</small></font>';
echo '</span>';
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 '<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: 336px;'>";
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: 226px;'>";
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>';
}
$foto = $pdo->query("SELECT * FROM `soo_news_foto` WHERE `id_news` = '$news[id]'");
while ($post = $foto->fetch(PDO::FETCH_ASSOC))
{
if($post['type']=='foto'){
$foto_id = $pdo->query("SELECT * FROM `gallery_foto` WHERE `id_user` = '$post[id_user]' AND `id` = '".intval($post['id_foto'])."'")->fetch(PDO::FETCH_BOTH);
if(isset($foto_id['id'])){
$ras = htmlspecialchars(text($foto_id['ras']));
echo "<br /><a href='/modules/foto/foto0/$foto_id[id].$foto_id[ras]'>";
echo'<img src="/modules/foto/foto640/'.$foto_id['id'].'.'.$foto_id['ras'].'" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px; max-width: 70%;"/><br />';
echo"</a><br />";
}
}
if($post['type']=='foto_upload'){
$ras = htmlspecialchars(text($post['ras']));
if(is_file(H.'sys/groups/foto/'.$post['id'].'.jpg')){
echo '<a href="/sys/groups/foto/'.$post['id'].'.jpg">';
if (IS_WEB == 1) {
echo'<br /><img src="/sys/groups/foto/'.$post['id'].'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;max-width: 70%;"/><br />';
}else{
echo'<br /><img src="/sys/groups/foto/'.$post['id'].'.jpg" style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;max-width: 60%;"/><br />';
}
echo"</a>";
}
}
if ($post['type'] == 'file') {
echo "<br /><b>Файл:</b> <small><a href='/user/file/file.php?id=".$post['id_file']."'><i class='fa fa-file fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post['name'],0,25))) . "</a></small><br>";
}
if ($post['type'] == 'music') {
echo '<br /><br /><audio style="border: 1px solid #CCDDED; padding: 2px; border-radius: 5px;" src="'.$df['name'].''.$music77.''.$post['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=".$post['id_file']."'><i class='fa fa-music fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post['name'],0,25))) . "</a></small><br>";
}
if ($post['type'] == '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_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.''.$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_file']."'><i class='fa fa-film fa-fw'></i> " . stripcslashes(htmlspecialchars(substr($post['name'],0,25))) . "</a></small><br>";
}
}
//////////////////////////////////////////////////
if ($news['mess']=='0'){
echo '<br>'.output_text($notes['msg']).'<br><br>';
}else{
echo '<br>'.output_text($news['mess']).'<br><br>';
}
include_once'votes.php';
}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>";
}
$notes = $pdo->query(("SELECT * FROM `notes` WHERE `id_news` = '$news[id]' LIMIT 1"))->fetch(PDO::FETCH_ASSOC);
$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>";
}
?>
<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='/modules/blogs/admin/top_delete.php?id=$notes[id]&delete'><button class='adm'>Удл. из ТОПа</button></a> ";
}else{
echo " <a href='/modules/blogs/admin/top_delete.php?id=$notes[id]&v'><button class='adm'>В ТОП</button></a> ";
}
}
if ($notes['block']==0)
{
echo " <a href='/modules/blogs/admin/block.php?id=$notes[id]'><button class='adm'>В блок</button></a> ";
}else{
echo " <a href='/modules/blogs/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='/modules/blogs/admin/cat_delete.php?id=$notes[id]&v'><button class='adm'>Вернуть в категорию</button></a> ";
}else{
echo " <a href='/modules/blogs/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='/modules/blogs/admin/ban.php?id=$notes[id]&ank=$news[avtor]&news'><button class='adm'>Выдать бан</button></a> ";
}else{
echo " <a href='/modules/blogs/admin/ban.php?id=$notes[id]&ank=$news[avtor]&news&r'><button class='adm'>Снять бан</button></a> ";
}
}
echo '</div>';
$mod = $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `mod` = '1' LIMIT 1"),0)->fetchColumn();
if(isset($user) && $user['id']==$soo['admid'] || $user['id']==$news['avtor'] || $mod || 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=".$soo['id']."&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.php?id=".$soo['id']."&id_news=".$news['id']."'><font color='#E24135'><i class='fa fa-trash fa-lg'></i> <b>Удалить</b></font></a></center></td>";
echo "</table>";
echo "</div>";
}
$markinfo = $pdo->query(("SELECT COUNT(*) FROM `mark_soo_news` WHERE `id_news` = '".htmlspecialchars($news['id'])."'"),0)->fetchColumn();
$share = $pdo->query(("SELECT COUNT(*)FROM `notes` WHERE `share_id`='".$news['id']."' AND `share_type`='soo_news'"),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 `like_object_soo_news` WHERE `id_object` = '$news[id]' AND `type` = 'soo_newsl' AND `like` = '1' 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 `like_object_soo_news` WHERE `id_object` = '$news[id]' AND `type` = 'soo_newsl' AND `like` = '1' 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 ($pdo->query(("SELECT COUNT(*) FROM `like_object_soo_news` WHERE `id_object` = '$news[id]' AND `type` = 'soo_newsl' AND `id_user` = '$user[id]' LIMIT 1"),0)->fetchColumn()==0)
echo "<a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='list.php?id=".htmlspecialchars($soo['id'])."&id_news=".htmlspecialchars($news['id'])."&like=1'><i class='fa fa-heart-o fa-fw'></i> Мне нравится</a>";
else
echo "<span style='margin-top: 3px;' class='btn btn-info-outline btn-sm'><i class='fa fa-heart fa-fw'></i></span>";
if ($pdo->query(("SELECT COUNT(*) FROM `mark_soo_news` WHERE `id_user` = '".htmlspecialchars($user['id'])."' AND `id_news` = '".htmlspecialchars($news['id'])."' LIMIT 1"),0)->fetchColumn()==0)
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='list.php?id=".htmlspecialchars($soo['id'])."&id_news=".htmlspecialchars($news['id'])."&fav=1'><i class='fa fa-plus fa-fw'></i> Добавить в закладки</a> \n";
else
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='list.php?id=".htmlspecialchars($soo['id'])."&id_news=".htmlspecialchars($news['id'])."&fav=0'><i class='fa fa-plus fa-fw'></i> Удалить из закладок</a> \n";
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='share.php?id=".$soo['id']."&id_news=".$news['id']."'><i class='fa fa-mail-forward fa-fw'></i> Поделиться</a>";
if ($news['avtor']!=$user['id']){
if($pdo->query(("SELECT COUNT(*)FROM `notes_eye` WHERE `id_user`='".$user['id']."' AND `id_post` = '".$news['id']."' AND `type`='soo' LIMIT 1"),0)->fetchColumn()==0) {
echo " <a style='margin-top: 3px;' class='btn btn-info-outline btn-sm' href='?id=$soo[id]&id_news=$news[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=$soo[id]&id_news=$news[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 `soo_news_komm` WHERE `id_news` = '".$news['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)){
echo "<div class='list-group-item'>";
echo "<b>Новые:</b> <a href='list.php?id=$soo[id]&id_news=$news[id]&page=$page&sort=1' class='".($user['sort']==1?'activ':'')."'>Внизу</a> | ";
echo "<a href='list.php?id=$soo[id]&id_news=$news[id]&page=$page&sort=0' class='".($user['sort']==0?'activ':'')."'>Вверху</a>";
echo "</div>";
}
/*---------------alex-borisi---------------------*/
}
$q=$pdo->query("SELECT * FROM `soo_news_komm` WHERE `id_news` = '$news[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);
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 ($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);
}
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 `soo_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 `soo_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` = 'soo_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>";
}
if ($post['sys'] == 0)
{
echo "<br>";
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> ";
}
$like = $pdo->query(("SELECT COUNT(*) FROM `like_post` WHERE `id_post` = '".$post['id']."' AND `type` = 'soo_news'"),0)->fetchColumn();
if ($pdo->query(("SELECT COUNT(*) FROM `like_post` WHERE `id_user` = '".$user['id']."' AND `id_post` = '".$post['id']."' AND `type` = 'soo_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=".$soo['id']."&id_news=".$news['id']."&type=soo_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='?id=".$soo['id']."&id_news=".$news['id']."&type=soo_news&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=".$soo['id']."&id_news=".$news['id']."&type=soo_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=".$soo['id']."&id_news=".$news['id']."&type=soo_news&id_post=$post[id]'><i class='fa fa-heart fa-fw'></i></a></span> ";
}
if (access('adm_mysql')){
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) && $news['avtor']==$user['id'] && $news['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']==$news['avtor']){
echo "<span style='float: right;'><a class='comm-in' href='delete_komm.php?id=".$soo['id']."&id_news=".$news['id']."&komm=".$post['id']."'><i class='fa fa-trash fa-fw'></i></a></span>";
}
}
echo '</td>';
echo '</tr></table>';
echo "</div>";
}
if ($k_page>1)str("list.php?id=$soo[id]&id_news=$news[id]&",$k_page,$page); // Вывод страниц
$avtor=get_user($news['avtor']);
$ank= $pdo->query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1");
if($news['private_komm']==1 || isset($user) && $pdo->query(("SELECT COUNT(*) FROM `soo_users` WHERE `id_soo` = '$soo[id]' AND `id_user`='$user[id]' AND `invit`='0' AND `activate`='0' LIMIT 1"),0)->fetchColumn()==1 || isset($user) && $user['id']==$soo['admid'] || isset($user) && $user['level']>0)
{}else{
echo "<div class='list-group-item'><div class='err'>Запись могут комментировать только участники группы</div></div>";
include_once '../../../sys/inc/tfoot.php';
exit;
}
if (isset($user))
{
echo "<form method='post' class='list-group-item' name='message'>";
echo auto_bb("message", "msg");
echo "<textarea placeholder='" . lang('Введите сообщение') . "...' name='msg' class='form-control'></textarea><br />";
$doc->Button('knopka', null, 'pencil', 'Опубликовать');
echo "<span style='float: right;'>";
$doc->Link('btn btn-secondary btn-sm', "/user/files_post/foto.php?id=$notes[id]&type=soo_news", 'file');
echo "</span><br>";
$files = $pdo->query("SELECT * FROM `files_post` WHERE `id_user` = '$user[id]' AND `type` = 'soo_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="?id='.$notes['id'].'&del_file='.$post['id'].'"><font color=#F56257><i class="fa fa-trash fa-lg"></i></font></a>';
echo '</span> ';
}
echo "</form>";
}
//////////////////////////////////////////
}
}
}
else
{
$set['title']='Ошибка 404'; // заголовок страницы
include_once '../../../sys/inc/thead.php';
err404();
}
include_once '../../../sys/inc/tfoot.php';
?>