Who Am I A Buddy Of - Version 2.0

[Gamingforce]

[ Feature Description ]
This feature allows users to easily see who they are buddies of along with an easy way to add/remove buddies right from the page! This modification is a big upgrade from the one I made for vBulletin 2. It has proved to be a very useful tool for my members. As of this version, there are noother known performance optimization techniques, nobugs and no security problems.

[ Version 2.0 Fix Log ]
2.00 -> 2.01 - July 20, 2004

Updated a non code related error in the installation instructions. (Bug finder: Dennis B)
Fixed a bug for people using tables with prefixes. (Bug finder: the Sandman)
2.00 -> 2.01 - July 20, 2004

Fixed a small warning that was displayed if zero people had you on their buddy list. (Bug finder: Zelda King)
Templates are now cached. (Bug finder: Zelda King)
[ Updates From Version 1.0 ]

Uses only one query to get all the information needed for this! (This took me a while to figure out but I got it all into one query using regular expressions and left joins).
User CP navigation link and proper displaying added.
Better formatting.
Easy add/remove buddies from the list with a "- buddy" if a user is already a buddy and a "+ buddy" if the user is not a buddy.
Percentage of users that are mutual buddies (both of you have each other on buddy lists).
Updated a security bug.
Huge performance increase.
Fixed the big bug that didn't display results if your userid was at the beginning or end of the buddylist.
[ Screenshots ]
http://www.gamingforce.com/chocobo/whobuddies-cp.gif

http://www.gamingforce.com/chocobo/whobuddies.gif

Enjoy! :)

[turbidblue]

am i first? awesome!

super easy install and very very cool!

thanks so much!

* turbidblue clicks install :)

[JagFan]

Thank you for this! Great hack!! (yes, very easy install!!)

[Koutaru]

Excellent hack I must say and coded well! :) Thanks!

[KTBleeding]

Awesome! I'll be installing this sometime shortly.

[Bryan Ex]

Wonderful addition! It took me all of two minutes to install and works perfectly. Nicely done.

[Zelda-King]

Thanks for the release. I was waiting for you to port this one.

[nexialys]

i thought that we had enough with vBFriends - View your social network (https://vborg.vbsupport.ru/showthread.php?t=66449) is working well, easy to manage, one file script, very attractive look too...

[Zelda-King]

Just a note: the following templates are uncached in whobuddies.php;

USERCP_SHELL (1)
usercp_nav_folderbit (3)
whobuddy (1)

EDIT: Here, I fixed it. :)

EDIT 2: If you have no buddies you get this error: Warning: Division by zero in /domain/url/whobuddies.php on line 50 (note line 50 is counting my template caching [in my attached file]. The default file would be about line 45 or something;
$mutualpercent = round((($mutualcount / $buddycount) * 100),2);).

Also noted: This hack adds a page so a Who's Online location needs adding. I'd post the code but I just used that Custom Add Online Locations hack. :D

No really, I always liked this hack. vBulletin should really be shipped with such a feature, I reckon.

[Gamingforce]

Thank you Zelda-King for spotting these!

2.00 -> 2.01 - July 20, 2004
-Fixed a small warning that was displayed if zero people had you on their buddy list. (Bug finder: Zelda King)
-Templates are now cached. (Bug finder: Zelda King)

To upgrade, all you need to do is download the new attachment in post #1 and upload the new whobuddies.php to your server.

[Gamingforce]

i thought that we had enough with vBFriends - View your social network (https://vborg.vbsupport.ru/showthread.php?t=66449) is working well, easy to manage, one file script, very attractive look too...True, but not everyone wants to make their buddy lists public and I feel like this is more straight-forward. This feature efficiently lists who you are a buddy of and your relationship to that buddy. You can easily add anyone (or remove anyone) from that list with just two clicks. Also, unlike friends.php, this only uses ONE database query whereas the other one can use many depending on how many buddies you have.

[Zelda-King]

Gamingforce: Very prompt fix job. Well done!

(Working perfectly now - v3.0.1.)

[Bro_Joey_Gowdy]

clciks install

[FleaBag]

Been waiting for this, cheers. :D

[Dennis B]

Gamingforce,

Nice job, will install tonite.

Just a remark: in the installation instructions you say:

[OPEN FILE includes/functions_user.php]
==================================================
(...)
==================================================
[CLOSE FILE includes/functions_newpost.php]

[Bryan Ex]

True, but not everyone wants to make their buddy lists public.
That was exactly the concern raised by my members in the past so this suits my board perfectly. Thanks again!

[the Sandman]

The install didn't work for me:


Invalid SQL:
SELECT usertextfield.userid, user.username
FROM vb3_usertextfield
LEFT JOIN vb3_user
USING (userid)
WHERE usertextfield.buddylist REGEXP '[ ]3[ ]'
OR usertextfield.buddylist REGEXP '^3[ ]'
OR usertextfield.buddylist REGEXP '[ ]3$'
ORDER BY user.username ASC

mysql error: Unknown table 'usertextfield' in field list
mysql error number: 1109
Did I mess something up?

[Oblivion Knight]

Very nice, thanks for sharing your work with us Gamingforce.. :)

[Gamingforce]

2.01 -> 2.02 - July 21, 2004
-Updated a non code related error in the installation instructions. (Bug finder: Dennis B)
-Fixed a bug for people using tables with prefixes. (Bug finder: the Sandman)

To upgrade, all you need to do is download the new attachment in post #1 and upload the new whobuddies.php to your server. You do not need to upgrade unless you are using database table prefixes.

[the Sandman]

2.01 -> 2.02 - July 21, 2004
Fixed a bug for people using tables with prefixes. (Bug finder: the Sandman)
That's much better! Thanks!

[Dennis B]

Installed. :)
Great hack, thanks!

[sabredog]

Hahah, a hack from a board I already go to. Good hack; I originally saw it on a vB2 and was wondering where I could find it. Thanks.

[YogiTW]

An interesting twist on this would be instead of comparing buddy lists, compare ignore lists :)

[y2krazy]

/me clicks install!

[Megareus Rex]

Excellent hack! Maybe this'll revive the lost art of the vb3 Buddy list :p:p

*installs*

[Shadow Blaze]

very nice... kinda depressing to be the owner/admin and not be on one users list :-p ^_^

[nautiqeman]

for some reason I don't have anyone in my list even tho I know that I do. I'm using 3.0.3 -- the other person that I know has me, has my name in his list, but I don't have his in mine -- does it have something to do with having multiple people? Because I look at the buddylist and each id is separated by a space. For some reason I think it's only reading the first id and not any others. Anyone else have this problem?

[Borgs8472]

<installs>

[DrkFusion]

I didn't think of this at all. I have a forum where people form networks, largely powered by external scripts, but same database, and the method I use now is tedious, this is much easier.

[shawno]

Gaming force,

Great hack.

One question for you - If User A sees that User B has added them to their buddy list (because unlike MSN messenger you don't have to 'accept' that a user wants to be added to their list) and if User A doesn't want to be a part of User B's buddy list does your hack allow User A to remove themselves from User B's buddy list?

Hope that makes sense.

Shawno

[Dark Aura]

Love this hack, just installed it (Y)

[Lord Brar]

* Lord Brar clicks install :D thanks, just what I was looking for... ;) Seems like now I can fully turn my site into a social networking site :P

[ecarabin]

/me clicks install too !!! so easy to install, thanks !

[Nordinho]

for some reason I don't have anyone in my list even tho I know that I do. I'm using 3.0.3 -- the other person that I know has me, has my name in his list, but I don't have his in mine -- does it have something to do with having multiple people? Because I look at the buddylist and each id is separated by a space. For some reason I think it's only reading the first id and not any others. Anyone else have this problem?

Same problem here...

[MikaK]

*install* Works like a charm.

=M=

[DavidNTD]

In and out.

How easy!

[vau7]

There is an opposite Hack like "who ignores me?, isnt it?
Im sure there has been one, but i cant find it. Does someone knows it?

[wb-legends]

i had my friend add me back to see if the hack worked and while he can see me on the list, i can't see him. is there any way to fix that?

[Julie]

Very cool! Was kinda shocked myself that so many had me on their list :P Hehe... Thanks!

*clicks install*

[yoyoyoyo]

Same problem here...Same here.. nobody on the list, though that is not true. Using 3.0.8.

[dolbex]

Same here.. nobody on the list, though that is not true. Using 3.0.8.

Exact same problem. Also, I wonder if anyone could break down the SQL statement that he is using to query...

[b00k]

Same here.. nobody on the list, though that is not true. Using 3.0.8.

Same here, using 3.0.7

uninstalling.