= 1) {
includeLang('supp');
$parse = $lang;
if($_GET['ticket'] == 0){
/// Deteilsanzeige des eigenen tickets
$query = doquery("SELECT * FROM {{table}} WHERE status >= '1' ORDER BY time", "supp");
while($ticket = mysql_fetch_array($query))
{
if($ticket['status']==1)
{
$status = "Ouvert";
}
if($ticket['status']==0)
{
$status = "Fermé";
}
if($ticket['status']==2)
{
$status = "Réponse de l'adminisrtateur";
}
if($ticket['status']==3)
{
$status = "Réponse du joueur";
}
$query6 = doquery("SELECT * FROM {{table}} WHERE id = '".intval($ticket['player_id'])."'", "users");
while($name6 = mysql_fetch_array($query6))
{
$playername = $name6['username'];
}
$parse['tickets'] .= ""
."| ".htmlentities($ticket['ID'])." | "
."".htmlentities($playername)." | "
."".htmlentities($ticket['subject'])." | "
."". $status ." | "
."".date("j-m-Y H:i:s",$ticket['time'])." | "
."
";
}
display(parsetemplate(gettemplate('admin/supp'), $parse), '',false, '',true);
}elseif($_GET['sendenticket'] =="1"){
/// Eintragen eines Neuen Tickets
$subject = $_POST['senden_ticket_subject'];
$tickettext = $_POST['senden_ticket_text'];
$time = time();
if(empty($tickettext) OR empty($subject)){
/// Prüfen ob beide felder mit Text versehen sind
display(parsetemplate(gettemplate('admin/supp_t_send_error'), $parse),false, '',true);
}else{
$Qryinsertticket = "INSERT {{table}} SET ";
$Qryinsertticket .= "`player_id` = '". intval($user['id']) ."',";
$Qryinsertticket .= "`subject` = '". mysql_real_escape_string($subject) ."',";
$Qryinsertticket .= "`text` = '". mysql_real_escape_string($tickettext) ."',";
$Qryinsertticket .= "`time` = '". $time ."',";
$Qryinsertticket .= "`status` = '1'";
doquery( $Qryinsertticket, "supp");
display(parsetemplate(gettemplate('admin/supp_t_send'), $parse), '',false, '',true);
}
}elseif($_GET['sendenantwort'] =="1"){
/// Eintragen der neuen Antwort
$antworttext = htmlentities($_POST['senden_antwort_text']);
$antwortticketid = $_POST['senden_antwort_id'];
if(empty($antworttext) OR empty($antwortticketid)){
/// Prüfen ob beide felder mit Text versehen sind
display(parsetemplate(gettemplate('admin/supp_t_send_error'), $parse), '',false, '',true);
}else{
$query = doquery("SELECT * FROM {{table}} WHERE `id` = '".$antwortticketid."'", "supp");
while($ticket = mysql_fetch_array($query))
{
$newtext = $ticket['text'].'
'.$antworttext.'';
$QryUpdatemsg = "UPDATE {{table}} SET ";
$QryUpdatemsg .= "`text` = '". mysql_real_escape_string($newtext) ."',";
$QryUpdatemsg .= "`status` = '2'";
$QryUpdatemsg .= "WHERE ";
$QryUpdatemsg .= "`id` = '". $antwortticketid ."' ";
doquery( $QryUpdatemsg, "supp");
}
display(parsetemplate(gettemplate('admin/supp_answ_send'), $parse), '',false, '',true);
}
}elseif($_GET['schliessen'] =="1"){
$schließen = $_GET['ticket'];
$QryUpdatemsg = "UPDATE {{table}} SET ";
$QryUpdatemsg .= "`status` = '0'";
$QryUpdatemsg .= "WHERE ";
$QryUpdatemsg .= "`id` = '". $schließen ."' ";
doquery( $QryUpdatemsg, "supp");
display(parsetemplate(gettemplate('admin/supp_t_close'), $parse), '',false, '',true);
}else{
/// Listenanzeige des einen tickets
$query2 = doquery("SELECT * FROM {{table}} WHERE `ID` = '".intval($_GET['ticket'])."'", "supp");
while($ticket2 = mysql_fetch_array($query2))
{
if($ticket2['status']==1)
{
$status = "Ouvert";
}
if($ticket2['status']==0)
{
$status = "Fermé";
}
if($ticket2['status']==2)
{
$status = "Réponse de l'adminisrtateur";
}
if($ticket2['status']==3)
{
$status = "Réponse du joueur";
}
$query6 = doquery("SELECT * FROM {{table}} WHERE id = '".intval($ticket2['player_id'])."'", "users");
while($name7 = mysql_fetch_array($query6))
{
$playername2 = $name7['username'];
}
$parse['tickets'] .= ""
."| ".htmlentities($ticket2['ID'])." | "
."".htmlentities($playername2)." | "
."".htmlentities($ticket2['subject'])." | "
."".$status." | "
."".date("j-m-Y H:i:s",htmlentities($ticket2['time']))." | "
."
";
$parse['text_view'] = $ticket2['text'];
$parse['id'] = $ticket2['ID'];
display(parsetemplate(gettemplate('admin/supp_detail'), $parse), '',false, '',true);
}
}
} else {
AdminMessage ( $lang['sys_noalloaw'], $lang['sys_noaccess'] );
}
?>