Файл: largewar.ru/tickets.php
Строк: 139
<?
include 'look/g.php';
include 'look/c.php';
include 'look/cfg.php';
include 'look/vuvod.php';
include 'look/myhead.php';
$pass = base64_decode($pass);
$g=mysql_query("SELECT * FROM `tb_uzers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
$pass = base64_encode($pass);
echo "<b>Тикет система:</b><br/>";
if($game=="save"){
$g=mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='$nick' AND `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
if(empty($msg)){echo "Вы не ввели сообщение
<li><a href="tickets.php?game=look&id=$id">В тикет</a>";
include 'look/nog.php';
exit;
}
$g=mysql_query("SELECT * FROM `tb_bans` WHERE `im`='$nick' LIMIT 1");
if(mysql_num_rows($g)==1){
echo "Вы забанены и неможете писать в тикеты";
echo "<li><a href="tickets.php">В тикет</a>";
include 'look/nog.php';
exit;
}
$result666 = mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='".$nick."' AND `id`='".$id."'");
$onoff = mysql_fetch_array($result666);
if($onoff[onoff]=="1"){echo "Тикет закрыт";
include 'look/nog.php';
exit;
}
$time = date("H:i:s");
$data=date("d-F-Y", time());
$data = str_replace("January","01",$data);
$data = str_replace("February","02",$data);
$data = str_replace("March","03",$data);
$data = str_replace("April","04",$data);
$data = str_replace("May","05",$data);
$data = str_replace("June","06",$data);
$data = str_replace("July","07",$data);
$data = str_replace("August","08",$data);
$data = str_replace("September","09",$data);
$data = str_replace("October","10",$data);
$data = str_replace("November","11",$data);
$data = str_replace("December","12",$data);
include 'look/smile.php';
mysql_query("UPDATE `tb_tickets` SET `status`='1' WHERE `nick`='$nick' AND `id`='$id'");
$query = "INSERT INTO tb_ticketmsgs VALUES('$nick','$id','$fid','$nick','$msg','$time [$data]')";
$result = mysql_query($query);
echo "Ответ успешно добавлен
<li><a href="tickets.php?game=look&id=$id">В тикет</a>";
}else{echo "Такой тикет не существует";}
include 'look/nog.php';
exit;
}
if($game=="otvet"){
$g=mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='$nick' AND `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
echo'<form method="post" action="tickets.php?game=save&id='.$id.'">';
echo "<br/>Сообщение:<br/>";
echo "<input class="button" name="msg" maxlength="500" title="Сообщение" emptyok="true"/>";
echo '<input class="button" type="submit" value="Ответить"/></form>';
}else{echo "Такой тикет не существует";}
include 'look/nog.php';
exit;
}
if($game=="onoff"){
$g=mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='$nick' AND `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
$result666 = mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='".$nick."' AND `id`='".$id."'");
$onoff = mysql_fetch_array($result666);
if($onoff[onoff]=="0"){
mysql_query("UPDATE `tb_tickets` SET `onoff`='1' WHERE `nick`='$nick' AND `id`='$id'");
echo "Тикет закрыт";
}else{
mysql_query("UPDATE `tb_tickets` SET `onoff`='0' WHERE `nick`='$nick' AND `id`='$id'");
echo "Тикет открыт";
}
}else{echo "Такой тикет не существует";}
include 'look/nog.php';
exit;
}
if($game=="del"){
$g=mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='$nick' AND `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
mysql_query("DELETE FROM `tb_ticketmsgs` WHERE `nick`='".$nick."' AND `id`='".$id."'");
mysql_query("DELETE FROM `tb_tickets` WHERE `nick`='".$nick."' AND `id`='".$id."'");
echo "Тикет удалён";
}else{echo "Такой тикет не существует";}
include 'look/nog.php';
exit;
}
if($game=="look"){
$g=mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='$nick' AND `id`='$id' LIMIT 1");
if(mysql_num_rows($g)==1){
$qi = mysql_query("SELECT * FROM `tb_ticketmsgs` WHERE `nick`='$nick' AND `id`='$id' ORDER by `fid` ASC");
while($row=mysql_fetch_array($qi))
{
echo "$row[autor] [$row[time]]: $row[msg]<br/>";
}
$result666 = mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='".$nick."' AND `id`='".$id."'");
$onoff = mysql_fetch_array($result666);
if($onoff[onoff]=="0"){
echo "<li><a href="tickets.php?game=otvet&id=$id">Ответить на тикет</a>";
}
echo "<li><a href="tickets.php?game=del&id=$id">Удалить тикет</a>";
if($onoff[onoff]=="0"){
echo "<li><a href="tickets.php?nick=$nick&pass=$pass&game=onoff&id=$id">Закрыть тикет</a>";
}else{
echo "<li><a href="tickets.php?game=onoff&id=$id">Открыть тикет</a>";
}
}else{echo "Такой тикет не существует";}
include 'look/nog.php';
exit;
}
if($game=="add"){
if(empty($names)){echo "Вы не ввели название тикета
<li><a href="tickets.php">Назад</a>";
include 'look/nog.php';
exit;
}
if(empty($msg)){echo "Вы не ввели сообщение
<li><a href="tickets.php">Назад</a>";
include 'look/nog.php';
exit;
}
$g=mysql_query("SELECT * FROM `tb_bans` WHERE `im`='$nick' LIMIT 1");
if(mysql_num_rows($g)==1){
echo "Вы забанены и неможете создавать тикеты";
echo "<li><a href="tickets.php">В тикет</a>";
include 'look/nog.php';
exit;
}
$q = mysql_query("SELECT COUNT(`nick`) FROM `tb_tickets` WHERE `nick`='$nick'");
$gid = mysql_result($q, 0);
if($gid>="3"){
echo "Заводить больше 3 тикетов запрещено
<li><a href="tickets.php">Назад</a>";
include 'look/nog.php';
exit;
}
include 'look/smile.php';
$time = date("H:i:s");
$data=date("d-F-Y", time());
$data = str_replace("January","01",$data);
$data = str_replace("February","02",$data);
$data = str_replace("March","03",$data);
$data = str_replace("April","04",$data);
$data = str_replace("May","05",$data);
$data = str_replace("June","06",$data);
$data = str_replace("July","07",$data);
$data = str_replace("August","08",$data);
$data = str_replace("September","09",$data);
$data = str_replace("October","10",$data);
$data = str_replace("November","11",$data);
$data = str_replace("December","12",$data);
$query = "INSERT INTO tb_tickets VALUES('$nick','$id','$names','$data [$time]','1','0')";
$result = mysql_query($query);
$tik=mysql_query("SELECT * FROM `tb_tickets` ORDER by `id` DESC");
$dat=mysql_fetch_array($tik);
$idi=$dat[id];
$query = "INSERT INTO tb_ticketmsgs VALUES('$nick','$idi','$fid','$nick','$msg','$data [$time]')";
$result = mysql_query($query);
echo "Тикет успешно создан<br/><a href="tickets.php">К тикетам</a>";
include 'look/nog.php';
exit;
}
$q = mysql_query("SELECT COUNT(`nick`) FROM `tb_tickets` WHERE `nick`='$nick'");
$kol = mysql_result($q, 0);
if($kol=="0"){echo "Тикетов нет";}
$qi = mysql_query("SELECT * FROM `tb_tickets` WHERE `nick`='$nick' ORDER by `time` DESC");
while($row=mysql_fetch_array($qi))
{
echo "<img src="kartinki/ticket.gif"><a href="tickets.php?game=look&id=$row[id]">$row[name]</a> [$row[time]]<br/>";
}
echo'<form method="post" action="tickets.php?game=add">';
echo "<br/>Название тикета:<br/>";
echo "<input class="button" name="names" maxlength="30" title="Название тикета" emptyok="true"/>";
echo "<br/>Сообщение:<br/>";
echo "<input class="button" name="msg" maxlength="500" title="Сообщение" emptyok="true"/>";
echo '<input class="button" type="submit" value="Создать"/></form>';
include 'look/nog.php';
exit;
}else{echo"Пароль или логин неверны";}
include 'look/nog.php';
?>