I want to remove all user who never login from my UBBThreads 6.2.
There is any way to do it?
Thank you
Elton

From the admin menu... .you can delete inactive users for x amount of days. Not sure how to delete existing users who have never logged in.

If you turn on email verification in your config file.... new users who register have to follow a link to validate their email address. If they don't validate their email address.... the system deletes the user after like 3 days.... thus removing users that have never logged in.

Hope that helps.

I also want to get rid of users who have never logged in but i'm on 6.1.1

I already used that option to delete inactive users for x amount of days, but it wont work with user who never login.

Before I had 6.1.1, whitout the option to check e-mail, this is why I have a bunch of users who just create username but never login. I could not find a way to remove them.

Elton,

If you have access to your database via phpMyAdmin or something similar, you can run the following query:

DELETE FROM w3t_Users WHERE U_Laston = U_Registered

This will delete all the users that never logged in but if you want the query to start from a particular date backwards (cause you don't want to delete users that just registered) you can put an additional WHERE clause like:

DELETE FROM w3t_Users WHERE U_Laston = U_Registered AND U_Registered < UNIX_TIMESTAMP('2002-10-01 00:00:00')

which will remove all the ones that registered and never logged in before the 1st of October 2002.

I hope this helps

Warm regards

Nikos

Thank you
It worked fine here
Thank you very much

Nikos..... you da man!

It occurred to me that although that query gets rid of the users, it won't remove the "Welcome" private messages from the database.

In adduser.php (// Get rid of any unverified email accounts that are over 24 hours old), both get removed, but it requires a loop, and can't be done with a simple query.

Actually, you could do it like this...

DELETE FROM w3t_Messages WHERE M_Subject = 'Welcome' AND M_Status = 'N'