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

Hundreds of Spam Bots on Website!!! Help??

Discussion in 'XenForo Questions and Support' started by Aero_4D, Sep 23, 2012.

  1. Aero_4D

    Aero_4D New Member

    As you can obviously tell by my website that was bombed by bots, before we even started getting real people online:


    I have a small problem.... I need a way to delete ALL users, AND remove all the spam in the chat..... I have tried through XenForo, but it would literally take 100's of hours to delete them all one by one... Someone told me there is a way for me to delete them all instantly through cPanel. Can anyone help me!!

    PS> How can I also install CAPTCHA so that this doesn't happen again?!
  2. RobParker

    RobParker Well-Known Member

    You can run an SQL query from within phpmyadmin if you have access to that. I suspect Jake will be along to help with that.

    The captcha options are in the admin control panel. I found the Q&A option with some good questions to be the best way to do it.
  3. Aero_4D

    Aero_4D New Member

    Alright, Captcha is installed, I'm in PHPMyAdmin.... How do I run the query?
  4. Chris D

    Chris D XenForo Developer Staff Member

    Jake Bunce and borbole like this.
  5. Aero_4D

    Aero_4D New Member

    Buy how can I simply delete ALL users from PHPMyAdmin?
  6. Chris D

    Chris D XenForo Developer Staff Member

    Have the users posted?

    If they have posted you will want to remove their posts first using the queries in the guide by Jake.

    Banning or deleting a user does not remove their posts so you will want to tidy that up first.
  7. Aero_4D

    Aero_4D New Member

    No, but after I delete their posts they keep posting. They're bots, so I need to delete them all first.
  8. surfsup

    surfsup Well-Known Member

    Close the forum first
    Chris D likes this.
  9. Chris D

    Chris D XenForo Developer Staff Member

  10. erich37

    erich37 Well-Known Member

    I have also been attacked by spammers.
    Although I did not start my Forum yet, there are a couple thousand spam-posts on it now and about 200 spam-accounts. No "real" members have registered yet on my Forum.

    How do I mass-delete all members via ACP ?
    Do I have to do this "one-by-one" ?

    I do not see any option in ACP to check a box in order to select all members and delete ALL of those members via just one click?

    Is there any way to do this without going into the database?

    Additionally, I would like to mass-ban the IP-addresses of ALL members at my Forum.

    Appreciate your help!
  11. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Basically everything is here:


    There is currently no mass prune feature for users. But the above guide does link a couple of options for users:

  12. erich37

    erich37 Well-Known Member

    there are spammers who have literally hundreds of different IP-addresses per one single user-account.

    Does it make sense to "ban" and "discourage" all those IP-addresses? Since it seems those are not the real IP-addresses of the spammer since I understand the spammers are coming via a Proxy and using fake IP-addresses ?

    there needs to be a tool in ACP to mass "ban" and mass "discourage" IP-addresses when one member is using hundreds of different IP-addresses.
    *Nate* likes this.
  13. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  14. Brandon Sheley

    Brandon Sheley Well-Known Member

    I just had to do this last night and all I did was sort by highest userID, then check mark the users I wanted to drop.
    If they’ve made new threads or post, you’ll do the same on your post and thread table, luckily all the users and post on my site looked exactly the same so it was easy to spot the spam.

    Good luck
  15. erich37

    erich37 Well-Known Member

    so I need to "manually" delete all spam-users ?
  16. Corwin

    Corwin Member

  17. erich37

    erich37 Well-Known Member

    the interesting thing is this:

    at my XF-Forums which are "Branding Free", there is literally no spam at all!
    So it seems the spammers are targeting XenForo-powered Forums specifically.
  18. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That works, but it leaves behind many joined records so it's not a very "clean" solution.
  19. tenants

    tenants Well-Known Member

    They just about always target forums from search or direct lists

    With Xrumer, see here:
    Google search: "Forum software by XenForo"

    It use to be even easier to target forums when they use to show the version numbers in the footer (but it was eventually realised, the version number was also being used for security exploits, hence we rarely now see forums with forum versions exposed publicly)

    I went for the brand free version for this very reason, to hold off the spam attacks until I had designed something to prevent them
  20. Brandon Sheley

    Brandon Sheley Well-Known Member

    ya but I sure wasn't going to manually delete 1,000 users (mass moderation on xf isn't the best)
    I tried to remove all records that I could find.

Share This Page