}
if (isset($_POST['reply_text']) && !empty($_POST['reply_text']) && $result['status'] != 0) {
squery("INSERT INTO karnaf_replies(tid,reply,r_by,r_time,r_from,ip) VALUES(%d,'%s','%s',%d,'%s','%s')", $id, $_POST['reply_text'], $nick, time(), $nick, get_session_ip());
if ((int) $result['status'] == 2) {
squery("UPDATE karnaf_tickets SET status=1,lastupd_time=%d WHERE id=%d AND status=2", time(), $id);
send_memo($result['rep_u'], "User has replied to ticket #" . $result['id'] . ". For more information visit: " . KARNAF_URL . "/edit.php?id=" . $result['id']);
}
echo "<div class=\"status\">Your reply has been saved.</div><br>";
$result['status'] = 1;
}
if (isset($_FILES['attachment-file']['name']) && !empty($_FILES['attachment-file']['name'])) {
$error = do_upload($id);
if ($error == "") {
if ((int) $result['status'] == 2) {
squery("UPDATE karnaf_tickets SET status=1,lastupd_time=%d WHERE id=%d AND status=2", time(), $id);
send_memo($result['rep_u'], "User has added an attachment to ticket #" . $result['id'] . ". For more information visit: " . KARNAF_URL . "/edit.php?id=" . $result['id']);
}
echo "<div class=\"status\">Your attachment has been saved.</div><br>";
} else {
echo "<div class=\"status_err\">Error: " . $error . "</div><br>";
}
}
if ($isoper) {
if (IsGroupMember($result['rep_g']) || IsKarnafAdminSession()) {
$isadmin = 1;
}
if ($result['is_private'] && !$isadmin) {
AccessDenied("Ticket is marked as private.");
}
add_log("karnaf_view", $result['id']);
if (isset($_GET['usermode'])) {
if (send_sms($_POST['sms_account'], $_POST['sms_to'], $_POST['sms_body'])) {
squery("INSERT INTO karnaf_actions(tid,action,a_by_u,a_by_g,a_time,a_type,is_private) VALUES(%d,'%s','%s','%s',%d,1,%d)", $id, "Sent SMS to " . $_POST['sms_to'], $nick, $group, time(), $is_private);
squery("UPDATE karnaf_tickets SET lastupd_time=%d WHERE id=%d", time(), $id);
$autostatus = "The SMS has been sent.";
if ($is_private != 1) {
$email_update_str = "Sent SMS to " . $_POST['sms_to'];
}
} else {
$autostatus = "Error! Could not send SMS!";
}
$autoload = 9;
}
if (isset($email_update_str) && !empty($email_update_str)) {
if ((!isset($is_private) || $is_private != "1") && (!isset($_POST['no_userupd']) || $_POST['no_userupd'] != "on")) {
if ($result['memo_upd'] == "1") {
send_memo($result['unick'], "Your ticket #" . $result['id'] . " has been updated. For more information visit: " . KARNAF_URL . "/view.php?id=" . $result['id'] . "&code=" . $result['randcode']);
}
if ($result['email_upd'] == "1") {
if (!defined("IRC_MODE") && isset($a_fullname) && !empty($a_fullname)) {
$body = "Your ticket #" . $result['id'] . " has been updated by " . $a_fullname . ":\r\n" . $email_update_str . "\r\n";
} else {
$body = "Your ticket #" . $result['id'] . " has been updated:\r\n" . $email_update_str . "\r\n";
}
$body .= "---\r\nFor more information visit: " . KARNAF_URL . "/view.php?id=" . $result['id'] . "&code=" . $result['randcode'];
$body .= "\r\n*** Please make sure you keep the original subject when replying us by email ***";
$newsubject = "[" . strtoupper($group) . "] Ticket #" . $result['id'];
if (!empty($result['title'])) {
$newsubject .= " - " . $result['title'];
}
send_mail($result['uemail'], $newsubject, $body);
if (isset($_POST['reply_cc']) && $_POST['reply_cc'] != $result['cc']) {
$tid = (int) $result2['merged_to'];
sql_free_result($query2);
$query2 = squery("SELECT t.id,t.status,t.rep_u,t.uphone,t.rep_g,t.title,o.email AS oemail,t.merged_to FROM (karnaf_tickets AS t LEFT JOIN users as o ON t.rep_u=o.user) WHERE t.id=%d", $tid);
if (!($result2 = sql_fetch_array($query2))) {
$tid = 0;
}
}
if ($tid) {
if ((int) $result2['status'] == 0) {
squery("INSERT INTO karnaf_actions(tid,action,a_by_u,a_by_g,a_time,a_type,is_private) VALUES(%d,'The ticket has been re-opened.','%s','%s',%d,1,%d)", $tid, "System", $result2['rep_g'], time(), 0);
squery("UPDATE karnaf_tickets SET status=1,lastupd_time=%d WHERE id=%d", time(), $tid);
}
squery("INSERT INTO karnaf_replies(tid,title,reply,r_by,r_time,r_from,ip,message_id) VALUES(%d,'%s','%s','%s',%d,'%s','%s','%s')", $tid, $m_subject, $m_body, "Guest", time(), $uname, "(EMAIL)", $m_msgid);
if ((int) $result2['status'] == 2) {
squery("UPDATE karnaf_tickets SET status=1,lastupd_time=%d WHERE id=%d", time(), $tid);
send_memo($result2['rep_u'], "User has replied to ticket #" . $result2['id'] . ". For more information visit: " . KARNAF_URL . "/edit.php?id=" . $result2['id']);
} else {
squery("UPDATE karnaf_tickets SET lastupd_time=%d WHERE id=%d", time(), $tid);
}
$text = "New reply from: " . $uname . "\r\n\r\n";
$text .= "To edit the ticket: " . KARNAF_URL . "/edit.php?id=" . $tid . "\r\n";
$text .= "---------------------------------------------------------------------------------------------\r\n";
$text .= "Sender: " . $uname . " <" . $reply_to . ">\r\n";
if (!empty($result2['uphone'])) {
$text .= "Phone: " . $result2['uphone'] . "\r\n";
}
if (!empty($m_subject)) {
$text .= "---------------------------------------------------------------------------------------------\r\n";
$text .= "Title: " . $m_subject . "\r\n";
}
$text .= "---------------------------------------------------------------------------------------------\r\n";
