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(if(note_date_created is null or max(note_date_created) 2 or ticket_timestamp >= now() - interval 7 day group by ticket_id having ticket_state_id <> 2 or max(note_date_created) >= now() - interval 7 day or max(note_id) is null order by ticket_state_id, date_last_activity desc, if(note_date_created is null,ticket_timestamp,note_date_created) "); ?>

Ticket list

state_id != $last_state_id) { $last_state_id = $row->state_id; ?>
state_name?> tickets
Assigned Submitted
Last activity 		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_activity?> 		ticket_author_email,20))?>
ticket_author_phone,20))?>
ticket_account_login,20))?>
ticket_account_domain,20))?> 		note_longtext,200))?>