Total Per Day..

[dc2007]

Hi i have a php mysql query where it see how many attachments users have downloaded per day but i need it to reset at each users midnight but at the moment its no its just removing one each time its 24 hour after.

 

if($row['postdate'] <= (time()-$permissions['ugpindexretention']*24*60*60) AND ($vbulletin->userinfo['userid'] != $row['owner']) AND (!in_array($vbulletin->userinfo['usergroupid'], array(6))))
{
standard_error("Sorry you can only download 10 attachments per 24 hours.");
}

[Barand]

SELECT COUNT(*) FROM downloadlog
WHERE owner = $userid
AND postdate > NOW() - INTERVAL 24 HOUR

 

If the count is 9 or less it's OK otherwise error message - and no resetting needed

[dc2007]

thanks for that mate but it was the wrong code lol here the proper one

 

for the download file

 

    $grabs= $db->query_first("
        SELECT COUNT(*) AS `grab`
        FROM " . TABLE_PREFIX . "downloaded AS down
        WHERE down.userid = '" . $vbulletin->userinfo['userid'] . "'
	AND down.time > NOW() - INTERVAL 24 HOUR
    ");
    $vbulletin->db->free_result($grabs);  
    $totgrabs = $grabs['grab'];


if($totgrabs >= $permissions['ugpindexperday'])
{
standard_error("You have reached you daily download limit of 10");
}

 

and for the display of how many the member had downed

 

$perd = $vbulletin->db->query_first("
        SELECT COUNT(*) AS `perday`
        FROM " . TABLE_PREFIX . "downloaded AS down
        WHERE down.userid = '" . $vbulletin->userinfo['userid'] . "'
AND down.time >= NOW() - INTERVAL 24 HOUR
    ");
    $vbulletin->db->free_result($perd);  
    $downed = $perd['perday'];

 

but its displaying 0

[Barand]

Does it work if you don't free the resultset first?

 

And of course it was the wrong code (I am not a psychic). Just an example.

 

Why second query when you already have "grabs"?

[dc2007]

no mate still not working

[Barand]

is down.time a DATETIME column?

[dc2007]

time        int(10) UNSIGNED No

[Barand]

try substituting

 

FROM_UNIXTIME(down.time)

[dc2007]

your a legend mate sorted

 

AND FROM_UNIXTIME(down.time) > NOW() - INTERVAL 24 HOUR

 

thank you.

 

maybe you could have a look at my other issue

 

http://forums.phpfreaks.com/index.php?topic=361603.0

 

thanks again..