Removing vBulletin bbcodes after importing database

[asterix23]

Hi

Just switch from vBulletin, I have now a lot of tags like this
[youtube=425,350]string[/youtube]
[YOUTUBE=string]string[/youtube]

How to replace this with

[media=youtube]\1[/media]

?

I did a try with Post Content Find / Replace, but did not work for me.

 

[Jake Bunce]

Use Kier's addon:

http://xenforo.com/community/threads/post-content-find-replace.6548/

Quick Find: [youtube

Regular Expression: #\[youtube=([^\]]+)\]([^\[]+)\[/youtube\]#siU

Replacement String: [media=youtube]\2[/media]

I assume the middle string is the video id, but I can't be sure about this replacement unless you give me an actual code example.

 

[asterix23]

I get this error
Please enter a message with no more than 5 pieces of media

 

[Jake Bunce]

I get this error
Please enter a message with no more than 5 pieces of media

You will need to increase this and try again:

Admin CP -> Home -> Options -> Messages -> Maximum Media Embeds per Message

 

[asterix23]

thanks work great

 

[StonePilot]

I've got a different set of code to change, I don't understand how it works, anyone help>?

[video=youtube;vPW6k3GWeUs]http://www.youtube.com/watch?v=vPW6k3GWeUs[/video]

 

[StonePilot]

Anyone?

 

[Jake Bunce]

@StonePilot

http://xenforo.com/community/threads/video-code-after-import.24280/#post-297772

 

[Superfluous]

Anyone have any idea what I'm doing wrong? I'm getting a "Please enter a valid message." error when trying to replace Youtube videos as advised in the description. I'm assuming it's trying to insert a blank message somewhere, but I don't know why I'd be replacing the video with a blank message.

 

[Jake Bunce]

Anyone have any idea what I'm doing wrong? I'm getting a "Please enter a valid message." error when trying to replace Youtube videos as advised in the description. I'm assuming it's trying to insert a blank message somewhere, but I don't know why I'd be replacing the video with a blank message.

That error usually indicates an empty post, but that shouldn't happen with your replacement.

Try submitting that replacement without "Save Changes" to preview what the result is.

 

[Superfluous]

That error usually indicates an empty post, but that shouldn't happen with your replacement.

Try submitting that replacement without "Save Changes" to preview what the result is.

Yeah it works fine without save changes - gives me 19,000+ results - and I've painfully waded down them to see if there were any empty ones, and there's none that I can see. I tried staggering the calls with your script modification with no luck as well.

 

[Superfluous]

That error usually indicates an empty post, but that shouldn't happen with your replacement.

Try submitting that replacement without "Save Changes" to preview what the result is.

Sorry to be a torture Jake, but do you have to hand the 'direct to database' SQL queries/regular expressions to do the same thing? (I'll do a trial run on a test site - at least it will return specific errors) I'm sure I seen you post them somewhere here before but I can't find them now. I've got a newly converted 7 million post forum with 20k of unparsed Youtube videos, and since the natives didn't want 'change' in the first place I need to placate them with fixes

 

[Jake Bunce]

MySQL has no regex replace to my knowledge. It requires a user defined function.

...7 million post...

That replacement tool doesn't handle large numbers of posts very well. This might help:

https://xenforo.com/community/threads/import-from-ipb-3-2-posts-not-parsed-at-all.39577/#post-435226

Otherwise I wrote a custom script to do replacements on extremely large forums. But using it safely and effectively requires working with the code. I can use this script on your forum but I would insist on running it myself. If you want me to do this then send me a PM with FTP access and links to posts that need fixing.

 

[balkanminion]

How i can fix it when i Imported my Forum from WBB 4.1?

My old YT Videos looks now like this > The Beatles - I Feel Fine - YouTube

 

[Jake Bunce]

How i can fix it when i Imported my Forum from WBB 4.1?

My old YT Videos looks now like this > The Beatles - I Feel Fine - YouTube

Can you post the raw unparsed code in the post? Use the [plain][/plain] tag here on this forum to post unparsed BB code.

 

[balkanminion]

[media]http://youtu.be/MOWDb2TBYDg[/media]

 

[Jake Bunce]

[media]http://youtu.be/MOWDb2TBYDg[/media]

Use Kier's addon:

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

Quick Find: [media]

Regular Expression: #\[media\]http://youtu\.be/([A-Za-z0-9_\-]+)\[/media\]#siU

Replacement String: [media=youtube]\1[/media]

This works on my test forum.

Youtube URLs come in a few varieties so if you find different URL formats you will need to adjust the Regular Expression accordingly.

 

[balkanminion]

I found 291 , but not all > http://balkanonline.net/threads/please-dont-stop-the-music.14/

 

[Jake Bunce]

I found 291 , but not all > http://balkanonline.net/threads/please-dont-stop-the-music.14/

Yep, that one is slightly different:

Quick Find: [media]

Regular Expression: #\[media\]https://www\.youtube\.com/watch\?v=([A-Za-z0-9_\-]+)\[/media\]#siU

Replacement String: [media=youtube]\1[/media]

 

[balkanminion]

Thanks it works, but i am getting an PHP Timeout Error.