" . $_SESSION["uid"] . ",
" . $row["user_id"] . ",
'" . $row["status"] . "',
'" . $row["status"] . "',
" . $row["group_id"] . ",
" . $row["group_id"] . ",
" . $body_id . ",
now())";
SQL_request($query);
update_ticket_time($ticket_id);
if(__CFG_SEND_EMAIL && $_REQUEST["message_status"] == "reply")
{
//erase rate and complain
$query = "UPDATE " . T_TICKETS . " SET rate=NULL, complain='0000-00-00 00:00:00' WHERE id=" . $ticket_id;
SQL_request($query);
//send email
if(strlen(trim($_REQUEST["subject"])) > 2) $subject = trim($_REQUEST["subject"]);
else $subject = $row["subject"];
$domen = substr($row["website"],7,-1);
print ($domen);
$subject = "ANSWER: ".$subject." /[CCSS:$ticket_id]";
$query = "SELECT email FROM " . T_GROUPS . " WHERE id=" . $row["group_id"];
$row1 = SQL_select($query, 0);
$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/plain; charset=iso-8859-1\n";
$headers .= "To: " . $row["from_email"] . " <" . $row["from_email"] . ">\n";
$headers .= "From:\"".$manager_info['name'].":".$manager_info['ugroup']."\" <{$row1['email']}@$domen>\n";
$message = "" . <<<sss
function change_queue()
{
if((int)$_REQUEST["new_queue"] > 0)
{
$query = "SELECT group_id
FROM " . T_USERS_GROUPS . "
WHERE user_id=" . $_SESSION["uid"] . "
AND group_id=" . $_REQUEST["new_queue"];
$row = SQL_select($query, 0);
if($row)
{
foreach($_SESSION["selected_tickets"] as $ticket_id)
{
$query = "SELECT status, user_id, group_id FROM " . T_TICKETS . " WHERE id=" . $ticket_id;
$row1 = SQL_select($query, 0);
if($row1["group_id"] != (int)$_REQUEST["new_queue"])
{
$query = "INSERT
INTO " . T_TICKETS_ACTIONS . " (ticket_id,
user_action,
now_user_id,
prev_user_id,
now_ticket_status,
prev_ticket_status,
now_group_id,
prev_group_id,
created)
VALUES (" . $ticket_id . ",
'changed_group',
" . $_SESSION["uid"] . ",
" . $row1["user_id"] . ",
'" . $row1["status"] . "',
'" . $row1["status"] . "',
" . (int)$_REQUEST["new_queue"] . ",
" . $row1["group_id"] . ",
now())";
SQL_request($query);
$query = "UPDATE " . T_TICKETS . " SET group_id=" . (int)$_REQUEST["new_queue"] . ", updated=now() WHERE id=" . $ticket_id;
SQL_request($query);
}
ini_set("max_execution_time", 29);
}
}
}
}
