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);
    }
}