|
|
Joined: Oct 2002
Posts: 105
Journeyman
|
Journeyman
Joined: Oct 2002
Posts: 105 |
I want to remove all user who never login from my UBBThreads 6.2. There is any way to do it? Thank you Elton
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
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.
|
|
|
|
Joined: Jul 2002
Posts: 135
Journeyman
|
Journeyman
Joined: Jul 2002
Posts: 135 |
I also want to get rid of users who have never logged in but i'm on 6.1.1
|
|
|
|
Joined: Oct 2002
Posts: 105
Journeyman
|
Journeyman
Joined: Oct 2002
Posts: 105 |
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.
|
|
|
|
Joined: Aug 2002
Posts: 1,191
Kahuna
|
Kahuna
Joined: Aug 2002
Posts: 1,191 |
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
Nikos
|
|
|
|
Joined: Oct 2002
Posts: 105
Journeyman
|
Journeyman
Joined: Oct 2002
Posts: 105 |
Thank you It worked fine here Thank you very much
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Nikos..... you da man!
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
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.
|
|
|
|
Joined: May 2002
Posts: 41
User
|
User
Joined: May 2002
Posts: 41 |
Actually, you could do it like this...
DELETE FROM w3t_Messages WHERE M_Subject = 'Welcome' AND M_Status = 'N'
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|