+ if ( $network )
+ {
+ # Find out how unseen network posts are spread across groups
+ $sql = "SELECT g.id, g.name, count(i.id) count " .
+ "FROM `group` g, group_member gm, item i " .
+ "WHERE g.uid = %d " .
+ "AND i.uid = %d " .
+ "AND i.unseen AND i.visible " .
+ "AND NOT i.deleted " .
+ "AND i.`contact-id` = gm.`contact-id` " .
+ "AND gm.gid = g.id GROUP BY g.id";
+ #echo '<SQL id="' . intval(local_user()) . '">' . $sql . '</SQL>';
+ $network_group = q($sql, intval(local_user()), intval(local_user()));
+ #echo '<COUNT R="' . count($network_group) . '"/>';
+ }
+