XF 1.5 Search and replace ?

[click here]

What is the best way to replace all of my old VB3.8 youtube code in post's, like:

[YOUTUBE]blablabla[/YOUTUBE]
and replace with
[MEDIA=youtube]blablabla[/MEDIA]

I guess I would have to search for [YOUTUBE] and replace with [MEDIA=youtube] and then search for [/YOUTUBE] and replace with [/MEDIA]

Is there a way to do this in XF or do I need to do it some how in MYPHP?

Thanks!

 

[Chris D]

On the assumption that the "blablabla" is actually a YouTube video ID and not a full YouTube URL then it should be simple enough to do it directly in the database - after taking a backup of course. Do not attempt this until after you have taken a back up:

https://xenforo.com/community/threads/post-content-find-replace.6548/page-2#post-101164

 

[AndyB]

In addition to what Chris wrote, I suggest using this in phpMyAdmin, it's nicer to use the same case XenForo does.

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

 

[click here]

Thank's, that worked.