Status: offline

timmus

Forum User
Newbie
Registered: 12/10/03
Posts: 2
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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
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