Inheritance diagram for ilMailDatabaseUpdateSteps:

Collaboration diagram for ilMailDatabaseUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)

	step_1 ()

	step_2 ()

	step_3 ()

	step_4 ()

	step_5 ()

	step_6 ()

	step_7 ()

	step_8 ()

	step_9 ()

	step_10 ()

	step_11 ()

	step_12 ()

	step_13 ()

	step_14 ()

	step_15 ()

Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilMailDatabaseUpdateSteps.php.

Member Function Documentation

◆ prepare()

ilMailDatabaseUpdateSteps::prepare ( ilDBInterface $db )

Definition at line 25 of file class.ilMailDatabaseUpdateSteps.php.

References $db.

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

◆ step_1()

ilMailDatabaseUpdateSteps::step_1 ( )

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

                             : void
     {
         if ($this->db->tableExists('mail') && $this->db->tableColumnExists('mail', 'm_email')) {
             $this->db->dropTableColumn('mail', 'm_email');
         }
     }

◆ step_10()

ilMailDatabaseUpdateSteps::step_10 ( )

Definition at line 157 of file class.ilMailDatabaseUpdateSteps.php.

References null.

                              : void
     {
         if (!$this->db->tableColumnExists('mail_options', 'absence_ar_subject')) {
             $this->db->addTableColumn(
                 'mail_options',
                 'absence_ar_subject',
                 [
                     'type' => 'text',
                     'length' => 255,
                     'notnull' => false,
                     'default' => null
                 ]
             );
         }
     }

◆ step_11()

ilMailDatabaseUpdateSteps::step_11 ( )

Definition at line 173 of file class.ilMailDatabaseUpdateSteps.php.

                              : void
     {
         if (!$this->db->tableExists('mail_auto_responder')) {
             $this->db->createTable(
                 'mail_auto_responder',
                 [
                     'sender_id' => [
                         'type' => 'integer',
                         'length' => 8,
                         'notnull' => true
                     ],
                     'receiver_id' => [
                         'type' => 'integer',
                         'length' => 8,
                         'notnull' => true
                     ],
                     'sent_time' => [
                         'type' => 'timestamp',
                         'notnull' => true
                     ]
                 ]
             );
             $this->db->addPrimaryKey('mail_auto_responder', ['sender_id', 'receiver_id']);
         }
     }

◆ step_12()

ilMailDatabaseUpdateSteps::step_12 ( )

Definition at line 199 of file class.ilMailDatabaseUpdateSteps.php.

References $res, and ilDBConstants\T_TEXT.

                              : void
     {
         $settings = [
             'mail_system_sys_signature',
             'mail_system_usr_from_name',
         ];
 
         foreach ($settings as $keyword) {
             $res = $this->db->queryF(
                 "SELECT value FROM settings WHERE keyword = %s AND value IS NOT NULL AND value != ''",
                 [ilDBConstants::T_TEXT],
                 [$keyword]
             );
             if ($this->db->numRows($res) === 1) {
                 $value = $this->db->fetchAssoc($res)['value'] ?? '';
                 if ($value === '') {
                     return;
                 }
 
                 $value = preg_replace(
                     '/\[([A-Z_]+?)\]/',
                     '{{$1}}',
                     $value
                 );
 
                 $this->db->manipulateF(
                     'UPDATE settings SET value = %s WHERE keyword = %s',
                     [ilDBConstants::T_TEXT, ilDBConstants::T_TEXT],
                     [$value, $keyword]
                 );
             }
         }
     }

◆ step_13()

ilMailDatabaseUpdateSteps::step_13 ( )

Definition at line 233 of file class.ilMailDatabaseUpdateSteps.php.

                              : void
     {
         if ($this->db->tableExists("mail_tpl_ctx")) {
             $query = "UPDATE mail_tpl_ctx SET " . PHP_EOL
                 . " component = REPLACE(component, 'Modules', 'components/ILIAS') " . PHP_EOL
                 . " WHERE component LIKE ('Modules/%')";
 
             $this->db->manipulate($query);
         }
     }

◆ step_14()

ilMailDatabaseUpdateSteps::step_14 ( )

Definition at line 244 of file class.ilMailDatabaseUpdateSteps.php.

                              : void
     {
         if ($this->db->tableExists("mail_tpl_ctx")) {
             $query = "UPDATE mail_tpl_ctx SET " . PHP_EOL
                 . " path = REPLACE(path, 'Modules', 'components/ILIAS') " . PHP_EOL
                 . " WHERE component LIKE ('Modules/%')" . PHP_EOL
                 . " AND path IS NOT NULL";
 
             $this->db->manipulate($query);
         }
     }

◆ step_15()

ilMailDatabaseUpdateSteps::step_15 ( )

Definition at line 256 of file class.ilMailDatabaseUpdateSteps.php.

References $res, and ilDBConstants\T_TEXT.

                              : void
     {
         $res = $this->db->queryF(
             "SELECT value FROM settings WHERE keyword = %s AND value IS NOT NULL AND value != ''",
             [ilDBConstants::T_TEXT],
             ['mail_system_sys_signature']
         );
         if ($this->db->numRows($res) === 1) {
             $value = $this->db->fetchAssoc($res)['value'] ?? '';
             $sys_general_signature = preg_replace('/(\s?\*\s?){2,}/', "\n\n-- \n", $value);
             // replace [] with {{}}
             $sys_general_signature = preg_replace('/\[([A-Z_]+?)\]/', '{{$1}}', $sys_general_signature);
             $sys_general_signature = str_replace(
                 ['CLIENT_URL', 'CLIENT'],
                 ['ILIAS_URL', 'INSTALLATION'],
                 $sys_general_signature
             );
             $this->db->manipulateF(
                 'DELETE FROM settings WHERE keyword = %s',
                 [ilDBConstants::T_TEXT],
                 ['mail_system_sys_signature']
             );
         }
         $this->db->insert('settings', [
             'module' => ['text', 'common'],
             'keyword' => ['text', 'mail_system_sys_general_signature'],
             'value' => [
                 'text',
                 $sys_general_signature ?? "\n\n-- \n{{INSTALLATION_NAME}}\n{{INSTALLATION_DESC}}\n{{ILIAS_URL}}\n"
             ],
         ]);
         $this->db->insert('settings', [
             'module' => ['text', 'common'],
             'keyword' => ['text', 'mail_system_usr_general_signature'],
             'value' => ['text', "\n\n-- \nThis mail was sent by {{USER_FULLNAME}} from {{INSTALLATION_NAME}}\n"],
         ]);
     }

◆ step_2()

ilMailDatabaseUpdateSteps::step_2 ( )

Definition at line 37 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         $result = $this->db->queryF('SELECT value FROM settings WHERE module = %s AND keyword = %s', ['text', 'text'], ['common', 'mail_system_sys_signature']);
         $row = $this->db->fetchAssoc($result);
         if (isset($row['value']) && $row['value'] !== '') {
             $new_value = str_replace(['[CLIENT_NAME]', '[CLIENT_DESC]', '[CLIENT_URL]'], ['[INSTALLATION_NAME]', '[INSTALLATION_DESC]', '[ILIAS_URL]'], $row['value']);
             if ($new_value !== $row['value']) {
                 $this->db->manipulateF(
                     'UPDATE settings SET value = %s WHERE module = %s AND keyword = %s',
                     ['text', 'text', 'text'],
                     [$new_value, 'common', 'mail_system_sys_signature']
                 );
             }
         }
     }

◆ step_3()

ilMailDatabaseUpdateSteps::step_3 ( )

Definition at line 53 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         $result = $this->db->query("SELECT tpl_id, m_message FROM mail_man_tpl WHERE m_message LIKE '%[CLIENT_NAME]%'");
         while ($row = $this->db->fetchAssoc($result)) {
             if (isset($row['m_message'], $row['tpl_id']) && $row['m_message'] !== '' && $row['tpl_id'] !== '') {
                 $new_value = str_replace('[CLIENT_NAME]', '[INSTALLATION_NAME]', $row['m_message']);
                 if ($new_value !== $row['m_message']) {
                     $this->db->manipulateF(
                         'UPDATE mail_man_tpl SET m_message = %s WHERE tpl_id = %s',
                         ['text', 'text'],
                         [$new_value, $row['tpl_id']]
                     );
                 }
             }
         }
     }

◆ step_4()

ilMailDatabaseUpdateSteps::step_4 ( )

Definition at line 70 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         $result = $this->db->query("SELECT lang, type, body FROM mail_template WHERE body LIKE '%[CLIENT_NAME]%'");
         while ($row = $this->db->fetchAssoc($result)) {
             if (isset($row['lang'], $row['type'], $row['body']) && $row['body'] !== '') {
                 $new_value = str_replace('[CLIENT_NAME]', '[INSTALLATION_NAME]', $row['body']);
                 if ($new_value !== $row['body']) {
                     $this->db->manipulateF(
                         'UPDATE mail_template SET body = %s WHERE lang = %s AND type = %s',
                         ['text', 'text', 'text'],
                         [$new_value, $row['lang'], $row['type']]
                     );
                 }
             }
         }
     }

◆ step_5()

ilMailDatabaseUpdateSteps::step_5 ( )

Definition at line 87 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         if ($this->db->tableExists('mail_options') && $this->db->tableColumnExists('mail_options', 'linebreak')) {
             $this->db->dropTableColumn('mail_options', 'linebreak');
         }
     }

◆ step_6()

ilMailDatabaseUpdateSteps::step_6 ( )

Definition at line 94 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         if (!$this->db->tableColumnExists('mail_options', 'absence_status')) {
             $this->db->addTableColumn(
                 'mail_options',
                 'absence_status',
                 [
                     'type' => 'integer',
                     'length' => 1,
                     'notnull' => true,
                     'default' => 0
                 ]
             );
         }
     }

◆ step_7()

ilMailDatabaseUpdateSteps::step_7 ( )

Definition at line 110 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         if (!$this->db->tableColumnExists('mail_options', 'absent_from')) {
             $this->db->addTableColumn(
                 'mail_options',
                 'absent_from',
                 [
                     'type' => 'integer',
                     'length' => 8,
                     'notnull' => true,
                     'default' => 0
                 ]
             );
         }
     }

◆ step_8()

ilMailDatabaseUpdateSteps::step_8 ( )

Definition at line 126 of file class.ilMailDatabaseUpdateSteps.php.

                             : void
     {
         if (!$this->db->tableColumnExists('mail_options', 'absent_until')) {
             $this->db->addTableColumn(
                 'mail_options',
                 'absent_until',
                 [
                         'type' => 'integer',
                         'length' => 8,
                         'notnull' => true,
                         'default' => 0
                     ]
             );
         }
     }

◆ step_9()

ilMailDatabaseUpdateSteps::step_9 ( )

Definition at line 142 of file class.ilMailDatabaseUpdateSteps.php.