Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
CRAP
0.00% covered (danger)
0.00%
0 / 101
ucp_remind
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
182
0.00% covered (danger)
0.00%
0 / 97
 main
0.00% covered (danger)
0.00%
0 / 1
182
0.00% covered (danger)
0.00%
0 / 97
<?php
/**
*
* This file is part of the phpBB Forum Software package.
*
* @copyright (c) phpBB Limited <https://www.phpbb.com>
* @license GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
    exit;
}
/**
* ucp_remind
* Sending password reminders
*/
class ucp_remind
{
    var $u_action;
    function main($id, $mode)
    {
        global $config, $phpbb_root_path, $phpEx, $request;
        global $db, $user, $template, $phpbb_container, $phpbb_dispatcher;
        if (!$config['allow_password_reset'])
        {
            trigger_error($user->lang('UCP_PASSWORD_RESET_DISABLED', '<a href="mailto:' . htmlspecialchars($config['board_contact']) . '">', '</a>'));
        }
        $username    = $request->variable('username', '', true);
        $email        = strtolower($request->variable('email', ''));
        $submit        = (isset($_POST['submit'])) ? true : false;
        add_form_key('ucp_remind');
        if ($submit)
        {
            if (!check_form_key('ucp_remind'))
            {
                trigger_error('FORM_INVALID');
            }
            if (empty($email))
            {
                trigger_error('NO_EMAIL_USER');
            }
            $sql_array = array(
                'SELECT'    => 'user_id, username, user_permissions, user_email, user_jabber, user_notify_type, user_type, user_lang, user_inactive_reason',
                'FROM'        => array(USERS_TABLE => 'u'),
                'WHERE'        => "user_email_hash = '" . $db->sql_escape(phpbb_email_hash($email)) . "'" .
                    (!empty($username) ? " AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'" : ''),
            );
            /**
            * Change SQL query for fetching user data
            *
            * @event core.ucp_remind_modify_select_sql
            * @var    string    email        User's email from the form
            * @var    string    username    User's username from the form
            * @var    array    sql_array    Fully assembled SQL query with keys SELECT, FROM, WHERE
            * @since 3.1.11-RC1
            */
            $vars = array(
                'email',
                'username',
                'sql_array',
            );
            extract($phpbb_dispatcher->trigger_event('core.ucp_remind_modify_select_sql', compact($vars)));
            $sql = $db->sql_build_query('SELECT', $sql_array);
            $result = $db->sql_query_limit($sql, 2); // don't waste resources on more rows than we need
            $rowset = $db->sql_fetchrowset($result);
            if (count($rowset) > 1)
            {
                $db->sql_freeresult($result);
                $template->assign_vars(array(
                    'USERNAME_REQUIRED'    => true,
                    'EMAIL'                => $email,
                ));
            }
            else
            {
                $message = $user->lang['PASSWORD_UPDATED_IF_EXISTED'] . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');
                if (empty($rowset))
                {
                    trigger_error($message);
                }
                $user_row = $rowset[0];
                $db->sql_freeresult($result);
                if (!$user_row)
                {
                    trigger_error($message);
                }
                if ($user_row['user_type'] == USER_IGNORE || $user_row['user_type'] == USER_INACTIVE)
                {
                    trigger_error($message);
                }
                // Check users permissions
                $auth2 = new \phpbb\auth\auth();
                $auth2->acl($user_row);
                if (!$auth2->acl_get('u_chgpasswd'))
                {
                    trigger_error($message);
                }
                $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_friendly(max(8, mt_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(mt_rand(6, 10));
                // Instantiate passwords manager
                /* @var $manager \phpbb\passwords\manager */
                $passwords_manager = $phpbb_container->get('passwords.manager');
                $sql = 'UPDATE ' . USERS_TABLE . "
                    SET user_newpasswd = '" . $db->sql_escape($passwords_manager->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->set_addresses($user_row);
                $messenger->anti_abuse_headers($config, $user);
                $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']);
                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';
    }
}