Welcome to Geeklog, Anonymous Wednesday, August 17 2022 @ 11:56 am EDT

Geeklog Forums

Pruning inactive users


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
 Quote

Status: offline

Dirk

Site Admin
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
 Quote

All times are EDT. The time is now 11:56 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