• 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

Stuart Wright

Well-known member
#1
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.

 

KURTZ

Well-known member
#2
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 ...
 

DaKat

Well-known member
#3
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.
I'm starting to see quite a few more of these myself and they are a pain.:(
 

Stuart Wright

Well-known member
#4
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 ...
Unfortunately I don't think this is always possible. In fact I think it is rarely possible.
 

ManagerJosh

Well-known member
#6
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.
Can i say OUCH? That query might kill larger boards.
 

Dean

Well-known member
#7
Stuart,

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