Jump to content

Manage Inactive Members


Recommended Posts

  • Replies 371
  • Created
  • Last Reply

I have mine set to delete inactive members whose last post was more than 70 days ago. But yesterday it deleted members who had only been inactive for a little over two weeks. Any idea why this may be??

I am really sorry to hear about this. Hope you didn't lose any valuable members!

Could you please run the task in debug mode, and show me the output from that?
Link to comment
Share on other sites

Thanks for taking a look at it for me, Martin.

Here's what I got:


[color=#000000]SELECT member_id[/color][color=#666600],[/color][color=#000000] members_display_name[/color][color=#666600],[/color][color=#000000] posts[/color][color=#666600],[/color][color=#000000] email[/color][color=#666600],[/color][color=#000000] member_group_id[/color][color=#666600],[/color][color=#000000] mgroup_others[/color][color=#666600],[/color][color=#000000] members_disable_pm[/color][color=#666600],[/color][color=#000000] allow_admin_mails[/color][color=#666600],[/color][color=#000000] joined[/color][color=#666600],[/color][color=#000000] last_activity[/color][color=#666600],[/color][color=#000000] last_visit[/color][color=#666600],[/color][color=#000000] last_post

FROM members

WHERE [/color][color=#666600]([/color][color=#000000] last_post [/color][color=#666600]<=[/color][color=#000000] [/color][color=#006666]1317216739[/color][color=#000000] OR last_post IS NULL [/color][color=#666600])[/color][color=#000000] AND joined [/color][color=#666600]<=[/color][color=#000000] [/color][color=#006666]1322055139[/color][color=#000000] AND member_group_id IN [/color][color=#666600]([/color][color=#006666]7[/color][color=#666600])[/color][color=#000000]

LIMIT [/color][color=#006666]0[/color][color=#666600],[/color][color=#006666]250[/color]

[color=#4C4C4C]Found 0 inactive users[/color]




Link to comment
Share on other sites

These members that were deleted, did they have any posts? The "last_post" column will be "NULL" for member who haven't posted yet.

In real words your query would be:
Select member where
- Their last post before 2011-09-28, or they haven't posted yet.
- They joined before or on 2011-11-23 (two weeks)
- And they're in the member group with the id 7

What you can do is raise the amount of days the member have to be registered to the same amount as their inactive days.

Link to comment
Share on other sites

  • 1 month later...

As far as I'm aware, IPS have gone away from that list of prohibited 3rd party addons, and are instead monitoring their servers on a site-to-site basis. The reason for the previous ban on this application is that users would increase the "members per cycle" value to ridiculous numbers. If you've left this setting untouched you have nothing to fear, but if you've set it higher than the default, reset it.

Link to comment
Share on other sites

  • 3 weeks later...
  • 2 weeks later...
  • 3 weeks later...
  • 2 weeks later...

Hi Martin... I installed this a while back but it hasn't been used as one of the other admins made a good point. Sometimes a member will send the other admins a pm stating that they may have long term sickness, etc, and may not be on the site for a long time. Naturally we don't want their account to be deleted, etc. Do you think you could add a feature where we could add ceratin member exceptions. Maybe an exception option where you type the first 3 letters of their name and it gives the closest matching members. Also a feature to remove members you have already put into the exception list.

This would guarantee we don't accidentially delete members we don't mean to automatically. This list would also ensure they wouldn't get any warning emails, PMs, etc.

Link to comment
Share on other sites

You could get around that by moving the member to a group that isn't touched by any of the tasks.

I had already thought of that. However all our member groups are used, and if we added another group, members would ask,"what's this new group for?" We in return would have to explain that it's for people with long term sickness, or going to be away for a while. Now some people don't want other members to know they have a medical condition, or whatever it could be, and just want to inform an admin in confidence.

Also we have lots of group which have varying forums permissions, etc. This new group couldn't be tailored for the varying permissions, and we would have to set up a exception group for each existing group which would get out of control.

Hence why I made my above suggestion. Do you feel you could add this function in?
Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Create New...