Member expiry
How Do I?
Hi,
Looking for a way to move members to a ‘Dormant’ member group if they haven’t logged into the site for x amount of time.
I’ve looked around the add-ons but cant find anything to achieve this.
Not sure if this could be done with an SQL query and cron job that could be scheduled daily.
Alternatively is there some add-on that could generate a list of members that haven’t logged into the site for x amount of time.
I know it’s a bit vague but does anyone have thoughts on this.
I’d be open to developers quoting to produce an add-on that could provide this function. A proper brief would be provided if there’s any interest.
Thanks
Wayne.
An addon could certainly do this but you could as well externally and then just change the database with the SQL queries.
Basically:
A query to check the last time logged in for all members, probably with a cron once a day.
Then run another query if they match your time and change the member group for the affected results.
You could then reverse it as well. And you probably want to email users first, assuming it will affect their functionality if you move them to a more restricted group.
Thanks, I’ll look at a cron and SLQ query as my first route.