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

[Carnage]

look at the user text field table. The signatures are in there. You may also have to remove sigs from the sigparsed table

[Danny M]

Originally Posted by Carnage-

look at the user text field table. The signatures are in there. You may also have to remove sigs from the sigparsed table

I don't understand though, wouldn't the code I used above work for all of the tables?

And I didn't get what you meant when you said: "You may also have to remove sigs from the sigparsed table". Can you explain more please, or do you use some sortof IM?

Thanks

[Carnage]

With the query you did before, you only affected the post table. The user signatures are stored in a different table; the user text field table's signature coloumn - you can look at this table in phpmyadmin.

If you run the same queries you did on the post table on the user text field table, you will be able to fix them properly.

---

The sig parsed table contains signatures that have been pre parsed. Once you've corrected the sigs in the user text field table, you may need to delete the effected signatures from teh sigparsed table before you see an effect.