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

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

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

XenForo developer
Staff member
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`