SMF to XenForo Import

[Skylined]

Some posts (and I guess conversations) contain hotlinked images, some of them are showing fine and others don't because the img bb code specifies the image's width and height.
I don't really know if this is because of SMF or a mod that I have installed.

Is there any way to run a SQL query to get rid of the whole width and height part?
Have in mind that the numbers (720 and 431) change depending on the size of the original image, and that it might have more or less digits, so I guess that some kind of wildcard should be used.


Now

[img width=720 height=431]http://ilinktoimage.jpg[/img]

How it should look like

[img]http://ilinktoimage.jpg[/img]

 

[Paul B]

@Skylined, I have split your post off and moved it to the appropriate support forum.

This add-on will help with that: http://xenforo.com/community/resources/post-content-find-replace.1549/

 

[Jake Bunce]

With that addon, use the following settings:

Quick Find: [img width

Regular Expression: #\[img width=[0-9]+ height=[0-9]+\]([^\[]+)\[/img\]#siU

Replacement String: [img]\1[/img]

That should do it.

 

[Skylined]

Thanks @Brogan and @Jake Bunce!

Worked like a charm!

 

[Skylined]

Found one more.

[img alt=Album name. 29.12.2013 - 52 KM height=174 width=234]http://linktoimage.jpg[/img]

 

[Jake Bunce]

Found one more.

[img alt=Album name. 29.12.2013 - 52 KM height=174 width=234]http://linktoimage.jpg[/img]

Quick Find: [img alt

Regular Expression: #\[img alt=.+ height=[0-9]+ width=[0-9]+\]([^\[]+)\[/img\]#siU

Replacement String: [img]\1[/img]

 

[dknife]

Ah these will come in handy, thanks! One other I noticed when I did my test migration was [iurl] since that won't be understood.

[iurl=http://www.somewebsite.com/forums/index.php?topic=100.0]

That search/replace will be very helpful.