Открываем components/users/model.php
312 строка
public function giveInvites
$sql = "SELECT u.id as id, IFNULL((u.invdate < DATE_SUB(NOW(), INTERVAL 1 {$sql_period})) OR u.invdate is NULL, 0) as is_time, IFNULL(SUM(k.points), 0) as karma FROM cms_users u LEFT JOIN cms_user_karma k ON k.user_id = u.id WHERE u.group_id = '1' or u.group_id = '2' GROUP BY u.id ";