Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Oct 2011, 00:37
Mulet Mulet is offline
 
Join Date: Oct 2011
Imported PHPBB3 boards, discovered hoard of spam accounts. Easy fast removal process?

Hey,

I've setup vBulletin, updated to 4.17 and discovered I have thousands of false accounts imported. Is there a plugion or method to search all users, and remove spammers?

Also, I have almost two thousand accounts prefixed with:

imported_

How can I bulk merge these?

Any help is appreciated
Reply With Quote
  #2  
Old 23 Oct 2011, 01:01
lild100 lild100 is offline
 
Join Date: Oct 2010
Im looking forward to the response to this. I have the same problem
Reply With Quote
  #3  
Old 23 Oct 2011, 01:15
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
Make sure you have a database backup before running this as i'm no database guru, in phpmyadmin run this:
delete from user where username='imported_%';

You will have to add the prefix if you use one in the tables like vb_user and vb_username, the % is a wildcard so it's looking to delete anything in the username column that has imported_ at the beginning of the name.

Hope it helps.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #4  
Old 23 Oct 2011, 01:20
Mulet Mulet is offline
 
Join Date: Oct 2011
Will that delete the imported_<NAME> accounts?

I'd like to merge them, as it is the imported_ accounts that have post data
Reply With Quote
  #5  
Old 23 Oct 2011, 01:37
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
it WILL delete them, like i said i'm no guru but i guess what you'll want is to delete the imported_ from every username then use an UPDATE query for the table to merge the usernames.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #6  
Old 23 Oct 2011, 01:43
Mulet Mulet is offline
 
Join Date: Oct 2011
OK, that seems reasonable, I spose I look something up.

Also, is there a method to bulk remove spam accounts? I have vbStopForumSpam, and was wondering if there is a "serach and kill" ability in either this or another product?
Reply With Quote
  #7  
Old 23 Oct 2011, 02:57
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
Unfortunately not, you would need to know the usergroup or email address or username, it's fair to say that you could use vbulletins built in prune users to prune say all accounts older than x days with zero posts.

I'll see what i can find on the UPDATE USER query

--------------- Added 23 Oct 2011 at 03:26 ---------------

Did you use Impex to import your database to vbulletin?, if not and you still have the database it might be wise to go back to the backup you made before adding all your new data and then use impex to import them.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #8  
Old 25 Oct 2011, 16:33
Mulet Mulet is offline
 
Join Date: Oct 2011
Hey Simon,

I ended up deleting the boards and starting from scratch with fresh boards, and a fresh import. No more merging of users, no need for sql. Thankyou for your help though.

I'll play around with the prune feature to try to ditch this hoard of false accounts.

However, do these accounts actually pose a threat? They came from bots plaguing a phpbb3 board, and the new boards are on a subdomain. Can they wake up and cause havok?

I'll remove them, but I'd rather not delay going online by another day while I remove the filthy filthy accounts.
Reply With Quote
  #9  
Old 15 Nov 2011, 10:10
Thunderbird8 Thunderbird8 is offline
 
Join Date: Aug 2009
Originally Posted by Simon Lloyd View Post
Make sure you have a database backup before running this as i'm no database guru, in phpmyadmin run this:
delete from user where username='imported_%';

You will have to add the prefix if you use one in the tables like vb_user and vb_username, the % is a wildcard so it's looking to delete anything in the username column that has imported_ at the beginning of the name.

Hope it helps.
I don't recommend doing this, since it would leave other issues on the board (I once accidentally emptied the forum users table...the weirdness that caused is hard to describe). The vB user prune function would probably clean up any loose ends from said accounts.

Originally Posted by Mulet
However, do these accounts actually pose a threat? They came from bots plaguing a phpbb3 board, and the new boards are on a subdomain. Can they wake up and cause havok?
Possibly, but the bots would need to reset their passwords first, just like the users would need to. Who knows if they're intelligent enough to do so .
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 02:50.

Layout Options | Width: Wide Color: