Dodgeboard
Well-known member
Hopefully Jake can chime in on this, as he seems to be the SQL query master.
We are seeing an increase in spam links in user fields on the users profile. I am wondering how others are dealing with the discovery and removal of these links.
I always check new registrations but the problem I am seeing is bot registrations that seem to return at a later date to add links in their signature, "about me" fields, with outbound links to viagra and charm bracelets etc.
I would like to have an SQL query that will search and display all "about me" "homepage" and "occupation" fields for the value "http".
What I would really like is an add-on that would limit any links in any of those fields based upon certain criteria (like 5 posts). This would help me to deal with profile spam links.
My mods use the spam cleaner, but it does not clean the users profile/fields.
Anyone else have any ideas? How are you dealing with spam links on rouge spammer profiles?
We are seeing an increase in spam links in user fields on the users profile. I am wondering how others are dealing with the discovery and removal of these links.
I always check new registrations but the problem I am seeing is bot registrations that seem to return at a later date to add links in their signature, "about me" fields, with outbound links to viagra and charm bracelets etc.
I would like to have an SQL query that will search and display all "about me" "homepage" and "occupation" fields for the value "http".
What I would really like is an add-on that would limit any links in any of those fields based upon certain criteria (like 5 posts). This would help me to deal with profile spam links.
My mods use the spam cleaner, but it does not clean the users profile/fields.
Anyone else have any ideas? How are you dealing with spam links on rouge spammer profiles?