deleting members who have never logged in

[kateheaven]

is there a way to mass delete members who have never logged in? i've tried doing it through the gallery usermgr.php (sorting members by last visit ascending) but this will still take ages because there are so many members.

[Nibbler]

You can do it via the database if you are comfortable with phpmyadmin

Code Select Expand

DELETE FROM cpg_users WHERE user_lastvisit = '0000-00-00 00:00:00'

Change cpg_ to the prefix you chose during installation and backup your users table before you run the query.

[kateheaven]

thanks, that worked good for me

[tjiepie]

Members must on the gallery activation his account by mail.
if the account no activate after 7 days can you delete these?

Example:
Members make a account
If the member after 7 days no activation his account, delete the account auto?

[Joachim Müller]

There's no auto-delete feature built into coppermine. If you need such a feature, you'll have to code it.