Welcome to Geeklog, Anonymous Wednesday, February 08 2023 @ 08:00 am EST

Geeklog Forums

Pruning inactive users

Status: offline


Forum User
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.


Status: offline


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

All times are EST. The time is now 08:00 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content