PHPJunkyard support forum

Posted: **Sat Jan 03, 2009 11:56 am**

Hi,

Forgot tracking ID? Sent to customer all tickets!

I want only status of open ticket list.

help please...

Posted: **Sat Jan 03, 2009 9:29 pm**

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

$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

Posted: **Sun Jan 04, 2009 5:57 pm**

Perfect! Thanks...

Posted: **Thu Jan 29, 2009 11:35 am**

how can i change new version (2.0) this?

Klemen wrote: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

Posted: **Thu Jan 29, 2009 6:27 pm**

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