closed_tickets.inc

不错的东西

<?php
$query = $sql->query("SELECT * FROM tickets WHERE `status` = '0' ORDER BY `date` ASC");
while($data = mysql_fetch_assoc($query))
{
	$_user['tickets'][$data['tid']]['level'] = $data['level'];
	$_user['tickets'][$data['tid']]['status'] = $data['status'];
	$_user['tickets'][$data['tid']]['hostname'] = $data['hostname'];
	$_user['tickets'][$data['tid']]['date'] = $data['date'];
	$_user['tickets'][$data['tid']]['subject'] = $data['subject'];
}
?>
<table width="50%">
<tr>
	<td>ID</td>
	<td>SUBJECT</td>
	<td>OPEN</td>
	<td>LEVEL</td>
	<td>STATUS</td>
</tr>
<?php
$level_txt = array("None","Low","Medium","High");
$status_txt = array("Closed","Open","On Hold");
if (isset($_user)) {
foreach($_user['tickets'] as $k => $ticket)
{
	?>

	<tr>
		<td><a href="?page=view_tickets&tid=<?=$k?>"><?=$k?></a></td>
		<td><a href="?page=view_tickets&tid=<?=$k?>"><?=$_user['tickets'][$k]['subject']?></a></td>
		<td><?=$_user['tickets'][$k]['date']?></td>
		<td><?=$level_txt[$_user['tickets'][$k]['level']]?></td>
		<td><?=$status_txt[$_user['tickets'][$k]['status']]?></td>
	</tr>

	<?php
}
}
?>

</table>
<br><br>
<a href="?page=view_tickets">[View Open]</a>