Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 24 May 2017, 13:31
Drakie Drakie is offline
 
Join Date: Feb 2011
Question Mass delete users if email contains ".top"?

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?
Reply With Quote
  #2  
Old 24 May 2017, 18:04
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
The answer to both is No.

For what reason in particular do you want to mass delete them ?
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #3  
Old 24 May 2017, 21:41
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Here you go ...

Originally Posted by BirdOPrey5 View Post
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
Reply With Quote
  #4  
Old 24 May 2017, 22:30
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: 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).
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 24 May 2017, 22:45
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
If they are just spam users who probably don't have any posts then this should be fine ... correct?
Reply With Quote
  #6  
Old 25 May 2017, 11:33
Drakie Drakie is offline
 
Join Date: Feb 2011
Originally Posted by Paul M View Post
The answer to both is No.

For what reason in particular do you want to mass delete them ?
They're all spammers.
Reply With Quote
  #7  
Old 25 May 2017, 11:43
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: 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 ?
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #8  
Old 27 May 2017, 00:34
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
use the User Moving/Pruning System and move them all to the banned group
Reply With Quote
Reply


Tags
massdelete, spam


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:29.

Layout Options | Width: Wide Color: