SQL queries to mass remove..........

[Adam H]

Profile messages, Spammers............lots of them have been posting their links all over visitor messages/profile messages and going through them one by one isnt an option.

is there a query which i can run to get rid of ALL profile posts by all members.

thanks in advance .

 

[Chris D]

Get rid of all profile posts by all members? Even legitimate ones?

If you insist...

First, remove all profile post comments:
TRUNCATE `xf_profile_post_comment`

Then, remove all profile posts:
TRUNCATE `xf_profile_post`

 

[Adam H]

Thanks Chris,

Yes its a newish forum so not many ( if any profile posts ).

 

[Jake Bunce]

You will also want to clear the statuses since they relate back to profile posts:

http://xenforo.com/community/threads/how-to-clear-all-user-statuses.30913/#post-353060