• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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