UR common friends

Whats your definition of related users?

This could be everything.

I think this is not a question for VIews. Its a specific question for User Relationships.

See http://drupal.org/node/239162 . I think this is a similar issue

subscribing

I am going to pay for the development of a block/module which will allow mutual friends to be shown. Would anyone be interested in sharing the cost with me?

I also am going to pay for a friend of a friend (people you might know) feature to be developed.

Please let me know if you're interested!

subscribing

subscribing

//This is what i used. I hope it helps.
//arg(2) is the name of viewed profile

function ur_common_friends_block($op='list', $delta=0, $edit=array()){
switch ($op) {
case 'list':
$blocks[0]['info'] = t('Common friends');
return $blocks;
case 'view':
$blocks['subject'] = t('Common Friends');
$blocks['content'] = _get_common_friends();
return $blocks;
}
}

function _get_common_friends(){
$output = '';
global $user;
$account = user_load(arg(2));
$result = db_query("SELECT requestee_id FROM user_relationships AS ur1
WHERE ur1.requester_id = %d AND (ur1.requestee_id IN
(SELECT ur2.requestee_id FROM user_relationships AS ur2
WHERE ur2.requester_id = %d)) ORDER BY RAND()", $user->uid, $account->uid);

while($common_friend = db_fetch_object($result)){
$friend = user_load($common_friend->requestee_id);
$output .= 'picture.'">';
}
return $output;
}

where do you have putted this function?

thx

can u make a view of it?

Closed #692124: Adding a mutual friends block as a duplicate of this issue.

now both issues are closed because of duplicate issue - One should be reopened :-)

This one should still be open, looks active to me.

Realized this is indeed a duplicate as well, leaving #239162: feature: block for "people you might know" as the authoritative mutual friends / common friends / people you might know issue.