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

Discussion in 'XenForo Questions and Support' started by Dodgeboard, Oct 11, 2012.

  1. Dodgeboard

    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?
     
  2. Digital Doctor

    Digital Doctor Well-Known Member

  3. Dodgeboard

    Dodgeboard Well-Known Member

  4. Digital Doctor

    Digital Doctor Well-Known Member

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

    Dodgeboard Well-Known Member

  6. lasertits

    lasertits Active Member

    Dodgeboard likes this.
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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%'
    
     
    Dodgeboard likes this.
  8. Dodgeboard

    Dodgeboard Well-Known Member

    Thanks Jake!
     
  9. Dodgeboard

    Dodgeboard Well-Known Member

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

    You may want to update your resource with this info.
     
  10. kortia

    kortia Member

    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.
     
  11. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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/
     
  12. kortia

    kortia Member

    Thank you! I assume I can use it while I am using stop spam here?
     
  13. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

    kortia Member

    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
     
  15. kortia

    kortia Member

    I dropped it in the library or should it be the library/xenforo/?
     
  16. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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

    Screen shot 2012-10-14 at 2.13.41 AM.png
     
    kortia and Dodgeboard like this.
  17. kortia

    kortia Member

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

    Dodgeboard Well-Known Member

    yes
     
  19. kortia

    kortia Member

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

    kortia Member

    YIPPI :)

    Thanks!
     

Share This Page