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

Lack of Interest [Suggestion] Spammy signature alerts

Discussion in 'Closed Suggestions' started by Stuart Wright, Aug 16, 2010.

  1. Stuart Wright

    Stuart Wright Well-Known Member

    We have a page on AVForums which runs this SQL:

    SELECT user.userid , user.username , posts,signature,count(usernote.userid) as notes
    FROM user,usertextfield LEFT JOIN usernote on usertextfield.userid=usernote.userid where user.userid=usertextfield.userid AND user.usergroupid=2 AND usertextfield.signature like '%www.%' AND (usertextfield.signature not like '%www.avforums.com%'
    AND usertextfield.signature not like '%www.flickr%'
    AND usertextfield.signature not like '%www.youtube%'
    AND usertextfield.signature not like '%www.invelos%'
    AND usertextfield.signature not like '%www.myspace%')
    AND membergroupids not like '%31%' GROUP BY user.userid ORDER BY userid DESC

    To show the signatures containing external links (with a few exceptions) and provide links through to see their posts, user notes and edit their profiles.
    This is a very handy tool because while some signatures are still valid (links to personal web pages etc.), those with spammy signatures are very obvious and can be dispensed with easily.

    A better system which alerted moderators would be a great bonus.

    Obviously spammers register with links in their signatures. Some post a few times and only then edit their signatures to add the links. They try to be crafty. Most are from India or China.

  2. KURTZ

    KURTZ Well-Known Member

    i think which the spammers trouble needs to be solved at the mountain not in the valley ... :) this is an interesting idea, but, personally, i think which we must stop the spammers at the registration, not after they are registered ...
  3. DaKat

    DaKat Well-Known Member

    I'm starting to see quite a few more of these myself and they are a pain.:(
  4. Stuart Wright

    Stuart Wright Well-Known Member

    Unfortunately I don't think this is always possible. In fact I think it is rarely possible.
  5. KURTZ

    KURTZ Well-Known Member

    check-out :)
  6. ManagerJosh

    ManagerJosh Well-Known Member

    Can i say OUCH? That query might kill larger boards.
  7. Dean

    Dean Well-Known Member


    Do you have rules for advertising things that may be of interest to your members such as where to buy products your forum is about? A store with a sale perhaps?

    If so, do you consider their sigs potential spam if there are links to their store?

    (This is a battle I am currently waging in.)
  8. DSF

    DSF Well-Known Member

    I say this day for day, again and again. It's possible. Proceed with intelligent. ;)
    KURTZ likes this.

Share This Page