mass delete/banning
 

long story short, the forums lm helping out at have a major spam problem, now lve managed to curb it with the "Bot Blocker" (many thanks to originally commissioned it), however now l wish to get rid of all the junk accounts by banning them somehow or completely removing them.

is there a way or modification that will allow me to mass edit users based upon profile fields? for example 90% of the bot accounts seem to have "man" set in the biography field if l could moved all the users that have that set it would mean l could get rid of the bot accounts that are already there.

any ideas will be gratefully appreciated.

You could move the users to another usergroup using an SQL query like:

So if you want to delete them you could create a temporary usergroup, move them to that group using the above query, then use Move/Prune users to delete them.