Change upload limit from 24 hours to "real" days

[CeBra]

Hi

my users complain about the fact that the upload limit is based on 24hrs rather than on real daycounts. I have searched the support forum and found a thread ( hack) where a change in uploadphoto.php from


if ( $User['uploadlimit'] > 0 ) {
$upload = ppmysql_query("SELECT COUNT(*) FROM {$Globals['pp_db_prefix']}photos WHERE userid={$User['userid']} AND date > UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 24 HOUR) )", $link);

to

if ( $User['uploadlimit'] > 0 ) {
$upload = ppmysql_query("SELECT COUNT(*) FROM
{$Globals['pp_db_prefix']}photos WHERE userid={$User['userid']} AND
FROM_UNIXTIME(date, '%Y-%m-%d') = CURDATE()", $link);

should solve the issue.

But somehow it doesn't work.

Now I am not expert enough to see what is wrong about the statement, but I would really love to change things so users are happy again

Any help is greatly appreciated!

[CeBra]

Hi

no reply so far. Has this issue by any chance been changed in 6.2?

[Chuck S]

This is not a bug by nature. The 24 hour limit is from the time the user uploads. So if he is uploading at 12 noon today it will check back to 12 noon yesterday.

[CeBra]

True. Not a "bug" - but still I am desperately trying to change that behaviour somehow so members can upload at 11 p.m. and again at 01 a.m. the other day if they feel to.

Could you Chuck provide me with the right code to modify the file? I think there are others around that would also appreciate that information.

[Chuck S]

Feel free to post in the modifications forum for someone to assist.