[evenmonkeys]

Okay... I think I've found the problem, but I can't seem to fix it...

This is showing 72 referrals:

PHP Code:

// ****************************************
// REFERRALS - NOT WORKING
    $yarubrefcount = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . " user WHERE referrerid = '$vbulletin->userinfo[userid]'");
    $yarubreferrals = vb_number_format($yarubrefcount['count']); 


This is showing 5 referrals (correct):

PHP Code:

// ****************************************
// REFERRALS - WORKING
    $yarubrefcount = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . " user WHERE referrerid = '1'");
    $yarubreferrals = vb_number_format($yarubrefcount['count']); 


However, I can't put in a number as that wouldn't do me any good for other members. =\ The problem's obviously the "where" part... Any ideas?