vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Mass Delete Users (https://vborg.vbsupport.ru/showthread.php?t=131054)

Liquid1ce 11-08-2006 08:43 AM

Mass Delete Users
 
Looking for a way to mass delete users with date of birth XXXX-XX-XX

Having problems with my forum with spam bots registering with a date of birth all the same but i would like to be able to mass delete all accounts with the date of birth i enter, does anyone have a way to do this.

Inferno Dragon 11-09-2006 01:15 PM

I want the same option..I want to delete bots who register with a specific email "xxx@cashette.com" there are more then 60 users :( and deleting them one by one sux <_<

Liquid1ce 11-09-2006 07:57 PM

i have the spam its a bot date of birth 03-28-1985

ive fixed it so they get blocked but theres accounts still there so need to delete them

CodeRed 11-28-2006 01:43 AM

im also up for a mod like this... i have 200+ bot accounts id like to zap! hehee...

jluerken 11-28-2006 06:57 AM

Create a new group and call it TRASH.
Remember the groupID.

Move the bots to this group and run a db query to delete them.
This should work but I've not tested it.

Before doing such things ALWAYS BACKUP YOUR DB.

netwind 12-07-2006 01:41 PM

simple deleting from user not good. many tables has wasted associated records.
better way : create new group, update users primary group id (usergroupid),
by complex condition, then prune members of group from admincp.

SubstanceP 01-05-2007 06:11 PM

Quote:

Originally Posted by netwind (Post 1133852)
simple deleting from user not good. many tables has wasted associated records.
better way : create new group, update users primary group id (usergroupid),
by complex condition, then prune members of group from admincp.

From the sidebar in the Admin CP, if you scroll down to Users (beneath attachments but above usergroups), there is a option called Prune / Move Users.

If you click on that, the screen allows you to select all users with filtering by:
Usergroup
Has not logged on for x days
Join Date is Before
Posts is less than #

It then gives you a list of all the users and each name has a checkbox that is already checked off. You can uncheck names or leave them all checked and at the bottom of the list, it allows you to either move the checked users to a usergroup or delete them. Would this accompish what some of you need without messing the database up? It is what I did so I hope it wasn't a bad idea.

Another thing I did to make life easier is I installed Access Permissions Based on User's Post Count (https://vborg.vbsupport.ru/showthread.php?t=96523)

Then you do not let members post in any forum except for intros or whatever forum you want to designate as a starting point. Now the member called FreeOnlineMags can only spam that one folder as a first post and that makes policing and cleaning up easier. You pay attention to intros since they definitely have to post there first. If you see something there, you just need to use the post count to determine if it's more than one. if it is more than one, you can pull up that person's threads and delete them as well. I find it easier than paying attention to the whole forum. I implemented that last spring and now most of our spam members register and don't bother with actually posting the spam since it's too easy for us to zap it fast.


All times are GMT. The time now is 07:05 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01066 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete