XF 2.0 Find/Replace Video vBulletin Video Embeds

[invictus]

I migrated from VB4 and have since upgraded to XF2.

I probably should have made use of this addon before upgrading to XF2 to find/replace video embeds in posts while I was still on XF1, but I overlooked this.

What is the recommended way to accomplish this in XF2? SQL query in xf_posts?

My post contents have video embeds that look like this:

[video=youtube;dKlgCk3IGBg]https://www.youtube.com/watch?v=dKlgCk3IGBg[/video]

I need to update them to look like this:

[MEDIA=youtube]dKlgCk3IGBg[/MEDIA]

Any help appreciated. I'm not good with regex queries. Thanks!

 

[Chris D]

There are some newer versions/flavours of MySQL which might support regular expression updates but I'm not certain.

There are plans to update the post content find/replace tool to XF2 though we don't have an ETA for it right now.

 

[AndyB]

My post contents have video embeds that look like this:

About how many of these embeds do you have?

 

[invictus]

About how many of these embeds do you have?

Around 3600 I think.

 

[invictus]

There are some newer versions/flavours of MySQL which might support regular expression updates.

I'm pretty sure MariaDB 10.1 that I am using does support it, but I need help writing the query.

 

[Chris D]

Here, this will be easier

https://xenforo.com/community/resources/post-content-find-replace.5748/

 

[Anomandaris]

I've got this working with Xenforo 2 and Post content find / replace 2.0.1.
Warning: Don't use this if you don't know what you're doing, make a backup first, always do a test run first.

Quick find:

[video

Regular expression

/(\[video=youtube;)([a-zA-Z0-9_-]{6,11})(\]https:\/)((?:\/[\w\.\-]+)+)(\?v=)([a-zA-Z0-9_-]{6,11})(\[\/video])/

Replacement string

[media=youtube]\2[/media]