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