Файл: jur_forum/jurnal_upswitch.php
Строк: 66
<?
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();
$con=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `upset` = '1' 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 " | <a href='/jur_forum/jurnal_up.php'>Новые ($con)</a>";
echo '</div>';
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `otkl` = '1' "), 0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($k_post == 0)
{
echo '<div class="err">';
echo "Пока пусто!";
echo '</div>';
}
$opd = mysql_query("SELECT * FROM `jurnal_forum` WHERE `id_user` = '$user[id]' AND `otkl` = '1' 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 (isset($_GET['vkl']) && $_GET['vkl']==$them['id'])
{
mysql_query("UPDATE `jurnal_forum` SET `otkl` = '0' WHERE `them_id` = '".intval($_GET['vkl'])."' AND `id_user` = '$user[id]'");
header("location: jurnal_upswitch.php");
}
echo "<div class='p_t'>";
$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_upswitch.php?vkl=$them[id]'>Включить</a>)";
echo "</div>n";
}
if ($k_page>1)str("?",$k_page,$page);
include_once '../sys/includes/footer.php';
?>