diff -Nur osticket_1.6.rc2/upload/include/staff/tickets.inc.php osticket_1.6.rc2-patch3/upload/include/staff/tickets.inc.php --- osticket_1.6.rc2/upload/include/staff/tickets.inc.php 2008-01-01 04:40:46.000000000 +0100 +++ osticket_1.6.rc2-patch3/upload/include/staff/tickets.inc.php 2008-01-24 09:03:14.000000000 +0100 @@ -154,11 +154,12 @@ $order_by =$order_by?$order_by:'priority_urgency,ticket.created'; $order=$order?$order:'DESC'; -$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name '. - ',status,source,isoverdue,ticket.created,pri.*'; +$qselect = 'SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,ticket.email,dept_name '. + ',status,source,isoverdue,ticket.created,pri.*,staff.firstname,staff.lastname'; $qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '. ' LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id '. - ' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() '; + ' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() '. + ' LEFT JOIN '.STAFF_TABLE.' staff ON ticket.staff_id=staff.staff_id'; //Pagenation stuff....wish MYSQL could auto pagenate (doh..I meant something better than limit) $total=db_count('SELECT count(*) '.$qfrom.' '.$qwhere); @@ -321,7 +322,8 @@ Department