Number of Items added in Last 24 Hours

by blogillu, Saturday, June 22, 2013, 15:00 (4319 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'];