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

[Dodgeboard]

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?

 

[Digital Doctor]

Have you tried either of these ?
http://xenforo.com/community/resources/splendidpoint-com-antispam-prevent-links-and-emails.106/
http://xenforo.com/community/resources/sonnb-stop-spam-here.1086/

 

[Dodgeboard]

Have you tried either of these ?
http://xenforo.com/community/resources/splendidpoint-com-antispam-prevent-links-and-emails.106/
http://xenforo.com/community/resources/sonnb-stop-spam-here.1086/

No, but it doesn't look like either of those deal with user fields like "about me". Still, I need a way to find the pre-existing ones.

Thx DD!

 

[Digital Doctor]

sonnb-stop spam here is pretty good. Ask your question in that thread.

 

[Dodgeboard]

After reading, looks like someone already asked my question. And NO, it does not deal with spam links in the "about" user fields.

 

[lasertits]

Have you tried XenUtilities addon?

• Account Spam Finder based on URLs in homepages, signatures and profiles
• Profile Spam Finder based on URLs in messages and message comments

http://xenforo.com/community/resources/8wayrun-com-xenutiles-tools.104/

 

[Jake Bunce]

I would like to have an SQL query that will search and display all "about me" "homepage" and "occupation" fields for the value "http".

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%'

 

[Dodgeboard]

Thanks Jake!

 

[Dodgeboard]

Awesome! Worked perfectly. Exactly what I was looking for!!

You may want to update your resource with this info.

 

[kortia]

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]

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/

 

[kortia]

Thank you! I assume I can use it while I am using stop spam here?

 

[Jake Bunce]

Thank you! I assume I can use it while I am using stop spam here?

I haven't tested that. I am not aware of any compatibility issues between the two.

 

[kortia]

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

 

[kortia]

I dropped it in the library or should it be the library/xenforo/?

 

[Jake Bunce]

I dropped it in the library or should it be the library/xenforo/?

The AntiSPAM folder goes into library, thereby creating library/AntiSPAM on your server.

Then install the XML:

Admin CP -> Home -> Install Add-on

You can type in the path on the server:

./library/AntiSPAM/addon-AntiSPAM.xml

 

[kortia]

Thank you. This is after I drop via FTP into the correct folder?

 

[Dodgeboard]

Thank you. This is after I drop via FTP into the correct folder?

yes

 

[kortia]

I was putting it in the wrong library folder in the www file, not the public folder. now says rebuilding cache and installed

 

[kortia]

YIPPI

Thanks!