Forgot tracking ID?

[hollandsedrop]

Hi,

Forgot tracking ID? Sent to customer all tickets!

I want only status of open ticket list.

help please...

[Klemen]

If I understood correctly... in index.php change

Code: Select all

$sql = "SELECT * FROM `hesk_tickets` WHERE `email` LIKE '$email'";

to

Code: Select all

$sql = "SELECT * FROM `hesk_tickets` WHERE `email` LIKE '$email' AND `status` != '3'";

I also recommend that you change words in emails/forgot_ticket_id.txt :
This e-mail contains a list of support tickets
change to
This e-mail contains a list of open support tickets

[hollandsedrop]

Perfect! Thanks...

[hollandsedrop]

how can i change new version (2.0) this?

If I understood correctly... in index.php change

Code: Select all

$sql = "SELECT * FROM `hesk_tickets` WHERE `email` LIKE '$email'";

to

Code: Select all

$sql = "SELECT * FROM `hesk_tickets` WHERE `email` LIKE '$email' AND `status` != '3'";

I also recommend that you change words in emails/forgot_ticket_id.txt :
This e-mail contains a list of support tickets
change to
This e-mail contains a list of open support tickets

[Klemen]

In the new version you have

Code: Select all

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

change it to

Code: Select all

$sql = 'SELECT * FROM `'.$hesk_settings['db_pfix'].'tickets` WHERE `email` LIKE \''.$email.'\' AND `status` != \'3\'';