Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: deleting members who have never logged in  (Read 3154 times)

0 Members and 1 Guest are viewing this topic.

kateheaven

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 78
    • Kate Hudson Heaven
deleting members who have never logged in
« 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.
« Last Edit: September 20, 2006, 12:36:56 am by GauGau »
Logged

Nibbler

  • Guest
Re: deleting members who have never logged in
« Reply #1 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.
Logged

kateheaven

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Female
  • Posts: 78
    • Kate Hudson Heaven
Re: deleting members who have never logged in
« Reply #2 on: September 20, 2006, 12:16:41 am »

thanks, that worked good for me :)
Logged

tjiepie

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 39
Re: deleting members who have never logged in
« Reply #3 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?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: deleting members who have never logged in
« Reply #4 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 21 queries.