Файл: jur_forum/jurnal_up.php
Строк: 75
<?
include_once '../sys/includes/start.php';
include_once '../sys/includes/compress.php';
include_once '../sys/includes/sess.php';
include_once '../sys/includes/home.php';
include_once '../sys/includes/settings.php';
include_once '../sys/includes/db_connect.php';
include_once '../sys/includes/ipua.php';
include_once '../sys/includes/fnc.php';
include_once '../sys/includes/user.php';
only_reg();
$set['title']='Оповещения форума ';
include_once '../sys/includes/header.php';
title();
auter();
if (isset($_GET['read']) && ($_GET['read']) == $user['id'])
{
mysql_query("UPDATE `jurnal_forum` SET `upset` = '0' , `del` = '0' WHERE `id_user` = '".intval($_GET['read'])."' AND `upset` = '1' ");
}
$con=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal_forum` WHERE `upset` = '1' AND `id_user` = '$user[id]' AND `otkl` = '0'"), 0);
$con2=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `del` = '0' AND `otkl` = '0'"), 0);
echo '<div class="title">';
echo "<a href='/jur_forum/jurnal_vse.php'>Все ($con2)</a>";
echo " | Новые ($con)</a>";
echo '</div>';
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `upset` = '1' AND `otkl` = '0'"), 0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($con == 0)
{
echo '<div class="err">';
echo "Пока пусто!";
echo '</div>';
}
$opd = mysql_query("SELECT * FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `otkl` = '0' ORDER BY `date` DESC LIMIT $start, $set[p_str]");
while ($op = mysql_fetch_assoc($opd))
{
$them=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_t` WHERE `id` = '$op[them_id]' LIMIT 1"));
$forum=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_f` WHERE `id` = '$them[id_forum]' LIMIT 1"));
$razdel=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_r` WHERE `id` = '$them[id_razdel]' LIMIT 1"));
if (($op['upset']==1))
{
if (isset($_GET['otkl']) && $_GET['otkl']==$them['id'])
{
mysql_query("UPDATE `jurnal_forum` SET `otkl` = '1' WHERE `them_id` = '".intval($_GET['otkl'])."' AND `id_user` = '$user[id]'");
header("location: jurnal_up.php");
}
echo "<div class='aut'>";
$count=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = '$forum[id]' AND `id_razdel` = '$razdel[id]' AND `id_them` = '$them[id]'"),0);
$count2=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = '$forum[id]' AND `id_razdel` = '$razdel[id]' AND `id_them` = '$them[id]'
AND `time` > '$op[time]'
"),0);
echo "<img src='/s-klub/img/forum.png'/> <a href='/forum/$forum[id]/$razdel[id]/$them[id]/?os=$user[id]'>$them[name]</a> ($count)n";
if ($them['id']==0)
{
echo "Тема удалена!";
mysql_query("DELETE FROM `jurnal_forum` WHERE `them_id` = '$op[them_id]' AND `id_user` = '$user[id]'");
}
if ($count2 > 0)
{
echo "<font color='red'> + ".$count2." </font>";
}
echo " (<a href='/jur_forum/jurnal_up.php?otkl=$them[id]'>Отключить</a>)";
echo "</div>n";
}
}
if ($k_page>1)str("?",$k_page,$page);
echo '<div class="foot">';
echo "<img src='/s-klub/img/del.png'/> <a href='/jur_forum/jurnal_up.php?read=$user[id]'>Отметить как прочитанные</a><br />";
echo '</div>';
$con3=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `otkl` = '1' "), 0);
echo '<div class="foot">';
echo "<img src='/s-klub/img/del.png'/> <a href='/jur_forum/jurnal_upswitch.php'>Отключенные уведомления </a>($con3)<br />";
echo '</div>';
include_once '../sys/includes/footer.php';
?>