My company needs a PHP/SQL based content management system which aggregates content from blogs, video sites, directories, etc. The website will display RSS feeds, and content from other websites, and will collect links. Additional Info (Added 10/29/2009 at 8:26 EST)... More specifically, we need a clone of surfthechannel.com with user accounts, link submission forms, commenting and voting systems, along with the ability to aggregate rss feeds and scrape links from surfthechannel.com and other tv-link websites such as tv-links.com and yidio.com . The final product must have an already populated database with links to all TV Shows and Movies.
A working sample is required or at least a demonstration of the ability to scrape links, aggregate rss feeds, and display content from other websites.