XF 1.4 help find and replace from db

jamalfree

Active member
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]
 
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
 
now i use this addon https://xenforo.com/community/resources/post-content-find-replace.1549/ but i dont know what i write in fields
post-content-find-replace-png.42172
 
Back
Top Bottom