vb.org Archive - Replace BB Codes

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Replace BB Codes (https://vborg.vbsupport.ru/showthread.php?t=243870)

Danny M

06-03-2010 01:34 PM

Replace BB Codes

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:

Code:

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

06-03-2010 02:33 PM

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

06-03-2010 02:44 PM

Quote:

Originally Posted by Carnage- (Post 2047673)

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

06-05-2010 09:52 AM

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.

All times are GMT. The time now is 07:23 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01660 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: