prepare($sql); $res->bindParam(':user', $data['login_name']); $res->execute(); if (!$res->rowCount()) { $data['success'] = false; $data['field_id'] = 'login_name'; $data['message'] = message('warning', 'Ooops!', TRANS('USERNAME_OR_EMAIL_NOT_FOUND'), ''); echo json_encode($data); return false; } $userData = $res->fetch(); $data['user_id'] = $userData['user_id']; $data['name'] = $userData['nome']; $data['mail_to'] = $userData['email']; } if (!empty($data['email'])) { $sql = "SELECT user_id, nome, email FROM usuarios WHERE email = :email "; $res = $conn->prepare($sql); $res->bindParam(':email', $data['email']); $res->execute(); if (!$res->rowCount()) { $data['success'] = false; $data['field_id'] = 'email'; $data['message'] = message('warning', 'Ooops!', TRANS('USERNAME_OR_EMAIL_NOT_FOUND'), ''); echo json_encode($data); return false; } elseif ($res->rowCount() > 1) { $data['success'] = false; $data['field_id'] = 'email'; $data['message'] = message('warning', 'Ooops!', TRANS('EMAIL_TO_OTHER_ACCOUNTS'), ''); echo json_encode($data); return false; } $userData = $res->fetch(); $data['user_id'] = $userData['user_id']; $data['name'] = $userData['nome']; $data['mail_to'] = $userData['email']; } $data['rand'] = md5(uniqid(rand(), true)); $data['forget_link'] = $row_config['conf_ocomon_site'] . '/setNewPass.php?code=' . $data['user_id'] . '|' . $data['rand']; if (!csrf_verify($post)) { $data = []; $data['success'] = false; $data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'), ''); echo json_encode($data); return false; } $sql = "UPDATE usuarios SET forget = :access_code WHERE user_id = :user_id "; try { $res = $conn->prepare($sql); $res->bindParam(':access_code', $data['rand']); $res->bindParam(':user_id', $data['user_id']); $res->execute(); $VARS = array(); $VARS['%usuario%'] = explode(' ', $data['name'])[0]; $VARS['%site%'] = "" . $row_config['conf_ocomon_site'] . ""; $VARS['%forget_link%'] = $data['forget_link']; $rowconf = getMailConfig($conn); $event = 'forget-password'; $eventTemplate = getEventMailConfig($conn, $event); /* Disparo do e-mail para o usuário */ $mail = (new Email())->bootstrap( transvars($eventTemplate['msg_subject'], $VARS), transvars($eventTemplate['msg_body'], $VARS), $data['mail_to'], $eventTemplate['msg_fromname'], ); if (!$mail->send()) { $mailNotification .= "
" . TRANS('EMAIL_NOT_SENT') . "
" . $mail->message()->getText(); } } catch (Exception $e) { $data = []; $exception .= "
" . $e->getMessage(); $data['success'] = false; $data['message'] = message('danger', 'Ooops!', TRANS('MSG_SOMETHING_GOT_WRONG'),''); $_SESSION['flash'] = message('success', '', $data['message'], ''); echo json_encode($data); return false; } $data = []; $data['success'] = true; $data['message'] = TRANS('PASS_RECOVERY_REQUEST_DONE'); $_SESSION['flash'] = message('success', '', $data['message'] . $exception . $mailNotification, ''); echo json_encode($data); return false;