I've been looking around the forums and found code to display a count of buddies a user has added to their buddylist...

$result = "SELECT DISTINCT(u.uid) as buddy, u.access FROM {buddylist} b INNER JOIN {users} u ON b.uid = u.uid WHERE b.buddy = %d ORDER BY u.access DESC";
print '<p class="column">Total number of fans: ' . $result->buddy . '</p>';

My problem is how can I change this to display the total number of users who have added me to their buddylist? Instead of showing who I added to my buddylist.

Thanks in advance for any help...

Comments

walker2238’s picture

walker2238 commented

Please ignore the above code as that is my lame attempt at getting it to show people who added me to their buddylist without even using COUNT haha dumb.... the code I am using to show who I added is as follows

$result = db_fetch_object(db_query('SELECT COUNT(*) AS how_many FROM {buddylist} WHERE uid = %d', $user->uid));
print '<p class="column">Total number of favorites: ' . $result->how_many . '</p>';

Sorry...

walker2238’s picture

walker2238 commented

Well I figured it out. So if anyone else is looking for this here is how you show the number of users who added you to their buddylist... to be displayed in the users profile... Nice module BTW very well documented. 

$result = db_fetch_object(db_query('SELECT COUNT(*) AS how_many FROM {buddylist} b INNER JOIN {users} u ON b.uid = u.uid WHERE b.buddy = %d', $user->uid));
print '<p class="column">Total number of users who have added you to their buddylist: ' . $result->how_many . '</p>';