UpdateSteps.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\OnScreenChat\Setup;

use ilDatabaseUpdateSteps;
use ilDBInterface;
use ilDBConstants;

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

    public function step_1(): void
    {
        $replace = [
            '&lt;' => '<',
            '&gt;' => '>',
            '&amp;' => '&',
            '&quot;' => '"',
        ];

        $replaced_message = 'message';
        foreach ($replace as $from => $to) {
            $replaced_message = sprintf(
                'REPLACE(%s, %s, %s)',
                $replaced_message,
                $this->db->quote($from, ilDBConstants::T_TEXT),
                $this->db->quote($to, ilDBConstants::T_TEXT)
            );
        }

        $this->db->manipulate('UPDATE osc_messages SET message = ' . $replaced_message);
    }
}