Index: trunk/admin/users/group_select.php =================================================================== diff -u -r3668 -r3683 --- trunk/admin/users/group_select.php (.../group_select.php) (revision 3668) +++ trunk/admin/users/group_select.php (.../group_select.php) (revision 3683) @@ -84,20 +84,23 @@ switch ($source) { case 'addcategory_permissions': $SelectorType = 'radio'; - $sql = 'SELECT DISTINCT(GroupId) + $exclude_sql = 'SELECT DISTINCT(GroupId) FROM '.TABLE_PREFIX.'Permissions WHERE CatId = '.$application->GetVar('CatId'); break; case 'adduser_groups': $SelectorType = 'radio'; - $sql = 'SELECT GroupId + $exclude_sql = 'SELECT GroupId FROM '.$objSession->GetEditTable('UserGroup').' WHERE PortalUserId = '.$application->GetVar('UserId'); break; + default: + $exclude_sql = ''; + break; } - $skip_groups = $db->GetCol($sql); + $skip_groups = $exclude_sql ? $db->GetCol($exclude_sql) : Array(); $where_clause = $skip_groups ? 'GroupId NOT IN ('.implode(',', $skip_groups).')' : '1'; $objGroups->LoadGroups('(Personal = 0) AND ('.$where_clause.')', trim($objConfig->Get('GroupSelect_SortField').' '.$order));