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

Remove Signature from Profile

Discussion in 'Troubleshooting and Problems' started by dvduval, Dec 19, 2012.

  1. dvduval

    dvduval Active Member

    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?
  2. borbole

    borbole Well-Known Member

    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.
    Luân Vũ likes this.

Share This Page