Re: How to track # of file downloads (DB or File)

2009-02-17 Thread Mike Cook
On Feb 17, 3:23 pm, Samuel DeVore wrote: > Of course if all you want is stats on the file downloads and your > server does that anyway, why not just filter/ collect stats from the > log files? > > Sam D Even if I don't initially start out recording other data, it's probably worth me creating a s

Re: How to track # of file downloads (DB or File)

2009-02-17 Thread Samuel DeVore
Of course if all you want is stats on the file downloads and your server does that anyway, why not just filter/ collect stats from the log files? Sam D On Tue, Feb 17, 2009 at 2:04 AM, Mike Cook wrote: > > Okay, definitely some food for thought here. > > @Miles J :: As brian states, this would

Re: How to track # of file downloads (DB or File)

2009-02-17 Thread Mike Cook
Okay, definitely some food for thought here. @Miles J :: As brian states, this would be for stats. It's okay knowing you have 10 downloads, but knowing the time, day, week, and month can help in understanding your visitors better. If I do get to the point of implementing an API then I should also

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread brian
On Mon, Feb 16, 2009 at 7:18 PM, Miles J wrote: > > Well you could save each download with a date... Yeah, this is what I'm saying--that, if a date is required, then simply incrementing a single field in the files table will not work and there needs to be a downloads table. The bonus is that you

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread Miles J
Well you could save each download with a date... and have a monthly cron that runs, calculates the total for that month and saves it to another table for monthly statistics, then erase all the previous single date records. But unless your doing by day, week, time etc, that wouldn't work. --~--~---

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread Alfredo Quiroga-Villamil
An approach to this could also be setting up a trigger in your database. This way you wouldn't need any code. You would let mysql for example do the work for you. Then you can use a neat little trick in mysql and call a "group by with rollup" and get the grouping plus the count. I hope that helps

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread brian
On Mon, Feb 16, 2009 at 5:44 PM, Miles J wrote: > > Well just think of it this way. What are you going to do with the > dates for each recorded download? statistics --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread Miles J
Well just think of it this way. What are you going to do with the dates for each recorded download? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@google

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread brian
On Mon, Feb 16, 2009 at 5:02 PM, Mike Cook wrote: > > There's never guarantees of having huge traffic but I do expect to get > a considerable amount, the number of files available will also grow to > several thousand within a year or so - there's certainly potential of > having tens of thousands

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread Mike Cook
There's never guarantees of having huge traffic but I do expect to get a considerable amount, the number of files available will also grow to several thousand within a year or so - there's certainly potential of having tens of thousands of downloads per month. This actually makes me wonder if I s

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread brian
On Mon, Feb 16, 2009 at 3:45 PM, Mike Cook wrote: > > I want to track the number of file downloads and I'm wondering if any > here have thoughts on how best to do this. > > At the moment I have a separate Files table for the details that > stores information such as; filename, filesize, version,

Re: How to track # of file downloads (DB or File)

2009-02-16 Thread Miles J
I do the same thing with my downloads. http://www.milesj.me/resources/script/commentia On the "download" action. I find the file in the database, I increment its download count if it exists and then I use the Media view to force a download. Your on the right track. As for the author part, if th

How to track # of file downloads (DB or File)

2009-02-16 Thread Mike Cook
I want to track the number of file downloads and I'm wondering if any here have thoughts on how best to do this. At the moment I have a separate Files table for the details that stores information such as; filename, filesize, version, first_downloaded and downloads. Is incrementing the 'download