Файл: 01019147adm/apsupport.php
Строк: 181
<?php
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/home.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';
include_once '../sys/inc/game.conf.php';
include_once '../sys/inc/thead.php';
include_once '../sys/inc/uhead.php';
if ($user['acces']==5)
{
if(isset($_GET['id']) && intval($_GET['id'])!=NULL && mysql_result(mysql_query("SELECT COUNT(*) FROM `ticket` WHERE `id` = '".intval($_GET['id'])."' AND `id_user` = '".$user['id']."'"),0)!=0)
{
$ticket=mysql_fetch_array(mysql_query("SELECT * FROM `ticket` WHERE `id`='".intval($_GET['id'])."'"));
if (isset($_POST['otvet']))
{
$msg=htmlspecialchars($_POST['otvet']);
if (strlen2($msg)>1024){$err[]='Сообщение слишком длинное';}
elseif (strlen2($msg)<2){$err[]='Короткое сообщение';}
elseif (mysql_result(mysql_query("SELECT COUNT(*) FROM `ticket_post` WHERE `id_user` = '".$user['id']."' AND `msg` = '".my_esc($msg)."' LIMIT 1"),0)!=0){$err='Ваше сообщение повторяет предыдущее';}
elseif(!isset($err)){
mysql_query("INSERT INTO `ticket_post` (id_ticket, id_user, time, msg) values('".$ticket['id']."', '".$user['id']."', '$time', '".my_esc($msg)."')");
header("Location: /dev/support.php?id=".$ticket['id']."".SID);
}
}
echo "<table class='wdt brown-header'>";
echo "<tr><td align='left'>Тикет №: $ticket[id]</td></tr></table>";
echo "<table class='wdt gray-table' width = '100%' style='table-layout: fixed'>";
echo "<tr style='border-bottom:1px #252525 solid;'><td><span class='white' style='overflow: auto;'>$ticket[opisanie]</span></td></tr>";
$q=mysql_query("SELECT * FROM `ticket_post` WHERE `id_ticket` = '".$ticket['id']."' ORDER BY `time` ASC");
while($post=mysql_fetch_array($q)){
echo "<tr style='border-bottom:1px #252525 solid;'>";
echo "<td style='padding-left: 20px; overflow: auto; table-layout: fixed;' class='yellow'><b style='color: #fff'>Комментарий:</b> $post[msg]</td></tr>";
}
echo "</tr></table>";
echo "<table class='wdt green-table'>";
echo "<tr><td><form action ='' method='post'>";
echo "<table class='wdt'><tr><td align='center'>";
echo "<textarea class='wdt' name='otvet' style='margin: 0px; padding: 0px'></textarea></td></tr>";
echo "<tr><td style='padding-top: 5px;'><input class='yes-btn' type='submit' value='Отправить'/></td></tr></table></form></td></tr></table>";
echo "<table class='wdt green-table'>";
echo "<tr><td align='center' style='padding: 0px; padding-left: 10px; padding-right: 10px; padding-bottom: 10px'>";
echo "<form action ='/dev/support.php' method='get'><input type='submit' class='no-btn' value='Назад'/></form></td></tr></table>";
include_once '../sys/inc/tfoot.php';
}
elseif(isset($_GET['all']))
{
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `ticket`"),0);
$k_page=k_page($k_post,10);
$page=page($k_page);
$start=10*$page-10;
echo "<table class='wdt msg-table'>";
echo "<tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-mex.png'></td>";
echo "<td align='left' style='vertical-align: top'>Упсс, похоже ты получил бан!</td></tr></table></td></tr></table>";
echo "<table class='wdt brown-header'><tr><td align='left'>Бан:</td></tr></table>";
$q=mysql_query("SELECT * FROM `ticket` ORDER BY `time` DESC LIMIT $start, 10");
while ($post = mysql_fetch_assoc($q))
{
$ank_one=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '".$post['id_user']."'"));
echo "<table class='wdt gray-table'>";
echo "<tr><td colspan='2' width='60px' style='border-top: 1px solid #000;' class='white' align='left'>";
echo "<a href='/dev/info.php?id=".$post['id_user']."' class='green'><b>$ank_one[nick]</b></a>: до ".vremja($post['time'])."";
echo "</br><b class='yellow'>Причина</b>: ".output_text($post['opisanie'])."";
if($post['time']>$time)
{
echo "</br><b class='yellow'>Статус</b>: <b class='red'>Активен</b></td></tr></table>";
}
else
{
echo "</br><b class='yellow'>Статус</b>: <b class='green'>Обнулен</b></td></tr></table>";
}
}
if ($k_page>1)str('?',$k_page,$page); // Вывод страниц
include_once '../sys/inc/tfoot.php';
}
else
{
echo "<table class='wdt msg-table'>";
echo "<tr><td align='left' style='vertical-align: top; width: 10%'><img src='/style/img/images/face-mex.png'></td>";
echo "<td align='left' style='vertical-align: top'>Здесь можно просматривать тикеты и отвечать на них!</td></tr></table></td></tr></table>";
echo "<table class='wdt brown-header'><tr><td align='left'>Управление:</td></tr></table>";
echo "<table class='wdt gray-table'><tr>";
echo "<td width='50%'><form action='/adm/turnirs.php?new_cup' method='post'><input type='hidden' name='method' value='topFriend'><input class='yes-btn' type='submit' value='Создание'></form></td><td>";
echo "<form action='/adm/turnirs.php?edit_cup' method='post'><input type='hidden' name='method' value='topFriend'><input class='yes-btn' type='submit' value='Редактирование'></form></td><tr><td>";
echo "<form action='/adm/turnirs.php?user_cup' method='post'><input type='hidden' name='method' value='topFriend'><input class='yes-btn' type='submit' value='Участники'></form></td><td>";
echo "<form action='/adm/turnirs.php?logs_cup' method='post'><input type='hidden' name='method' value='topFriend'><input class='yes-btn' type='submit' value='Логи'></form></td></tr></table>";
echo "<table class='wdt brown-header'><tr><td align='left'>Статистика:</td></tr></table>";
$cup_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `turnir`"),0);
$cup_count_open = mysql_result(mysql_query("SELECT COUNT(*) FROM `turnir` WHERE `status` = '0'"),0);
$cup_count_close = mysql_result(mysql_query("SELECT COUNT(*) FROM `turnir` WHERE `status` = '1'"),0);
$cup_count_logs = mysql_result(mysql_query("SELECT COUNT(*) FROM `lograce_turnir`"),0);
echo "<table class='wdt green-table white' width='100%'>";
echo "<tr><td><table class='wdt black' style='border: 1px solid #111; table-layout: fixed' width='100%'>";
echo "<tr><td style='background-color: #444;border-bottom: 1px solid #222;' colspan='2' align='center'><b>Статистика</b></td></tr>";
echo "<tr><td style='background-color: #333; overflow: hidden;'>Инфо</td>";
echo "<td style='background-color: #333' align='right'>Количество</td></tr>";
echo "<tr><td class='white' align='left' style='border-bottom: 1px solid #333; vertical-align: top;'><b class='orange'>Всего тикетов</b></td>";
echo "<td align='right' style='border-bottom: 1px solid #333; vertical-align: top;'> <b class='yellow'>$cup_count</b></td>";
echo "<tr><td class='white' align='left' style='border-bottom: 1px solid #333; vertical-align: top;'><b class='orange'>Открытых тикетов</b></td>";
echo "<td align='right' style='border-bottom: 1px solid #333; vertical-align: top;'> <b class='yellow'>$cup_count_open</b></td>";
echo "<tr><td class='white' align='left' style='border-bottom: 1px solid #333; vertical-align: top;'><b class='orange'>Закрытых тикетов</b></td>";
echo "<td align='right' style='border-bottom: 1px solid #333; vertical-align: top;'> <b class='yellow'>$cup_count_close</b></td>";
echo "</tr></table></td></tr>";
echo "<table class='wdt gray-table'>";
echo "<tr><td class='white td-cell' align='center' style='height:30px;'><form action ='/adm/' method='get'><input class='no-btn' type='submit' value='В админку'></form></td></tr></table>";
include_once '../sys/inc/tfoot.php';
}
}
else
{
header("Location: /dev/garage.php");
}
?>