• 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..........

#1
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
#2
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`