Register   Login
     
  Feedback Center  
All Feedback » Subscription Tools You must be logged in to subscribe.

Module to display role/plan and expiration date.
Feedback ID: 374 Status: Open
Product: Subscription Tools Implemented? No
Created On: 8/4/2006 Created By: Joe Rattz
Details: I would like to see a module that is template driven that has tokens supporting the user id, user display name, subscription role, substription begin date, subscription expiration date, etc. That way, via a template, a user could specify a module and add it to their home page that says something like:

Welcome Joe Rattz
Your Gold Member
subscription will expire
on: MM/DD/YYYY

Then, you (Scott) should add that to the left pane of the skin here, right below the logo and above the Private Messages. Then when your users login, we can tell what role we have and exactly when it expires. I suspect anyone using the subscription tools (I am not) would like the same thing. As a subscriber, I sure would like for the sites I subscribe to, to have that.

Here are some additional features to consider:

1. Perhaps the ability to format some portion of the message in red when it gets a specified number of days from the expiration date.

2. An optional 'renew now' button or link for the user to click to be directed to where they can renew.



Voting
  Votes For 100%       Votes Against 0%       (6 votes)

You don't have permission to vote.

Comments
By Joe Rattz @ 8/4/2006
That shouldn't have said 'That way, via a template, a user could', instead, it should have said a site admin could do that.

By Scott McCulloch @ 10/5/2006
You should already be able to do some of this via the "Status" module, but it's not as straight forward as I would like, I'll see what I can do. It doesn't have expiry etc.

By Scott McCulloch @ 1/5/2007
Have you looked at the status module that accompanies the signup one? It does some of the functionality..

By Joe Rattz @ 1/5/2007
I wasn't wanting it for my sites...I don't use the subscription tools module(s). I wanted your site to have it so I can easily see when my subscription expires. Right now, in the left pane there is a module with the title of Membership. In it, I can tell that I am a Gold Member. But, I can't tell when my subscription expires.

By Shan-Ming Chiu @ 8/5/2007
I would like the Subscription tools status module to have an [EXPIRYDATE] token that displays the member's expiration date in the role.

By ToBocom @ 10/23/2007
You can set up a raport with the raport module and put in SQL something like this. This will show those how have exspired or are going to exspire within the next 20 days, this SQL only show those with a special atribut in the subscriptionname.

SELECT dnn_Roles.RoleName as Subscription, dnn_Users.FirstName as Firstnavn, dnn_Users.LastName as Lastname, dnn_Users.Email, dnn_UserRoles.ExpiryDate as Exspire
FROM dnn_Users
INNER JOIN dnn_UserRoles on dnn_UserRoles.UserId = dnn_Users.UserId
INNER JOIN dnn_Roles on dnn_UserRoles.RoleId = dnn_Roles.RoleId
WHERE dnn_Roles.PortalId = 1
AND (EffectiveDate <= getdate() or EffectiveDate is null)
AND (DATEDIFF(day, GETDATE(), dnn_UserRoles.ExpiryDate) <= 20)
AND (dnn_Roles.RoleName like '%Subscripers%')
ORDER BY dnn_Roles.RoleName

Anyway it would be nice to have a buildt in though

Post Comment
You don't have permission to comment.