I am looking for someone knowledgeable with the Joomla site workings, PHP and SQL to create a script or module for our website that is capable of automatically distributing pre-created serial keys/codes to our members. The keys are received in the format of a spreadsheet, but can be uploaded to a database table prior to use if required by the script/module. Here is an ideal flowchart for the process:
1. Identify user.
2. Check to see if user has already obtained a code for the particular event.
3. If they have, display the code they already received.
4. If they have NOT, obtain a code from the available list, and assign the code to that user.
5. Remove the applied code from the list.
I would prefer this be done on the page/site itself, and not through an email process.
I had come up with a possible solution myself, but it doesn't seem stable enough and I would prefer a more professional approach.
This is a really simple project, a script really, so I don't have a large budget in mind for it. Please feel free to message me with any questions.