Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2006, 08:43 AM
Liquid1ce's Avatar
Liquid1ce Liquid1ce is offline
 
Join Date: Feb 2004
Location: /root
Posts: 196
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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.
Reply With Quote
  #2  
Old 11-09-2006, 01:15 PM
Inferno Dragon's Avatar
Inferno Dragon Inferno Dragon is offline
 
Join Date: Sep 2005
Location: United Kingdom
Posts: 153
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 <_<
Reply With Quote
  #3  
Old 11-09-2006, 07:57 PM
Liquid1ce's Avatar
Liquid1ce Liquid1ce is offline
 
Join Date: Feb 2004
Location: /root
Posts: 196
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 11-28-2006, 01:43 AM
CodeRed CodeRed is offline
 
Join Date: Aug 2005
Posts: 102
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im also up for a mod like this... i have 200+ bot accounts id like to zap! hehee...
Reply With Quote
  #5  
Old 11-28-2006, 06:57 AM
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Posts: 1,016
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 12-07-2006, 01:41 PM
netwind netwind is offline
 
Join Date: Feb 2005
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 01-05-2007, 06:11 PM
SubstanceP SubstanceP is offline
 
Join Date: Apr 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by netwind View Post
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.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 01:40 PM.


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.04695 seconds
  • Memory Usage 2,213KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete