vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Mass removal of bogus accounts (https://vborg.vbsupport.ru/showthread.php?t=304382)

dekaybrown 11-10-2013 05:15 PM

Mass removal of bogus accounts
 
I attempted to contact VBulletin, but since they are selling 5 now, they closed the 4 forum.

A feature that would be immensely beneficial would be the ability to mass prune bogus accounts based on various fields in the registration.

For instance, mass prune all accounts with the words (example) "Ugg Boots" in the home page field, or all accounts with the word "man" in the biography box.

With the onslaught of spam these days, the spammers are getting clever, floating IP addresses, cracking human verification, etc.. it is becoming more and more challenging each day keeping these wolves at bay.

Honestly, my wrist is starting to hurt from all of the mouse clicks needed to get these crappy accounts off my forums. in this example alone, it takes almost 800 mouse clicks to delete these users...

https://vborg.vbsupport.ru/external/2013/11/2.gif

Imagine (I gave up) how much work I face trying to remove all of the 2642 bogus users with"man" as the biography. (nearly 8000 mouse clicks)

and these are the ones spam o matic miss!

Max Taxable 11-10-2013 05:31 PM

Mass move them all into a new usergroup, then mass delete from there.
Quote:

With the onslaught of spam these days, the spammers are getting clever, floating IP addresses, cracking human verification, etc.. it is becoming more and more challenging each day keeping these wolves at bay.
Install THIS MOD to end all the bogus bot registrations.

ForceHSS 11-10-2013 08:29 PM

use mass prune option delete all users with 0 posts

dekaybrown 11-10-2013 08:31 PM

Quote:

Originally Posted by ForceHSS (Post 2459805)
use mass prune option delete all users with 0 posts

That also kills all the real accounts set up by people who lurk.

ForceHSS 11-10-2013 08:40 PM

Then see what the spammers have in common and use that

Install this
https://vborg.vbsupport.ru/showthrea...48042&page=206
Then do this
https://vborg.vbsupport.ru/showpost....postcount=3087
And install this as well
https://vborg.vbsupport.ru/showthread.php?t=294633

dekaybrown 11-10-2013 09:12 PM

Quote:

Originally Posted by Max Taxable (Post 2459750)
Mass move them all into a new usergroup, then mass delete from there..

I just went over my usergroup manager, and I cannot find anything that allows me to mass move people to a new group based on profile entries???

ForceHSS 11-10-2013 10:29 PM

Quote:

Originally Posted by dekaybrown (Post 2459815)
I just went over my usergroup manager, and I cannot find anything that allows me to mass move people to a new group based on profile entries???

Run this query change the x to the group you want them moved to
Code:

UPDATE `user` SET `usergroupid`='x', `homepage`='Ugg Boots' WHERE (`posts`='0')
Code:

UPDATE `userfield` SET `field1`='' WHERE (`field1`='man')

dekaybrown 11-10-2013 11:00 PM

Thank you very much...

ForceHSS 11-11-2013 12:43 AM

Quote:

Originally Posted by dekaybrown (Post 2459830)
Thank you very much...

Happy to help

Spangle 11-12-2013 03:20 PM

This is the best spam stopper I've tried, https://vborg.vbsupport.ru/showthread.php?t=289463


All times are GMT. The time now is 07:18 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.01124 seconds
  • Memory Usage 1,738KB
  • 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
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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