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

Removing MyBB tags after importing database

Jake Bunce

XenForo moderator
Staff member
#3
Here are the values you can use in that addon.

Updating the [align=center][/align] tags:

Quick Find:
[align​

Regular Expression:
#\[align=center\](.*)\[/align\]#siU​

Replacement String:
[center]\1[/center]​

Screenshot:

Screen shot 2011-09-07 at 8.45.45 PM.png

Updating the [size=x-small][/size] tags:

Quick Find:
[size​

Regular Expression:
#\[size=x-small\](.*)\[/size\]#siU​

Replacement String:
[size=1]\1[/size]​

Screenshot:

Screen shot 2011-09-07 at 8.52.18 PM.png
 
#4
Thank you, you are awesome :p

Too bad it doesn't clean the tags when there are multiple lines or images etc, we'll have to clean a lot of the messages and signatures (there are 20 000 members and 250k messages, good luck to us ^^)
 

Brogan

XenForo moderator
Staff member
#5
You could also try a simple replace using SQL, which may capture some of the others.

For example:
Code:
UPDATE xf_post SET message = REPLACE(message,'[size=x-small]','[SIZE=1]')
You won't be able to do that with the closing align tag though as it will vary depending on whether it is center, right or left.