XF 2.1 Profile post spam

Morrus

Member
While importing from vB4, I've noticed a lot of profile post spam that had never been noticed on the old vB4 site. I only noticed it now because it pops up in a sidebar and on What's New? in the default Xenforo configuration. Pages and pages and pages of them.

I need to delete ALL profile posts. I started doing it manually, but there are thousands of the things across hundreds of pages, so I need an SQL query instead.

(Not sure what to do about the accounts themselves).

Anybody know what the SQL query would look like to simply delete al profile posts? (I'm assuming there's no function to do so -- I couldn't find one).
 
You can also disable prpofile post commenting, or at least disable showing the comments in the sidebar or what's new - that removes a lot of the incentive to post profile spam since no one else is likely to even see it.
 
Top Bottom