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

Remove Signature from Profile

dvduval

Active member
#1
So have a ton of profile spam, and just want to make it of no value by not showing the signature on the profile, or maybe not show profiles that have 0 posts. What can I do to solve this?
 

borbole

Well-known member
#2
So have a ton of profile spam, and just want to make it of no value by not showing the signature on the profile, or maybe not show profiles that have 0 posts. What can I do to solve this?
Run this query at the SQL box in the phpmyadmin:

Code:
UPDATE xf_user_profile
LEFT JOIN xf_user ON (xf_user.user_id = xf_user_profile.user_id)
SET signature = ''
WHERE xf_user.message_count = 0;
If you are using another prefix for your tables, replace xf_ with your custom prefix at the query above. Hope it helps.