Coders 4 Africa

ksituma wrote:

I am developing an elearning website and I have a set of pre-entered PINS in a database. For the user to access certain resources within my site, this PINS have to be entered and matched to the ones in database. When they are matched the user can gain access to the resources and the PIN should expire upon usage so that it cannot be re-used,i am in desperate need of a script that can help me achieve that.

I have a couple of questions regarding your inquiry.
1) Where do you want to handle this PIN management feature in the Database itself or in your business logic code
2) What languages and framework are you using for this website.
Thanks

I understand that Moodle is written in PHP. I don't thin k you need a separate DB for that you can create a separate within the DB that is created by Moodle. So here what I think, you should write a PHP methods that does the following create randomized PINs for your user upon course registration, and store them in the new table.
Once a course is activated for a given user (using one PIN), have another method that delete that PIN. Lastly you may need to integrate that in the Moodle registration class and switch the (Moodle) method or the code within the method that generate the PIN with your own newly created method. You may have to do the same integration with your DeletePIN method.

The question is how comfortable are you with PHP and the Moodle source code?