Remove Signature from Profile

[dvduval]

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]

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:

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.