pquery('select email1 from vtiger_users where user_name= ? ', array($username)); if ($adb->num_rows($result) > 0) { $email = $adb->query_result($result, 0, 'email1'); } if (vtlib_purify($_REQUEST['emailId']) == $email) { $time = time(); $options = array( 'handler_path' => 'modules/Users/handlers/ForgotPassword.php', 'handler_class' => 'Users_ForgotPassword_Handler', 'handler_function' => 'changePassword', 'handler_data' => array( 'username' => $username, 'email' => $email, 'time' => $time, 'hash' => md5($username.$time) ) ); $trackURL = Vtiger_ShortURL_Helper::generateURL($options); $content = 'Dear Customer,

You recently requested a password reset for your VtigerCRM Open source Account.
To create a new password, click on the link here.

This request was made on '.date("Y-m-d H:i:s").' and will expire in next 24 hours.

Regards,
VtigerCRM Open source Support Team.
'; $subject = 'Vtiger CRM: Password Reset'; $mail = new Vtiger_Mailer(); $mail->IsHTML(); $mail->Body = $content; $mail->Subject = $subject; $mail->AddAddress($email); $status = $mail->Send(true); if ($status === 1 || $status === true) { header('Location: index.php?modules=Users&view=Login&mailStatus=success'); } else { header('Location: index.php?modules=Users&view=Login&error=statusError'); } } else { header('Location: index.php?modules=Users&view=Login&error=fpError'); } }