view_users();
$icon_array['ok'] = cpg_fetch_icon('ok', 1);
$icon_array['search'] = cpg_fetch_icon('search', 1);
$icon_array['add_user'] = cpg_fetch_icon('add_user', 2);
$icon_array['edit'] = cpg_fetch_icon('edit', 2);
if (USER_ID !='') {
if (GALLERY_ADMIN_MODE) {
$lim_user = 0;
$number_of_columns = 10;
}
elseif ($CONFIG['allow_memberlist']) {
$lim_user = 1;
$number_of_columns = 9;
show_memberlist;
}
else {
$lim_user = 2;
cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);
}
}
else {
$lim_user = 3;
cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);
}
function show_memberlist()
{
cpg_db_query("DELETE FROM {$CONFIG['TABLE_USERS']} WHERE user_name = '' LIMIT 1");
pageheader($lang_usermgr_php['title']);
list_users();
pagefooter();
}
function list_group_alb_access($group_id) { //shows a list of albums a specific group can see. Categories are listed with albums for clarity
global $CONFIG, $group_id, $aid, $icon_array;
$query = "
SELECT
group_id, albums.aid AS aid, group_name, categories.name AS category, albums.title AS album
FROM
{$CONFIG['TABLE_USERGROUPS']} AS groups,
{$CONFIG['TABLE_ALBUMS']} AS albums
LEFT JOIN
{$CONFIG['TABLE_CATEGORIES']} AS categories
ON
albums.category = categories.cid
WHERE
group_id = $group_id AND albums.visibility = groups.group_id
ORDER BY
category, album";
$result = cpg_db_query($query);
$albs = cpg_db_fetch_rowset($result);
mysql_free_result($result);
foreach($albs as $album) {
$aid = $album['aid'];
echo '
';
}
}
function list_groups_alb_access() //shows a list of albums each group can see. Categories are listed with albums for clarity
{
global $CONFIG;
global $lang_usermgr_php, $lang_common, $group_id, $icon_array;
starttable(500, $lang_usermgr_php['groups_alb_access'].' '.cpg_display_help('f=users.htm&as=user_cp_edit_permission_by_group&ae=user_cp_edit_permission_by_group_end', '450', '300'), 3);
$sql = "
SELECT
group_id, group_name, categories.name AS category, albums.title AS album
FROM
{$CONFIG['TABLE_USERGROUPS']} AS groups, {$CONFIG['TABLE_ALBUMS']} AS albums
LEFT JOIN
{$CONFIG['TABLE_CATEGORIES']} AS categories
ON
albums.category = categories.cid
WHERE
albums.visibility = groups.group_id
GROUP BY
group_name
ORDER BY
group_name, category, album
";
$result = cpg_db_query($sql);
$groups = cpg_db_fetch_rowset($result);
mysql_free_result($result);
echo "