Posted: Fri May 14, 2004 12:16 pm
Code: Select all
if ($_REQUEST['do'] == "close") {
if (p_ticket('close')) {
$db->query("UPDATE ticket SET is_open = 0, date_closed = '$now_' WHERE id = '$id'");
ticketlog($id, 'close');
if ($_REQUEST[email] == '1') {
$ticket = $db->query_return("SELECT * FROM ticket WHERE id = '$id'");
$user_details = $db->query_return("SELECT * FROM user WHERE id = '$ticket[userid]'");
$user_details = update_user_details($user_details);;
eval(makeemaileval('message', 'BODY_question_closed', $subject, $ticket));
dp_mail($user_details['email'], $subject, trim($message));
ticketlog($ticket['id'], 'email_sent_to_user', NULL, NULL, "To: $user_details[email], Subject: $subject");
}
jump("ticketview.php?id=$id", "The ticket has been closed");
}
}
?>