Файл: cmpl_mail/index.php
Строк: 291
<?php
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/shif.php';
include_once '../sys/inc/user.php';
$set['title']='Жалобы в почте';
include_once '../sys/inc/thead.php';
title();
aut();
err();
include_once 'style.php';
if(isset($_GET['user']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$_GET[user]'"),0)!=0)
{
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Жалобы</a></div>n";
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$_GET[user]' LIMIT 1"));
echo "<img src='img/user.png'/> Ник: <a href='/?user=$ank[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>$ank[nick]</a><br/>";
echo "<img src='img/cat.png'/> Имя: ".htmlspecialchars($ank['ank_name'])."<br/>";
echo "<img src='img/time.png'/> Посл.посещение: ".vremja($ank['date_last'])."<br/>";
echo "<img src='img/ok.png'/> О себе: ".output_text($ank['ank_o_sebe'])."<br/>";
echo "<img src='img/closed.png'/><a href='/adm_panel/ban.php?id=$ank[id]'>Выдать бан</a>";
include_once '../sys/inc/tfoot.php';
exit;
}
if(isset($_GET['do_cmpl']))
{
$doc=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$_GET[do_cmpl]' LIMIT 1"));
if($doc['do_cmpl_mail']==0)
{
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Жалобы</a></div>n";
if(isset($_POST['ok']))
{
mysql_query("UPDATE `user` SET `do_cmpl_mail` = '1' WHERE `id` = '$doc[id]' LIMIT 1");
echo "<div class='msg'><img src='img/ok.png'/> Успешно!</div>";
}
else
{
echo "Вы действительно хотите запретить писать жалобы даному пользователю?<br />n";
echo "<form method='post' action='?do_cmpl=$doc[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>n";
echo "<input type='submit' name='ok' value='Да' />n";
echo "</form>n";
echo "<small> <a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Нет</a></small><br />n";
}
include_once '../sys/inc/tfoot.php';
exit;
}
else
{
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Жалобы</a></div>n";
if(isset($_POST['ok']))
{
mysql_query("UPDATE `user` SET `do_cmpl_mail` = '0' WHERE `id` = '$doc[id]' LIMIT 1");
echo "<div class='msg'><img src='img/ok.png'/> Успешно!</div>";
}
else
{
echo "<img src='img/err.png'/> Вы действительно хотите разрешить писать жалобы даному пользователю?<br />n";
echo "<form method='post' action='?do_cmpl=$doc[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>n";
echo "<input type='submit' name='ok' value='Да' />n";
echo "</form>n";
echo "<small> <a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Нет</a></small><br />n";
}
include_once '../sys/inc/tfoot.php';
exit;
}
}
if(isset($_GET['msg_mail']) && mysql_result(mysql_query("SELECT COUNT(*) FROM `mail_cmpl` WHERE `id` = '$_GET[msg_mail]' LIMIT 1"),0)!=0)
{
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Жалобы</a></div>n";
$msg_id=$_GET['msg_mail'];
$msg=mysql_fetch_array(mysql_query("SELECT * FROM `mail_cmpl` WHERE `id` = '$msg_id' LIMIT 1"));
$avtor=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = $msg[id_who] LIMIT 1"));
$komm=mysql_fetch_array(mysql_query("SELECT * FROM `mail` WHERE `id` = '$msg[id_subject]' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `id` = '$msg[id_subject]'"),0)==0)
{
echo "<font color='red'><img src='img/err.png'/> Сообщение удалено, но в базе данных система нашла копию етого сообщения:
</font><br/>";
echo "<img src='img/cat.png'/> ".output_text($msg['msg_mail'])."<br />n";
}
else echo "<img src='img/cat.png'/> ".output_text($komm['msg'])."<br />n";
include_once '../sys/inc/tfoot.php';
exit;
}
if(isset($_GET['msg']))
{
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?".(isset($_GET['resh'])?"resh":"unresh")."'>Жалобы</a></div>n";
$msg_id=$_GET['msg'];
$msg=mysql_fetch_array(mysql_query("SELECT * FROM `mail_cmpl` WHERE `id` = '$msg_id' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `mail_cmpl` WHERE `id` = '$msg[id]' LIMIT 1"),0)==0)
{
echo "<img src='img/err.png'/> Сообщение не найдено!n";
include_once '../sys/inc/tfoot.php';
exit;
}
elseif(strlen2($msg['msg'])<1)
{
echo "<img src='img/err.png'/> Сообщение не найдено!n";
include_once '../sys/inc/tfoot.php';
exit;
}
echo "<img src='img/cat.png'/> ".output_text($msg['msg'])."<br />n";
include_once '../sys/inc/tfoot.php';
exit;
}
if(isset($_GET['resh']))
{
echo "<div class='title1'><b>Жалобы решенные</b></div>n";
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail_cmpl` WHERE `ok` = '1'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$cmpl_list = mysql_query("SELECT * FROM `mail_cmpl` WHERE `ok` = '1' ORDER BY time LIMIT $start, $set[p_str]");
if (mysql_num_rows($cmpl_list)==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Список пустn";
echo " </td>n";
echo " </tr>n";
}
while ($post = mysql_fetch_array($cmpl_list))
{
if(isset($num) && $num==1)
{
echo "<div style='padding:1px;background-color:#edeff4;border-top:1px dotted #CCC'>";
$num=0;
}
else
{
echo "<div style='padding:1px;background-color:#fff;border-top:1px dotted #CCC'>";
$num=1;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `id` = '$post[id_subject]'"),0)==0)
{
echo "<font color='red'><img src='img/err.png'/> Сообщение удалено</font><br/>";
}
$avtor=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_who]' LIMIT 1"));
$komm=mysql_fetch_array(mysql_query("SELECT * FROM `mail` WHERE `id` = '$post[id_subject]' LIMIT 1"));
$avtor_komm=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]' LIMIT 1"));
$avtor_kont=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_kont]' LIMIT 1"));
$user_ok=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_resh]' LIMIT 1"));
echo "<img src='img/cat.png'/> <u><span style='font-size: small'><a href='?user=$avtor[id]&".(isset($_GET['resh'])?"resh":"unresh")."'><span style='color:#660066'>$avtor[nick]</span></a></span> <font color='green'>[".vremja($post['time'])."]</font></u>n";
if($avtor['do_cmpl_mail']==0)echo "[<a class='icolink' href='?do_cmpl=$avtor[id]&".(isset($_GET['resh'])?"resh":"unresh")."' title='удалить' style='color:red;font-size:small'><b><img src='img/closed.png'/></b></a>]<br/>n";
else echo "[<a class='icolink' href='?do_cmpl=$avtor[id]&".(isset($_GET['resh'])?"resh":"unresh")."' title='удалить' style='color:green;font-size:small'><b><img src='img/open.png'/></b></a>]<br/>n";
echo "<a href='?msg_mail=$post[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>Прочитать сообщение</a><br/>n";
echo "Автор сообщения:<a href='?user=$avtor_komm[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>$avtor_komm[nick]</a><br/>n";
echo "Сообщение получил: <a href='?user=$avtor_kont[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>$avtor_kont[nick]</a><br/>n";
echo "<b><a href='?msg=$post[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>Сообщение пользователя</a></b><br/>n";
echo "<span style='color: #79358c'><img src='img/ok.png'/> Даную жалобу рассмотрел <a href='?user=$user_ok[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>$user_ok[nick]</a></span><font color='green'> (".vremja($post['time_resh']).")</font>n";
echo "</div>";
}
if ($k_page>1)str("?resh&",$k_page,$page); // Вывод страниц
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?'>Жалобы</a></div>n";
include_once '../sys/inc/tfoot.php';
exit;
}
//ЛОЛ ЛОЛ ЛОЛ
if(isset($_GET['unresh']))
{
echo "<div class='title1'><b>Жалобы нерешенные</b></div>n";
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail_cmpl` WHERE `ok` = '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$cmpl_list = mysql_query("SELECT * FROM `mail_cmpl` WHERE `ok` = '0' ORDER BY time LIMIT $start, $set[p_str]");
if (mysql_num_rows($cmpl_list)==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Список пустn";
echo " </td>n";
echo " </tr>n";
}
if(isset($_GET['ok']))
{
mysql_query("UPDATE `mail_cmpl` SET `ok` = '1', `id_resh` = '$user[id]', `time_resh` = '$time' WHERE `id` = '".intval($_GET['ok'])."' AND `ok` = '0'");
header("Location:?unresh&ok");
}
while ($post = mysql_fetch_array($cmpl_list))
{
if(isset($num) && $num==1)
{
echo "<div style='padding:1px;background-color:#edeff4;border-top:1px dotted #CCC'>";
$num=0;
}
else
{
echo "<div style='padding:1px;background-color:#fff;border-top:1px dotted #CCC'>";
$num=1;
}
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `id` = '$post[id_subject]'"),0)==0)
{
echo "<font color='red'><img src='img/err.png'/> Сообщение удалено</font><br/>";
}
$avtor=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_who]' LIMIT 1"));
$komm=mysql_fetch_array(mysql_query("SELECT * FROM `mail` WHERE `id` = '$post[id_subject]' LIMIT 1"));
$avtor_komm=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_user]' LIMIT 1"));
$avtor_kont=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$post[id_kont]' LIMIT 1"));
echo "<u><span style='font-size: small'><a href='?user=$avtor[id]&".(isset($_GET['resh'])?"resh":"unresh")."'><span style='color:#660066'>$avtor[nick]</span></a></span> <font color='green'>[".vremja($post['time'])."]</font></u>n";
if($avtor['do_cmpl_mail']==0)echo "[<a class='icolink' href='?do_cmpl=$avtor[id]&".(isset($_GET['resh'])?"resh":"unresh")."' title='удалить' style='color:red;font-size:small'><b><img src='img/closed.png'/></b></a>]<br/>n";
else echo "[<a class='icolink' href='?do_cmpl=$avtor[id]&".(isset($_GET['resh'])?"resh":"unresh")."' title='удалить' style='color:green;font-size:small'><b><img src='img/open.png'/></b></a>]<br/>n";
echo "<b><a href='?msg_mail=$post[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>Прочитать сообщение</a></b><br/>n";
echo "Автор сообщения:<a href='?user=$avtor_komm[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>$avtor_komm[nick]</a><br/>n";
echo "Сообщение получил: <a href='?user=$avtor_kont[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>$avtor_kont[nick]</a><br/>n";
echo "<b><a href='?msg=$post[id]&".(isset($_GET['resh'])?"resh":"unresh")."'>Сообщение пользователя</a></b><br/>n";
echo "<a href='?unresh&ok=$post[id]' style='color:green'><img src='img/ok.png'/> Решить жалобу</a></div>n";
}
if ($k_page>1)str("?unresh&",$k_page,$page); // Вывод страниц
echo "<div class='backlink'><img src='img/back.png' alt=''/><a href='?'>Жалобы</a></div>n";
include_once '../sys/inc/tfoot.php';
exit;
}
else
{
echo "<div class='title1'><b>Жалобы решенные</b></div>n";
$count_unresh=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail_cmpl` WHERE `ok` = '0'"),0);
$count_resh=mysql_result(mysql_query("SELECT COUNT(*) FROM `mail_cmpl` WHERE `ok` = '1'"),0);
echo "<img src='img/closed.png'/> <a href='?resh'>Решенные жалобы</a> ($count_resh)<br/>";
echo "<img src='img/closed.png'/> <a href='?unresh'>Нерешенные жалобы</a> ($count_unresh)";
include_once '../sys/inc/tfoot.php';
exit;
}
?>