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 }