PHP list_group_alb_access示例

示例#1

文件： usermgr.php 项目： CatBerg-TestOrg/coppermine

function list_groups_alb_access()
{
    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 = "\n      SELECT\n        group_id, group_name, categories.name AS category, albums.title AS album\n      FROM\n        {$CONFIG['TABLE_USERGROUPS']} AS groups, {$CONFIG['TABLE_ALBUMS']} AS albums\n      LEFT JOIN\n        {$CONFIG['TABLE_CATEGORIES']} AS categories\n      ON\n        albums.category = categories.cid\n      WHERE\n        albums.visibility = groups.group_id\n      GROUP BY\n        group_name\n      ORDER BY\n        group_name, category, album\n    ";
    $result = cpg_db_query($sql);
    $groups = cpg_db_fetch_rowset($result, true);
    echo "\n    <td>{$lang_usermgr_php['category']}</td>\n    <td>{$lang_common['album']}</td>\n    <td>{$lang_usermgr_php['modify']}</td>\n    ";
    foreach ($groups as $group) {
        $group_name = $group['group_name'];
        $group_id = $group['group_id'];
        echo '<tr><td colspan="3" class="tableh1">' . $group_name . '</td></tr>';
        list_group_alb_access($group_id);
    }
    endtable();
}

示例#2

文件： usermgr.php 项目： phill104/branches

function list_groups_alb_access()
{
    global $CONFIG;
    global $lang_usermgr_php, $lang_common, $group_id;
    starttable(500, $lang_usermgr_php['groups_alb_access'], 3);
    $sql = "\n      SELECT\n        group_id, group_name, categories.name AS category, albums.title AS album\n      FROM\n        {$CONFIG['TABLE_USERGROUPS']} AS groups, {$CONFIG['TABLE_ALBUMS']} AS albums\n      LEFT JOIN\n        {$CONFIG['TABLE_CATEGORIES']} AS categories\n      ON\n        albums.category = categories.cid\n      WHERE\n        albums.visibility = groups.group_id\n      GROUP BY\n        group_name\n      ORDER BY\n        group_name, category, album\n    ";
    $result = cpg_db_query($sql);
    $groups = cpg_db_fetch_rowset($result);
    mysql_free_result($result);
    echo "\n    <td><b>{$lang_usermgr_php['category']}</b></td>\n    <td><b>{$lang_common['album']}</b></td>\n    <td><b>{$lang_usermgr_php['modify']}</b></td>\n    ";
    foreach ($groups as $group) {
        $group_name = $group['group_name'];
        $group_id = $group['group_id'];
        echo '<tr><td colspan="3" class="tableh1_compact">' . $group_name . '</td></tr>';
        list_group_alb_access($group_id);
    }
    endtable();
}