- $ev = qu("SELECT count(`event`.`id`) AS total, type, start, adjust FROM `event`
- WHERE `event`.`uid` = %d AND `start` < '%s' AND `finish` > '%s' and `ignore` = 0
- ORDER BY `start` ASC ",
- intval(local_user()),
- dbesc(datetime_convert('UTC', 'UTC', 'now + 7 days')),
- dbesc(datetime_convert('UTC', 'UTC', 'now'))
- );
+ $cachekey = "ping_init:".local_user();
+ $ev = Cache::get($cachekey);
+ if (is_null($ev)) {
+ $ev = qu("SELECT type, start, adjust FROM `event`
+ WHERE `event`.`uid` = %d AND `start` < '%s' AND `finish` > '%s' and `ignore` = 0
+ ORDER BY `start` ASC ",
+ intval(local_user()),
+ dbesc(datetime_convert('UTC', 'UTC', 'now + 7 days')),
+ dbesc(datetime_convert('UTC', 'UTC', 'now'))
+ );
+ if (dbm::is_result($ev)) {
+ Cache::set($cachekey, $ev, CACHE_HOUR);
+ }
+ }