addTable('group_setcap', 'gs'); $q->addQuery('gs.group_id, g.group_name, gs.setcap_id, ga.name'); $q->addJoin('user_setcap', 'us', 'us.group_id = gs.group_id'); $q->addJoin('gacl_aro_groups', 'ga', 'ga.id = gs.setcap_id'); $q->addJoin('groups', 'g', 'g.group_id = us.group_id'); $q->addWhere('us.user_id = '.$user_id); $q->addOrder('gs.group_id'); $usc = $q->loadList();//print_r($sql); $q->clear(); $gid=array();$gsc=array(); foreach ($usc as $r) { $gsc[$r['group_name']][$r['setcap_id']]=$r['name']; $gid[] = $r['group_id']; } $gid = array_values(array_unique($gid)); $gid[] = -1; $perms =& $AppUI->acl(); $user_roles = $perms->getUserRoles($user_id); $canEdt= $perms->checkModule('admin', 'edit', null, $AppUI->user_groups[-1]); $q = new DBQuery; $q->addTable('user_setcap', 'us'); $q->addQuery('us.setcap_id, g.group_name'); $q->addJoin('groups', 'g', 'g.group_id = us.group_id'); $q->addWhere('us.setcap_id <> 0 && us.user_id ='.$user_id); $scg = $q->loadList(); $q->clear(); foreach ($scg as $r) { if (!is_null($r['group_name'])) $scgr[$r['setcap_id']][]=$r['group_name']; else $scgr[$r['setcap_id']][]=''.$dPconfig['organization_name'].''; } ?>

"; } $buf = ''; $style = ''; $buf .= ""; $buf .= ""; $buf .= ''; echo "$buf"; } ?> _('Sets of Capabilities');?> _('Groups');?>   "; $buf .= $row['value']=='admin' ? "".$row['name']."" : $row['name']; $buf .= " " . $bu . " '; if ($canEdt) { $buf .= "_('delete')."\">" . dPshowImage( './images/icons/stock_delete-16.png', 16, 16, '' ) . ""; } $buf .= '

$row) { ?> _('Groups');?> _('Sets of Capabilities');?>   : ".$dPconfig['organization_name'].""; $q = new DBQuery; $q->addTable('gacl_aro_groups'); $q->addQuery('id'); $q->addWhere('value = \'admin\''); $id = $q->loadResult(); $q->clear(); ?> value=>