I have a website that is getting some decent traffic. The problem for me is that a huge amount of bandwidth is from people downloading files. So much that I regularly go over my bandwidth quota. I have almost 500 files.

I'd like to make only the first X number of files available to users in a specific role? In other words, I would serve up to 10 files per month to users who are normal registered users and up to 100 files for those who have donated to the site.

I know this feature is not one that is likely to make it into the official release soo..

Is there a way I can hook into when a user downloads a file via sql trigger and keep track of things from the database side?

I have considered a secondary respository for donaters but I think moving files between the public and private download modules would be harder to maintain.

Are there any other ideas you guys might have at controlling my bandwidth?