From 7a1db2e08335cc47dddd4712416ac65678efa8e1 Mon Sep 17 00:00:00 2001 From: Michael Vogel Date: Thu, 16 Apr 2015 06:47:09 +0200 Subject: [PATCH] Only show one notification per parent --- mod/ping.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/mod/ping.php b/mod/ping.php index 6207663391..6545ab458b 100644 --- a/mod/ping.php +++ b/mod/ping.php @@ -22,24 +22,24 @@ function ping_init(&$a) { $firehose = intval(get_pconfig(local_user(),'system','notify_full')); - $t = q("select count(*) as `total` from `notify` where `uid` = %d and `seen` = 0 AND `msg` != ''", + $t = q("select count(*) as `total` from `notify` where `uid` = %d and `seen` = 0 AND `msg` != '' GROUP BY `parent`", intval(local_user()) ); if($t && intval($t[0]['total']) > 49) { $z = q("select * from notify where uid = %d AND `msg` != '' - and seen = 0 order by date desc limit 0, 50", + and seen = 0 GROUP BY `parent` order by date desc limit 0, 50", intval(local_user()) ); $sysnotify = $t[0]['total']; } else { $z1 = q("select * from notify where uid = %d AND `msg` != '' - and seen = 0 order by date desc limit 0, 50", + and seen = 0 GROUP BY `parent` order by date desc limit 0, 50", intval(local_user()) ); $z2 = q("select * from notify where uid = %d AND `msg` != '' - and seen = 1 order by date desc limit 0, %d", + and seen = 1 GROUP BY `parent` order by date desc limit 0, %d", intval(local_user()), intval(50 - intval($t[0]['total'])) ); -- 2.39.5