Index: trunk/admin/category/addcategory_permissions.php =================================================================== diff -u -r13 -r18 --- trunk/admin/category/addcategory_permissions.php (.../addcategory_permissions.php) (revision 13) +++ trunk/admin/category/addcategory_permissions.php (.../addcategory_permissions.php) (revision 18) @@ -208,7 +208,7 @@ $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=".$c->Get("CategoryId")." GROUP BY Name"; +$sql .="LEFT JOIN ".GetTablePrefix()."PortalGroup as g ON p.GroupId=g.GroupId WHERE p.CatId=".(int)$c->Get("CategoryId")." GROUP BY Name"; //$sql = "SELECT GroupId, count(*) as PermCount FROM ".GetTablePrefix()."Permissions WHERE CatId=".$c->Get("CategoryId")." GROUP BY GroupId"; $objGroupList->Query_Item($sql); @@ -249,7 +249,8 @@ ">
- + + ">