limiting downloads --- need help with time

[robsgaming]

i created a simple download script that logs the username, filename, and time of a download from a user.

the time is in this format: 2003-09-16 13:55:32

my question is how hard would it be, based on the log, to limit a user to only say 5 downloads per hour? i want to run a simple query or something that if 5 rows exist with the same hour, then no more downoloads are possible, does that make sense?

[biggus]

if the download times are stored in a database, just

$SQL="select count(*) where downloaderuserid = $downloaderuserid and downloadtime <'".date("M d Y")." ".date("H").":00' and downloadtime >'".date("M d Y")." ".(date("H")-1).":00'";

if the count(*) is > 5, then no download.

That should limit them to that specic hour (2PM - 3PM, for example). You may have to play around with the date format to get it right. http://us3.php.net/manual/en/function.date.php