Automatically Add a New User to Their Referrer's Buddy List

This one was done by request. It's a simple, easy to install hack that will take you less than 5 minutes to install. No screenshots because there's nothing to shoot.

If a new person registers at your board and lists an existing member as a referrer, this will automatically add the new user to the referrer's buddy list. And, the honor will be automatically reciprocated.

This is a great hack for beginners to try because it involves only one file edit and no templates, phrases, or database changes.

Enjoy

[T3MEDIA]

any idea on how to change this to just the new user addes the referrer as a buddy only? (instead of doing both the new user and the referrer)

[T3MEDIA]

bump

[Colin F]

T3MEDIA, amykhar didn't check the supported field, so please don't keep bumping the thread.

Thanks.

[T3MEDIA]

Any idea on how to change this to just the new user addes the referrer as a buddy only? (instead of doing both the new user and the referrer)
Colin F (please.) I can ask others. chilax.

[amykhar]

Announcement: I will not be porting this hack to 3.5. It did not have enough interest to warrant the effort.

[akanevsky]

Okay, you got some excess queries and code here...

There is no reason behind veryfind referrer's id, because it is already verified by vBulletin... All you need to do is this:

After

PHP Code:

 if (!$testreferrerid = $DB_site->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE username = '" . addslashes(htmlspecialchars_uni($_POST['referrername'])) . "'"))
 {
    eval('$errors[130] = "' . fetch_phrase('badreferrer', PHRASETYPEID_ERROR) . '";');
 } 


Add

PHP Code:

    else
 {
    $DB_site->query("
        UPDATE " . TABLE_PREFIX . "usertextfield
        SET buddylist = TRIM(CONCAT(buddylist, ' ', '$testreferrerid[userid]'))
        WHERE username = '" . addslashes(htmlspecialchars_uni($_POST['referrername'])) . "'
    ");
 } 


And this

PHP Code:

 if ($referrer)
 {
    // Put it in the database.
    $DB_site->query("
           UPDATE " . TABLE_PREFIX . "usertextfield
           SET buddylist = '" . addslashes($testreferrerid[userid]) . "'
           WHERE userid = $userid
    ");
 } 


Should be replaced by

PHP Code:

    if ($referrer)
 {
    // Put it in the database.
    $DB_site->query("
        UPDATE " . TABLE_PREFIX . "usertextfield
        SET buddylist = '$testreferrerid[userid]'
        WHERE userid = '$userid';
    ");
 } 


Oops, looks like I have rewritten your hack. Oh well.. :P