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

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