A few months back I drove myself crazy trying to figure out how to reverse the order of the internal notes so that they showed up in the order in which they were made. (i.e. oldest at the top)
Tonight I sat down and figured it out in about 3 minutes.
Sorry I can't give exact line numbers in the code, as I have my system heavily modded.
In file viewticket.inc.php search for:
<?
//Internal Notes
$sql ='SELECT note_id,title,note,source,created FROM '.TICKET_NOTE_TABLE.' WHERE ticket_id='.db_input($id).' ORDER BY created DESC';
if(($resp=db_query($sql)) && ($notes=db_num_rows($resp))){
$display=($notes>5)?'none':'block'; //Collapse internal notes if more than 5.
?>
Within that bit of code, find the bit that says "ORDER BY created DESC" and change it to read "ORDER BY created ASC".
Or just replace it with this...
<?
//Internal Notes
$sql ='SELECT note_id,title,note,source,created FROM '.TICKET_NOTE_TABLE.' WHERE ticket_id='.db_input($id).' ORDER BY created ASC';
if(($resp=db_query($sql)) && ($notes=db_num_rows($resp))){
$display=($notes>5)?'none':'block'; //Collapse internal notes if more than 5.
?>
Enjoy! :
