function send_user_message(&$sql, $user_id, $reseller_id) { if (!isset($_POST['uaction'])) { return; } if ($_POST['subj'] === '') { set_page_message(tr('Please specify message subject!')); return; } if ($_POST['user_message'] === '') { set_page_message(tr('Please type your message!')); return; } $ticket_date = time(); $urgency = $_POST['urgency']; $subj = $_POST['subj']; $user_message = preg_replace("/\n/", "<br>", $_POST["user_message"]); $ticket_status = 1; $ticket_reply = 0; $ticket_level = 1; $query = <<<SQL_QUERY insert into tickets (ticket_level, ticket_from, ticket_to, ticket_status, ticket_reply, ticket_urgency, ticket_date, ticket_subject, ticket_message) values (?, ?, ?, ?, ?, ?, ?, ?, ?) SQL_QUERY; $rs = exec_query($sql, $query, array($ticket_level, $user_id, $reseller_id, $ticket_status, $ticket_reply, $urgency, $ticket_date, htmlspecialchars($subj, ENT_QUOTES, "UTF-8"), htmlspecialchars($user_message, ENT_QUOTES, "UTF-8"))); send_tickets_msg($reseller_id, $user_id, $subj); set_page_message(tr('Your message was sent!')); header("Location: support_system.php"); exit(0); }
function send_user_message(&$sql, $user_id, $reseller_id, $ticket_id) { if (!isset($_POST['uaction'])) { return; } elseif ($_POST['uaction'] == "close") { close_ticket($sql, $ticket_id); return; } elseif ($_POST['uaction'] == "open") { open_ticket($sql, $ticket_id); return; } elseif ($_POST['user_message'] === '') { set_page_message(tr('Please type your message!')); return; } $ticket_date = time(); $subj = $_POST['subject']; $user_message = preg_replace("/\n/", "<br>", $_POST["user_message"]); $ticket_status = 2; $ticket_reply = $_GET['ticket_id']; $query = <<<SQL_QUERY select ticket_level, ticket_from, ticket_to, ticket_status, ticket_reply, ticket_urgency, ticket_date, ticket_subject, ticket_message from tickets where ticket_id = ? SQL_QUERY; $rs = exec_query($sql, $query, array($ticket_reply)); $ticket_level = $rs->fields['ticket_level']; if ($ticket_level != 1) { $ticket_to = $rs->fields['ticket_from']; $ticket_from = $rs->fields['ticket_to']; } else { $ticket_to = $rs->fields['ticket_to']; $ticket_from = $rs->fields['ticket_from']; } $urgency = $_POST['urgency']; $query = <<<SQL_QUERY insert into tickets (ticket_from, ticket_to, ticket_status, ticket_reply, ticket_urgency, ticket_date, ticket_subject, ticket_message) values (?, ?, ?, ?, ?, ?, ?, ?) SQL_QUERY; $rs = exec_query($sql, $query, array($ticket_to, $ticket_from, $ticket_status, $ticket_reply, $urgency, $ticket_date, htmlspecialchars($subj, ENT_QUOTES, "UTF-8"), htmlspecialchars($user_message, ENT_QUOTES, "UTF-8"))); set_page_message(tr('Message was sent.')); send_tickets_msg($ticket_from, $ticket_to, $subj); }
function send_user_message(&$sql, $user_id, $reseller_id, $ticket_id) { if (!isset($_POST['uaction'])) { return; } elseif ($_POST['uaction'] == "close") { close_ticket($sql, $ticket_id); return; } elseif ($_POST['uaction'] == "open") { // open ticket open_ticket($sql, $ticket_id); return; } elseif ($_POST['user_message'] === '') { // no message check->error set_page_message(tr('Please type your message!')); return; } $ticket_date = time(); $subj = $_POST['subject']; $user_message = preg_replace("/\n/", "<br>", $_POST["user_message"]); $ticket_status = 4; $ticket_reply = $_GET['ticket_id']; $urgency = $_POST['urgency']; $ticket_from = $user_id; $ticket_to = $reseller_id; $query = <<<SQL_QUERY insert into tickets (ticket_from, ticket_to, ticket_status, ticket_reply, ticket_urgency, ticket_date, ticket_subject, ticket_message) values (?, ?, ?, ?, ?, ?, ?, ?) SQL_QUERY; $rs = exec_query($sql, $query, array($ticket_from, $ticket_to, $ticket_status, $ticket_reply, $urgency, $ticket_date, htmlspecialchars($subj, ENT_QUOTES, "UTF-8"), htmlspecialchars($user_message, ENT_QUOTES, "UTF-8"))); set_page_message(tr('Message was send!')); // Update all Replays -> Status 1 $query = <<<SQL_QUERY update tickets set ticket_status = '1' where ticket_id = ? or ticket_reply = ? SQL_QUERY; $rs = exec_query($sql, $query, array($ticket_reply, $ticket_reply)); while (!$rs->EOF) { $rs->MoveNext(); } send_tickets_msg($ticket_to, $ticket_from, $subj); }