Dragonfly CMS - German Community

// Inserts a thumbnail if the album contains 1 or more images
        $visibility = $alb_thumb['visibility'];
        if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || $visibility == 

$USER_DATA['group_id'] || USER_IS_ADMIN || user_ingroup($visibility,$USER_DATA['user_group_list_cp'])) 

{
            if ($count > 0) { // Inserts a thumbnail if the album contains 1 or more images
                if ($alb_thumb['filename']) {
                    $picture = &$alb_thumb;
                } else {
                    $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight FROM 

{$CONFIG['TABLE_PICTURES']} WHERE pid='{$alb_stat['last_pid']}'";
                    $result = $db->sql_query($sql, false,__FILE__,__LINE__);
                    $picture = $db->sql_fetchrow($result);
                    $db->sql_freeresult($result);
                } 
                $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], 

$CONFIG['alb_list_thumb_size']);
                $alb_list[$alb_idx]['thumb_pic'] = "<img src=\"" . get_pic_url($picture, 'thumb') . 

"\" {$image_size['geom']} title=\"".$alb_thumb['title']."\" alt=\"".$alb_thumb['title']."\" 

border=\"0\" class=\"image\" />";
            } else { // Inserts an empty thumbnail if the album contains 0 images
                $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']);
                $alb_list[$alb_idx]['thumb_pic'] = "<img src=\"$CPG_M_DIR/images/nopic.jpg\" 

{$image_size['geom']} alt=\"".NO_IMG_TO_DISPLAY."\" title=\"".NO_IMG_TO_DISPLAY."\" border=\"0\" 

class=\"image\" />";
            } 
        } elseif ($CONFIG['show_private']) {
            $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']);
            $alb_list[$alb_idx]['thumb_pic'] = "<img src=\"$CPG_M_DIR/images/private.jpg\" 

{$image_size['geom']} alt=\"".MEMBERS_ONLY."\" title=\"".MEMBERS_ONLY."\" border=\"0\" class=\"image\" 

/>";
        } 

        // Prepare everything
        $last_upload_date = $count ? localised_date($alb_stat['last_upload'], LASTUP_DATE_FMT) : '';
        $alb_list[$alb_idx]['aid'] = $alb_thumb['aid'];
        $alb_list[$alb_idx]['album_title'] = $alb_thumb['title'];
        $alb_list[$alb_idx]['album_desc'] = decode_bbcode($alb_thumb['description']);
        $alb_list[$alb_idx]['pic_count'] = $count;
        $alb_list[$alb_idx]['last_upl'] = $last_upload_date;
        $alb_list[$alb_idx]['album_info'] = sprintf(N_PICTURES, $count) . ($count ? 

sprintf(LAST_ADDED, $last_upload_date) : "");
        $alb_list[$alb_idx]['album_adm_menu'] = (GALLERY_ADMIN_MODE || (USER_ADMIN_MODE && $cat == 

USER_ID + FIRST_USER_CAT)) ? html_albummenu($alb_thumb['aid']) : '';
    }

    if ($buffer) {
        ob_start();
        theme_display_album_list_cat($alb_list, $nbAlb, $cat, $PAGE, $totalPages);
        $cat_albums = ob_get_contents();
        ob_end_clean();
        return $cat_albums;
    }
    else{
        theme_display_album_list($alb_list, $nbAlb, $cat, $PAGE, $totalPages);
       }
}

if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || $visibility == $USER_DATA['group_id'] || USER_IS_ADMIN)

if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || $visibility == $USER_DATA['group_id'] || USER_IS_ADMIN || user_ingroup($visibility,$USER_DATA['user_group_list_cp']))

function list_users()
{
    global $db, $CONFIG, $PAGE, $CPG_M_DIR, $CPG_M_URL;
    global $template_user_list_info_box;
    global $field_user_id, $field_user_name;
    $sql = "SELECT $field_user_id, " .
           "$field_user_name, user_avatar as avatar, user_avatar_type, a.title, " .
           "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_ALBUMS']} AS a ON (category = " . FIRST_USER_CAT . " + $field_user_id " . " AND ".VIS_GROUPS.")".
           "LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.aid = a.aid AND approved = 'YES') " .
           "GROUP BY $field_user_id ORDER BY $field_user_name";
    $result = $db->sql_query($sql, false,__FILE__,__LINE__);
    $user_count = $db->sql_numrows($result);
    if (!$user_count) {
        msg_box(USER_LIST, NO_USER_GAL, '', '', '100%');
        $db->sql_freeresult($result);
        return;
    } 

$result = $db->sql_query($sql, false,__FILE__,__LINE__);