$font ".SECURITY.""; } else { header("Cache-control: private"); head(); $login = $_COOKIE['PHPCookie']; $userdetail = explode("&", $login); $username = $userdetail[0]; $passdetail = explode("=", $login); $password = $passdetail[1]; if (!$username && !$password) { echo "$font ".LOGIN_TITLE." "; loginf(); } else { // start of getting user data $d = new dbC(); $d->connect($db_host, $db_username, $db_password, $db); $sql_result = $d->query("select * from $db_prefix"."users where username='$username' and password='$password'"); if($sql_result) { while ($r = $d->fetch_array($sql_result)) { $userid = $r["id"]; $name = $r["name"]; $email = $r["email"]; $groupid = $r["group_id"]; $adminis = $r["admin"]; $level = $r["level"]; } } $d->close(); // end of getting user information // start of header data // static html echo "
 
  "; echo "
$font $font "; $username=strtolower($username); $admin=strtolower($admin); if($username == "$admin" && !empty($admin)){ echo "$font ".C_USER." - ".MOD_USER." | ".MAN_GROUP." | ".OPTIONS." | ".REPORTS.""; } echo "
$font $name ($username) UID: $userid | ".LOGOUT." | ".EDIT_A." | "; if($allowmsg == "1"){ echo "".MESS_C.""; $d->connect($db_host, $db_username, $db_password, $db); $getpm1=$d->query("select * from $db_prefix"."privatemessage where to_userid='$userid'"); $getnum1=$d->numrows($getpm1); $d->close(); if($getnum1 == "0" || $getnum1 == ""){ echo " (0)"; } else { echo " ($getnum1)"; } } echo "
"; echo "
 
 
"; echo "$font $back"; if($level == "0"){ if(empty($_GET['ticket_id'])){ echo "$font

Sorry, Ticket ID is required.

"; } else { $ticket_id=$_GET['ticket_id']; $d->connect($db_host, $db_username, $db_password, $db); $getreport=$d->query("select * from $db_prefix"."responsetime where ticket_id='$ticket_id' order by id desc"); $total=$d->numrows($getreport); $d->close(); if($total == "0"){ echo "

Currently, there is no updates for Ticket ID: $ticket_id

"; } else { echo "

Status Report for Ticket ID: ($ticket_id)

"; $d->connect($db_host, $db_username, $db_password, $db); $result=$d->query("select * from $db_prefix"."list where ticket_id='$ticket_id'"); $getC=$d->numrows($result); $ticketData=$d->fetch_array($result); $getC=$d->query("select ticket_comment_id from $db_prefix"."tickets_comment where ticket_id='$ticket_id' and ticket_comment_update='1'"); $c=$d->numrows($getC); $getU=$d->query("select ticket_comment_id from $db_prefix"."tickets_comment where ticket_id='$ticket_id' and ticket_comment_update='2'"); $u=$d->numrows($getU); $ticket_sub=$ticketData['ticket_short_description']; $ticket_sub=stripslashes($ticket_sub); $ticket_sub=safeHTML($ticket_sub); $ticket_full=$ticketData['ticket_full_description']; $ticket_full=stripslashes($ticket_full); $ticket_full=safeHTML($ticket_full); $ticket_full=cleanup($ticket_full); echo "
"; echo ""; echo " "; echo "
$font Ticket ID : $ticket_id   $font Created on: ".$ticketData['ticket_added_date']."
$font Ticket Status : $font ".$ticketData['ticket_status']."  
$font Ticket : $font $ticket_sub  
$font Ticket Data: $font $ticket_full"; echo " Comments: $c
Updates: $u
$font $font

"; echo "
"; while($getData=$d->fetch_array($getreport)){ $rep=$getData['response']; $act=$getData['action']; echo "
$font $rep: $act "; } echo "

"; } } } else { echo "$font


".ERRORADMIN."

"; } } // end of logged in user check } // end of admin file check foot(); ?>