As promised, I dug back through my code to figure out how to add the opened date back into the mix. Hopefully you will find what I found. I am not sure what the instructions in the original MOD that Scottro did that adds ticket age were (or if it was his MOD that removed the date column), but my date columns were simply commented out. I took the comment tags out and the date column reappeared. The sorting function is still intact and still works.
Just in case, I will paste the snippets of code that I have in hopes that you will be able to find the corresponding code in yours to work with. I apologize that I can't give line numbers as my system has been heavily modded and line numbers would probably confuse the issue more.
This is all in includes/staff/tickets.inc.php
For the header row, here is the date in between the ticket number and Age columns.
<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="55"> <a href="tickets.php?sort=timeopen&order=<?=$negorder?><?=$qstr?>" title="Sort By Age <?=$negorder?>">Age</a></th>
And here is the data rows, also with the Date in between the Tickets and Age columns. (My MOD to add sound on refresh if the is a new ticket is at the bottom.)
<td align="center" title="<?=$row?>" nowrap><a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?> Ticket: <?=$row?>"
href="tickets.php?id=<?=$row?>"><?=$tid?></a></td>
<td align="center" nowrap><?=Format:($row)?></td>
<td class="nohover" align="center" >
<?
$diff =$row;
$min = "min";
$mins = "mins";
$hours = "hours";
$hour = "hour";
$day = "day";
$days = "days";
if ( $diff <= 1 ){
print ($diff . " " . $min);
}elseif ( $diff > 1 && $diff <= 59 ){
print ($diff . " " . $mins);
}elseif ( $diff >= 60 && $diff <= 119 ){
$diff = round($diff / 60);
print (1 . " " . $hour);
}elseif ( $diff >= 120 && $diff <= 1439 ){
$diff = round($diff / 60);
print ($diff . " " . $hours);
}elseif ( $diff >= 1440 && $diff <= 2879 ){
print (1 . " " . $day);
}elseif ( $diff >= 2880 ){
$diff = round($diff / 1440);
print ($diff . " " . $days);
}else {};
?>
Begin MOD Beep On New Ticket
<? if ( $diff < 1 ){ ?> <embed src="blip1.wav" width="0" height="0" autoplay="true"></embed> <?}?>
End MOD Beep On New Ticket
</td>
Once you have the new comlumns (back) in place, you may have to edit the "width" tag of each TH header to account for the added column.
I hope this all makes sense and it helps you get the date column back into your ticket system like you wanted! Now that I have it back in, I think I am going to keep it.