[Thunderbird8]

Originally Posted by Simon Lloyd

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 .