Need a MOD to mass delete users with 0 posts

[Eric HRF]

Need a MOD to mass delete users with 0 posts to make my life easier!

TIA

Eric

[Seven Skins]

You dont need a MOD goto adminCP > users > prune/move users ... search and delete them.

.

[Eric HRF]

Thank You!

[LeHHeL]

Unfortunatelly if I have thousand of users (spammers) it will not delete, will say invalid action .... :-(

So I need to delete now manually, in a way ...

[snakes1100]

What group are they in?

[LeHHeL]

around 2000 (already deleted) was in Awaiting autorization, the rest are - Users Awaiting Email Confirmation.

--------------- Added 1256840162 at 1256840162 ---------------

Strange if I delete around 10-20 is OK, but if I delete all from the page (I think 100) then not delete.

--------------- Added 1256840274 at 1256840274 ---------------

Users Awaiting Email Confirmation 5,655 (of course all spam) - now I found how to stop, but this was there and I need to delete.

[James Birkett]

Hmm. SQL query?
DELETE * FROM user WHERE posts = 0

[LeHHeL]

Is this safe ?
I mean no other table are connected?

[snakes1100]

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.

[LeHHeL]

I have done that but I cannot move to that Spammers group. If I select 20 I can, if I select more I get error and not move.

[Lynne]

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.

[LeHHeL]

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.

[saimon69]

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?

Saimon69

[Vault_Dweller]

mabe this (https://vborg.vbsupport.ru/showthread.php?t=218210) is what you need?

[basskiller]

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.

this works perfectly and quite quick.. thanks