function getTicketData($ticket_id)
{
$ticket_id = intval(mysql_html($ticket_id));
if (canSeeTicket($ticket_id)) {
global $mysql;
$query = "SELECT *, FROM_UNIXTIME(time) AS readableTime FROM 1fx_tickets_messages INNER JOIN 1fx_tickets ON 1fx_tickets_messages.ticket_id=1fx_tickets.ticket_id INNER JOIN 1fx_users ON 1fx_users.user_id=1fx_tickets_messages.user_id WHERE 1fx_tickets.ticket_id={$ticket_id} ORDER BY 1fx_tickets_messages.time DESC";
$result = mysqli_query($mysql, $query);
while ($row = mysqli_fetch_array($result)) {
$data[] = array("fullname" => $row['fullname'], "time" => $row['readableTime'], "title" => $row['title'], "message" => $row['message'], "user_ip" => $row['user_ip'], "status" => getStatusById($row['status']), "ticket_status" => $row['ticket_status']);
}
return $data;
} else {
return array();
}
}
<?php
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . '../template/header.php';
showHeader();
require_once BASE_PATH . 'public/status-atividade/queries.php';
require_once BASE_PATH . 'src/protectCSRF.php';
if (isset($_REQUEST['id'])) {
$action = 'update';
$id = trim($_REQUEST['id']);
$status = getStatusById($id);
$status = $status['status'];
} else {
$action = 'insert';
$id = null;
$status = null;
}
?>
<div class="container">
<h2>Cadastro de status de atividade</h2><br />
<div class="row">
<div class="col-md-6 col-md-offset-6">
<a href="<?php
echo SITE_URL;
?>
status-atividade/index.php"
class="btn btn-primary" title="Voltar">
<span class="glyphicon glyphicon-chevron-left"></span> Voltar</a>
<?php
if ($id) {
?>
}
?>
</td>
<td><?php
echo $myAccount['email'];
?>
</td>
<td><?php
echo $myAccount['fullname'];
?>
</td>
<td id="status<?php
echo $myAccount['id'];
?>
"><?php
echo getStatusById($myAccount['status']);
?>
</td>
<td>
<button class="btn btn-default" type="button" onclick="manageAccount('<?php
echo $myAccount['id'];
?>
');">Manage account</button>
<?php
if (intval($myAccount['status']) != 3) {
?>
<button class="btn btn-default" type="button" onclick="modifyPrivileges('<?php
echo $myAccount['id'];
?>
');">Modify privileges</button><?php
}
