Quickly Add or Remove Users from Buddy List

[noonespecial]

I'm looking to quickly add a user into the buddylist array - or then remove it from that array with a different command.

So if user A wants to add user B to their buddylist, it runs a quick check, then alters that column (usertextfield.buddylist).

If they want to remove the buddy - it removes the ID from usertextfield.buddylist.

What's the SQL for this? Do I have to first grab all the data from buddylist, and then add the value, and then put it back in? Is there a easier way?

[Lynne]

Are you thinking of writing this as a Mod because there already is one: Buddy & Ignore List Add/Remove in Postbit I'm sure you can download that and see what the query is.

[noonespecial]

That just provides a link to send someone to the profile.php page to add buddies. That page for adding buddies is absolutely annoying.

[MoT3rror]

This is how I add friends through php.

PHP Code:

$db->query_write("
                REPLACE INTO " . TABLE_PREFIX . "userlist
                    (userid, relationid, type, friend)
                VALUES
                    ($userid2, $userid, 'buddy', 'yes'),
                    ($userid, $userid2, 'buddy', 'yes')
            ");

$db->query_write("
                UPDATE " . TABLE_PREFIX . "user
                SET friendcount = friendcount + 1
                WHERE userid IN ($userid2, " . $userid . ")
            ");

            $db->query_write("
                UPDATE " . TABLE_PREFIX . "user
                SET friendreqcount = IF(friendreqcount > 0, friendreqcount - 1, 0)
                WHERE userid = " . $userid
            );

require_once(DIR . '/includes/functions_databuild.php');
build_userlist($userid);
build_userlist($userid2); 


[noonespecial]

Originally Posted by MoT3rror

This is how I add friends through php.

PHP Code:

$db->query_write("
                REPLACE INTO " . TABLE_PREFIX . "userlist
                    (userid, relationid, type, friend)
                VALUES
                    ($userid2, $userid, 'buddy', 'yes'),
                    ($userid, $userid2, 'buddy', 'yes')
            ");

$db->query_write("
                UPDATE " . TABLE_PREFIX . "user
                SET friendcount = friendcount + 1
                WHERE userid IN ($userid2, " . $userid . ")
            ");

            $db->query_write("
                UPDATE " . TABLE_PREFIX . "user
                SET friendreqcount = IF(friendreqcount > 0, friendreqcount - 1, 0)
                WHERE userid = " . $userid
            );

require_once(DIR . '/includes/functions_databuild.php');
build_userlist($userid);
build_userlist($userid2); 


So using a different table than VB's default?

Interesting.

[MoT3rror]

It is code for vBulletin 3.7. Probably different then 3.6 or 3.5.

[noonespecial]

Yep, it is. :-/

That's too bad - that's easier to manipulate and get at the data. 3.6 is different.

--------------- Added [DATE]1208820707[/DATE] at [TIME]1208820707[/TIME] ---------------

I ended up just doing it kinda like this:

PHP Code:

require_once('./global.php');
require_once(DIR . '/includes/functions_user.php');

$userid = $vbulletin->input->clean_gpc('r', 'u', TYPE_UINT); 
$buddylist=explode(' ', trim($vbulletin->userinfo['buddylist']));

if (!in_array($userid, $buddylist))
{
$db->query_write("update usertextfield 
SET buddylist = '".$vbulletin->userinfo['buddylist']." $userid'
WHERE userid=".$vbulletin->userinfo['userid']."
");
}
else
{
echo "Already your friend ++++head.";
} 


--------------- Added [DATE]1208821038[/DATE] at [TIME]1208821038[/TIME] ---------------

If anyone has a better/more efficient way -- I'd love to hear it.

Thanks!