Hi,

I have two questions relating to the order of tickets and messages:

Is there an option to display a timestamp on each ticket in staff panel?

Do you mean like this?

http://www.osticket.com/forums/showthread.php?t=2069(http://www.osticket.com/forums/showthread.php?t=2069)

Once inside a ticket, the messages are displayed with the newest at the bottom. Can this be change so newer messages are at the top (and you don't need to constantly scroll down to the bottom of each ticket!)

Great bit of software, trialled a few different help desks over the past few months and this seems to tick all the boxes... thanks.

Open \include\staff\viewticket.inc.php, FIND:

//get messages

$sql='SELECT msg.msg_id,msg.created,msg.message,count(attach_id) as attachments FROM '.TICKET_MESSAGE_TABLE.' msg '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON msg.ticket_id=attach.ticket_id AND msg.msg_id=attach.ref_id AND ref_type='M' ".

' WHERE msg.ticket_id='.db_input($id).

' GROUP BY msg.msg_id ORDER BY created';

REPLACE WITH:

//get messages

$sql='SELECT msg.msg_id,msg.created,msg.message,count(attach_id) as attachments FROM '.TICKET_MESSAGE_TABLE.' msg '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON msg.ticket_id=attach.ticket_id AND msg.msg_id=attach.ref_id AND ref_type='M' ".

' WHERE msg.ticket_id='.db_input($id).

' GROUP BY msg.msg_id ORDER BY created DESC';

FIND:

//get answers for messages

$sql='SELECT resp.*,count(attach_id) as attachments FROM '.TICKET_RESPONSE_TABLE.' resp '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON resp.ticket_id=attach.ticket_id AND resp.response_id=attach.ref_id AND ref_type='R' ".

' WHERE msg_id='.db_input($msg_row).' AND resp.ticket_id='.db_input($id).

' GROUP BY resp.response_id ORDER BY created';

REPLACE WITH:

//get answers for messages

$sql='SELECT resp.*,count(attach_id) as attachments FROM '.TICKET_RESPONSE_TABLE.' resp '.

' LEFT JOIN '.TICKET_ATTACHMENT_TABLE." attach ON resp.ticket_id=attach.ticket_id AND resp.response_id=attach.ref_id AND ref_type='R' ".

' WHERE msg_id='.db_input($msg_row).' AND resp.ticket_id='.db_input($id).

' GROUP BY resp.response_id ORDER BY created DESC';

This worked well.. Thanks!

Is there a mod to show the newest post in a ticket at the top? (ie Item #2 in belliez's request)

I've searched but can't seem to find anything.

You got it!

This worked well.. Thanks!

Is there a mod to show the newest post in a ticket at the top? (ie Item #2 in belliez's request)

I've searched but can't seem to find anything.

I've just done this MOD a few minutes ago. Now you can find it here:

http://www.osticket.com/forums/showthread.php?t=2152(http://www.osticket.com/forums/showthread.php?t=2152)

Cheers!

Best regards,

Masino Sinaga