--- tickets.inc.php	(original copy)
+++ tickets.inc.php	(modified copy)
@@ -197,7 +197,7 @@
 
 
 $qselect = 'SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name '.
-           ',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments ';
+           ',ticket.status,ticket.source,ticket.lastresponse,ticket.lastmessage,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments ';
 $qfrom=' FROM '.TICKET_TABLE.' ticket '.
        ' LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id ';
 
@@ -370,22 +370,35 @@
             <?if($canDelete || $canClose) {?>
 	        <th width="8px">&nbsp;</th>
             <?}?>
-	        <th width="70" >
+	        <th width="60" >
                 <a href="tickets.php?sort=ID&order=<?=$negorder?><?=$qstr?>" title="Sort By Ticket ID <?=$negorder?>">Ticket</a></th>
 	        <th width="70">
                 <a href="tickets.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Date</a></th>
-	        <th width="280">Subject</th>
-	        <th width="120">
+	        <th width="250">Subject</th>
+	        <th width="90">
                 <a href="tickets.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Department</a></th>
-	        <th width="70">
+	        <th width="60">
                 <a href="tickets.php?sort=pri&order=<?=$negorder?><?=$qstr?>" title="Sort By Priority <?=$negorder?>">Priority</a></th>
-            <th width="180" >From</th>
+            <th width="130" >From</th>
+            <th width="130">Last Responder</th>
         </tr>
         <?
         $class = "row1";
         $total=0;
         if($tickets_res && ($num=db_num_rows($tickets_res))):
             while ($row = db_fetch_array($tickets_res)) {
+            	if (NULL == $row['lastresponse']) {
+            		$last_responder = "None";
+            	}  elseif (strtotime($row['lastresponse']) > strtotime($row['lastmessage'])) {
+	            	$responder_qry = "SELECT `staff_name` FROM ".TICKET_RESPONSE_TABLE." WHERE ticket_id='".$row['ticket_id']."' ORDER BY `created` DESC LIMIT 1";
+	            	$responder_res = db_query($responder_qry);
+	            	if (db_num_rows($responder_res) > 0) {
+	            		$responder = db_fetch_row($responder_res);
+	            		$last_responder = $responder[0];
+	            	} 
+            	} else {
+            		$last_responder = Format::truncate($row['name'],22,strpos($row['name'],'@'));
+            	}
                 $tag=$row['staff_id']?'assigned':'openticket';
                 $flag=null;
                 if($row['lock_id'])
@@ -418,6 +431,7 @@
                 <td nowrap><?=Format::truncate($row['dept_name'],30)?></td>
                 <td class="nohover" align="center" style="background-color:<?=$row['priority_color']?>;"><?=$row['priority_desc']?></td>
                 <td nowrap><?=Format::truncate($row['name'],22,strpos($row['name'],'@'))?>&nbsp;</td>
+                <td nowrap><?=$last_responder?>&nbsp;</td>
             </tr>
             <?
             $class = ($class =='row2') ?'row1':'row2';