Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Oct 2002
Posts: 105
ehm
Offline
Journeyman
Journeyman
Offline
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

Sponsored Links
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
ehm
Offline
Journeyman
Journeyman
Offline
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
Sponsored Links
Joined: Oct 2002
Posts: 105
ehm
Offline
Journeyman
Journeyman
Offline
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
Offline
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
Offline
Joined: May 2002
Posts: 41
Actually, you could do it like this...

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


Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)