[development] Download stats for October

[Earl Miles]

Derek Wright wrote:
> 
> On Nov 15, 2006, at 1:31 PM, Dries Buytaert wrote:
> 
>> Better yet would be to track downloads from within the project  
>> module.  Then we can sort projects by number of downloads.
> 
> http://drupal.org/node/66015
> http://drupal.org/node/52475
> 
> much easier to implement now with new release system.  either  directly 
> in the {project_release_nodes} table (new column called  
> "num_downloads") or in a {project_release_downloads} (with 2 columns:  
> nid, num), we could store the data in the DB.  we just need a cron  job 
> running on d.o to periodically take the raw download stats and  update 
> the DB correctly.
> 
> we could display this info in 3 places:
> 1) on each release node itself
> 2) next to the "Download" link in all the existing project browsing  pages
> 3) add a new "Browse by popularity" sorting method (that's what  #52475 
> is talking about).

We could go a step further and keep more detailed statics.

project_nid
release_nid
period 	        -- day/month/year
date            -- 20061102 / 200611 / 2006
count

Getting totals would be simple queries AND we could get daily/monthly/yearly 
statistics should we want.