Posted on: 12/10/03 09:25pm
By: timmus
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
Re:Pruning inactive users
Posted on: 12/11/03 03:29am
By: Dirk
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