Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190721.sql =================================================================== diff -u -rfadc30445af67b39ce07890493c9cea08c3ea5db -rcd25fd46424cbe1430b34ce394ee2cd35c92cc04 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190721.sql (.../patch20190721.sql) (revision fadc30445af67b39ce07890493c9cea08c3ea5db) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190721.sql (.../patch20190721.sql) (revision cd25fd46424cbe1430b34ce394ee2cd35c92cc04) @@ -1,11 +1,14 @@ CREATE FUNCTION `strip_tags`($str MEDIUMTEXT) RETURNS MEDIUMTEXT BEGIN DECLARE $start, $end INT DEFAULT 1; - LOOP + DECLARE $tag CHAR(3); + main: LOOP SET $start = LOCATE("<", $str, $start); - IF (!$start) THEN RETURN $str; END IF; + IF (NOT $start) THEN RETURN $str; END IF; SET $end = LOCATE(">", $str, $start); - IF (!$end) THEN SET $end = $start; END IF; + IF (NOT $end) THEN SET $end = $start; END IF; + SET $tag = SUBSTRING($str, $start + 1, 3); + IF $tag = 'img' OR $tag = 'IMG' THEN SET $start = $end; ITERATE main; END IF; SET $str = INSERT($str, $start, $end - $start + 1, ""); END LOOP; END;