From b8c4d73377d93cc54cb10fd1c3fac173c8f57627 Mon Sep 17 00:00:00 2001 From: Friendika Date: Tue, 31 May 2011 19:24:26 -0700 Subject: show group affiliations in contact editor --- include/group.php | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'include/group.php') diff --git a/include/group.php b/include/group.php index d1b336946..804d0c58f 100644 --- a/include/group.php +++ b/include/group.php @@ -185,3 +185,15 @@ function expand_groups($a) { $ret[] = $rr['contact-id']; return $ret; } + + +function member_of($c) { + + $r = q("SELECT `group`.`name`, `group`.`id` FROM `group` LEFT JOIN `group_member` ON `group_member`.`gid` = `group`.`id` WHERE `group_member`.`contact-id` = %d AND `group`.`deleted` = 0 ORDER BY `group`.`name` ASC ", + intval($c) + ); + + return $r; + +} + -- cgit v1.2.3