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!

PLEASE NOTE: This is NOT a request for an entire site!

Rather, the only thing I am looking for is a rather simple script that will automatically distribute serial codes/keys from a pre-defined spreadsheet OR database table (whichever would be easiest and most secure). Again, this is a very short project that should only take a professional an hour or so to complete.

Please bid accordingly, as I am not prepared to pay someone $100/hour for scripting.

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 of event and promotion, simple free php code, promotion for events, project name ideas free, place code, php website builder free, php free code, php codes list, php codes free, php builder, new joomla website for free, key ideas, ideal ideas, how to use joomla to create a website, how to use code to create a website, how to create free php, how to create database using php, how to create a joomla website

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)