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(); }
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(); }