Fix small bugs on MySQL and web pages and test

I have a program that I am trying to sell online. The program links to our online registration page. A RAC coder has already done some work, but I need a little follow up from a MySQL expert. The existing registration process is as follows: - User provides his information in the registration webpage ([login to view URL]). - Upon successful entry, user is redirected to the PayPal - Checkout page - Upon successful completion of PayPal payment details, user is redirected to the successful purchase page ([login to view URL]). Moreover, an e-mail containing the product key is sent to the user. All of the above mentioned functionalities are already incorporated, although the email has had reported problems. The remaining points are mentioned below. -To verify that all transaction details are correctly inserted into database, and provide a mechanism for seeing database contents. -we need a page that deals with the "Forgot Password" functionality. Most of the code for this functionality is already available in forgot_password.php. It needs to be tested. -Once user successfully purchases EFE license through PayPal, user is redirected to a webpage that displays product activation information. That page needs to display the product key. Code for this functionality is in successfulpurchase.php. It needs to be tested. All in all, the selected coder will be required to perform the following tasks: 1. Modify habit3 web pages (most probably, [login to view URL] web-page) to provide "forgot password" functionality. 2. Modify habit3 web pages (most probably, [login to view URL]) to display the product key on that page. 3. To verify database records for all transactions. 4. To verify PayPal integration using live PayPal account. Please note that since most of the things are already available, the new tasks should be able to be completed within 2-3 working days, according to the coder who began the project. Thanks for bidding! ## Deliverables 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). * * *This broadcast message was sent to all bidders on Wednesday Oct 5, 2005 5:36:19 PM: I have reactivated this bid request. Any of you who are still interested, please let me know. Sorry for letting this go so long, things have been hectic. -Kelly ## Platform MySQL Ver 12.21 Distrib 4.0.15, for unknown-freebsd4.4 (i386) Upgrading MySQL would be acceptable if it's helpful. The root password has been lost, so that is an issue. FreeBSD 4.7-RELEASE-p28 The OS cannot be changed, it's on a virtual server maintained by someone else. Although, the registration process was thoroughly tested using the PayPal sandbox feature, it needs to be tested using a live PayPal account. Do NOT bid if you do not have a Paypal account. I will provide money for testing, but you MUST have an account. We couldn't test some parts of the system because of a database issue. The following error was encountered when we tried to test them: Warning: mysql_connect(): Access denied for user: 'root localhost' It is possible that there some problem with the database configuration.