Serial Key/Code Distribution PHP/SQL Script For Joomla Site

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.

^^ This is my ideal method, but if you have another idea I would be open to other options.

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.

I am using Community Builder for user management, and that allows for simple creation of additional user data fields. So, that might be an easy place to save the key to for a promotion. If it would make things easy, I could simply add a new field to the user data for the key to be stored when the user initiates the script. This would also make it easy to determine whether or not they had already obtained a key. I'm not sure how the field naming would need to be done, or if there would be a way to alter the script accordingly with future events (perhaps by simply changing the field name in the script for the new event page?)...

Just some ideas to help make it an easy project. Again, if you're familiar with Joomla and/or Community Builder and can handle PHP/SQL scripting, this should be rather straight-forward.

This is a really simple project, a script really, so I have a really small budget in mind. This is probably an hour or less of work for someone skilled with Joomla and PHP. I don't need a complex system, or a multi-function module. Just something to automatically hand out keys to our users.

Please feel free to message me with any questions.

Thank you!

Skills: Joomla, PHP, SQL

See more: php serial, joomla serial keys, serial key module script, serial key script php, joomla serial key, php serial key script, website promotion script, website event promotion, simple free php code, project name ideas free, place code, php website builder free, php free code, php codes list, php codes free, php builder, new joomla website free, key ideas, ideal ideas, create free php, create database using php, how code, hand out, free website builder easy, free php codes

About the Employer:
( 0 reviews ) Grand Rapids, United States

Project ID: #1282085

5 freelancers are bidding on average $220 for this job


Please check PMB

$150 USD in 3 days
(349 Reviews)

Hi sir, we are a web design, web development expert company. We are offering an efficient,professional ,friendly service. Can you check our skills in pmb and discuss with us about your project? Thanks :)

$150 USD in 3 days
(155 Reviews)

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, More

$500 USD in 5 days
(74 Reviews)

Hi, Joomla/ PHP expert here, Please view PM. Thanks Harish.

$75 USD in 1 day
(58 Reviews)

php/mysql/joomla experienced

$225 USD in 2 days
(2 Reviews)