UBB.Developers Forums UBB.threads 7 Development How Do I? How do I delete registered users...

What is the best route to delete users that have not atleast logged on to the site within 1 year?

Query to delete all users that have not logged-in since they registered. Submitted by Akd96

DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered`


https://www.ubbdev.com/forum/showflat.php/Number/94362

[]AllenAyres said:
Query to delete all users that have not logged-in since they registered. Submitted by Akd96

DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered`


https://www.ubbdev.com/forum/showflat.php/Number/94362 [/]
Thanks for the reply, I did find that one while searching, but am trying to delete users that have not logged in within the last year. I see that I just need to change the 'U_Registered' to a date/time stamp but I am not sure how to do that.

In that case select the 'advanced' link in the Member Management part of your control panel. Choose the "Last online:" section and set it for before one year ago.