SQL commands for deleting users

[loki66]

Can someone tell me the magic sql command to delete users:
- who never signed up (last active=never)
- who never posted (posts=o)

I have too many to do it 50 by 50

Thanks,

[Steve]

Admin -> Forum Maintenance -> Members ... use the dropdown to select each option and type in the number of days. You can get rid of all users who haven't activated their accounts and all users who haven't logged in over a large number of days.

[shadav]

adding on to what steve said there are 2 mods that will do this automatically (well for inactivity not for posting)

Delete Unactivated Members
removes members after x days that registered but never activated accounts

email Inactive Users
removes members that haven't logged in after x days

and then there's this mod
Enhancements to purge inactive members
which is another good one to have

[Kindred]

Just a note... please do not try to delete users directly in the database. There are tasks that need to be run and associated tables to be cleaned up when a user us deleted.

[loki66]

Thanks, I tried the third mod but with no results ... No users were deleted ... I am wondering if it works with a large number of days = 6000