This problem is solved and solution will be available soon.
open index.php and replace the whole function
function list_users()
{
}
with this:
function list_users()
{
global $CONFIG, $PAGE, $FORBIDDEN_SET, $CPG_M_DIR;
global $lang_list_users, $lang_errors, $template_user_list_info_box;
global $field_user_id, $field_user_name;
$sql = "SELECT $field_user_id, " .
"$field_user_name, " .
"COUNT(DISTINCT a.aid) as alb_count, " .
"COUNT(DISTINCT pid) as pic_count, " .
"MAX(pid) as thumb_pid " .
"FROM {$CONFIG['TABLE_USERS']} AS u " .
"INNER JOIN {$CONFIG['TABLE_USERGROUPS']} AS g ON user_group_cp = group_id " .
"INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON category = " . FIRST_USER_CAT . " + $field_user_id " .
"LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.aid = a.aid AND approved = 'YES' $FORBIDDEN_SET) " .
"GROUP BY user_id ORDER BY $field_user_name";
$result = db_query($sql);
$user_count = mysql_num_rows($result);
if (!$user_count) {
msg_box($lang_list_users['user_list'], $lang_list_users['no_user_gal'], '', '', '100%');
mysql_free_result($result);
return;
}
$user_per_page = $CONFIG['thumbcols'] * $CONFIG['thumbrows'];
$totalPages = ceil($user_count / $user_per_page);
if ($PAGE > $totalPages) $PAGE = 1;
$lower_limit = ($PAGE-1) * $user_per_page;
$upper_limit = min($user_count, $PAGE * $user_per_page);
$row_count = $upper_limit - $lower_limit;
$rowset = array();
$i = 0;
mysql_data_seek($result, $lower_limit);
while (($row = mysql_fetch_array($result)) && ($i++ < $row_count)) $rowset[] = $row;
mysql_free_result($result);
$user_list = array();
for ($i = 0; $i < $row_count; $i++) {
$user = &$rowset[$i];
$user_thumb = '<img src="' . $CPG_M_DIR . '/images/nopic.jpg" class="image" border="0">';
$user_pic_count = $user['pic_count'];
$user_thumb_pid = $user['thumb_pid'];
$user_album_count = $user['alb_count'];
if ($user_pic_count) {
$sql = "SELECT filepath, filename, url_prefix, pwidth, pheight " .
"FROM {$CONFIG['TABLE_PICTURES']} " .
"WHERE pid='$user_thumb_pid'";
$result = db_query($sql);
if (mysql_num_rows($result)) {
$picture = mysql_fetch_array($result);
mysql_free_result($result);
$image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['thumb_width']);
$user_thumb = "<img src=\"" . get_pic_url($picture, 'thumb') . "\" {$image_size['geom']} alt=\"\" border=\"0\" class=\"image\">";
}
}
$albums_txt = sprintf($lang_list_users['n_albums'], $user_album_count);
$pictures_txt = sprintf($lang_list_users['n_pics'], $user_pic_count);
$params = array('{username}' => $user[$field_user_name],
'{USER_ID}' => $user[$field_user_id],
'{ALBUMS}' => $albums_txt,
'{PICTURES}' => $pictures_txt,
);
$caption = template_eval($template_user_list_info_box, $params);
$user_list[] = array('cat' => FIRST_USER_CAT + $user[$field_user_id],
'image' => $user_thumb,
'caption' => $caption,
);
}
theme_display_thumbnails($user_list, $user_count, '', '', 1, $PAGE, $totalPages, false, true, 'user');
}