[Boofo]

Originally Posted by gspot

Thanks, the file referals.php has been revised to this latest addon thanks to - BOOFO

You almost got it. You forgot to add the TABLE_PREFIX to the tables.

The query should actually be:

PHP Code:

$referrers = $DB_site->query("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 user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT $max");