|
|
Joined: Jan 2003
Posts: 141
Journeyman
|
Journeyman
Joined: Jan 2003
Posts: 141 |
Is there a way to do a search for the users that have never logged in? Even though I have instructions on exactly how to register, there are still alot of people that can't figure it out and I have quite a few registered users that have never logged in. I would like to search for them and send them an email if at all possible.
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
SELECT * FROM w3t_Users WHERE U_Laston = U_Registered Here's a variation that might provide a more readable result: SELECT U_Number,U_Username,U_Email,FROM_UNIXTIME(U_Registered) FROM w3t_Users WHERE U_Laston = U_Registered ORDER BY U_Registered DESC
|
|
|
|
Joined: Jan 2003
Posts: 141
Journeyman
|
Journeyman
Joined: Jan 2003
Posts: 141 |
|
|
|
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
|
|
|
|
|