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

XF 1.4 Old FONT-Tags after Import from VBulletin

Arno Nühm

Active member
#1
After Import from VBulletin to Xenforo we have a lot of old [ FONT ] Tags (without spaces) that are not rendered correctly.

I guess it's because of the comma inside, e.g.

Code:
[font=Verdana, Arial, Helvetica, sans-serif]
There are a lot of different FONT-Codes like that inside the xf_posts and I need to remove them all.

I would love to replace all font tags with at least one comma with the first font name and remove the rest.

Code:
[font=Verdana, Arial, Helvetica, sans-serif]
should be replaced to

Code:
[font=Verdana]
There must be any regular expression in mysql to do this?

Can anyone please help me?