Mass delete users if email contains ".top"?

[Drakie]

I have a lot of spam users registered with emails ending with the TLD ".top".
I would like to delete all these users. Is there a way to mass delete them?

Maybe through PHPMyAdmin or is there a mod for this?

[Paul M]

The answer to both is No.

For what reason in particular do you want to mass delete them ?

[CAG CheechDogg]

Here you go ...

Originally Posted by BirdOPrey5

There is no built in function to mass delete users by email address in any version of vbulletin...

the database queries mentioned in the 3rd post will work just fine...

In phpmyadmin go to your database and run the query:

delete from user where email like "'%mailru%"

will delete every user with "mailru" in the email address.

But manually running queries can be dangerous!!! 1 little typo and you might end up deleting everyone so before you ever think about doing this make sure you have a backup of your database.

Got this from this thread ....

https://vborg.vbsupport.ru/showthread.php?t=152746

[Paul M]

Do not do that, its very bad advice.

There is a LOT more to deleting users than just the user table.

(The post is almost 7 years old btw).

[CAG CheechDogg]

If they are just spam users who probably don't have any posts then this should be fine ... correct?

[Drakie]

Originally Posted by Paul M

The answer to both is No.

For what reason in particular do you want to mass delete them ?

They're all spammers.

[Paul M]

Yes, I know that, you mentioned it in the first post.

But why do you want to delete them, as opposed to just ignoring them, what issue are they causing you ?

[ForceHSS]

use the User Moving/Pruning System and move them all to the banned group