ilMailDatabaseUpdateSteps Class Reference

Inheritance diagram for ilMailDatabaseUpdateSteps:

Collaboration diagram for ilMailDatabaseUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
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_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']]
                    );
                }
            }
        }
    }

Field Documentation

$db

ilDBInterface ilMailDatabaseUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• Services/Mail/classes/Setup/class.ilMailDatabaseUpdateSteps.php