Ban or delete all users with one ip adress

[Zyon]

Hello all!

I need help as faster as can!

My forum was attacked by spambot, and in few hours they are created more than 90 accounts with 2 ip's.

I want to delete or ban them all so they wouldn't be displayed on memberlist. I haven't time to delete them all manually.

Please help anybody!

[Simon Lloyd]

Maybe something like:DELETE FROM " . TABLE_PREFIX . "user WHERE ipaddress=xxx.xxx.x.xxx

By the way, they could only set up so many accounts with just 2 ips because you have the registration settings set that way, change it and protect yourself!!!!!

[Zyon]

I will, I'm just created forum (again), and I'm just start to work with it when this happend.

So where to put that code?
I'm little stupid for php, I don't know it...

[Simon Lloyd]

You should be able to run it from admincp>mainatainance>execute Queries