[surfhog]

thanks boofo

finally this appears to work now without any errors

I will post on the other threa ref forum quick stats, which i still have error

Originally Posted by Boofo

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.