I am busy with some experimental integration work, and currently I am trying to succesfully import the data from a old phpBB forum to oxwall forum. The users and forums are imported successfully, but I have a issue with the images in the posts. 

When, working in the database, opening the text column of a post in the phpbb database, images are posted like this:

[img:o4dl8gj4]http://jaymz.wen9.com/fsx/pics/blue1024.jpg[/img:o4dl8gj4]

However, in order to display correctly in oxwall, it should be converted to

<span><img style="padding:5px;" src="http://jaymz.wen9.com/fsx/pics/blue1024.jpg" />

Any idea how to write a SQL query to fix that?

Cheers

Jakes