Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Deleting inactive/defunct users

Quote Reply
Deleting inactive/defunct users
I would like to purge my DB of users that don't have links. Here is a SQL query that will list the ID's of linkowners, but I can't seem to get one working that will find (or better yet, delete) the opposite of this...

SELECT ID FROM DB_Links, DB_Users WHERE DB_Links.LinkOwner = DB_Users.Username

Any thoughts? I saw a post from pugdog a while back that addressed this issue using the addition of a user_num_links column, but I'm not good enough at SQL to figure out the holes in the code to make it work.

Best Regards