mass delete/banning

[Auron]

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.

[kh99]

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

UPDATE user LEFT JOIN userfield ON (user.userid = userfield.userid)
   SET usergroupid = X WHERE field1 = 'man'

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.