• 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

#1
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.
 
#3
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.
 

Brogan

XenForo moderator
Staff member
#4
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.
 
#5
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?
 

Mike

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