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

A

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:

http://earthreborn.us/forum/
http://earthreborn.us/forum/
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?!
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
RobParker said:
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.
Click to expand...
Alright, Captcha is installed, I'm in PHPMyAdmin.... How do I run the query?
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Chris Deeming said:
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.
Click to expand...
No, but after I delete their posts they keep posting. They're bots, so I need to delete them all first.
 
Upvote 0 Downvote
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!
 
Upvote 0 Downvote
Basically everything is here:

http://xenforo.com/community/resources/dealing-with-forum-spam.980/

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

4) This person wanted to mass delete all users in the moderation queue, but there is no option to mass select the delete option on that page. I posted a template edit here to change the default selections:

http://xenforo.com/community/threads/how-to-mass-delete-users-awaiting-approval.35568/#post-404156

This is useful if you want to delete all users in the moderation queue and there are a lot of them.

5) Here is a query to mass ban all users who registered between two dates:

http://xenforo.com/community/thread...d-accounts-by-certain-date.35697/#post-405829
Click to expand...
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Aero_4D said:
Buy how can I simply delete ALL users from PHPMyAdmin?
Click to expand...

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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Brandon Sheley said:
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
Click to expand...

That works, but it leaves behind many joined records so it's not a very "clean" solution.
 
Upvote 0 Downvote
erich37 said:
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.
Click to expand...

They just about always target forums from search or direct lists

With Xrumer, see here:
http://ixrumer.com/general/36-xrumer-7528-elite.html
XenForo (footprint "Forum software by XenForo")
Click to expand...
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
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

Raven
  • Question Question
XF 1.2 Cleaning hundreds of spam posts?
Replies
2
Views
603
Raven
Raven
Back
Top Bottom