Find:
// Build SQL table, should work with all bridges
$sql = "SELECT {$f['user_id']} AS user_id, {$f['username']} AS user_name, {$f['email']} AS user_email, {$f['regdate']} AS user_regdate, {$f['lastvisit']} AS user_lastvisit, {$f['active']} AS user_active, "
. "COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota "
. "FROM {$this->usertable} AS u "
. "INNER JOIN `{$C['dbname']}`.{$C['TABLE_USERGROUPS']} AS g ON u.{$f['usertbl_group_id']} = g.group_id "
. "LEFT JOIN `{$C['dbname']}`.{$C['TABLE_PICTURES']} AS p ON p.owner_id = u.{$f['user_id']} "
. $options['search']
. "GROUP BY user_id " . "ORDER BY " . $sort_codes[$options['sort']] . " "
. "LIMIT {$options['lower_limit']}, {$options['users_per_page']};";
and replace with:
// Build SQL table, should work with all bridges
$sql = "SELECT {$f['user_id']} AS user_id, {$f['username']} AS user_name, {$f['email']} AS user_email, {$f['regdate']} AS user_regdate, {$f['lastvisit']} AS user_lastvisit, {$f['active']} AS user_active, "
. "'0' AS pic_count, '0' AS disk_usage, group_name, group_quota "
. "FROM {$this->usertable} AS u "
. "INNER JOIN `{$C['dbname']}`.{$C['TABLE_USERGROUPS']} AS g ON u.{$f['usertbl_group_id']} = g.group_id "
. "LEFT JOIN `{$C['dbname']}`.{$C['TABLE_PICTURES']} AS p ON p.owner_id = u.{$f['user_id']} "
. $options['search']
. "GROUP BY user_id " . "ORDER BY " . $sort_codes[$options['sort']] . " "
. "LIMIT {$options['lower_limit']}, {$options['users_per_page']};";
I forced the return of 0 for those fields - so the fields are still set in the result set... It will just show 0 file/0 space used...