Customise Forgot Ticket email

[chrisn0123]

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

[Klemen]

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'; 

[chrisn0123]

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

Thanks loads )