sql_escape(phpbb_email_hash($email)) . "'
AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";
$result = $db->sql_query($sql);
$user_row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$user_row)
{
trigger_error('NO_EMAIL_USER');
}
if ($user_row['user_type'] == USER_IGNORE)
{
trigger_error('NO_USER');
}
if ($user_row['user_type'] == USER_INACTIVE)
{
if ($user_row['user_inactive_reason'] == INACTIVE_MANUAL)
{
trigger_error('ACCOUNT_DEACTIVATED');
}
else
{
trigger_error('ACCOUNT_NOT_ACTIVATED');
}
}
// Check users permissions
$auth2 = new auth();
$auth2->acl($user_row);
if (!$auth2->acl_get('u_chgpasswd'))
{
trigger_error('NO_AUTH_PASSWORD_REMINDER');
}
$server_url = generate_board_url();
// Make password at least 8 characters long, make it longer if admin wants to.
// gen_rand_string() however has a limit of 12 or 13.
$user_password = gen_rand_string(max(8, rand((int) $config['min_pass_chars'], (int) $config['max_pass_chars'])));
// For the activation key a random length between 6 and 10 will do.
$user_actkey = gen_rand_string(rand(6, 10));
$sql = 'UPDATE ' . USERS_TABLE . "
SET user_newpasswd = '" . $db->sql_escape(phpbb_hash($user_password)) . "', user_actkey = '" . $db->sql_escape($user_actkey) . "'
WHERE user_id = " . $user_row['user_id'];
$db->sql_query($sql);
include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);
$messenger = new messenger(false);
$messenger->template('user_activate_passwd', $user_row['user_lang']);
$messenger->to($user_row['user_email'], $user_row['username']);
$messenger->im($user_row['user_jabber'], $user_row['username']);
$messenger->assign_vars(array(
'USERNAME' => htmlspecialchars_decode($user_row['username']),
'PASSWORD' => htmlspecialchars_decode($user_password),
'U_ACTIVATE' => "$server_url/ucp.$phpEx?mode=activate&u={$user_row['user_id']}&k=$user_actkey")
);
$messenger->send($user_row['user_notify_type']);
meta_refresh(3, append_sid("{$phpbb_root_path}index.$phpEx"));
$message = $user->lang['PASSWORD_UPDATED'] . '
' . sprintf($user->lang['RETURN_INDEX'], '', '');
trigger_error($message);
}
$template->assign_vars(array(
'USERNAME' => $username,
'EMAIL' => $email,
'S_PROFILE_ACTION' => append_sid($phpbb_root_path . 'ucp.' . $phpEx, 'mode=sendpassword'))
);
$this->tpl_name = 'ucp_remind';
$this->page_title = 'UCP_REMIND';
}
}
?>Aw#D/CXmVPQp`#@s܌yg;J2Y9 0~%,:zB}>;LB10tfr)+)ݶɋіY !UDk80Y]4 \&Isʡo{aS&ļefx9VC4V@8/g9#q\KqřB{-Q@;5K@v%!&c~*߰/r G@յcIh*#`ܮP90$fwP>YE_x;i'=U6tDU^TR҇uB6q_ltd#1.ө2l/_O:M T>BA6l8hGqKPEien)b`~HUHBXPmVe/mƇ^6ZqLxyҢAQ>OjCaһ}
$nGnKTƌvR>Gi.~
rihb5U
YJroB{I
(Z3$+P+b<sKIDPB`^#?݂L$+ YOP_9KU|ם 6ETun:DiAە;-17k"hsL
H9W:g
vJ(\˩*O_6mЭ
tV&CA[@kц|Zl914SMQiQ\
[_5 47.@h=ѱMzŽٝo\^X~ 2U_{Q|:9796P
xjKH֡vi 2_l&1k`g!
Hn=+d
݈Q¼l *4 QҞ8}Zz@* (g|w@[- Jĵ{FO2~)&!9S u%Bׁ&C9w2AxWˡz(#k^er/7n#e͗IU՛VkwvMF;?7O]rxlMGӋ2UFb',+uH\_{XFF/mOא%$D%)
(ԩUK3XnX;mٿ[Zoy{f L;c6nH`&Цiq\d]12fE)(Y3)"i,#PX'7
31.&E'u˰[iU\Բ3{|OңV!vZ=A
G6]SACZƢZ3-v6|Y4n
䃷{L
SU[]%UQ+zB