Number of Items added in Last 24 Hours
Can I show Number of Items added in Last 24 Hours in side tab of my selfoss...?
Is there any code for that?
Can I show Number of Items added in Last 24 Hours in side tab of my selfoss...?
Is there any code for that?
I have successfully added code for that...
Thank god..
$res = \F3::get('db')->exec('SELECT count(*) AS amount
FROM items
WHERE datetime > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 24 HOUR)');
return $res[0]['amount'];