Profile Enhancements - [rellect] Mutual Friends

Mutual Friends

If you installed the mod, please "Mark as Installed".

Description:
This mod adds a new block (and tab) to the profile which shows the mutual friends of you and the user. Just like in facebook.

Compatibility:
vBulletin 4.1.0 and newer.

Installations:
You don't have to change anything in the templates/files, just upload the plugin and that's all.
AdminCP > Plugins & Products > Manage Products > [Add/Import Product]

History:

• [17-12-11] v1.0:
  First Release
  [17-12-11] v1.1:
  Fixed: contact users were counted as friends.
• [18-12-11] v1.2
  Fixed: sql error

[Taurus1]

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbuserlist
WHERE userlist.userid = 5798
AND userlist.relationid IN
(
SELECT relationid
FROM vbuserlist
WHERE userlist.userid = 3
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
)
AND userlist.type = 'buddy'
AND userlist.friend = 'yes';

MySQL Error : Unknown column 'userlist.userid' in 'where clause'
Error Number : 1054
Request Date : Saturday, December 17th 2011 @ 11:15:18 PM
Error Date : Saturday, December 17th 2011 @ 11:15:18 PM
Script : ******************
Referrer : ****************
IP Address : *************
Username : ***********
Classname : vB_Database
MySQL Version : 5.1.56-log

Please advise. Thanks.

[MalluParadise]

Originally Posted by RellecT

I can, But if you have many mutual friends, there will be no enough space in the block to display all the users.. that the reason why there is a tab.

why can't u give a option wat ever we want to enable through Admin cp

[alencete]

I have a similar problem witch db on 4.1.8

[Mr_Running]

Originally Posted by RellecT

I release new version (1.1) that fix a bug: contact users were counted as friends.

Awesome !

Now a Contacts option list would be nice too.
Maybe viewable only by the logged in user looking at their own profile...it does not need to be viewable by everyone else.

I wonder if the Mutual Friends could be listed within the Friends Tab? Maybe friends on the left and mutual friends on the right.
Contacts could be a third row.

[rellect]

Originally Posted by paulket

I would love to use this mod but there is a conflict with it and the Forum Members (membelist.php) mod by ChrisTERiS

I get this database error when they are both enabled:

Originally Posted by Taurus1

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbuserlist
WHERE userlist.userid = 5798
AND userlist.relationid IN
(
SELECT relationid
FROM vbuserlist
WHERE userlist.userid = 3
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
)
AND userlist.type = 'buddy'
AND userlist.friend = 'yes';

MySQL Error : Unknown column 'userlist.userid' in 'where clause'
Error Number : 1054
Request Date : Saturday, December 17th 2011 @ 11:15:18 PM
Error Date : Saturday, December 17th 2011 @ 11:15:18 PM
Script : ******************
Referrer : ****************
IP Address : *************
Username : ***********
Classname : vB_Database
MySQL Version : 5.1.56-log

Please advise. Thanks.

Originally Posted by alencete

I have a similar problem witch db on 4.1.8

I've released new version 1.2 that suppose to fix that.
There was a little mistake in the query..
my server ignored that so I coudn't know about it.
I have fixed the query, please check if it works now

Originally Posted by MalluParadise

why can't u give a option wat ever we want to enable through Admin cp

I will consider that in the next version

Originally Posted by Mr_Running

Awesome !

Now a Contacts option list would be nice too.
Maybe viewable only by the logged in user looking at their own profile...it does not need to be viewable by everyone else.

I wonder if the Mutual Friends could be listed within the Friends Tab? Maybe friends on the left and mutual friends on the right.
Contacts could be a third row.

What do you mean? "Mutual Contacts"?

About the other thing, I pretty sure that it can't be done that way but I will check it.

[mitch84]

hi, after install I can't see new tab in my profil, because I haven't mutual friend or a other problem? thx

[paulket]

Installed and it is working perfectly now

[rellect]

Originally Posted by mitch84

hi, after install I can't see new tab in my profil, because I haven't mutual friend or a other problem? thx

The mutual friends block not visible on your own profile..
from the simple fact that you don't have mutual friends with yourself

The mutual friends block is not visible in following cases:

1. You view your own profile
2. You have no mutual friends with the user that you are viewing his profile (contact users doesn't counts as friends)
3. You are viewing the user profile as a guest

Be sure that you actually have mutual friends with the user that you view his profile.
remember that mutual friends are friends that you have in common with the user you are viewing his profile.

[OldSchoolDSL]

Installed today's update and all is working (as it was before)

4.1.9

Thanks

[Mr_Running]

Originally Posted by RellecT

I've released new version 1.2 that suppose to fix that.
There was a little mistake in the query..
my server ignored that so I coudn't know about it.
I have fixed the query, please check if it works now


I will consider that in the next version


What do you mean? "Mutual Contacts"?

About the other thing, I pretty sure that it can't be done that way but I will check it.

Well Mutual Contacts could be another option.
I was thinking in terms of each user seeing a list of their own Contacts.
The Contacts seem to be a void that vB missed...or maybe I missed the contact list.