First we'll need to add the phone column to the $qselect...
Find this...
$qselect = 'SELECT DISTINCT
ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,ticket.subject,ticket.name,ticket.work,ticket.original_order,ticket.email,dept_name '.
',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments ';
and replace with this...
$qselect = 'SELECT DISTINCT
ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,ticket.subject,ticket.name,ticket.work,ticket.original_order,ticket.phone,ticket.email,dept_name '.
',ticket.status,ticket.source,isoverdue,isanswered,ticket.created,pri.* ,count(attach.attach_id) as attachments ';
Then, we'll need to replace the "Priority" header with "Phone"...
Find this...
<th width="70">
<a href="tickets.php?sort=pri&order=<?=$negorder?><?=$qstr?>" title="Sort By Priority <?=$negorder?>">Priority</a></th>
and replace with this
<th width="70"> Phone </th>
Now let's replace the listed priorities with the phone row that we added to the $qselect.
Find this...
<td class="nohover" align="center" style="background-color:<?=$row?>;"><?=$row?></td>
and replace with this...
<td class="nohover" align="center"><?=$row?></td>
: