Inactive Users and Bad email addresses

jjanssen - March 17, 2004 - 21:21

Hi everyone,
I have had my new drupal site running for over a month now and things are going well. I have noticed, however, that while several people have registered, I have noticed several users who typed their email address incorrectly, as well as several people who have signed up and then promptly not done anything. I was wondering if anyone knew of a way in the database to be able to tell if a user has actually ever logged on or not. I looked in the users table and didn't see any fields that jumped out at me. That way, I can easily go through and purge users who haven't logged in ever periodically so people can re-register with the username they want. Thanks!

» Login or register to post comments

Hi, The field you are

mercmobily - April 5, 2006 - 09:11

Hi,

The field you are looking for is "access" in the "users" table.
If it's 0, the user never logged in.

Since you also have the "created" field, you can easily write a query which will delete users that are more than 5 days old (using "created") and for which access=0.

That's what we do at Free Software Magazine

Bye!

Merc.

Also...

mercmobily - April 5, 2006 - 10:21

Sunny is right, using a module is probably a good idea.
I looked for a while, but I must say in the end I gave up and did it myself.

Note: if you change the database directly, I would advise you to never ever delete users, but mark them as "locked" instead (status=0).

Merc.

Module exists

sangamreddi - April 5, 2006 - 09:52

There are several modules exists for thsi purpose. Depending upon the Drupal version, the modules are available. check the modules section for more info.
Sunny
www.gleez.com | www.sandeepone.com