Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Jul 2007, 14:15
jeffmezick jeffmezick is offline
 
Join Date: Jun 2007
Mass delete or ban users bases on email address

I have tons of spammers and bots signed up using mail.ru addresses and some others. Is there a way to search for and then mass delete or ban all users who have registered with a mail.ru email address. I would prefer to ban them, rather than just delete them.
Reply With Quote
  #2  
Old 19 Jul 2007, 14:18
G0F0RBR0KE's Avatar
G0F0RBR0KE G0F0RBR0KE is offline
 
Join Date: Mar 2005
Real name: James
There is no mass nor mass delete. Are all those bot using close to same IP?

If so, read the vBoptions on how to ban those IP using the asterisk *
__________________
http://youtube.com/xgoforbrokex
Reply With Quote
  #3  
Old 19 Jul 2007, 14:38
jeffmezick jeffmezick is offline
 
Join Date: Jun 2007
Thank you EvilAkuma. Unfortunately, they are going through a proxy or something so they all have a different IP.

Is deleting them as simple as logging in to mysql and doing something like this:
>>delete from user where email like '%mailru%';

Or to ban them all could I:
>> update user set usergroupid = '20' set usertitle = 'Banned' where email like '%mail.ru%'

Does anyone know if anything other than the users table holds info on the users and if changing this would be a solution?

I've searched through most of the tables and it looks like the user table is the only one I need to change. Does anyone else have any information on this at all? It would be nice to hear another opinion before I do it.

Last edited by jeffmezick; 19 Jul 2007 at 22:47. Reason: Automerged Doublepost
Reply With Quote
  #4  
Old 28 Sep 2007, 06:40
GrendelKhan{TSU's Avatar
GrendelKhan{TSU GrendelKhan{TSU is offline
 
Join Date: Jun 2005
would love to know this as well. have the same problem.
__________________
Unreal Addicts: The Ultimate UT Fraggin Fix
Unreal Tournament Sniper Clan and UT Gaming Community.
Serving frags and fun to the UT Community Since 1999
www.UnrealAddicts.com
Reply With Quote
  #5  
Old 23 Dec 2010, 12:52
ip3 ip3 is offline
 
Join Date: Jul 2010
are there any updates to this question? are newer versions of vb able to mass delete or ban users?
Reply With Quote
  #6  
Old 23 Dec 2010, 22:41
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #7  
Old 28 Jan 2011, 01:21
xlguy's Avatar
xlguy xlguy is offline
 
Join Date: Feb 2004
Is there nothing else you need to do? Such as update other tables, like the PM one etc?
__________________
xlguy
Reply With Quote
Reply



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 20:05.

Layout Options | Width: Wide Color: