Файл: plugins/notes/list.php
Строк: 455
<?
include_once '../../sys/inc/start.php';
include_once '../../sys/inc/compress.php';
include_once '../../sys/inc/sess.php';
include_once '../../sys/inc/home.php';
include_once '../../sys/inc/settings.php';
include_once '../../sys/inc/db_connect.php';
include_once '../../sys/inc/ipua.php';
include_once '../../sys/inc/fnc.php';
include_once '../../sys/inc/user.php';
/* Бан пользователя */
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `ban` WHERE `razdel` = 'notes' AND `id_user` = '$user[id]' AND (`time` > '$time' OR `view` = '0')"), 0)!=0)
{
header('Location: /ban.php?'.SID);
exit;
}
$notes = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1"));
if (!isset($notes['id']))
{
header('Location: index.php');
exit;
}
$avtor=get_user($notes['id_user']);
if (isset($user))
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_count` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0);
// Закладки
$markinfo = mysql_result(mysql_query("SELECT COUNT(*) FROM `bookmarks` WHERE `id_object` = '".$notes['id']."' AND `type`='notes'"),0);
if (isset($user))
mysql_query("UPDATE `notification` SET `read` = '1' WHERE `type` = 'notes_komm' AND `id_user` = '$user[id]' AND `id_object` = '$notes[id]'");
/*
================================
Модуль жалобы на пользователя
и его сообщение либо контент
в зависимости от раздела
================================
*/
if (isset($_GET['spam']) && isset($user))
{
$mess = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes_komm` WHERE `id` = '".intval($_GET['spam'])."' limit 1"));
$spamer = get_user($mess['id_user']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `spamus` WHERE `id_user` = '$user[id]' AND `id_spam` = '$spamer[id]' AND `razdel` = 'notes_komm' AND `spam` = '".$mess['msg']."'"),0)==0)
{
if (isset($_POST['msg']))
{
if ($mess['id_user']!=$user['id'])
{
$msg=mysql_real_escape_string($_POST['msg']);
if (strlen2($msg)<3)$err='Укажите подробнее причину жалобы';
if (strlen2($msg)>1512)$err='Длина текста превышает предел в 512 символов';
if(isset($_POST['types'])) $types=intval($_POST['types']);
else $types='0';
if (!isset($err))
{
mysql_query("INSERT INTO `spamus` (`id_object`, `id_user`, `msg`, `id_spam`, `time`, `types`, `razdel`, `spam`) values('$notes[id]', '$user[id]', '$msg', '$spamer[id]', '$time', '$types', 'notes_komm', '".my_esc($mess['msg'])."')");
$_SESSION['message'] = 'Заявка на рассмотрение отправлена';
header("Location: ?id=$notes[id]&page=".intval($_GET['page'])."&spam=$mess[id]");
exit;
}
}
}
}
$set['title']='Блог ' . text($notes['name']) . '';
include_once '../../sys/inc/thead.php';
title();
aut();
err();
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `spamus` WHERE `id_user` = '$user[id]' AND `id_spam` = '$spamer[id]' AND `razdel` = 'notes_komm'"),0)==0)
{
echo "<div class='mess'>Ложная информация может привести к блокировке ника.
Если вас постоянно достает один человек - пишет всякие гадости, вы можете добавить его в черный список.</div>";
echo "<form class='nav1' method='post' action='?id=$notes[id]&page=".intval($_GET['page'])."&spam=$mess[id]'>n";
echo "<b>Пользователь:</b> ";
echo " ".avatar($spamer['id'])." ".group($spamer['id'])." <a href="/info.php?id=$spamer[id]">$spamer[nick]</a>n";
echo "".medal($spamer['id'])." ".online($spamer['id'])." (".vremja($mess['time']).")<br />";
echo "<b>Нарушение:</b> <font color='green'>".output_text($mess['msg'])."</font><br />";
echo "Причина:<br />n<select name='types'>n";
echo "<option value='1' selected='selected'>Спам/Реклама</option>n";
echo "<option value='2' selected='selected'>Мошенничество</option>n";
echo "<option value='3' selected='selected'>Оскорбление</option>n";
echo "<option value='0' selected='selected'>Другое</option>n";
echo "</select><br />n";
echo "Комментарий:$tPanel";
echo "<textarea name="msg"></textarea><br />";
echo "<input value="Отправить" type="submit" />n";
echo "</form>n";
}else{
echo "<div class='mess'>Жалоба на <font color='green'>$spamer[nick]</font> будет рассмотрена в ближайшее время.</div>";
}
echo "<div class='foot'>n";
echo "<img src='/style/icons/str2.gif' alt='*'> <a href='?id=$notes[id]&page=".intval($_GET['page'])."'>Назад</a><br />n";
echo "</div>n";
include_once '../../sys/inc/tfoot.php';
exit;
}
/*
==================================
The End
==================================
*/
// Запись просмотра
if (isset($user) && mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_count` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)==0){
mysql_query("INSERT INTO `notes_count` (`id_notes`, `id_user`) VALUES ('$notes[id]', '$user[id]')");
mysql_query("UPDATE `notes` SET `count` = '".($notes['count']+1)."' WHERE `id` = '$notes[id]' LIMIT 1");
}
/*------------очищаем счетчик этого обсуждения-------------*/
if (isset($user))
{
mysql_query("UPDATE `discussions` SET `count` = '0' WHERE `id_user` = '$user[id]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1");
}
/*---------------------------------------------------------*/
$set['title']='Блог - ' . text($notes['name']) . '';
$set['meta_description'] = text($notes['msg']);
include_once '../../sys/inc/thead.php';
if (isset($_POST['msg']) && isset($user))
{
$msg=$_POST['msg'];
if (strlen2($msg)>1024){$err='Сообщение слишком длинное';}
elseif (strlen2($msg)<2){$err='Короткое сообщение';}
elseif (mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_komm` WHERE `id_notes` = '".intval($_GET['id'])."' AND `id_user` = '$user[id]' AND `msg` = '".my_esc($msg)."' LIMIT 1"),0)!=0){$err='Ваше сообщение повторяет предыдущее';}
else
//Начисление рейтинга и монет за активность
mysql_query("UPDATE `user` SET `money` = '" . ($user['money'] + 2) . "', `rating` = '" . ($user['rating'] + 1) . "' WHERE `id` = '$user[id]' LIMIT 1");
if(!isset($err)){
/*
==========================
Уведомления об ответах
==========================
*/
if (isset($user) && $respons==TRUE){
$notifiacation=mysql_fetch_assoc(mysql_query("SELECT * FROM `notification_set` WHERE `id_user` = '".$ank_otv['id']."' LIMIT 1"));
if ($notifiacation['komm'] == 1 && $ank_otv['id'] != $user['id'])
mysql_query("INSERT INTO `notification` (`avtor`, `id_user`, `id_object`, `type`, `time`) VALUES ('$user[id]', '$ank_otv[id]', '$notes[id]', 'notes_komm', '$time')");
}
/*
====================================
Обсуждения
====================================
*/
$q = mysql_query("SELECT * FROM `frends` WHERE `user` = '".$notes['id_user']."' AND `i` = '1'");
while ($f = mysql_fetch_array($q))
{
$a=get_user($f['frend']);
$discSet = mysql_fetch_array(mysql_query("SELECT * FROM `discussions_set` WHERE `id_user` = '".$a['id']."' LIMIT 1")); // Общая настройка обсуждений
if ($f['disc_notes']==1 && $discSet['disc_notes']==1) /* Фильтр рассылки */
{
//---------друзьям автора--------------//
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `discussions` WHERE `id_user` = '$a[id]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1"),0)==0)
{
if ($notes['id_user'] != $a['id'] || $a['id'] != $user['id'])
mysql_query("INSERT INTO `discussions` (`id_user`, `avtor`, `type`, `time`, `id_sim`, `count`) values('$a[id]', '$notes[id_user]', 'notes', '$time', '$notes[id]', '1')");
}
else
{
$disc = mysql_fetch_array(mysql_query("SELECT * FROM `discussions` WHERE `id_user` = '$a[id]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1"));
if ($notes['id_user'] != $a['id'] || $a['id'] != $user['id'])
mysql_query("UPDATE `discussions` SET `count` = '".($disc['count']+1)."', `time` = '$time' WHERE `id_user` = '$a[id]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1");
}
//-------------------------------------//
}
}
//-------------отправляем автору------------//
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `discussions` WHERE `id_user` = '$notes[id_user]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1"),0)==0)
{
if ($notes['id_user'] != $user['id'])
mysql_query("INSERT INTO `discussions` (`id_user`, `avtor`, `type`, `time`, `id_sim`, `count`) values('$notes[id_user]', '$notes[id_user]', 'notes', '$time', '$notes[id]', '1')");
}
else
{
$disc = mysql_fetch_array(mysql_query("SELECT * FROM `discussions` WHERE `id_user` = '$notes[id_user]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1"));
if ($notes['id_user'] != $user['id'])
mysql_query("UPDATE `discussions` SET `count` = '".($disc['count']+1)."', `time` = '$time' WHERE `id_user` = '$notes[id_user]' AND `type` = 'notes' AND `id_sim` = '$notes[id]' LIMIT 1");
}
mysql_query("INSERT INTO `notes_komm` (`id_user`, `time`, `msg`, `id_notes`) values('$user[id]', '$time', '".my_esc($msg)."', '".intval($_GET['id'])."')");
mysql_query("UPDATE `user` SET `balls` = '".($user['balls']+1)."' WHERE `id` = '$user[id]' LIMIT 1");
$_SESSION['message'] = 'Сообщение успешно отправлено';
header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
exit;
}
}
if (isset($user))
$frend = mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$user[id]' AND `frend` = '$avtor[id]') OR (`user` = '$avtor[id]' AND `frend` = '$user[id]') LIMIT 1"),0);
title();
aut(); // форма авторизации
err();
if ($notes['private']==1 && $user['id']!=$avtor['id'] && $frend!=2 && !user_access('notes_delete'))
{
msg('Дневник доступен только для друзей');
echo " <div class='foot'>n";
echo "<a href='index.php'>Назад</a><br />n";
echo " </div>n";
include_once '../../sys/inc/tfoot.php';
exit;
}
if ($notes['private']==2 && $user['id']!=$avtor['id'] && !user_access('notes_delete'))
{
msg('Пользователь запретил просмотр дневника');
echo " <div class='foot'>n";
echo "<a href='index.php'>Назад</a><br />n";
echo " </div>n";
include_once '../../sys/inc/tfoot.php';
exit;
}
if (isset($_GET['delete']) && ($user['id']==$avtor['id'] || user_access('notes_delete'))){
echo '<div class="mess">';
echo "Вы действительно хотите удалить дневник " . output_text($notes['name']) . "?";
echo '</div>';
echo "<a class='link' href='delete.php?id=$notes[id]'><i class='fas fa-check-circle'></i> Удалить</a> <a class='link' href='list.php?id=$notes[id]'><i class='fas fa-times-circle'></i> Отмена</a>";
include_once '../../sys/inc/tfoot.php';
}
if (isset($user))
{
if (isset($_GET['like']) && $_GET['like'] == 1)
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)==0)
{
mysql_query("INSERT INTO `notes_like` (`id_notes`, `id_user`, `like`) VALUES ('$notes[id]', '$user[id]', '1')");
mysql_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['like']) && $_GET['like'] == 0)
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)==0)
{
mysql_query("INSERT INTO `notes_like` (`id_notes`, `id_user`, `like`) VALUES ('$notes[id]', '$user[id]', '0')");
mysql_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 (mysql_result(mysql_query("SELECT COUNT(*) FROM `bookmarks` WHERE `id_user` = '".$user['id']."' AND `id_object` = '".$notes['id']."' AND `type`='notes' LIMIT 1"),0)==0)
{
mysql_query("INSERT INTO `bookmarks` (`type`,`id_object`, `id_user`, `time`) VALUES ('notes','$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 (mysql_result(mysql_query("SELECT COUNT(*) FROM `bookmarks` WHERE `id_user` = '".$user['id']."' AND `id_object` = '".$notes['id']."' AND `type`='notes' LIMIT 1"),0)==1)
{
mysql_query("DELETE FROM `bookmarks` WHERE `id_user` = '$user[id]' AND `id_object` = '$notes[id]' AND `type`='notes' ");
$_SESSION['message'] = 'Дневник удален из закладок';
header("Location: list.php?id=$notes[id]&page=".intval($_GET['page'])."");
exit;
}
}
}
//Содержимое блога
echo '<a class="link" href="index.php"><i class="fas fa-angle-left"></i> Все блоги</a>';
echo '<table style="border-bottom:none;" class="mess">';
echo '<td width="3%">' .avatar($avtor['id']).'</td>';
echo '<td>';
echo group($avtor['id']);
echo " ".user::nick($avtor['id'],1,1,1)."</br>";
echo 'Добавлено '.vremja($notes['time']).'';
echo '</td></table>';
$stat1 = $notes['msg'];
if (!$set['web'])$mn=500;else $mn=500; // количество слов выводится в зависимости от браузера
$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 '<div class="mess">' . output_text($stat_1) , ''; // вывод статьи со всем форматированием
echo "</br></br><span style='font-size: 12px; color: #67676e;'><i class='far fa-eye'></i> ".$notes['count']."</span><span style='float:right;'>";
$l1=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '0' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0);
$l2=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '1' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0);
if (isset($user) && $user['id']!=$avtor['id']){
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `id_user` = '".$user['id']."' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)==0)
echo "<a href='list.php?id=$notes[id]&like=1'><i class='fas fa-thumbs-up'></i></a> <span style='font-size: 12px; color: #67676e;'>".($l2-$l1)."</span> <a href='list.php?id=$notes[id]&like=0'><i class='far fa-thumbs-up'></i></a>";
else
echo "<span style='font-size: 12px; color: #67676e;'> <i class='fas fa-thumbs-up'></i> ".($l2-$l1)."</span> <i class='far fa-thumbs-up'></i> ";
}else{
echo "<span style='font-size: 12px; color: #67676e;'> <i class='fas fa-thumbs-up'></i> ".($l2-$l1)."</span> <i class='far fa-thumbs-up'></i> ";
}
echo '</span>';
notes_share($notes['id']); echo '</div>';
if ($k_page>1)str("?id=$notes[id]&",$k_page,$page); // Вывод страниц
/*----------------------листинг-------------------
$listr = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes` WHERE `id` < '$notes[id]' ORDER BY `id` DESC LIMIT 1"));
$list = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes` WHERE `id` > '$notes[id]' ORDER BY `id` ASC LIMIT 1"));
echo '<div class="c2" style="text-align: center;">';
echo '<span class="page">'.($list['id']?'<a href="list.php?id='.$list['id'].'">« Пред.</a> ':'« Пред. ').'</span>';
$k_1=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes` WHERE `id` > '$notes[id]'"),0)+1;
$k_2=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes`"),0);
echo ' ('.$k_1.' из '.$k_2.') ';
echo '<span class="page">' . ($listr['id'] ? '<a href="list.php?id=' . $listr['id'] . '">След. »</a>' : ' След. »') . '</span>';
echo '</div>';
/*----------------------plugins---------------*/
//Управление
if (isset($user) && (user_access('notes_delete') || $user['id']==$avtor['id'])){
echo '<table style="text-align:center;" cellspacing="0" cellpadding="0">';
echo "<td><a rel style='border-right: none;' class='link' href='edit.php?id=$notes[id]'>Изменить</a></td>";
echo "<td><a class='link' href='?id=$notes[id]&delete'>Удалить</a></td>";
echo '</table>';
}
/*
===================================
Комментарии дневников
===================================
*/
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_komm` WHERE `id_notes` = '".intval($_GET['id'])."'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo '<div class="hr"></div>';
if ($k_post==0)
{
echo '<div class="gmenu">';
echo "Комментариев нет";
echo '</div>';
}
else if (isset($user))
{
/*------------сортировка по времени--------------
if (isset($user)){
echo "<div id='comments' class='menus'>";
echo "<div class='webmenu'>";
echo "<a href='list.php?id=$notes[id]&page=$page&sort=1' class='".($user['sort']==1?'activ':'')."'>Внизу</a>";
echo "</div>";
echo "<div class='webmenu'>";
echo "<a href='list.php?id=$notes[id]&page=$page&sort=0' class='".($user['sort']==0?'activ':'')."'>Вверху</a>";
echo "</div>";
echo "</div>";
}
/*---------------alex-borisi---------------------*/
}
$q=mysql_query("SELECT * FROM `notes_komm` WHERE `id_notes` = '".intval($_GET['id'])."' ORDER BY `time` $sort LIMIT $start, $set[p_str]");
echo "<table class='post'>n";
while ($post = mysql_fetch_assoc($q))
{
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1"));
echo '<table class="mess">';
echo '<td style="vertical-align: top;" width="3%">';
if (isset($user) && $ank['id'] != $user['id'])echo "<a href='?id=$notes[id]&response=$ank[id]'>";
echo ''.avatar($ank['id']).'</a>';
echo '</td><td>' .group($ank['id'])."";
echo " ".user::nick($ank['id'])."";
echo "".medal($ank['id'])." ".online($ank['id'])."";
echo '<span style="float: right; font-size: .7em;">' .vremja($post['time']). '</span></br>';
$postBan = mysql_result(mysql_query("SELECT COUNT(*) FROM `ban` WHERE (`razdel` = 'all' OR `razdel` = 'notes') AND `post` = '1' AND `id_user` = '$ank[id]' AND (`time` > '$time' OR `navsegda` = '1')"), 0);
if ($postBan == 0) // Блок сообщения
{
echo output_text($post['msg'])."<br />n";
}else{
echo output_text($banMess).'<br />';
}
if (isset($user)){
echo '<span style="float: right; margin-top: -15px;font-size: 12px;">';
if ($ank['id']!=$user['id'])
echo "<a href="?id=$notes[id]&page=$page&spam=$post[id]"><i class='fas fa-exclamation-triangle'></i></a> ";
if (isset($user) && (user_access('notes_delete') || $user['id']==$notes['id_user']))
echo '<a href="delete.php?komm='.$post['id'].'"><i class="fas fa-times-circle"></i></a>';
echo '</span>';
}
echo '</td></table>';
}
echo "</table>n";
if ($k_page>1)str("list.php?id=".intval($_GET['id']).'&',$k_page,$page); // Вывод страниц
if ($notes['private_komm']==1 && $user['id']!=$avtor['id'] && $frend!=2 && !user_access('notes_delete')){
msg('Комментировать могут только друзья');
echo " <div class='foot'>n";
echo "<a href='index.php'>Назад</a><br />n";
echo " </div>n";
include_once '../../sys/inc/tfoot.php';
exit;
}
if ($notes['private_komm']==2 && $user['id']!=$avtor['id'] && !user_access('notes_delete')){
msg('Пользователь запретил комментирование дневника');
echo " <div class='foot'>n";
echo "<a href='index.php'>Назад</a><br />n";
echo " </div>n";
include_once '../../sys/inc/tfoot.php';
exit;
}
if (isset($user)){
echo '<div class="hr"></div>';
echo '<div class="mess">';
echo "<form method="post" name='message' action="?id=".intval($_GET['id'])."&page=$page".$go_otv."">n";
if ($set['web'] && is_file(H.'style/themes/'.$set['set_them'].'/altername_post_form.php'))
include_once H.'style/themes/'.$set['set_them'].'/altername_post_form.php';
else
echo "$tPanel<textarea placeholder='Введите сообщение...' name="msg">$otvet</textarea><br />n";
echo '<table>';
echo "<td><input value="Отправить" type="submit" /></td>";
?><td width="1"><a href="#" onclick="$('.smile').toggle();return false;"><i style="color: #757577; font-size: 18px;" class="far fa-smile"></i></a></td><?
echo '</table>';
echo "</form>n";
echo '</div>';
include '../../ajax/smile.php';
}
include_once '../../sys/inc/tfoot.php';
?>