Index: trunk/admin/category/addcategory_permissions.php =================================================================== diff -u -N -r4446 -r5180 --- trunk/admin/category/addcategory_permissions.php (.../addcategory_permissions.php) (revision 4446) +++ trunk/admin/category/addcategory_permissions.php (.../addcategory_permissions.php) (revision 5180) @@ -156,8 +156,11 @@ $order = $objConfig->Get("Group_SortOrder"); $objGroupList->Clear(); -$sql = "SELECT ResourceId, g.name as Name, ELT(g.Personal+1,'Group ','User ') as UserGroup FROM ".GetTablePrefix()."Permissions as p "; -$sql .="LEFT JOIN ".GetTablePrefix()."PortalGroup as g ON p.GroupId=g.GroupId WHERE (p.CatId=".(int)$c->Get("CategoryId").") AND (g.Personal = 0) GROUP BY Name"; +$sql = 'SELECT ResourceId, g.name AS Name, ELT(g.Personal + 1,"Group ","User ") AS UserGroup + FROM '.TABLE_PREFIX.'Permissions p + LEFT JOIN '.TABLE_PREFIX.'PortalGroup g ON p.GroupId = g.GroupId + WHERE (p.CatId = '.(int)$c->Get('CategoryId').') AND (g.Personal = 0) AND (p.Type = 0) + GROUP BY Name'; //$sql = "SELECT GroupId, count(*) as PermCount FROM ".GetTablePrefix()."Permissions WHERE CatId=".$c->Get("CategoryId")." GROUP BY GroupId"; $objGroupList->Query_Item($sql);