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?