Revive - implode to rv_zones

[wojtek]

Hi, 

   I have a problem with imploding some extra date to rv_zones table. 

I found an extra code - JS script - in to my prepend field in rv_zones.
It's a second time when I have come across something like this. Have any of you had to deal with this?

[wojtek]

I suspect it is some kind of SQL implode into the database. Have any of you encountered this problem? Ad server is running on AWS.

Edited September 21, 2021 by wojtek

[wojtek]

If anyone encounters a problem with SQL implode to table rv_zones or any others, below I left TRIGGER to fix it.

 

DELIMITER $$
CREATE TRIGGER implode_detection_rv_zones
    BEFORE UPDATE ON rv_zones 
    FOR EACH ROW 
        BEGIN
            IF OLD.prepend <> NEW.prepend THEN
                set NEW.prepend = SUBSTRING(NEW.prepend, 1, POSITION('span><script' in NEW.prepend)+4);
            END IF;
        END
$$
DELIMITER ;