// /* SuperUser or Designers with "Administer Respondents(puser)" permissions only*/ if($GLOBALS['ESPCONFIG']['auth_type'] != 'ldap_both' && $GLOBALS['ESPCONFIG']['auth_type'] != 'ldap_resp' && $_SESSION['acl']['superuser'] != 'Y' && count($_SESSION['acl']['puser']) == 0 && !auth_no_access(_('to access this form'))) { return; } $sql = 'SELECT username, fname, lname, realm, disabled, expiration FROM '.$GLOBALS['ESPCONFIG']['respondent_table']; /* load only accounts available to _this_ user */ if($_SESSION['acl']['superuser'] != 'Y') { $realms = array_to_insql( array_merge( $_SESSION['acl']['pall'], $_SESSION['acl']['puser'])); $sql .= " WHERE realm $realms"; } $sql .= ' ORDER BY '; $base = $GLOBALS['ESPCONFIG']['ME'] .'?where=respondents'; if(!isset($_GET['u'])) $_GET['u'] = ''; if(!isset($_GET['g'])) $_GET['g'] = ''; if(!isset($_GET['f'])) $_GET['f'] = ''; if(!isset($_GET['l'])) $_GET['l'] = ''; if(!isset($_GET['s'])) $_GET['s'] = ''; if($_GET['u'] == 'd') { $us = 'username DESC'; $u = 'a'; } else { $_GET['u'] = 'a'; $us = 'username ASC'; $u = 'd'; } if($_GET['g'] == 'd') { $gs = 'realm DESC'; $g = 'a'; } else { $_GET['g'] = 'a'; $gs = 'realm ASC'; $g = 'd'; } if($_GET['f'] == 'd' || $_GET['l'] == 'd') { $ls = 'lname DESC'; $l = 'a'; $fs = 'fname DESC'; $f = 'a'; } else { $_GET['l'] = 'a'; $ls = 'lname ASC'; $l = 'd'; $_GET['f'] = 'a'; $fs = 'fname ASC'; $f = 'd'; } if($_GET['s'] == 'g') { $sql .= "$gs, $us"; $u = "&s=u&g=" . $_GET['g'] ."&u=". $_GET['u']; $g = "&s=g&g=$g&u=". $_GET['u']; $f = "&s=f"; $l = "&s=l"; } elseif($_GET['s'] == 'f' || $_GET['s'] == 'l') { $sql .= "$fs, $ls"; $f = "&s=f&f=$f"; $l = "&s=l&l=$l"; $u = "&s=u"; $g = "&s=g"; } else { $sql .= "$us, $gs"; $u = "&s=u&g=" . $_GET['g'] ."&u=$u"; $g = "&s=g&g=" . $_GET['g'] ."&u=". $_GET['u']; $f = "&s=f"; $l = "&s=l"; } $result = execute_sql($sql); $bg = $ESPCONFIG['bgalt_color2']; ?>

MoveNext(); if($d == 'N') $d = ' '; else $d = '('. _('disabled') .')'; if (empty($fname)) $fname = ' '; if (empty($lname)) $lname = ' '; if ($bg == $ESPCONFIG['bgalt_color1']) $bg =& $ESPCONFIG['bgalt_color2']; else $bg =& $ESPCONFIG['bgalt_color1']; ?>

">
">      ">

" . _('Go back to Management Interface') . "\n"); ?>