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.
 
Top