Clean posts after import

[Janm]

I transferred from phpbb3 to vBulletin and I have many posts with:

[ size=7 ]Bron: Wikipedia[ /size ]

etc. without spaces

They show up huge in vBulletin.

I would like to remove all those bbcodes. How must I do that?

Jan

[Jerry]

I'd replace the initial size tag using SQL with something like :



UPDATE post SET pagetext=REPLACE(pagetext,"[size=7]","[size=3]")


Or another size.

I suggest backing up your database before running any direct SQL against it.

[Janm]

What is the best way to make a backup? Does VB have an option? I'm not a phpmyadmin kinda a guy ;)

Can't I remove all size=* codes?

Jan