From 2ae0076ae2f08a0f88ad96db4cac0d1b303260ce Mon Sep 17 00:00:00 2001 From: friendica Date: Sat, 28 Jul 2012 17:21:42 -0700 Subject: move today's events into a ping notification --- mod/ping.php | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mod') diff --git a/mod/ping.php b/mod/ping.php index 05bfe7842..99ff48aa7 100644 --- a/mod/ping.php +++ b/mod/ping.php @@ -14,6 +14,7 @@ function ping_init(&$a) { $result['intros'] = 0; $result['mail'] = 0; $result['register'] = 0; + $result['events'] = 0; $result['notice'] = array(); $result['info'] = array(); @@ -154,6 +155,16 @@ function ping_init(&$a) { $t5 = dba_timer(); + $events = q("SELECT count(`event`.`id`) as total FROM `event` + WHERE `event`.`uid` = %d AND `start` < '%s' AND `finish` > '%s' + ORDER BY `start` ASC ", + intval(local_user()), + dbesc(datetime_convert('UTC','UTC','now + 1 days')), + dbesc(datetime_convert('UTC','UTC','now')) + ); + + if($events) + $result['events'] = intval($events[0]['total']); $x = json_encode($result); -- cgit v1.2.3