ILIAS\Chatroom\Setup\UpdateSteps Class Reference

Inheritance diagram for ILIAS\Chatroom\Setup\UpdateSteps:

Collaboration diagram for ILIAS\Chatroom\Setup\UpdateSteps:

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

Protected Attributes
ilDBInterface	$db

Private Member Functions
	dropColumnWhenExists (string $table, string $column)
	dropTableWhenExists (string $table)

Detailed Description

Definition at line 27 of file UpdateSteps.php.

Member Function Documentation

dropColumnWhenExists()

ILIAS\Chatroom\Setup\UpdateSteps::dropColumnWhenExists ( string  $table, string  $column  )

private

Definition at line 99 of file UpdateSteps.php.

                                                                        : void
    {
        if ($this->db->tableColumnExists($table, $column)) {
            $this->db->dropTableColumn($table, $column);
        }
    }

Referenced by ILIAS\Chatroom\Setup\UpdateSteps\step_1(), and ILIAS\Chatroom\Setup\UpdateSteps\step_3().

Here is the caller graph for this function:

dropTableWhenExists()

ILIAS\Chatroom\Setup\UpdateSteps::dropTableWhenExists ( string  $table )

private

Definition at line 106 of file UpdateSteps.php.

                                                       : void
    {
        if ($this->db->tableExists($table)) {
            $this->db->dropTable($table);
        }
    }

Referenced by ILIAS\Chatroom\Setup\UpdateSteps\step_2(), and ILIAS\Chatroom\Setup\UpdateSteps\step_5().

Here is the caller graph for this function:

prepare()

ILIAS\Chatroom\Setup\UpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 31 of file UpdateSteps.php.

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

References ILIAS\Chatroom\Setup\UpdateSteps\$db.

step_1()

ILIAS\Chatroom\Setup\UpdateSteps::step_1

(

)

Definition at line 36 of file UpdateSteps.php.

                            : void
    {
        $this->db->dropTable('chatroom_prooms', false);
        $this->db->dropTable('chatroom_proomaccess', false);
        $this->db->dropTable('chatroom_psessions', false);
 
        $this->dropColumnWhenExists('chatroom_history', 'sub_room');
        $this->dropColumnWhenExists('chatroom_settings', 'allow_private_rooms');
        $this->dropColumnWhenExists('chatroom_settings', 'private_rooms_enabled');
    }

References ILIAS\Chatroom\Setup\UpdateSteps\dropColumnWhenExists().

Here is the call graph for this function:

step_2()

ILIAS\Chatroom\Setup\UpdateSteps::step_2

(

)

Definition at line 47 of file UpdateSteps.php.

                            : void
    {
        $this->dropTableWhenExists('chatroom_smilies');
    }

References ILIAS\Chatroom\Setup\UpdateSteps\dropTableWhenExists().

Here is the call graph for this function:

step_3()

ILIAS\Chatroom\Setup\UpdateSteps::step_3

(

)

Definition at line 52 of file UpdateSteps.php.

                            : void
    {
        $this->dropColumnWhenExists('chatroom_settings', 'restrict_history');
    }

References ILIAS\Chatroom\Setup\UpdateSteps\dropColumnWhenExists().

Here is the call graph for this function:

step_4()

ILIAS\Chatroom\Setup\UpdateSteps::step_4

(

)

Definition at line 57 of file UpdateSteps.php.

                            : void
    {
        $query = '
            UPDATE object_data
            INNER JOIN chatroom_settings ON object_data.obj_id = chatroom_settings.object_id
            SET object_data.offline = IF(chatroom_settings.online_status = 1, 0, 1)
            WHERE object_data.type = %s
        ';
 
        $this->db->manipulateF(
            $query,
            [ilDBConstants::T_TEXT],
            ['chtr']
        );
    }

References ilDBConstants\T_TEXT.

step_5()

ILIAS\Chatroom\Setup\UpdateSteps::step_5

(

)

Definition at line 73 of file UpdateSteps.php.

                            : void
    {
        $this->dropTableWhenExists('chatroom_uploads');
        $this->db->manipulate('DELETE FROM chatroom_bans WHERE user_id NOT IN (SELECT usr_id FROM usr_data)');
    }

References ILIAS\Chatroom\Setup\UpdateSteps\dropTableWhenExists().

Here is the call graph for this function:

step_6()

ILIAS\Chatroom\Setup\UpdateSteps::step_6

(

)

Definition at line 79 of file UpdateSteps.php.

                            : void
    {
        $replace = [
            '&lt;' => '<',
            '&gt;' => '>',
            '&amp;' => '&',
            '&quot;' => '"',
        ];
 
        $s = 'JSON_VALUE(message, "$.content")';
        foreach ($replace as $from => $to) {
            $s = sprintf('REPLACE(%s, %s, %s)', $s, $this->db->quote($from, ilDBConstants::T_TEXT), $this->db->quote($to, ilDBConstants::T_TEXT));
        }
 
        $this->db->manipulate(
            'UPDATE chatroom_history SET message = JSON_SET(message, "$.content", ' . $s . ') ' .
            'WHERE JSON_VALID(message) = 1 AND JSON_VALUE(message, "$.type") = ' . $this->db->quote('message', ilDBConstants::T_TEXT)
        );
    }

References ilDBConstants\T_TEXT.

Field Documentation

$db

ilDBInterface ILIAS\Chatroom\Setup\UpdateSteps::$db

protected

Definition at line 29 of file UpdateSteps.php.

Referenced by ILIAS\Chatroom\Setup\UpdateSteps\prepare().

---

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

• components/ILIAS/Chatroom/classes/Setup/UpdateSteps.php