Geeklog Forums

My Geeklog system has run itself up to 1200 users. How can I delete "inactive" users or users who haven't posted a story in a long time? Is there any safe way to prune the database? Even doing this in SQL would be ok.

Tim

As of 1.3.8, Geeklog logs the last time a user logged in ('lastlogin' in table gl_userinfo). It shouldn't be too hard to create a list of users who haven't logged in for x days based on that information.

Deleting a user's account, though, shouldn't be done in MySQL directly, as several tables need to be updated.

bye, Dirk