**This program is a news portal using multiple news feeds (updated every 10 minutes) and deleting all news articles older than 24 hours.** It should have a similar format as shown at <[url removed, login to view]>. With all of the news feeds, you'll have to (automatically) import news feeds into a MySQL database table. You need to have the program check for duplicates (using title as reference). In the MySQL table you'll have at least all of the following fields in the table: 1. the news source 2. time/date gathered 3. title 4. description (if available) 5. news photo (if available) 6. url 7. current number of hits/views Adding other news sources must be easy -- assuming they have the same XML format as the following (6) required news sources: 1) Fox -- [url removed, login to view],4313,0,[url removed, login to view] 2) BBC -- [url removed, login to view] 3) CNN -- [url removed, login to view] 4) AP -- [url removed, login to view] 5) Washington Post -- [url removed, login to view] 6) NY Times -- [url removed, login to view] The page shown to the public should show the most popular news articles sorted in descending order for the last 24 hours (in the left column) -- showing each article's title (hyperlinked), photo (if available), news source, description, and current number of views. In the right column, 20 of the newest articles need to be shown with newest first and then the 20th item last -- each showing title (hyperlinked). For each title, it will need to be hyperlinked and a redirect will be needed to count every hit/view (for each article -- this will require a MySQL increment on the hit/views field). Please leave comments in code for easy modification.
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 program needs to work with PHP ver. 5.2.1, and MySQL ver. 5.0.24-standard. Do not use Cron jobs.