From 82eb265a20d73beff7673299a6c4ab8a4d8b8673 Mon Sep 17 00:00:00 2001 From: friendica Date: Sun, 17 Aug 2014 17:48:41 -0700 Subject: add collections widget to connections page - and some more work on realms --- mod/connections.php | 3 +++ 1 file changed, 3 insertions(+) (limited to 'mod') diff --git a/mod/connections.php b/mod/connections.php index 1875ed908..028889647 100644 --- a/mod/connections.php +++ b/mod/connections.php @@ -337,6 +337,9 @@ function connections_content(&$a) { } $sql_extra .= (($searching) ? protect_sprintf(" AND xchan_name like '%$search_txt%' ") : ""); + if($_REQUEST['gid']) { + $sql_extra .= " and xchan_hash in ( select xchan from group_member where gid = " . intval($_REQUEST['gid']) . " and uid = " . intval(local_user()) . " ) "; + } $r = q("SELECT COUNT(abook.abook_id) AS total FROM abook left join xchan on abook.abook_xchan = xchan.xchan_hash where abook_channel = %d and not (abook_flags & %d) and not (xchan_flags & %d ) $sql_extra $sql_extra2 ", -- cgit v1.2.3