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