PDA

View Full Version : Mass removal of bogus accounts


dekaybrown
11-10-2013, 05:15 PM
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.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 (https://vborg.vbsupport.ru/showthread.php?t=294633) 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
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/showthread.php?t=248042&page=206
Then do this
https://vborg.vbsupport.ru/showpost.php?p=2457233&postcount=3087
And install this as well
https://vborg.vbsupport.ru/showthread.php?t=294633

dekaybrown
11-10-2013, 09:12 PM
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
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

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


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
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

Max Taxable
11-12-2013, 03:27 PM
This is the best spam stopper I've tried, https://vborg.vbsupport.ru/showthread.php?t=289463I'm the one who paid to have that developed originally. I no longer recommend it.

interfx
12-21-2014, 08:00 PM
Run this query change the x to the group you want them moved to

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


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


Can you please describe how to do this? I have 2000 registrations with biography="man", and would like to delete them...

Thanks for a more detailed instruction on your second example...

Thanks -