230381 PHP/MySQL Repair and Debug

I have a PHP/MySQL script that is in desperate need of some solid fixing and debugging. The current script is the result of another project that has gone bad: the selected programmer was very unreliable and undependable. Moving forward, I need YOU to finish what they started: build a web application that uses information given in a URL or email and parses data from a MySQL database into a predefined web template. The application makes / will make extensive use of the following technologies: PHP 4.X Asynchronous Javascript and XML (AJAX) MySQL 4.X [login to view URL] (Ajax library & framework) [login to view URL] (Graphing utility) [login to view URL] (Heatmap reporting utility) [login to view URL] (Email application) [login to view URL] (WYSIWYG Web-based editor) Modrewrite and htaccess files [login to view URL],en/ (survey tool) [login to view URL] (PHP PDF creation tool) [login to view URL] (Ad hoc free form solutions) Data mapping XML and CSV importer Google analytics How it all works together and what “good” looks like - a demo story: 1. I have a list of names and addresses and other information that I want to upload into an online database. The list is formatted as either XML or CSV. I login to the system, create a database “shell”, map and import the data into the application. 2. I want to send out emails to my customer list that I just uploaded. These emails are extensively personalized using data elements from the contact list. I create an email template: one in text, one in HTML. I insert elements into the email template so that “Hello {first_name}…” becomes “Hello John”, “Hello Suzy” etc… The number of personalization elements in the email template can be unlimited, and is conditional on the database that I upload to the system. (PHPLIST & TinyMCE) 3. I also want to have a webpage that looks like the HTML template that I created for the emails. Now, when John or Suzy read their email, they notice they can visit a webpage that is personalized for them. The URL that they are prompted to visit looks something like [login to view URL] OR John_Doe.MyDomain.com. (TinyMCE) 4. In fact, I can create an UNLIMITED number of webpage templates, and have them randomly or sequentially assigned to people in my contact list. This is so that I can perform AB Split testing on the various templates. 5. The first time that John visits his webpage, I get an email alert telling me that he is visiting the site for the very first time. 6. Now that John is on the webpage, he can complete a survey. (LimeSurvey and/or FreeFormSolutions) He is not required to login to anything (necessarily – this CAN be an option, though). Rather, the application knows it is him because he is visiting his unique URL. (htaccess & modrewrite) The system will show John his survey, and in fact even populate the survey fields with information that is already known about him. If John makes the effort to finish the survey, he will get some kind of reward from us. 7. At the end of the campaign, I can login to the system and see all kinds of reports. Clicking on a couple of different links give me various options of presenting the data: bar, line, pie, funnel… all charts are offered. (FusionCharts) I choose which one looks best and print them, along with data details into a PDF file (FPDF). 8. I can also get a visual representation of where people are clicking on the web pages (Clickheat). 9. The application also has three levels of permissioning so that I can have people that are Super Administrators, Administrators and just users. Super admins can rwx everything and grant access to the system. Administrators can rwx most everything, and can only grant access to users. Users can just rwx their own stuff. Super Administrators also have reporting AND heatmap access. 10. Ideally, the application will have a menu for access and permission where users priviledges can be turned on or off anytime. 11. Lost password uses email to send a password if lost 12. Install and config application to help on initial use of app, given basic details like server, mysql data, etc. I have an alpha and a beta version of the application. Admittedly, it seems like the alpha works better than the beta right now – so I might be just starting over from scratch. Give me an idea of what it would take to build and integrate all these elements, and let's get started! Full requirements documents, source code from alpha and beta app, and access to previous project board documentation available for review upon shortlisting. You will also be allowed to revise your quote upon review of files. 100% serious job and all money in escrow upon project award. Possible bonus as well, depending on how well you stick to the schedule. Important notes: No money will released from escrow until I see something that is workable. I will not pay for buggy code or just because you need money. For additional reference, please see following Scriptlance projects: ID # 1201678874 (latest effort - and the one you will be fixing) ID # 1193293244 (first effort - good job but programmer got too busy)