<?
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';
$notes = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes` WHERE `id` = '". intval($_GET['id']) ."' LIMIT 1"));
$avtor=get_user($notes['id_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 `mark_notes` WHERE `id_list` = '".$notes['id']."'"),0);
if (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");
header("Location: list.php?id=$notes[id]");
}
//------------очищаем счетчик этого обсуждения-------------//
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']='Дневник ' . $avtor['nick'] . '';
include_once '../../sys/inc/thead.php';
if (isset($_POST['msg']) && isset($user))
{
$msg=$_POST['msg'];
if (isset($_POST['translit']) && $_POST['translit']==1)$msg=translit($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='Ваше сообщение повторяет предыдущее';}
elseif(!isset($err)){
//----------------уведомления------------------//
if (isset($user) && $respons==TRUE){
$msgenta = 'Привет, '.$user['nick'].' ответил вам в [url=/plugins/notes/list.php?id='.$notes['id'].'][b] дневнике '.$notes['name'].'[/b][/url]';
mysql_query("INSERT INTO `lenta_komm` (`id_user`, `id_kont`, `msg`, `time`) values('160', '$ank_otv[id]', '$msgenta', '$time')");
}
if(isset($user) && $notes['id_user']!=$user['id'] && $respons==false){
$msg_p = 'Привет, '.$user['nick'].' оставил в твоем дневнике [url=/plugins/notes/list.php?id='.$notes['id'].'][b]'.$notes['name'].'[/b][/url] комментарий';
mysql_query("INSERT INTO `lenta_komm` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$notes[id_user]', '".my_esc($msg_p)."', '$time')");
}
//-------------------alex-borisi------------------//
######################Обсуждения
$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']);
//---------друзьям автора--------------//
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 ($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` = '$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");
}
//-------------------------------------//
}
//-------------отправляем автору------------//
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");
msg('Ваш комментарий успешно принят');
}
}
$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);
err();
title();
aut(); // форма авторизации
if ($notes['private']==1 && $user['id']!=$avtor['id'] && $frend!=2 && $user['level']<$avtor['level']){
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['level']<$avtor['level']){
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['sort']) && $_GET['sort']=='up'){
mysql_query("UPDATE `user` SET `sort` = '1' WHERE `id` = '$user[id]' LIMIT 1");
header("location: list.php?id=$notes[id]&page=$page");
}
if (isset($_GET['sort']) && $_GET['sort']=='down'){
mysql_query("UPDATE `user` SET `sort` = '0' WHERE `id` = '$user[id]' LIMIT 1");
header("location: list.php?id=$notes[id]&page=$page");
}
//--------------------------------------------------------------------//
if (isset($_GET['delete']) && $user['id']==$avtor['id'] || isset($_GET['delete']) && $user['level']>$avtor['level']){
echo "<center>";
echo "Вы действительно хотите удалить дневник " . output_text($notes['name']) . "?<br />";
echo "[<a href='delete.php?id=$notes[id]'><img src='/style/icons/ok.gif'> удалить</a>] [<a href='list.php?id=$notes[id]'><img src='/style/icons/delete.gif'> отмена</a>] \n";
echo "</center>";
include_once '../../sys/inc/tfoot.php';
}
if (isset($_GET['markinfo'])){
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `mark_notes` WHERE `id_list` = '$notes[id]'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>\n";
if ($k_post==0)
{
echo " <tr>\n";
echo " <td class='p_t'>\n";
echo "Нет дневника в закладках\n";
echo " </td>\n";
echo " </tr>\n";
}
$q=mysql_query("SELECT * FROM `mark_notes` WHERE `id_list` = '$notes[id]' ORDER BY id DESC LIMIT $start, $set[p_str]");
while ($post = mysql_fetch_assoc($q))
{
$ank_p=get_user($post['id_user']);
echo " <tr>\n";
if ($set['set_show_icon']==2){
echo " <td class='icon48' rowspan='2'>\n";
avatar($ank_p['id']);
echo " </td>\n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>\n";
echo "".status($ank_p['id'])."";
echo " </td>\n";
}
echo " <td class='p_t'>\n";
echo " ".group($ank_p['id'])." <a href='/info.php?id=$ank_p[id]'>" . GradientText("$ank_p[nick]", "$ank_p[ncolor]", "$ank_p[ncolor2]") . "</a>\n";
echo "".medal($ank_p['id'])." ".online($ank_p['id'])." (".vremja($post['time']).") ";
echo " </td>\n";
echo " </tr>\n";
}
echo "</table>\n";
if ($k_page>1)str('?',$k_page,$page); // Вывод страниц
echo " <div class='foot'>\n";
echo "<a href='list.php?id=$notes[id]'>Назад</a><br />\n";
echo " </div>\n";
include_once '../../sys/inc/tfoot.php';
}
//------------------------like-----------------//
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");
msg('Ваш положительный отзыв принят');
}
}
//-----------------------------------------------//
//------------------------dlike-----------------//
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");
msg('Ваш отрицательный отзыв принят');
}
}
//-----------------------------------------------//
//-----------------------добавляем в закладки------------//
if (isset($_GET['fav']) && $_GET['fav']==1){
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `mark_notes` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$notes['id']."' LIMIT 1"),0)==0){
mysql_query("INSERT INTO `mark_notes` (`id_list`, `id_user`, `time`) VALUES ('$notes[id]', '$user[id]', '$time')");
msg('' . output_text($notes['name']) . ' добавлен в закладки');
}
}
//-------------------------------------------------------//
//-----------------------удаляем из закладок------------//
if (isset($_GET['fav']) && $_GET['fav']==0){
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `mark_notes` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$notes['id']."' LIMIT 1"),0)==1){
mysql_query("DELETE FROM `mark_notes` WHERE `id_user` = '$user[id]' AND `id_list` = '$notes[id]' ");
msg('' . output_text($notes['name']) . ' удален из закладок');
}
}
//-------------------------------------------------------//
echo "<div class='foot'>\n";
echo " ".group($avtor['id'])." <a href='/info.php?id=$avtor[id]'>" . GradientText("$avtor[nick]", "$avtor[ncolor]", "$avtor[ncolor2]") . "</a> ".online($avtor['id'])." ".medal($avtor['id'])." ";
echo "/ <b>" . output_text($notes['name']) . "</b>";
echo " (".vremja($notes['time']).")\n";
echo " </div>\n";
echo output_text($notes['msg'])."<br />";
$q=mysql_query("SELECT * FROM `notes_image` WHERE `id_notes` = '".intval($notes['id'])."' ORDER BY `id` ");
$num2=0;
while ($post = mysql_fetch_assoc($q))
{
//-----------зебра-----------//
if ($num2==0)
{echo " <div class='nav1'>\n";
$num2=1;
}elseif ($num2==1)
{echo " <div class='nav2'>\n";
$num2=0;}
//---------------------------//
echo "<center>";
echo "<a href='/sys/notes/$notes[id]/$post[url].jpg'><img src='/sys/notes/pr_$notes[id]/$post[url].jpg' alt=''/></a>\n";
if ($post['msg'])echo "<font size='2'>".htmlspecialchars($post['msg'])."</font><br />";
echo "</center>";
echo "</div>";
}
//----------------------листинг-------------------//
if (isset($_GET['dir']))
{
$sorts = "AND `id_dir` = '$notes[id_dir]'";
$ss = "&dir=$_GET[dir]";
}else{
$sorts = null;
$ss = null;
}
$listr = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes` WHERE `id` < '$notes[id]' $sorts ORDER BY `id` DESC LIMIT 1"));
$list = mysql_fetch_assoc(mysql_query("SELECT * FROM `notes` WHERE `id` > '$notes[id]' $sorts ORDER BY `id` ASC LIMIT 1"));
echo "<center>";
if ($listr['id'] || $list['id'])echo "<div class=\"foot\">\n";
if ($list['id'])echo "<span class='pages'><a href='list.php?id=$list[id]$ss'>«Пред.</a></span>";
if ($listr['id'] && $list['id'])echo " • ";
if ($listr['id'])echo "<span class='pages'><a href='list.php?id=$listr[id]$ss'>След.»</a></span>";
echo "</center>";
if ($listr['id'] || $list['id'])echo "</div>\n";
//----------------------alex-borisi---------------//
echo "<div class='main_null'>";
if (isset($user) && ($user['level']>$avtor['level']) || $user['id']==$avtor['id']){
echo "Инструменты: ";
echo "[<a href='image.php?id=$notes[id]'><img src='/style/icons/pht2.png' alt=''/> фото</a>]";
echo " [<a href='edit.php?id=$notes[id]'><img src='/style/icons/edit.gif'> ред</a>] [<a href='?id=$notes[id]&delete'><img src='/style/icons/delete.gif'> удл</a>]\n";
}
echo "</div>";
if ($avtor['id']==$user['id'])echo "<div class='main'>";
else
echo "<div class='main_null'>";
echo "<b>Рейтинг: $notes[count]</b><br />";
echo "</div>";
if (isset($user) && $user['id']!=$avtor['id']){
echo "<div class='main'>";
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 "[<img src='/style/icons/like.gif' alt='*' /> <a href='list.php?id=$notes[id]&like=1'>Нравится</a>] [<a href='list.php?id=$notes[id]&like=0'><img src='/style/icons/dlike.gif' alt='*' /></a>]<br />\n";
else
echo "[<img src='/style/icons/like.gif' alt='*' /> ".mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '1' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)."] [<img src='/style/icons/dlike.gif' alt='*' /> ".mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '0' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)."]\n";
echo "</div>";
}else{
echo "<div class='main'>";
echo "[<img src='/style/icons/like.gif' alt='*' /> ".mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '1' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)."] [<img src='/style/icons/dlike.gif' alt='*' /> ".mysql_result(mysql_query("SELECT COUNT(*) FROM `notes_like` WHERE `like` = '0' AND `id_notes` = '".$notes['id']."' LIMIT 1"),0)."]\n";
echo "</div>";
}
//--------------------------В закладки-----------------------------//
if (isset($user)){
echo "<div class='main_seriy'>";
echo "<div class='main'>";
echo "<img src='/style/icons/fav.gif' alt='*' /> ";
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `mark_notes` WHERE `id_user` = '".$user['id']."' AND `id_list` = '".$notes['id']."' LIMIT 1"),0)==0)
echo "<a href='list.php?id=$notes[id]&fav=1'>Добавить в закладки</a><br />\n";
else
echo "<a href='list.php?id=$notes[id]&fav=0'>Удалить из закладок</a><br />\n";
echo "В закладках у <a href='list.php?id=$notes[id]&markinfo'>$markinfo</a> чел.";
echo "</div>";
echo "</div>";
}
//-------------------------------------------------------------//
echo 'Поделится:<script type="text/javascript" src="//yandex.st/share/share.js" charset="utf-8"></script>
<span class="yashare-auto-init" data-yashareL10n="ru" data-yashareType="none" data-yashareQuickServices="vkontakte,twitter,odnoklassniki,moimir"></span>';
$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='foot'>";
echo "Новые:";
if (isset($user) && $user['sort']==0)
echo " <a href=\"list.php?id=$notes[id]&page=$page&sort=up\" title='Вверху'>вверху</a> | <b>внизу</b>";
else
echo " <b>вверху</b> | <a href=\"list.php?id=$notes[id]&page=$page&sort=down\" title='Внизу'>внизу</a>";
echo "</div>";
if ($user['sort']==0)$sort = "ASC";
if ($user['sort']==1)$sort = "DESC";
$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";
if ($k_post==0)
{
echo " <tr>\n";
echo " <td class='p_t'>\n";
echo "Нет комментариев\n";
echo " </td>\n";
echo " </tr>\n";
}
while ($post = mysql_fetch_assoc($q))
{
//$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1"));
$ank=get_user($post['id_user']);
echo " <tr>\n";
if ($set['set_show_icon']==2){
echo " <td class='icon48' rowspan='2'>\n";
avatar($ank['id']);
echo " </td>\n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>\n";
echo "".status($ank['id'])."";
echo " </td>\n";
}
echo " <td class='p_t'>\n";
echo " ".group($ank['id'])." <a href='/info.php?id=$ank[id]'>" . GradientText("$ank[nick]", "$ank[ncolor]", "$ank[ncolor2]") . "</a> <a href='?id=$notes[id]&response=$ank[id]'>[*]</a> \n";
echo "".medal($ank['id'])." ".online($ank['id'])." (".vremja($post['time']).")";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
if ($set['set_show_icon']==1)echo " <td class='p_m' colspan='2'>\n"; else echo " <td class='p_m'>\n";
echo output_text($post['msg'])."<br />\n";
if (isset($user) && ($user['group_access']>6 || $user['level']!=0 && $user['id']==$notes['id_user']))
echo "<a href='delete.php?komm=$post[id]'>Удалить</a><br />\n";
echo " </td>\n";
echo " </tr>\n";
}
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['level']<=$avtor['level']){
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['level']<=$avtor['level']){
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 "<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';
elseif ($set['mobile'] && is_file(H.'style/themes/'.$set['set_them'].'/altername_post_form.php'))
include_once H.'style/themes/'.$set['set_them'].'/altername_post_form.php';
elseif ($set['smart'] && 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 "Сообщение:<br />\n<textarea name=\"msg\">$otvet</textarea><br />\n";
if ($user['set_translit']==1)echo "<label><input type=\"checkbox\" name=\"translit\" value=\"1\" /> Транслит</label><br />\n";
echo "<input value=\"Отправить\" type=\"submit\" />\n";
echo "</form>\n";
}
echo " <div class='foot'>\n";
echo "<a href='index.php'>Назад</a><br />\n";
echo " </div>\n";
include_once '../../sys/inc/tfoot.php';
?>