It's also still the case that all downloads from the same IP address are counted, even though the settings are configured to only count one download per 60-minute period. This is obviously being used manipulatively to artificially inflate the download numbers. This problem has existed for years...
Hi
Think this is a bug
Colin
Problem also resolved. The issue lies within this file. The time query should be handled using UTC time; otherwise, the setting will not take effect.
httpdocs/components/com_jdownloads/src/Helper/JDHelper.php
Search for this line within the function in the editor.
$query->where('log_datetime <= NOW() AND log_datetime >= (NOW() - INTERVAL '.$duration.' MINUTE)');
Replace them with:
$query->where('log_datetime <= UTC_TIMESTAMP() AND log_datetime >= (UTC_TIMESTAMP() - INTERVAL '.$duration.' MINUTE)');
Hi Ingo,
thank you for investigating this and sharing your solution. The UTC adjustment looks plausible, and I have noted it for verification and inclusion in a future maintenance release.
Version 4.1.8 is already frozen and focuses on security fixes, so this change will not be included in that release.
The release of version 4.1.8 is scheduled for tomorrow.
Best regards
Arno
It seems that some more Security items have been identified. So in consequence version 4.1.8 is delayed - it is estimated to be cleared for release by Wednesday 11th or Thursday 12th.
ColinM