ilUserDB90 Class Reference

Inheritance diagram for ilUserDB90:

Collaboration diagram for ilUserDB90:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	creates a column "rid" that is used to reference d IRSS Resource for a Profile Picture More...
	step_2 ()
	Modifies the 'passwd' field in table 'usr_data' to accept longer passwords. More...
	step_3 ()
	step_4 ()
	Remove the special charactor selector settings from the user preferences. More...
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
	step_10 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Private Attributes
const	USER_DATA_TABLE_NAME = 'usr_data'

Detailed Description

Author

Fabian Schmid fabia.nosp@m.n@sr.nosp@m..solu.nosp@m.tion.nosp@m.s

Definition at line 28 of file class.ilUserDB90.php.

Member Function Documentation

prepare()

ilUserDB90::prepare

(

ilDBInterface

$db

)

Definition at line 34 of file class.ilUserDB90.php.

References $db.

                                              : void
    {
        $this->db = $db;
    }

step_1()

ilUserDB90::step_1

(

)

creates a column "rid" that is used to reference d IRSS Resource for a Profile Picture

Definition at line 43 of file class.ilUserDB90.php.

                            : void
    {
        if (!$this->db->tableColumnExists(self::USER_DATA_TABLE_NAME, 'rid')) {
            $this->db->addTableColumn(
                'usr_data',
                'rid',
                [
                    'type' => 'text',
                    'notnull' => false,
                    'length' => 64,
                    'default' => ''
                ]
            );
        }
    }

step_10()

ilUserDB90::step_10

(

)

Definition at line 124 of file class.ilUserDB90.php.

References $res, ilSecuritySettings\MAX_LOGIN_ATTEMPTS, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                             : void
    {
        $query = 'SELECT value FROM settings WHERE module = %s AND keyword = %s';
        $res = $this->db->queryF(
            $query,
            [\ilDBConstants::T_TEXT, \ilDBConstants::T_TEXT],
            ['common', 'ps_login_max_attempts']
        );

        // We should adjust the usr_data values, even if the "Max. Login Attempts" are currently not set
        $max_login_attempts = min(
            (int) ($this->db->fetchAssoc($res)['value'] ?? ilSecuritySettings::MAX_LOGIN_ATTEMPTS),
            ilSecuritySettings::MAX_LOGIN_ATTEMPTS
        );

        $max_login_attempts_exceeded = $max_login_attempts + 1;

        $this->db->manipulateF(
            'UPDATE usr_data SET login_attempts = %s WHERE login_attempts > %s',
            [\ilDBConstants::T_INTEGER, \ilDBConstants::T_INTEGER],
            [$max_login_attempts_exceeded, $max_login_attempts_exceeded]
        );
    }

step_2()

ilUserDB90::step_2

(

)

Modifies the 'passwd' field in table 'usr_data' to accept longer passwords.

Definition at line 62 of file class.ilUserDB90.php.

                            : void
    {
        if ($this->db->tableColumnExists(self::USER_DATA_TABLE_NAME, 'passwd')) {
            $this->db->modifyTableColumn(
                'usr_data',
                'passwd',
                [
                    'type' => 'text',
                    'length' => 100,
                    'notnull' => false,
                    'default' => null
                ]
            );
        }
    }

step_3()

ilUserDB90::step_3

(

)

Definition at line 78 of file class.ilUserDB90.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->modifyTableColumn(
            'usr_sess_istorage',
            'session_id',
            [
                'type' => ilDBConstants::T_TEXT,
                'length' => '256'
            ]
        );
    }

step_4()

ilUserDB90::step_4

(

)

Remove the special charactor selector settings from the user preferences.

Definition at line 93 of file class.ilUserDB90.php.

                            : void
    {
        $this->db->manipulate("DELETE FROM usr_pref WHERE keyword LIKE 'char_selector%'");
    }

step_5()

ilUserDB90::step_5

(

)

Definition at line 98 of file class.ilUserDB90.php.

                            : void
    {
        $query = 'ALTER TABLE ' . self::USER_DATA_TABLE_NAME . ' MODIFY firstname VARCHAR(128);';
        $this->db->manipulate($query);
    }

step_6()

ilUserDB90::step_6

(

)

Definition at line 103 of file class.ilUserDB90.php.

                            : void
    {
        $query = 'ALTER TABLE ' . self::USER_DATA_TABLE_NAME . ' MODIFY lastname VARCHAR(128);';
        $this->db->manipulate($query);
    }

step_7()

ilUserDB90::step_7

(

)

Definition at line 108 of file class.ilUserDB90.php.

                            : void
    {
        $query = 'ALTER TABLE ' . self::USER_DATA_TABLE_NAME . ' MODIFY email VARCHAR(128);';
        $this->db->manipulate($query);
    }

step_8()

ilUserDB90::step_8

(

)

Definition at line 113 of file class.ilUserDB90.php.

                            : void
    {
        $query = 'DELETE FROM rbac_ta WHERE typ_id=22 AND ops_id=48 ;';
        $this->db->manipulate($query);
    }

step_9()

ilUserDB90::step_9

(

)

Definition at line 118 of file class.ilUserDB90.php.

                            : void
    {
        $query = 'DELETE FROM settings WHERE module="common" AND keyword="user_adm_alpha_nav";';
        $this->db->manipulate($query);
    }

Field Documentation

$db

ilDBInterface ilUserDB90::$db

protected

Definition at line 32 of file class.ilUserDB90.php.

Referenced by prepare().

USER_DATA_TABLE_NAME

const ilUserDB90::USER_DATA_TABLE_NAME = 'usr_data'

private

Definition at line 30 of file class.ilUserDB90.php.

---

The documentation for this class was generated from the following file:

• Services/User/classes/Setup/class.ilUserDB90.php