XF 2.2 Find and replace unlinked Imgur images and properly wrap in Bbcode?

[nodle]

Wanting to see if someone had a solution for broken Imgur links that have no associated [IMG] image link [/IMG] to the post? They are just raw pasted links that did not get transferred to the proper Become from an old import. I was hoping to use: Xenforo Find/Replace that could search for the beginning https or http://imgur.* and then wrap [IMG] [/IMG] so that they could display properly. Is there anyway to do this properly? Thanks!

 

[nodle]

Could you use something like?

UPDATE xf_post SET message = REPLACE(message,'https://i.imgur.com/*','[IMG]https://i.imgur.com/*[/IMG]');

Or am I way off?

 

[nodle]

I came across this:



Does anyone think something like this would work using the find/replace tool?

 

[nodle]

The post above doesn't work. Anyone else have an idea? @Brogan I see you know quite a few of these, do you have any idea?

 

[nodle]

@Chris D any ideas?

 

[beerForo]

Post here for help

Post Content Find / Replace

Chris D submitted a new resource: Post Content Find / Replace - Allows an administrator to do a regular expression find and replace in the content of all posts. This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource...

xenforo.com

 

[nodle]

In case anyone every reads this in the future, i figured it out by myself:

Quick Find: https://i.imgur.com

Regular Expression: /https:\/\/i\.imgur\.com\/(.*?)\.(jpg)/i

Replacement String: [img]https://i.imgur.com/\1jpg[/img]

Change the .jpg/.png/.gif accordingly in both spots.