![]() |
|
Thread Tools |
#1
|
|||
|
|||
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.
No members have liked this post.
|
#2
|
||||
|
||||
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 * No members have liked this post.
|
#3
|
|||
|
|||
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. No members have liked this post.
Last edited by jeffmezick; 19 Jul 2007 at 22:47. Reason: Automerged Doublepost |
#4
|
||||
|
||||
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 No members have liked this post.
|
#5
|
|||
|
|||
are there any updates to this question? are newer versions of vb able to mass delete or ban users?
No members have liked this post.
|
#6
|
||||
|
||||
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:
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. No members have liked this post.
|
#7
|
||||
|
||||
Is there nothing else you need to do? Such as update other tables, like the PM one etc?
__________________
xlguy No members have liked this post.
|
![]() |
«
Previous Thread
|
Next Thread
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 00:12.