", $_POST["message"]);
$message = rawurlencode($msg);
$time = gmdate("l dS of F Y \a\\t h:i:s a", time()+($TIME_offset * 3600));
DATABASE_query("INSERT INTO ".$DB_prefix."responses (`ticketid`,`author`,`time`,`message`) VALUES ('$tid','0','$time','$message')");
DATABASE_query("UPDATE ".$DB_prefix."tickets SET status='3' WHERE id='$tid'");
}elseif($_POST["x"] == "close"){
$tid = $_POST["tid"];
DATABASE_query("UPDATE ".$DB_prefix."tickets SET status='0' WHERE id='$tid'");
}elseif($_POST["x"] == "open"){
$tid = $_POST["tid"];
DATABASE_query("UPDATE ".$DB_prefix."tickets SET status='1' WHERE id='$tid'");
}
}
$TICKET_tid = $_GET["tid"];
$result = DATABASE_query("SELECT * FROM ".$DB_prefix."tickets WHERE id='$TICKET_tid' AND username='$TICKETS_username'");
if($get = DATABASE_fetch($result)){
$TICKET_tid = $get["id"];
$TICKET_urgency = $get["urgency"];
$TICKET_subject = $get["subject"];
$TICKET_user = $get["username"];
$TICKET_operator = $get["operator"];
$TICKET_department = $get["department"];
$TICKET_status = $get["status"];
if($TICKET_status == "2"){
// Mark ticket as read
$tid = $TICKET_tid;
DATABASE_query("UPDATE ".$DB_prefix."tickets SET status='1' WHERE id='$tid'");
}
if($TICKET_status == 0){
$TICKET_status = "Closed";
}else{
$TICKET_status = "Open";
}
$result = DATABASE_query("SELECT * FROM ".$DB_prefix."operators WHERE operator='$TICKET_operator'");
if($fetch = DATABASE_fetch($result)){
$TICKET_name = $fetch["firstname"]." ".$fetch["lastname"];
}else{
$TICKET_name = "Unknown";
}
$result = DATABASE_query("SELECT * FROM ".$DB_prefix."departments WHERE operator='$TICKET_operator' AND department='$TICKET_department'");
if($fetch = DATABASE_fetch($result)){
$TICKET_email = $fetch["email"];
}else{
$TICKET_email = "Unknown";
}
if($TICKET_urgency == 1){
$TICKET_urgency = $LANG_low;
}elseif($TICKET_urgency == 2){
$TICKET_urgency = $LANG_medium;
}elseif($TICKET_urgency == 3){
$TICKET_urgency = $LANG_high;
}elseif($TICKET_urgency == 4){
$TICKET_urgency = $LANG_vhigh;
}else{
$TICKET_urgency = $LANG_low;
}
?>
|
1){
$TICKET_rnum = $TICKET_rid - 1;
$TICKET_head = $LANG_response." ".$TICKET_rnum;
}
if($TICKET_author == 0){
$result_user = DATABASE_query("SELECT * FROM ".$DB_prefix."users WHERE username='$TICKET_user'");
if($find = DATABASE_fetch($result_user)){
$TICKET_authoru = $find["username"];
$TICKET_authorn = $find["firstname"]." ".$find["lastname"];
}
}elseif($TICKET_author == 1){
$result_op = DATABASE_query("SELECT * FROM ".$DB_prefix."operators WHERE operator='$TICKET_operator'");
if($find = DATABASE_fetch($result_op)){
$TICKET_authoru = $find["operator"]." - ".$TICKET_department;
$TICKET_authorn = $find["firstname"]." ".$find["lastname"];
}
}else{
$TICKET_authoru = "Unknown";
$TICKET_authorn = "Unknown";
}
?>
|
");
}
}
?>
|