Removing MyBB tags after importing database

[Moi EtOuir]

Hi,

I got a problem after importing a MyBB database to Xenforo
(I did Mybb -> Vbulletin -> Xenforo)

All the tags like this :
[align=center][/align]
[size=x-small][/SIZE]

Are not working, it's just showing the text
I can't find a way to remove all the tags from the messages, or change them to blank :/

I don't know regex/regular expressions, I didn't go that far in php
( http://xenforo.com/community/threads/post-content-find-replace.6548/ )

 

[Jake Bunce]

You can use Kier's addon to replace the old BB code with new BB code. For example, [align=center][/align] should be replaced with [center][/center].

 

[Jake Bunce]

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:



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

Quick Find:

[size​

Regular Expression:

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

Replacement String:

[size=1]\1[/size]​

Screenshot:

 

[Moi EtOuir]

Thank you, you are awesome

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 ^^)

 

[Paul B]

You could also try a simple replace using SQL, which may capture some of the others.

For example:

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.