Number of Items added in Last 24 Hours

by blogillu, Saturday, June 22, 2013, 08:08 (3820 days ago)

Can I show Number of Items added in Last 24 Hours in side tab of my selfoss...?
Is there any code for that?

Number of Items added in Last 24 Hours

by blogillu, Saturday, June 22, 2013, 15:00 (3820 days ago) @ blogillu

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'];

RSS Feed of thread
powered by my little forum