Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2013, 05:15 PM
dekaybrown's Avatar
dekaybrown dekaybrown is offline
 
Join Date: Mar 2009
Location: Upstate NY
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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...



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!
Reply With Quote
  #2  
Old 11-10-2013, 05:31 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 11-10-2013, 08:29 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

use mass prune option delete all users with 0 posts
Reply With Quote
Благодарность от:
Max Taxable
  #4  
Old 11-10-2013, 08:31 PM
dekaybrown's Avatar
dekaybrown dekaybrown is offline
 
Join Date: Mar 2009
Location: Upstate NY
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ForceHSS View Post
use mass prune option delete all users with 0 posts
That also kills all the real accounts set up by people who lurk.
Reply With Quote
  #5  
Old 11-10-2013, 08:40 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #6  
Old 11-10-2013, 09:12 PM
dekaybrown's Avatar
dekaybrown dekaybrown is offline
 
Join Date: Mar 2009
Location: Upstate NY
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Max Taxable View Post
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???
Reply With Quote
  #7  
Old 11-10-2013, 10:29 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dekaybrown View Post
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')
Reply With Quote
  #8  
Old 11-10-2013, 11:00 PM
dekaybrown's Avatar
dekaybrown dekaybrown is offline
 
Join Date: Mar 2009
Location: Upstate NY
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you very much...
Reply With Quote
Благодарность от:
Max Taxable
  #9  
Old 11-11-2013, 12:43 AM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dekaybrown View Post
Thank you very much...
Happy to help
Reply With Quote
  #10  
Old 11-12-2013, 03:20 PM
Spangle Spangle is offline
 
Join Date: Jun 2011
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thread Tools
Display Modes

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 04:35 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.09190 seconds
  • Memory Usage 2,259KB
  • 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
  • (2)bbcode_code
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (2)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete