Replace BB Codes

[Danny M]

Hey,

After I imported my phpBB forum software to VBulletin, all of my BB codes went 'funny' and added extra characters such as:

[center:2pho4l6i][/center:2pho4l6i]
[b:4dub7k7g][/b:4dub7k7g]


I have fixed most of these BB Codes now by entering the code below into phpmyadmin:

UPDATE post
SET
    pagetext = replace( pagetext, substring( pagetext, locate( '[center', pagetext ) , 16 ) , '[center' )
WHERE
    LOCATE( '[center', pagetext ) >0;

UPDATE post
SET
    pagetext = replace( pagetext, substring( pagetext, locate( '[/center', pagetext ) , 17 ) , '[/center' )
WHERE
    LOCATE( '[/center', pagetext ) >0;

But this only fixed the center BB codes in the forum posts. So users who had center tags in their signatures still have the horrible BB code around their signatures

Does anyone know how I can fix this?

Hope you understand, thanks