Add Referral ID Entry Boxes to osCommerce Customer Registration form.

This project adds two (2) Referral ID entry boxes to my osCommerce customer registration form. The two boxes; “Referred ID and “Referral ID?? shall be displayed at the bottom of the customer registration form when the customer click on “create an account??. The Referral IDs will be used to track customers who refer friends to my Website. This project only creates the two Referral ID boxes and the MySQL entries. The tracking functions will be done with a separate program that is not a part of this project. My Website: <[login to view URL]> ## Deliverables Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). 4) The “Referred ID?? and “Referral ID?? entry boxes shall be displayed at the bottom of my osCommerce customer registration form when the customer click on “create an account??. 5) The “Referred ID?? box shall be the first (top) box. Under the box, shall display the message: “Enter the Referral ID of the person that referred you to this Website.?? 6) The System shall check that the “Referred ID?? entered is valid. (matches the Referral ID of a registered member) If the Referred ID entered does not match the Referral ID of a registered member a message shall be displayed. “The Referred ID you entered does not match one of our Members. Please check the exact spelling and re-enter or leave blank?? 7) The “Referral ID?? box shall be displayed next. Under the “Referral ID?? box shall display the message: “Enter a Referral ID for yourself. Min of 8, Max of 40 characters.?? 8) The length of the Referral ID shall be a min of 8 and a max of 40 characters and numbers. 9) The system shall check to determine that another customer has not used the “Referral ID??. If the Referral ID is not unique display: “The Referral ID you entered has been used. Please enter a different Referral ID.?? 9) The Referral ID boxes shall not require entries. Customer can choose not to participate in the Referral Program by leaving the “Referred ID?? and “Referral ID?? blank. 10) The Referred ID and Referral ID shall be saved in variables in the MySQL database under Customer. One variable is already set up; “customer_referral_id?? can be used for the customer “Referral ID??. You need to change this variable to “varchar(40) You need to add the “Referred ID variable. 11) In the Admin area under Customer, the Admin shall have feature to view and edit the members “Referred ID?? and “Referral ID??. The entries made shall be checked to determine if they are valid. See 6) and 9) or valid entry criteria. 12) In the Store under: My Account > “View or change my account information??: Shall include the following information at the bottom on the form: Referred ID, Referral ID. Customer can not change the Referred ID or the Referral ID after they have registered. 13) The code shall be well annotated so that I can easily find the code changes and additions. 14) A list of each file changed shall be provided. 15) Coder shall provide bug fixed associated with this project for a period of 6 months. Notes: Here is an osCommerce contribution that you might be able to use for some of the code. [login to view URL],2082 I do not want this contribution installed. I reference it here because it includes code for the entry boxes for the Referral IDs. This contribution was installed on my website and then it was removed or disabled. Parts of the code are still there. This code has option for where the registration boxes are displayed and the form of the Referral ID. If you use parts of this code you need to fix the options in this code to force the Referral ID boxes to display in the registration form and set the type of Referral ID to “user entered??. In the MySQL database under “customer?? the variable for one of the Referral ID is there: “customer_referral_id??. You can use this variable for the “Referral ID??. You need to change this variable to “varchar(40)". You need to add the “Referred ID Variable. In the Admin area under “Configuration?? there is still a link to “Referral Options??. This can be removed. ## Platform My Website is hosted by iPowerweb. A UNIX server. My OsCommerce is CREloaded 6.15 with many modifications. It uses PHP and MySQL data base.