tinyMCE integration into existing custom CMS in PHP/perl/mySQL

We have an existing custom CMS that needs to have tinyMCE integrated into the admin section. The system tracks information about community outreach programs. Also, a "live search" box to speed the navigation between programs needs to be added. Those are the two main pieces of functionality that need to be added - however, making sure all the HTML code the system stores is compatible with the new HTML code tinyMCE will generate will involve some sort of conversion, and verification all the formatting remains intact in the front and back end systems. There are many views of the data to verify the new tinyMCE generated HTML code maintains the existing formatting. In the text areas of data, the admins are entering bare HTML code which is not validated, except be looking at the "display mode" of the data, so expect invalid markup that must be fixed. The admin CMS section is written in PHP/mySQL, and the front end search tool is written in perl/mySQL. Attached to this request is the database structure only, with the data from the "sections" table included as it is part of the structure of the data a "program" tracks. There are further specifications in the attached zip file in the scope of work document. Please read in its entirety before bidding. The client updates data on almost a daily basis. A snapshot of the data and the entire system will be provided when the project starts. This can be used to develop the project, however, the system must be launched on their server in a maintenance window between a friday evening and sunday evening - which means there will be a new snapshot of data that must then be made compatible with the new tinyMCE system. The CMS must support use of common special characters such as en dash, em dash, single/double quotes, copyright symbol, etc. Again, please refer to file attachment for more details of specifications and screen shots of current system. ## Deliverables 1) Complete and fully-functional working program(s) in a web production environment as well as complete source code AND DOCUMENTATION 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). In this case, an open source editor, tinyMCE is requested to be used in integration and tinyMCE copyright will remain the property of the 3rd party developer. ## Platform Production environment is apache 2.0.59, PHP 5.21, mySQL 4.2.11, perl 5.x? PHP has magic_quotes ON, but code should be written to be portable and account for settings like this.