[rellect] Mutual Friends

[rellect]

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

[infun]

Excellent
I installed.

[rellect]

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

[datoneer]

Sorry but i don't see mutual friends anywhere...vb 4.1.8

[rellect]

Sorry but i don't see mutual friends anywhere...vb 4.1.8
The mutual friends block is not visible in following cases:
You view your own profile
You have no mutual friends with the user that you are viewing his profile (contact users doesn't counts as friends)
You are viewing the user profile as a guestBe sure that you actually have mutual friends with the user that you view his profile.
If you are sure that you have mutual friends with the user,
Send me a link to the forum and I'll check it out.

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

[datoneer]

Sorry mate my mistake. Works perfect!

[OldSchoolDSL]

Installed and working

4.1.9

[MalluParadise]

can u add the option to dis enable Tab or block. If a person like me a block, we can enable tabs and see the mutual friends.

[rellect]

can u add the option to dis enable Tab or block. If a person like me a block, we can enable tabs and see the mutual friends.
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.

[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:


Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vb_userlist
WHERE userlist.userid = 3
AND userlist.relationid IN
(
SELECT relationid
FROM vb_userlist
WHERE userlist.userid = 1
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'

[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]

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]

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. :cool:

[rellect]

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:

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.

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

why can't u give a option wat ever we want to enable through Admin cp
I will consider that in the next version :)

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. :cool:
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]

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 :p

The mutual friends block is not visible in following cases:
You view your own profile
You have no mutual friends with the user that you are viewing his profile (contact users doesn't counts as friends)
You are viewing the user profile as a guestBe 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]

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.

[rellect]

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.
Oh now I see what you mean.
I will consider that but for a new mod, if I will build it..
Anyway the contacts for my opinion are useless..
friends should be the only option..

[TheLastSuperman]

Another good idea, I like your recent releases - Keep up the good work and thanks for being part of the community! :cool:

[rellect]

Another good idea, I like your recent releases - Keep up the good work and thanks for being part of the community! :cool:
Thanks :)

[Mr_Running]

Oh now I see what you mean.
I will consider that but for a new mod, if I will build it..
Anyway the contacts for my opinion are useless..
friends should be the only option..

Yes I agree friends should be the only option.
Now being able to put friends into different lists now that would be something...

Thank you for the Mutual Friends mod. :D

[rellect]

Yes I agree friends should be the only option.
Now being able to put friends into different lists now that would be something...

Thank you for the Mutual Friends mod. :D
you are welcome :)

[Mariner1]

Doesnt work for me,using 4.18.Ive looked at a freinds profile,no tab there

[rellect]

Doesnt work for me,using 4.18.Ive looked at a freinds profile,no tab there
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.

the block and the tab are automatically hidden if you don't have mutual friends with the user that you view his profil.

[Mariner1]

when you say friends in common do you mean people you add as a friend

[rellect]

when you say friends in common do you mean people you add as a friend
I'm mean to users that they friends of yours and friends of the user that you are viewing his profile.
in every user profile you will see other mutual friends because it depends on the user you are viewing his profile
but if there is no mutual friends, the block will be invisible

[Bubble #5]

4.2.1

No such block is showing up in profile.

Can we add the block manually?

[rellect]

4.2.1

No such block is showing up in profile.

Can we add the block manually?
I've tested the mod in 4.2.1 and it works.
Please read this message (https://vborg.vbsupport.ru/showpost.php?p=2278843&postcount=18). If you still believe there is an issue, contact with me in PM.

[hazem_aliraqi]

thanks ... installed