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

How do you deal with profile spam links? I need a query to find it.

Dodgeboard

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

Jake Bunce

XenForo moderator
Staff member
#7
I would like to have an SQL query that will search and display all "about me" "homepage" and "occupation" fields for the value "http".
Code:
SELECT u.username, up.homepage, up.occupation, up.about
FROM xf_user AS u
LEFT JOIN xf_user_profile AS up ON (up.user_id = u.user_id)
WHERE up.homepage LIKE '%http%'
OR up.occupation LIKE '%http%'
OR up.about LIKE '%http%'
 
#10
I am looking for a way to just turn off the ability to add a link on there profile. We are on over load with this and I am not a programmer. so I do not understand what Jake is saying or to do what Dodge is talking about. I did purchase the stop spam here program and look forward to installing it as spam is getting out of control.
 

Jake Bunce

XenForo moderator
Staff member
#11
I am looking for a way to just turn off the ability to add a link on there profile. We are on over load with this and I am not a programmer. so I do not understand what Jake is saying or to do what Dodge is talking about. I did purchase the stop spam here program and look forward to installing it as spam is getting out of control.
This addon is supposed to do that:

http://xenforo.com/community/resources/splendidpoint-com-antispam-prevent-links-and-emails.106/

More info is here:

http://xenforo.com/community/resources/dealing-with-forum-spam.980/
 
#14
Thanks. I just need to learn how to upload add-ons. I did it via FTP and dropped it in the library folder but not seeing it in my admin. Looked and looked no youtubes on how to upload the files. I am green on programming.
wordpress no problem, anything else ugg