Open file classes/xaFront.class.php and find function
getMembersList. Replace its body with
PHP Code:
$sql = "SELECT SQL_CALC_FOUND_ROWS acc.`id`, acc.`username`, acc.`fullname`, acc.`status`, acc.`avatar`, ";
$sql .= " COUNT(art.`id`) AS amount, acc.`admin` ";
$sql .= " FROM `{$this->mPrefix}accounts` AS acc ";
$sql .= " LEFT JOIN `{$this->mPrefix}articles` AS art ON acc.`id`=art.`id_account` ";
$sql .= "WHERE acc.`admin`='0' ";
$sql .= ($aFilter && 'begins' == $aCondition) ? " AND `username` LIKE '{$aFilter}%' " : '';
$sql .= ($aFilter && 'contains' == $aCondition) ? " AND `username` LIKE '%{$aFilter}%' " : '';
$sql .= " GROUP BY acc.`id` ";
$sql .= " ORDER BY $aOrder ";
$sql .= ($aStart || $aLimit) ? " LIMIT {$aStart},{$aLimit} " : '';
return $this->getAll($sql);