I want a script that can do the following:
1) Keywords should have a search funcion. Search words should find results from search engines such as Google, Yahoo and MSN and then it creates an html friendly page with the search results. For example if the keyword searched was "Web Hosting" it would show results pulled from Google for web hosting directly on our site, and then also create a page specifically for those results called web-hosting.html. The url would be the keyword that was used.
2) Each keyword that is used, the last ten are shown on the main page under latest, then it shows 10 random searches, then it shows the last 1000 words searched on the homepage, and then it continues to the next 1000, the next 1000 and it continues one like that. Each keyword needs to be it's own search engine friendly page with search results.
3) A sitemap xml file should be used as the feed for easy search engine indexing.
4) I will provide a text file with search terms that should be on the site by default to get it active.
An example of a site that does this see [url removed, login to view]
The page should have header/footer files for easy editing of the header/footer displayed on the site so it can be easy to insert advertisements on the pages, for example google adsense in the header/footer.
The database should be mysql and importing many keywords at once should be easy for a non techie person.