ILIAS\User\Setup\DBUpdateSteps10 Class Reference

Inheritance diagram for ILIAS\User\Setup\DBUpdateSteps10:

Collaboration diagram for ILIAS\User\Setup\DBUpdateSteps10:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 25 of file DBUpdateSteps10.php.

Member Function Documentation

prepare()

ILIAS\User\Setup\DBUpdateSteps10::prepare

(

\ilDBInterface

$db

)

Prepare the execution of the steps.

Do not use anything from the globals or the DIC inside your steps, only use the instance of the database provided here.

Implements ilDatabaseUpdateSteps.

Definition at line 29 of file DBUpdateSteps10.php.

References ILIAS\User\Setup\DBUpdateSteps10\$db.

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

step_1()

ILIAS\User\Setup\DBUpdateSteps10::step_1

(

)

Definition at line 34 of file DBUpdateSteps10.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        $this->db->manipulate(
            'DELETE FROM usr_pref WHERE keyword = ' . $this->db->quote('hits_per_page', \ilDBConstants::T_TEXT)
        );
        $this->db->manipulate(
            'DELETE FROM settings WHERE ' . $this->db->like('keyword', \ilDBConstants::T_TEXT, '%hits_per_page%')
        );
    }

step_2()

ILIAS\User\Setup\DBUpdateSteps10::step_2

(

)

Definition at line 44 of file DBUpdateSteps10.php.

References ilDBConstants\T_INTEGER.

                            : void
    {
        if (!$this->db->tableColumnExists(ChangeMailTokenDBRepository::TABLE_NAME, 'usr_id')) {
            $this->db->addTableColumn(
                ChangeMailTokenDBRepository::TABLE_NAME,
                'usr_id',
                [
                    'type' => \ilDBConstants::T_INTEGER,
                    'notnull' => true,
                    'length' => 8
                ]
            );
        }
        if (!$this->db->tableColumnExists(ChangeMailTokenDBRepository::TABLE_NAME, 'status')) {
            $this->db->addTableColumn(
                ChangeMailTokenDBRepository::TABLE_NAME,
                'status',
                [
                    'type' => \ilDBConstants::T_INTEGER,
                    'notnull' => false,
                    'length' => 1
                ]
            );
        }
        if ($this->db->tableColumnExists(ChangeMailTokenDBRepository::TABLE_NAME, 'valid_until')) {
            $this->db->renameTableColumn(
                ChangeMailTokenDBRepository::TABLE_NAME,
                'valid_until',
                'created_ts'
            );
        }
        if (!$this->db->primaryExistsByFields(ChangeMailTokenDBRepository::TABLE_NAME, ['token'])) {
            $this->db->manipulate('DELETE token1 FROM ' . ChangeMailTokenDBRepository::TABLE_NAME . ' token1 '
                . 'INNER JOIN ' . ChangeMailTokenDBRepository::TABLE_NAME . ' token2 '
                . 'WHERE token1.token = token2.token AND token1.created_ts < token2.created_ts');
            $this->db->addPrimaryKey(ChangeMailTokenDBRepository::TABLE_NAME, ['token']);
        }
    }

step_3()

ILIAS\User\Setup\DBUpdateSteps10::step_3

(

)

Definition at line 83 of file DBUpdateSteps10.php.

References ILIAS\Repository\int(), null, ilSessionReminder\SUGGESTED_LEAD_TIME, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                            : void
    {
        $query = 'SELECT * FROM settings WHERE module = %s AND keyword = %s';
        $result = $this->db->queryF(
            $query,
            [\ilDBConstants::T_TEXT, \ilDBConstants::T_TEXT],
            ['common', 'session_reminder_enabled']
        );
        $session_reminder = $result->numRows() ? (bool) $this->db->fetchAssoc($result)['value'] : false;
        $query = 'SELECT * FROM settings WHERE module = %s AND keyword = %s';
        $result = $this->db->queryF(
            $query,
            [\ilDBConstants::T_TEXT, \ilDBConstants::T_TEXT],
            ['common', 'session_reminder_lead_time']
        );
        $session_reminder_lead_time = $result->numRows() ? (int) $this->db->fetchAssoc($result)['value'] : null;
        if ($session_reminder && !isset($session_reminder_lead_time)) {
            $query = 'INSERT INTO settings (module, keyword, value) VALUES (%s, %s, %s)';
            $this->db->manipulateF(
                $query,
                [\ilDBConstants::T_TEXT, \ilDBConstants::T_TEXT, \ilDBConstants::T_INTEGER],
                ['common', 'session_reminder_lead_time', \ilSessionReminder::SUGGESTED_LEAD_TIME]
            );
        }
        $query = 'DELETE FROM settings WHERE module = %s AND keyword = %s';
        $this->db->manipulateF(
            $query,
            [\ilDBConstants::T_TEXT, \ilDBConstants::T_TEXT],
            ['common', 'session_reminder_enabled']
        );
        $query = 'DELETE FROM usr_pref WHERE keyword = %s';
        $this->db->manipulateF(
            $query,
            [\ilDBConstants::T_TEXT],
            ['session_reminder_enabled']
        );
    }

Here is the call graph for this function:

step_4()

ILIAS\User\Setup\DBUpdateSteps10::step_4

(

)

Definition at line 121 of file DBUpdateSteps10.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_5()

ILIAS\User\Setup\DBUpdateSteps10::step_5

(

)

Definition at line 145 of file DBUpdateSteps10.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if ($this->db->tableColumnExists('personal_clipboard', 'title')) {
            $this->db->modifyTableColumn('personal_clipboard', 'title', [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 255,
                'notnull' => false
            ]);
        }
    }

Field Documentation

$db

ilDBInterface ILIAS\User\Setup\DBUpdateSteps10::$db

protected

Definition at line 27 of file DBUpdateSteps10.php.

Referenced by ILIAS\User\Setup\DBUpdateSteps10\prepare().

---

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

• components/ILIAS/User/src/Setup/DBUpdateSteps10.php