Print Page - deleting members who have never logged in

Title: deleting members who have never logged in
Post by: kateheaven on September 14, 2006, 11:48:36 PM

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.

Title: Re: deleting members who have never logged in
Post by: Nibbler on September 14, 2006, 11:57:34 PM

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

Code Select

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.

Title: Re: deleting members who have never logged in
Post by: kateheaven on September 20, 2006, 12:16:41 AM

thanks, that worked good for me :)

Title: Re: deleting members who have never logged in
Post by: tjiepie on March 01, 2009, 02:54:09 AM

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?

Title: Re: deleting members who have never logged in
Post by: Joachim Müller on March 01, 2009, 08:54:36 PM

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

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: kateheaven on September 14, 2006, 11:48:36 PM