Last post Dec 22, 2005 10:06 AM by cs77
Dec 20, 2005 03:51 PM|cs77|LINK
Hi all. I've searched around for info on this, but not been able to find what I'm looking for. If this has been discussed elsewhere please point me in the right direction. If not, I'd love to hear your feedback.
I should also preface this by stating that I am fairly new to DotNetNuke. I think it's a great project, and I'm excited to build this site (and many more I'll do) within this framework, but I'm still a novice. I have followed the SeaburyDesign video tutorials
on creating a new module, and I'm fairly comfortable with that. But I want to do more than what the tutorial covered and I'm afraid if I just jump into it I'll end up kludging it.
On to my challenge. I'm writing a module for DNN (or possibly several modules that will work together). I want to be able to provide a training course of sorts for my clients. When they register they'll pay a monthly fee to access the content. During their
first month of membership, they'll have access to month one's content. One month after they registered their cc will be charged again and assuming the charge clears they'll then gain access to month two's content (still able to view month one's content as
well) and so on for the length of the series (18-24 months in total, user can cancel any time).
Each month's content will include an article or two and some web based tools (calculators, worksheets, etc).
Initally we'll be storing & processing the CC's manually. I'll write some script or something to run against the db and update the successfull (and unsucsessful) charges. But, I need a table in which to store each user's membership info (date registered,
active [bit], etc).
Several questions arise from this. The first, and most important to me right now (unless you all show me something I'm missing) is understanding what is the best way to add persistent user-specific data to the db. I assume (danger!) that I could create a
table (TrainingCourseUsers) that includes DNN's UserID, PortalID, & ModuleID, along with the additional fields I need to store, but is this the best way to do it, or is there a better way I'm missing?
The next question I have is regarding DNN's subscription engine. I know DNN already has a subscription model for charging for portals, but can this same module be used to charge recurring monthly subscription fees? Also, can it's current model support multiple
subscription levels (free, $1, $2, $5)?
I have more questions regarding this, but I don't want to complicate matters right now, so I think I'll leave it at this and add more later as I get a better understanding of how to do what I'm trying to do.
Thanks in advance for your thoughts & recommendations on this one.
Dec 20, 2005 05:03 PM|mikeh36|LINK
Dec 20, 2005 05:10 PM|cs77|LINK
Thanks for the tip...I'll look into it.
Scott...if you do have any documentation on how you did your multiple subscription levels I'd be very interested in learning more about it.
Thanks all! Please keep the ideas coming.
Dec 22, 2005 10:06 AM|cs77|LINK
Many thanks to Mike for his direction. I was searching Scott McCulloch's website and I found an article outlining how he handles the various subscription levels:
This article walks step-by-step through the process. While it's a bit kludgy for users to "upgrade" their subscription level, it is a great start for what I was after.
Thanks again Mike!