new function in u.module.php

[code]
function mutualfriends($url = 0) {
global $client, $apps, $uhome,$ubase, $current_sub_menu, $offset, $num_per_page, $page;
$profile = $this->settabmenu($url, 1,'u');
$current_sub_menu['href'] = 'u/'.$url.'/friends';

    // Mutual friends
    $output = '<ul class="small_avatars">';
    $res = sql_query("SELECT u.* FROM `".tb()."friends` as f1 inner join `".tb()."friends` as f2 on f1.fid = f2.fid left join `".tb()."accounts` as u on f1.fid=u.id where f1.uid={$profile['id']} and f2.uid={$client['id']}  ORDER BY f1.created DESC LIMIT $offset, $num_per_page");
    while ($row = sql_fetch_array($res)) {
        $output .= '<li>';
        $output .= '<span>'.url('u/'.$row['username'], $row['username']).'</span> '.avatar($row);
        $output .= '</li>';
    }
    $output .= '</ul>';

    // pager
    $res = sql_query("select count(*) as total from `".tb()."friends` as f1 inner join `".tb()."friends` as f2 on f1.fid = f2.fid where f1.uid={$profile['id']} and f2.uid={$client['id']} ".dbhold() );
    $row = sql_fetch_array($res);
    $total = $row['total'];
    $pb       = new PageBar($total, $num_per_page, $page);
    $pb->paras = $ubase.'u/'.$profile['username'].'/friends';
    $pagebar  = $pb->whole_num_bar();
    $output .= $pagebar;

    section(
        array('title'=>t('Mutual Friends'),
        'content'=>$output)
        );
}   

[/code]

added some code in the function show_sidebar

before

[code]
//friends
[/code]

[code]
// Mutual friends
$res = sql_query("SELECT u.* FROM ".tb()."friends as f1 inner join ".tb()."friends as f2 on f1.fid = f2.fid left join ".tb()."accounts as u on f1.fid=u.id where f1.uid={$owner['id']} and f2.uid={$client['id']} ".dbhold('f1')." ORDER BY f1.created DESC LIMIT 30");
$output = '';
while ($row = sql_fetch_array($res)) {
$f = 1;
$output .= avatar($row);
}
ass(array('title'=>t('Mutual Friends'), 'content' => '<div class="toolbar">'.url('u/'.$owner['username'] .'/mutualfriends',t('See all')).'</div>'.$output));
[/code]

very nice.. Falcone the Master of Jcow..

yep dj master jcow

is it possible in v3.3 ?

nice I get it . thanks falcone

nice job falcon. its work perfect at my network. thanks.

[quote=defender]

is it possible in v3.3 ? [/quote]

no need , thanks again,
only one thing
when I look at my profile, mutual and my friends are the same, it is possible not show mutual at own profile ?

[quote=defender]

when I look at my profile, mutual and my friends are the same, it is possible not show mutual at own profile ? [/quote]

yes, is it possible to hide it from (my profil) ?

when i pusch the link (see all) under Mutual Friends.

I get this error code:

Fatal error: Call to undefined method u::mutualfriends() in /mnt/webcluster1storage4/T/theracew/www/index.php on line 33

the are two parts, a new function called mutualfriends and a new section.

did you add the mutualfriends function in the u.module.php file (or u.php for older versions) ?

do you have the script to hide mutual friend from (my profil) ?

[code]
// Mutual friends
if ($client['id'] != ($owner['id']) ) {

    $res = sql_query("SELECT u.* FROM `".tb()."friends` as f1 inner join `".tb()."friends` as f2 on f1.fid = f2.fid left join `".tb()."accounts` as u  on f1.fid=u.id where f1.uid={$owner['id']} and f2.uid={$client['id']} ".dbhold('f1')." ORDER BY f1.created DESC LIMIT 30");
    $mfs = sql_counts($res);
    $output = '';
    while ($row = sql_fetch_array($res)) {
        $output .= avatar($row);
    }
    if ($mfs > 0) {
    $mfstext = ($mfs == 1)?t(' friend in common'):t(' friends in common');  
    ass(array('title'=>t('Mutual Friends'), 'content' => '<div class="toolbar"><span style="float:left">'.$mfs.$mfstext.'</span><span style="float:right">'.url('u/'.$owner['username'] .'/mutualfriends',t('See all')).'</span></div><div style="clear:both;"></div>'.$output));
    }

}
[/code]

oke falcone thanks. i will try.