Ban all users that registered / logged in with a certain IP

[StonePilot]

I have noticed that some of the spammers that have hit me have done so with only a few IP addresses.

One spammer setup over 200 user accounts with the same IP address.

It would be very nice if I had a tool to BAN all of the user accounts that were created with a certain IP address (like add a BAN all button in the AdminCP > Users > IP Lookup page).

Anyone else have this problem? This might take me hours to get all of them gone.

[Sam-TheMaster]

Any update on this situation? I am having same situation with a very big range of registered users with few ip and now I have blocked but still old user accounts made by those ip come over my board and create post overnight and those figures are far higher than normal users post. I am getting more than 2000-3000 postings with buggy zen cart shopping post and I have to delete that mess everyday with tool like Spam-o-matic - even after report to akismet data and stopformspam database, no satisfactory result.

Can any one throw light on this?

[nhawk]

No need to ban the actual users.

Go to AdminCP->Options->User Banning Options.

Make sure Enable Banning Options is set to 'Yes' and enter the IP addresses in the box provided.

Just be sure to ban the user if they post spam again with a different IP.

EDIT: Use this sparingly. If you get to agressive with this you can ban millions of users.

[Sam-TheMaster]

the trouble is. those user names registered with specific ip is bugging me more and more. i am getting those user id spaming again with different ip and they are continous spaming with few seconds interval and I am really need to ban them so they can't bug my site anymore.

[kh99]

You could do this:

- create a new user group (maybe copy Banned so they have no permissions).
- execute this SQL (obviously, you'll want to replace X with the id of the group you created, and 1.2.3.4 with the actual ip address. Also, if you have a table prefix you'll need to add it to the beginning of 'user'.)

UPDATE user SET usergroupid=X WHERE ipaddress='1.2.3.4'

- Now you can use "Prune/Move Users" to do what you want with users in usergroup X.

BTW although it's pretty simple, you still may want to have a backup of your db before trying this.