Total Number of Friends

[bergs]

I'm trying to display the total number of friends on a user page - if anyone has this working or has any idea how to implement a count function into Pligg 9, them please let me know!

Thanks,
bergs

[bergs]

Figured this out!

I just created a function that counts the number of friends a user has:

function count_friends(){
global $db, $user;
$friends = "SELECT count(*) FROM " . table_friends . " INNER JOIN " . table_users . " ON " . table_friends . ".friend_from = " . table_users . ".user_id WHERE (((" . table_friends . ".friend_to)= " . $user->id . ")) ;";
$count=$db->get_var($friends);
echo $count;
}