|
|
|
$hesklang['open'],
1 => $hesklang['wait_staff_reply'],
2 => $hesklang['wait_cust_reply'],
3 => $hesklang['closed']
);
/* Get ticket(s) from database */
require(HESK_PATH . 'inc/database.inc.php');
hesk_dbConnect();
$sql = 'SELECT * FROM `'.$hesk_settings['db_pfix'].'tickets` WHERE `email` LIKE \''.$email.'\'';
$result = hesk_dbQuery($sql);
$num=hesk_dbNumRows($result);
if ($num < 1)
{
hesk_error($hesklang['tid_not_found']);
}
$tid_list='';
$name='';
while ($my_ticket=hesk_dbFetchAssoc($result))
{
$name = $name ? $name : $my_ticket['name'];
$tid_list .= "
$hesklang[trackID]: $my_ticket[trackid]
$hesklang[subject]: $my_ticket[subject]
$hesklang[status]: ".$my_status[$my_ticket['status']]."
$hesk_settings[hesk_url]/ticket.php?track=$my_ticket[trackid]
";
}
/* Get e-mail message for customer */
$message=file_get_contents(HESK_PATH.'emails/forgot_ticket_id.txt');
$message=str_replace('%%NAME%%',$name,$message);
$message=str_replace('%%NUM%%',$num,$message);
$message=str_replace('%%LIST_TICKETS%%',$tid_list,$message);
$message=str_replace('%%SITE_TITLE%%',$hesk_settings['site_title'] ,$message);
$message=str_replace('%%SITE_URL%%',$hesk_settings['site_url'] ,$message);
/* Send e-mail */
$headers="From: $hesk_settings[noreply_mail]\n";
$headers.="Reply-to: $hesk_settings[noreply_mail]\n";
@mail($email,$hesklang['tid_email_subject'],$message,$headers);
?>
|
|