I have an online application for which I will sell various forms of a license to use it. An individual can purchase a license for $xx, or a license for some number of users at $yy, for a high school or college class. What is the best way to set this up?
I need to keep track of the number of individual users that access a particular license and limit users to the number that was purchased. A person/teacher could buy a license and get a license code delivered by email. The license code would be distributed to students, who would log in to a "Class" and get access to the page with the application, if they enter the correct license code. I would need to also get some identifier from the student, like her email address and name. I'd like to avoid having a large number of individual student accounts, so perhaps there would be only one account per class. All students would log in to the "class" account. Even nicer, the teacher who buys the license would get an automatic account created, with name of the class as the user and license code as the password. The student would then have to enter an email address to get to the application page, if the student has previously logged in, or if the number of licenses had not been exceeded.
I'd appreciate any suggestions of modules or techniques that would support this need. I'm not a module developer, so pre-built modules are preferable. But, I'm not afraid of using jQuery to do some of the specialized code.
Thanks for any ideas. I use Drupal 6.20 Bill
William A. Prothero http://earthednet.org/
I'm not sure what you're expecting drupal to do vs. your online application. But if you need to produce a report from an arbitrary database, with the context of a drupal site (as your subject suggests), you might consider giving http://drupal.org/project/forena a try.
Dave
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of prothero Sent: Sunday, January 30, 2011 12:56 PM To: support@drupal.org Subject: [support] Report from an arbitrary database
I have an online application for which I will sell various forms of a license to use it. An individual can purchase a license for $xx, or a license for some number of users at $yy, for a high school or college class. What is the best way to set this up?
I need to keep track of the number of individual users that access a particular license and limit users to the number that was purchased. A person/teacher could buy a license and get a license code delivered by email. The license code would be distributed to students, who would log in to a "Class" and get access to the page with the application, if they enter the correct license code. I would need to also get some identifier from the student, like her email address and name. I'd like to avoid having a large number of individual student accounts, so perhaps there would be only one account per class. All students would log in to the "class" account. Even nicer, the teacher who buys the license would get an automatic account created, with name of the class as the user and license code as the password. The student would then have to enter an email address to get to the application page, if the student has previously logged in, or if the number of licenses had not been exceeded.
I'd appreciate any suggestions of modules or techniques that would support this need. I'm not a module developer, so pre-built modules are preferable. But, I'm not afraid of using jQuery to do some of the specialized code.
Thanks for any ideas. I use Drupal 6.20 Bill
William A. Prothero
Thanks, Dave. This may be useful for another application I'm thinking of, as long as it will access external mySQL databases. Bill
William A. Prothero http://earthednet.org/
On Jan 31, 2011, at 9:05 AM, Metzler, David wrote:
I'm not sure what you're expecting drupal to do vs. your online application. But if you need to produce a report from an arbitrary database, with the context of a drupal site (as your subject suggests), you might consider giving http://drupal.org/project/ forena a try.
Dave
[ Drupal support list | http://lists.drupal.org/ ]
It will access any PDO database (mysql included) and also allows native support for Oracle. We use it for reporting against oracle, but also used it to add chat logs to the Openfire chat server: another mysql application.
I'm working on adding Postgres native support as well in order to take advantage of some of the cool XML specific technologies in postgres.
If you have any trouble using it, file issues on the issue queue.
Dave
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of prothero Sent: Monday, January 31, 2011 10:44 AM To: support@drupal.org Subject: Re: [support] Report from an arbitrary database
Thanks, Dave. This may be useful for another application I'm thinking of, as long as it will access external mySQL databases. Bill
William A. Prothero
On Jan 31, 2011, at 9:05 AM, Metzler, David wrote:
I'm not sure what you're expecting drupal to do vs. your online application. But if you need to produce a report from an arbitrary database, with the context of a drupal site (as your subject suggests), you might consider giving http://drupal.org/project/forena a try. Dave
[ Drupal support list | http://lists.drupal.org/ ]
Dave: Thanks. I'll certainly give it a try. Thanks for your contribution. Bill William A. Prothero http://earthednet.org/
On Jan 31, 2011, at 10:49 AM, Metzler, David wrote:
It will access any PDO database (mysql included) and also allows native support for Oracle. We use it for reporting against oracle, but also used it to add chat logs to the Openfire chat server: another mysql application.
I'm working on adding Postgres native support as well in order to take advantage of some of the cool XML specific technologies in postgres.
If you have any trouble using it, file issues on the issue queue.
Dave
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of prothero Sent: Monday, January 31, 2011 10:44 AM To: support@drupal.org Subject: Re: [support] Report from an arbitrary database
Thanks, Dave. This may be useful for another application I'm thinking of, as long as it will access external mySQL databases. Bill
William A. Prothero http://earthednet.org/
On Jan 31, 2011, at 9:05 AM, Metzler, David wrote:
I'm not sure what you're expecting drupal to do vs. your online application. But if you need to produce a report from an arbitrary database, with the context of a drupal site (as your subject suggests), you might consider giving http://drupal.org/project/ forena a try.
Dave
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Metzler, David -
prothero