XF 1.4 Replace old BBCode in Posts

[xoa]

Hello, I need to replace some old BBCodes in my forum.

This is what I have:

[iframe]www.mylinktoreplace.it/folder/page.html[/iframe]

And this is what I'd like to have:

[parsehtml]<iframe width=100% height=1200px frameborder=0 scrolling=yes src="http://www.mylinktoreplace.it/folder/page.html"></iframe>

So basically, I just have to search for

[iframe]

and replace with

[parsehtml]<iframe width=100% height=1200px frameborder=0 scrolling=yes src="http://

and search for

[/iframe]

and replace with

"></iframe>[/parsehtml]

Easy, but how to realize this?
Thank you

 

[Paul B]

If the strings are identical, you can do it in phpMyAdmin.

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

 

[xoa]

Wow, that was probably the fastest response I got in a forum. I tried this before already, but I was getting an error. Maybe I messed up with something. But this time it worked. Thank you a lot.

EDIT: Oh, I also noticed that I have to update all the links since I'm coming from IPB. I don't know how to do this or if this is possible:

The thread in Xenforo is this one:

http://forum.cemfactor.com/index.php?threads/svolte-di-popoli-info.1136/

But in another post, the link is still in "IPB style", like this:

http://forum.cemfactor.com/topic/1136-svolte-di-popoli-info/

I thinks this one is not that easy as the BBCode replacement

 

[Mike]

You would really want to handle that with the IPB redirects in the resources (which would handle external links as well).