CareerCup

Lets say we have a database table with below columns:
UserID, lastDownloadresetDateTime, lastDownloadDateTime, downloadCount.

lastDownloadresetDateTime would store the datetime when user tries to download something and the lastDownloadedDateTime > 24hrs.

That is: pseudo logic

if (lastDownloadresetDateTime - currentDateTime < 24 hrs AND downloadCount == 10)
{
	// deny access for downloading
}
else
{
	// allow download access and set the below values for the user
	if (lastDownloadresetDateTime - currentDateTime > 24 hours)
	{
		update lastDownloadresetDateTime = currentDateTime 
		update downloadCount = 1;
	}
	else
	{
		update downloadCount++;
	}
}