} 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";