Who Am I A Buddy Of - Version 2.0

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




Enjoy!

[Gamingforce]

Originally Posted by nexialys

i thought that we had enough with vBFriends - View your social network 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.

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

Originally Posted by Gamingforce

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]

Originally Posted by Gamingforce

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!