class.ilUserDB90.php

Go to the documentation of this file.

<?php

use ILIAS\Setup;
use ILIAS\Refinery;
use ILIAS\Setup\Environment;
use ILIAS\Setup\Objective;
use ILIAS\UI;

class ilUserDB90 implements ilDatabaseUpdateSteps
{
    private const USER_DATA_TABLE_NAME = 'usr_data';

    protected ilDBInterface $db;

    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }


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

    public function step_2(): 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
                ]
            );
        }
    }

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

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

    public function step_5(): void
    {
        $query = 'ALTER TABLE ' . self::USER_DATA_TABLE_NAME . ' MODIFY firstname VARCHAR(128);';
        $this->db->manipulate($query);
    }
    public function step_6(): void
    {
        $query = 'ALTER TABLE ' . self::USER_DATA_TABLE_NAME . ' MODIFY lastname VARCHAR(128);';
        $this->db->manipulate($query);
    }
    public function step_7(): void
    {
        $query = 'ALTER TABLE ' . self::USER_DATA_TABLE_NAME . ' MODIFY email VARCHAR(128);';
        $this->db->manipulate($query);
    }
    public function step_8(): void
    {
        $query = 'DELETE FROM rbac_ta WHERE typ_id=22 AND ops_id=48 ;';
        $this->db->manipulate($query);
    }
    public function step_9(): void
    {
        $query = 'DELETE FROM settings WHERE module="common" AND keyword="user_adm_alpha_nav";';
        $this->db->manipulate($query);
    }

    public function step_10(): 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]
        );
    }
}