XF 1.3 Question about cleaning up forum posts

[MITK]

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.

 

[Paul B]

You can do it one of two ways.

Using simple SQL queries if the content is identical.
Using this add-on for more complex content: http://xenforo.com/community/resources/post-content-find-replace.1549/

 

[MITK]

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.

 

[Paul B]

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.

 

[MITK]

Brogan,

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?

 

[Bionic Rooster]

Is there any update on a simple SQL queries to remove   from posts?

 

[Mike]

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.

 

[Bionic Rooster]

@Mike thanks bud