XF 2.2 Removing old BB code from posts.

[Heraldic Age]

Let's say I want to remove the following legacy BBcode:

[video=youtube]

Then I run:

UPDATE xf_post SET message = REPLACE(message, '[video=youtube][/video]', '[MEDIA=youtube][/MEDIA]');

Is this correct? Just checking here before I bottle it and have to restore a backup. For example, the Xenforo Youtube embed code is:

[MEDIA=youtube][/MEDIA]

So, I don't want to remove the

=youtube]

part that matches on accident.

Post content find/replace doesn't work due to large forum size.

 

[Paul B]

Assuming the video ID is between the existing tags like this -- [video=youtube]MurHt7Sxhyk[/video], you need to run two separate queries.

UPDATE xf_post SET message = REPLACE(message, '[video=youtube]', '[MEDIA=youtube]');

UPDATE xf_post SET message = REPLACE(message, '[/video]', '[/MEDIA]');

Take a backup of the xf_post table first, just in case.

 

[Heraldic Age]

Assuming the video ID is between the existing tags like this -- [video=youtube]MurHt7Sxhyk[/video], you need to run two separate queries.

UPDATE xf_post SET message = REPLACE(message, '[video=youtube]', '[MEDIA=youtube]');

UPDATE xf_post SET message = REPLACE(message, '[/video]', '[/MEDIA]');

Take a backup of the xf_post table first, just in case.

Thanks!