280492 Website Frontend from Databas

Revamp Website Frontend from Databas - PHP/MySQL/XML/AJAX Redesign templates / NO design required / NO Backend programming required I need the frontend recoded of my MySql/PHP deals site - the site is FULLY functional but needs to be cleaned up for SEO/Speed and because it is butt ugly. NOTE: I have a css template ready to go so no design is involved. NOTE: There is no programming of the backend required for this project. I will provide a link to the site for interest programmers in PMB. PLEASE view BEFORE bidding and BO automated "I can do this" bids will be considered ========================================================================================== Project: You will essentially pull the data from the database into a series of preformated pages. To reduce DB serverload I require you to generate xml/rss files at regular intervals (cron) and base pages on those files. If you are familar with Flashden plugins you will understand some of the xml formats required. Database: The site consists of 4 basic database tables categories // stores // deals // categorized (connects deals to stores) From these tables specific data needs to be parsed into xml files used in frontend templates. I use php includes thoughout the templates for different content so they must still work. Templates: All pages based on one simple CSS template. Header, Footer, Left Sidebar, Right sidebar, Body - Header Static except for Title, Description, Keywords Metadata - Left Sidebar - - Categories Navigation Module // Categories with internal linking (fixed) - - Stats Module // # Deals, # Stores, # Categories (include) - Body - - [login to view URL] = 5 Newest deals, 5 Exping deals, 5 Popular deals - - [login to view URL] = Deal description, link to category, link to Store - - [login to view URL] = Store description, All deals available from that store - - [login to view URL] = All deals relating to a single category - - [login to view URL] = generic pages used for swapping content area in body area : - - - search results - - - top 50 - - - expiring 50 - - - recommend 50 - - - exclusive 50 - - - submit a deal - - - about - - - contact - - - privacy - Right Sidebar - - Latest 20 deals (include) - Footer Static Modules (includes) Although all code alreday exist for these functions you will probably want to program this yourself. categories - navigation (fixed position) Latest Deals - As Sidebar (compact) / As Page (more detailed) Expiring Deals - As Sidebar (compact) / As Page (more detailed) Recomended Deals - - As Sidebar (compact) / As Page (more detailed) Most Popular Deals - As Sidebar (compact) / As Page (more detailed) Seach Results - As Page (more detailed) Stats - As sidebar - # deals, # Stores, # Categories VERY IMPORTANT: The site is to be built in a test directory before moving to the front page - no writng to the DB allowed or alteration of the current site in any way What I want is a facelift that is quick, clean and SEO friendly. You will create xml files from the backend DB as basis of site and implement into the CSS template I am not a programmer, mysql expert or ajax guru, but I expect that you are and are open to suggestions as to how YOU can redo my site. I will ignore all clip n paste "we can do it" bids and request examples of your work in PMB before your bid. Payment on completion of project - no escrow unless you have a spotless record with over 50 complete projects. I would really like to find a php,mysql,ajax expert I can turn to for all my needs in the future and I hope this project will be the start of a long working relationship! Thanks in advance