Do NOT do the query above!!! User information is in a few different tables.
LeHHeL, what error are you getting? When you go to the page to delete the users, enter "1" for Posts i less than, and then try deleting them by groups. Use the Has not logged on for x days option and put in a large number to get a small group of users, and then keep decreasing the number of days until you get all the users you want.
I do like this and working (even will take some time)
I start to look for 365 days and come back with 10 minus, like 355, 345 etc and if users is not pass over the result 200 (tested now carefully) then can delete. All what is over 200, cannot delete.
Alternatively, a mysql query should be possible in changing the main usergroup of the spammers to one that you destined for them and then do the prune from the admincp, is it feasible?
Do not delete manually as James stated, as that wouldn't remove all info.
Create a new usergroup called spammers, move all the users awaiting into that group, then mass delete thru that group, i believe user awaiting falls into the protected groups when using that tool.
10-29-2009, 08:31 PM
Linear Mode
