I would like double verification from the top Dogs on here that the following IS the correct SQL command to delete all members who have not logged in since they registered.
DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered`
Thank you
Musky
How's all this "hopie-changie" working out for you???
Will that axe users who just registered today? is there any way to set a time - say so it gets those who registered a month ago on back to board start date?
It will only axe users that have registered right that second. Once they register, and go to another page, the U_Laston value is updated, as it records time in seconds.
If you ran that query from the sql command box in .threads it would only report 1 row affected even though it would have deleted multiple rows. Bug in the current releases that don't actually tell you the total # of rows affected, it always says 1.