XF 1.4 help find and replace from db

jamalfree

Active member
#1
hi
i want to replace many codes from db with reg exp for wining time and effort please help some codes
for example
[FONT=Verdana, Arial, Helvetica, sans-serif]
i want any code begin with [FONT and endedd with ] shoud remove it

and
any code begin [COLOR endedd with ] remove it



sql
UPDATE `xf_post` SET message = replace( message, '', '' ) ;
UPDATE `xf_post` SET message = replace( message, '[COLOR=#003366', '' ) ;[/QUOTE]
 

jamalfree

Active member
#2
and

[table1="width:95%;background-image:url('[url]http://www.site.com/mwaextraedit2/backgrounds/170.gif');background-color:white;[/url]"]
[table1="width:95%;background-image:url('[url]http://www.site.com/mwaextraedit2/backgrounds/170.gif');background-color:white;[/url]"]

and any code begin with
[table1
ended with ]
shoud remov it
 
Top