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 14: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 19:04

The answer to both is No.

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

CAG CheechDogg

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

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

Drakie

25 May 2017 12: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 12: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 01:34

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

All times are GMT. The time now is 01:33.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, 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.