coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: bryan on December 03, 2003, 02:04:24 AM

Title: Is there a way to delete all inactive users at once?
Post by: bryan on December 03, 2003, 02:04:24 AM
Is there a way to delete all inactive users at once?
Title: Is there a way to delete all inactive users at once?
Post by: Joachim Müller on December 03, 2003, 08:09:10 AM
out-of-the box: no!
This is a hack that should be easy tho accomplish though, but what do you define as inactivity?
You'll have to disable the "remember me" option on login, so the user won't be recognized on every visit and is forced to log on each time, just to keep your activity log up to date (if you define activity by "visits to your gallery"). It'l become trickier if you define activity by participation via rating/comments/uploads...

GauGau
Title: Is there a way to delete all inactive users at once?
Post by: Oasis on December 03, 2003, 08:17:20 AM
I think he means inactive users as in users that have not activated their accounts....

If so, just go to phpmyadmin and execute this query in the coppermine database:

DELETE FROM cpg11d_users WHERE user_active='NO'
Title: Is there a way to delete all inactive users at once?
Post by: bryan on December 20, 2003, 05:42:41 PM
Oh thanks! :)