How do you delete members in the masses?

[Biology Forums]

I have loads of members who have registered, but have never logged in. I tried to delete them 20 at a time in: index.php?action=viewmembers but it's taking too long. Is there a way to increase the number of members listed per page? Currently it is 20, I want it to be at least 100. How do I do that?

[Sir Osis of Liver]

Run this query in phpmyadmin -

Code Select Expand



DELETE FROM smf_members WHERE lastLogin = 0;



edit:  fixed it for 1.1.18

[Kindred]

Doing direct database deletes like that is a bad idea, because there are interconnected tables that need to be taken into account. Just deleting the member from the table will result in other stuff that will need to be cleaned up eventually.

[Colin]

What ever you do, backup before you execute any raw query.

[Biology Forums]

Thanks guys. Extra precaution is always taken with a large forum.

[Kindred]

even with extra precautions (like backing up), I still say that you should ***NOT*** be doing direct database deletes of users.
There are functions to properly handle the removal of members and associated data. Doing it directl in the database leaves a bunch of tangled cords hanging....

[Biology Forums]

even with extra precautions (like backing up), I still say that you should ***NOT*** be doing direct database deletes of users.
There are functions to properly handle the removal of members and associated data. Doing it directl in the database leaves a bunch of tangled cords hanging....

I agree, and for that reason alone, I'm doing it through the forum.

[Sir Osis of Liver]

Actually, if the users never logged in or posted, should do no harm to delete them (I've done it more than once).

[Arantor]

* Arantor will agree with Krash's last statement

Never logged in = no records anywhere else for them because they never logged in and thus never had chance to do anything.

[Sir Osis of Liver]

"Even a blind squirrel occasionally finds an acorn."

[Arantor]

You're better than that

[Biology Forums]

Okay, thanks all.