UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Please triple check this:

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

That looks correct and should delete users who have never logged in.

Usual warnings apply - backup your database first. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

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.

I tried that command and it DID only delete one person.

Not the over 100 that I know I have on board.

Is there another command?

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.

Thank you Rick.
I did get the message "One Row deleted..."
But after I read your response I checked the number of members and it dropped by about 200.

Thank you

Musky