• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 vBulletin import - can I change YouTube BBcodes via SQL?

#1
Hi!

I've imported a fairly large (3.5m post) forum from vBulletin 4 to XenForo.

Everything seems to have gone alarmingly smoothly but I'm stuck on two points. One I'll deal with in another post, but for the YouTube embeds, I'm struggling with solutions offered elsewhere on this forum.

In imported messages, a YouTube embed looks like this:

Code:
[video=youtube;r_rbWytPvEs][MEDIA=youtube]r_rbWytPvEs[/MEDIA]
But it needs to look like this:

Code:
[media=youtube]http://www.youtube.com/watch?v=r_rbWytPvEs[/media]
I've tried the steps suggested here but I either get a blank screen or I'll click the button and the page will simply refresh, having not done anything.

Is there any way I can get this done with an SQL query or two? It's the YouTube ID in the opening code that's the tricky bit - is it possible to use some sort of wildcard?

Thanks in advance!