vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   How do I Mass Delete over 45k Inactive Users? (https://vborg.vbsupport.ru/showthread.php?t=306647)

K-fab 01-07-2014 12:50 AM

Quote:

Originally Posted by Zachery (Post 2472708)
Banning IP's is a waste of time, you should use better Q/A verification, and stop the problem completely.

I'm up to about 15 questions and still adding them.

I figure the IP ban can't hurt, right? Or is it really that much of a waste of time?

ozzy47 01-07-2014 12:54 AM

Banning the IP's is a waist of time, they can change them as needed.

ForceHSS 01-07-2014 01:08 AM

Quote:

Originally Posted by K-fab (Post 2472699)
New forum owner here (took over an existing site).

I just pruned out a bunch on v3.7.1. Did a search on users that haven't posted in "x" time, had less than 1 post, haven't been on the site for six months, etc.. It came up with 51K+ non-users (mainly spammers - they all need to be beaten about the shins with a stick).

It removes 999 at a time and I clicked 52 times. Pain, but works. Once I got the place clean, I've been staying on top of it.

I check my new registrations every morning while I sit and drink my coffee. Usually it's about 20 new users and of that only three or four will be legit.

I cross reference each IP address (google ip spam, then paste each IP addy in the search window) and if it comes up on the spam list, I delete that member and block the IP addy.
User CP
vBulletin Options
User Banning Options
There's a window in there to put IP addy's and it will block out those from coming to the site.

Seems to work pretty well and doesn't take long.

To make it go faster, I open each new registration in a new tab instead of clicking on that member and having to go through the search again and again.

I cut/paste the IP in the spam check and if it comes up on any sort of list, I just delete the user and add the IP to the block list. If it comes up legit, I approve the registration. Close each user tab after you decide to keep or delete.

install this

Max Taxable 01-07-2014 01:33 AM

Quote:

Originally Posted by K-fab (Post 2472717)
I'm up to about 15 questions and still adding them.

I figure the IP ban can't hurt, right? Or is it really that much of a waste of time?

Sure it can. Today's spammer IP might easily be tomorrow's legitimate user, in today's internet.

Banning IPs is so 20th Century, really.

K-fab 01-07-2014 01:37 AM

Then I guess I'll get the install listed above you done and go in and remove my banned IP addresses. I don't want to kill off legit members, just stop the junk.

rhondajean 02-13-2015 03:29 AM

jazmos, I've just done this. I'm using VB 5.1.5. Today I deleted 16,000 inactive members after sending them emails giving them the opportunity to make one post to be saved. Many did, most didn't, so today I chopped them. I did it in prune/move users. They're right above saying you can only delete 999 at a time, but I couldn't mass untick them all to select 999.

This worked: I went to the User Moving/Pruning System and deleted them by selecting a few months at a time. It took me about 30 minutes to do all of them but at least I didn't have to sit there clicking on 9999999 names. Good luck!

bzcomputers 02-13-2015 03:44 PM

To stop future issues you can also use:
https://vborg.vbsupport.ru/showthread.php?t=236117

You can set it to automatically prune "Users Awaiting Email Confirmation" after xx days.

I personally set it for 30 days. If they don't activate their account within 30 days of registering the account gets deleted automatically.


All times are GMT. The time now is 03:30 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.01040 seconds
  • Memory Usage 1,730KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete