// /* load only accounts available to _this_ user */ if($_SESSION['acl']['superuser'] != 'Y' && !auth_no_access(_('to access this form'))) { return; } $errstr = ''; if(!empty($_POST['r']) && !empty($_POST['t'])) { $sql = "INSERT INTO ".$GLOBALS['ESPCONFIG']['realm_table']." (name, title, changed) VALUES (". _addslashes($_POST['r']) .", ". _addslashes($_POST['t']).", ". sys_time_stamp().")"; if(!execute_sql($sql)) $errstr = _('Error adding group.') . ' (' . ErrorMsg() .')'; } if(!empty($_GET['del'])) { if($_GET['del'] == 'superuser') { $errstr = _('Error deleting group.'); } else { $sql = "SELECT count(d.username) FROM ".$GLOBALS['ESPCONFIG']['designer_table']." d WHERE d.realm=". _addslashes($_GET['del']); $count = get_one($sql); if ($count > 0) { $errstr = _('Group is not empty.'); } else { $sql = "DELETE FROM ".$GLOBALS['ESPCONFIG']['realm_table']." WHERE name=". _addslashes($_GET['del']); if(!execute_sql($sql)) $errstr = _('Error deleting group.'); } } } $sql = 'SELECT r.name, r.title, count(d.username) FROM '.$GLOBALS['ESPCONFIG']['realm_table'].' r LEFT JOIN '.$GLOBALS['ESPCONFIG']['designer_table'].' d ON r.name=d.realm GROUP BY r.name, r.title ORDER BY r.name'; $sql2 = 'SELECT count(d.username) FROM '.$GLOBALS['ESPCONFIG']['realm_table'].' r LEFT JOIN '.$GLOBALS['ESPCONFIG']['respondent_table'].' d ON r.name=d.realm GROUP BY r.name ORDER BY r.name'; $result = execute_sql($sql); $result2 = execute_sql($sql2); $i = 0; $bg = $ESPCONFIG['bgalt_color2']; ?>

'. mkerror($errstr) ."

\n"); ?> " . _('Go back to Management Interface') . "\n"); ?> MoveNext(); $result2->Move($i++); $count += $result2->fields[0]; if ($bg == $ESPCONFIG['bgalt_color1']) $bg =& $ESPCONFIG['bgalt_color2']; else $bg =& $ESPCONFIG['bgalt_color1']; ?>

			". _('Delete') .""); ?>

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