From b19764c9a1842cc366ffb641984395210e92c2b1 Mon Sep 17 00:00:00 2001 From: friendica Date: Wed, 13 Feb 2013 04:12:13 -0800 Subject: fix to common friends - it seems it counts the right number of common friends, but they are all you --- include/socgraph.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'include/socgraph.php') diff --git a/include/socgraph.php b/include/socgraph.php index 7e2d65bb4..f6be92657 100644 --- a/include/socgraph.php +++ b/include/socgraph.php @@ -165,7 +165,7 @@ function common_friends($uid,$xchan,$start = 0,$limit=100000000,$shuffle = false else $sql_extra = " order by xchan_name asc "; - $r = q("SELECT * from xchan left join xlink on xlink_xchan = xchan_hash where xlink_xchan = '%s' and xlink_link in + $r = q("SELECT * from xchan left join xlink on xlink_link = xchan_hash where xlink_xchan = '%s' and xlink_link in (select abook_xchan from abook where abook_xchan != '%s' and abook_channel = %d and abook_flags = 0 ) $sql_extra limit %d, %d", dbesc($xchan), dbesc($xchan), -- cgit v1.2.3