• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 Question about cleaning up forum posts

After my import from SMF to PHPBB3 to XF I have a lot of text on the forums like  

Wondering the best way to remove that on a larger scale? We have 100,000 posts so to go in each one and clear out the command would take forever.
The second option you listed, would it work if the content is different?

[ IMG ]url to image[ /IMG ]

So i would like to replace the img tags with what XF uses but keep the content in the middle the same.


XenForo moderator
Staff member
Well you could even use simple queries for that, just replacing the opening and closing tags.
Assuming there is no optional parameter in the opening tag.

It'a a matter of choice though - both approaches are valid.

It looks like the tool will not work with my   issue and i tried figure out how I can delete it via myphpadmin but I can't even find the 40,000 records of these. I seen on a few posts you are a mysql guy, do you know how i can correctly find and remove these from the forum?


XenForo developer
Staff member
You can do simply replacements with a query:
UPDATE xf_post SET message = REPLACE(message, 'old', 'new');
Change old and new as necessary. Always take a backup before running direct queries.