user_is_admin) { header("Location: login.php"); exit; } include "top.php"; $q = mysql_query_wrapper("select *, date_format(ticket_date_created, '%b %e %k:%i') nice_ticket_date_created, date_format(max(note_date_created), '%b %e %k:%i') nice_last_note_date_created from tickets left outer join notes on ticket_id=note_ticket_id left join states on ticket_state_id=state_id left outer join users on ticket_assigned_to=user_id where ticket_state_id <> 2 or ticket_timestamp + interval 180 day >= now() group by ticket_id having ticket_state_id <> 2 or max(note_date_created) + interval 180 day >= now() order by ticket_state_id, note_date_created "); ?>

Ticket list

state_id != $last_state_id) { $last_state_id = $row->state_id; ?>
state_name?> tickets
Assigned Submitted
Last note added 		Contact email
Phone number 		Login
Domain name 		Problem description
user_id) { if ($row->user_id == $user->user_id) echo ""; echo htmlspecialchars($row->user_name); if ($row->user_id == $user->user_id) echo ""; } else if ($row->ticket_state_id == 0) { echo "Everybody (eg. you)"; } ?>  nice_ticket_date_created?>
nice_last_note_date_created?> 		ticket_author_email,20))?>
ticket_author_phone,20))?>  		ticket_account_login,20))?>
ticket_account_domain,20))?> 		note_longtext,200))?>