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'.)
Code:
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.