Hey Guys,

Something I am finding a huge problem with, is dealing with expired users. Now Subscription Tools went part of the way to fixing this problem by sending out reminders, but there is another thing that I think would make this a supurb module!

Would it be possible to add a feature so that when a user expires, it removed the plans role and adds them to a different role?

An example.

A user joins a plan called Member. Just before it expires a year later he starts getting reminders.If he then does not renew his subsctption, it removed him from Members and adds him to Expired Members.

This way I can then have a module on the home page aimed just at Expired Members, asking them to rejoin !!

I think this would make this module stand out. There is nothing that I can find can do this so far, and would love to see it added.

I would appreciate any feedback from the developers on if this is possible or would be even considered?

Many Thanks

Marc

When your user subscribes, does an expiry date get added to their Member role?  If so, can you target users in the Member role whose expiry date is in the last 14 (or whatever)  days eg something like:

select u.username, ur.expirydate from UserRoles as ur
inner join users as u on ur.userid = u.userid
inner join roles as r on ur.roleid = r.roleid
where
  u.userid = [LoggedOnUserID] and
  r.RoleName = 'Member' and
  r.PortalID = YourPortalID and
  (datediff(d, getdate(), ur.expirydate) <= '0' and datediff(d, getdate(), ur.expirydate) > '-14' )

You could use OpenWebStudio to run this, replacing [LoggedOnUserID] in the code above with [Userid,System], I'm sure someone will have another method though I suggest OWS because of its ability to not display the module if the result is null.

Hi Marc,

The expiry date mean that they don't belong to that role any more and can't view role-specific content.  The pseudo code above selects those for whom the expiry date has arrived and is less than 14 days ago.  Using OWS/ListX will allow you create a module to target them when they visit your site, using something like SqlGridSelectedView (or maybe the reports module) will allow you to use similar code to extract these details into a list that you can use to badger them.

Barry