[Boofo]

Originally Posted by surfhog

ops!!! removed i hope
okay I will do as you say and thanks again

Ok, here is your fix.

Replace the top referrer code in the index.php with this:

PHP Code:

    // <!-- TOP REFERRER -->
    $ref = $DB_site->query_first("
        SELECT COUNT(*) AS referrals, user.username, user.userid
        FROM " . TABLE_PREFIX . "user AS users
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (users.referrerid = user.userid)
        WHERE users.referrerid <> 0
        AND users.referrerid NOT IN (1)
        GROUP BY users.referrerid
        ORDER BY referrals
        DESC LIMIT 1
    "); 


Thanks to NTLDR for fiinding my mistake.