We are considering porting our web site to Drupal. We are an on-line documentation company that provides documents by U.S. state for a fixed monthly fee. So a person subscribes to say, Illinois and we allow them to download documents related to illinois. Each state has several different types of documents and they are organized in a several databases. The documents in a file directory are useless without the database lookup, so HTACCESS won't work for us. The pages that delivery Illinois documents are also used to deliver all the other states.
The way we have done this in the past is to display the states that the user has active licenses in and let them select which state they want to view. So if a user has a valid license we let them access the document lookup pages but only for the states they have active licenses for.
Is there an easy way to "sell" a subscrition for a state and then be able to cleanly check (database lookup) to see what active licenses they have?
I can see setting a role for any user with an "active license" and giving them access to the pages - but is there an easy way to find out what licenes are active?
In addition, say they have three licenses, would I have to set up user roles for each license?
Thanks,
Andy
