RSS aggregation --> MySQL --> sort --> cache pages --> count clicks

I've an idea for a new site, and I've been trying to see if there is a script out there that can do what I want.

Basically it would have the same functionality of www.EATSLEEPFOOTBALL.COM
Where it would do the following

1. Read a few Hundred RSS feeds every hour
2. Store the data from them in a DB for 72 hours or so
3. Run a script that will create pages with links to these news parts & count clicks to have a popular news part.
4. SEO'd output so that www.mynewsite/apples/ will have links to RSS news about apples.

plus a few more things

If anyone knows a script and I use it it in the end I will send them $20 in paypal.

Or if someone is willing to code something like this, please send me a quote via PM.

Cheers,
p.

 

has anyone used CaRP for doing stuff with RSS feeds ??