vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=325132

Mass delete users if email contains ".top"?
by Drakie
24 May 2017 13:31

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 24 May 2017 18:04

The answer to both is No.

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

CAG CheechDogg 24 May 2017 21:41

Here you go ...

Quote:

Originally Posted by BirdOPrey5 (Post 2138329)
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:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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://www.vbulletin.org/forum/showthread.php?t=152746

Paul M 24 May 2017 22:30

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 24 May 2017 22:45

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

Drakie 25 May 2017 11:33

Quote:

Originally Posted by Paul M (Post 2586901)
The answer to both is No.

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

They're all spammers.

Paul M 25 May 2017 11:43

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 27 May 2017 00:34

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


All times are GMT. The time now is 20:41.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.