PHPJunkyard support forum

Posted: **Wed Oct 12, 2011 10:25 am**

Hi there!

I know the forgot_ticket_id.txt is located under languages etc, but was wondering
if I could customise the list, so it sorts by open jobs first.. then closed?

At the moment, it just sorts the list by date whether its resolved or open.

Cheers!

Chris

Posted: **Wed Oct 12, 2011 5:10 pm**

In index.php try changing

Code: Select all

$sql = 'SELECT * FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'tickets` WHERE `email` LIKE \''.hesk_dbEscape($email).'\'';

to

Code: Select all

$sql = 'SELECT * FROM `'.hesk_dbEscape($hesk_settings['db_pfix']).'tickets` WHERE `email` LIKE \''.hesk_dbEscape($email).'\' ORDER BY `status` ASC';

Posted: **Thu Oct 13, 2011 11:52 am**

That's absolutely brilliant and worked a treat!!!

Thanks loads

)

PHPJunkyard support forum

Customise Forgot Ticket email

Customise Forgot Ticket email

Re: Customise Forgot Ticket email

Re: Customise Forgot Ticket email