__('Delete'), 2 => __('Copy'), 3 => __('Enable'), 4 => __('Disable'), 5 => __('Batch Copy') ); set_default_action(); if (isset_request_var('update_policy')) { update_policies(); } else { switch (get_request_var('action')) { case 'actions': form_actions(); break; case 'save': form_save(); break; case 'perm_remove': perm_remove(); break; case 'user_edit': top_header(); user_edit(); bottom_footer(); break; case 'checkpass': $error = secpass_check_pass(get_nfilter_request_var('password')); if ($error == '') { print $error; } else { print 'ok'; } break; default: if (!api_plugin_hook_function('user_admin_action', get_request_var('action'))) { top_header(); user(); bottom_footer(); } break; } } /* -------------------------- Actions Function -------------------------- */ function update_policies() { $policies = array('policy_graphs', 'policy_trees', 'policy_hosts', 'policy_graph_templates'); foreach ($policies as $p) { if (isset_request_var($p)) { db_execute_prepared("UPDATE `user_auth` SET `$p` = ? WHERE `id` = ?", array(get_filter_request_var($p), get_filter_request_var('id'))); } } header('Location: user_admin.php?action=user_edit&header=false&tab=' . get_nfilter_request_var('tab') . '&id=' . get_filter_request_var('id')); exit; } function form_actions() { global $user_actions, $auth_realms; /* if we are to save this form, instead of display it */ if (isset_request_var('associate_host')) { foreach ($_POST as $var => $val) { if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) { /* ================= input validation ================= */ input_validate_input_number($matches[1]); /* ==================================================== */ if (get_nfilter_request_var('drp_action') == '1') { db_execute_prepared('REPLACE INTO user_auth_perms (user_id, item_id, type) VALUES (?, ?, 3)', array(get_nfilter_request_var('id'), $matches[1])); } else { db_execute_prepared('DELETE FROM user_auth_perms WHERE user_id = ? AND item_id = ? AND type = 3', array(get_nfilter_request_var('id'), $matches[1])); } } } header('Location: user_admin.php?action=user_edit&header=false&tab=permsd&id=' . get_nfilter_request_var('id')); exit; } elseif (isset_request_var('associate_graph')) { foreach ($_POST as $var => $val) { if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) { /* ================= input validation ================= */ input_validate_input_number($matches[1]); /* ==================================================== */ if (get_nfilter_request_var('drp_action') == '1') { db_execute_prepared('REPLACE INTO user_auth_perms (user_id, item_id, type) VALUES (?, ?, 1)', array(get_nfilter_request_var('id'), $matches[1])); } else { db_execute_prepared('DELETE FROM user_auth_perms WHERE user_id = ? AND item_id = ? AND type = 1', array(get_nfilter_request_var('id'), $matches[1])); } } } header('Location: user_admin.php?action=user_edit&header=false&tab=permsg&id=' . get_nfilter_request_var('id')); exit; } elseif (isset_request_var('associate_template')) { foreach ($_POST as $var => $val) { if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) { /* ================= input validation ================= */ input_validate_input_number($matches[1]); /* ==================================================== */ if (get_nfilter_request_var('drp_action') == '1') { db_execute_prepared('REPLACE INTO user_auth_perms (user_id, item_id, type) VALUES (?, ?, 4)', array(get_nfilter_request_var('id'), $matches[1])); } else { db_execute_prepared('DELETE FROM user_auth_perms WHERE user_id = ? AND item_id = ? AND type = 4', array(get_nfilter_request_var('id'), $matches[1])); } } } header('Location: user_admin.php?action=user_edit&header=false&tab=permste&id=' . get_nfilter_request_var('id')); exit; } elseif (isset_request_var('associate_groups')) { foreach ($_POST as $var => $val) { if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) { /* ================= input validation ================= */ input_validate_input_number($matches[1]); /* ==================================================== */ if (get_nfilter_request_var('drp_action') == '1') { db_execute_prepared('REPLACE INTO user_auth_group_members (user_id, group_id) VALUES (?, ?)', array(get_nfilter_request_var('id'), $matches[1])); } else { db_execute_prepared('DELETE FROM user_auth_group_members WHERE user_id = ? AND group_id = ?', array(get_nfilter_request_var('id'), $matches[1])); } } } header('Location: user_admin.php?action=user_edit&header=false&tab=permsgr&id=' . get_nfilter_request_var('id')); exit; } elseif (isset_request_var('associate_tree')) { foreach ($_POST as $var => $val) { if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) { /* ================= input validation ================= */ input_validate_input_number($matches[1]); /* ==================================================== */ if (get_nfilter_request_var('drp_action') == '1') { db_execute_prepared('REPLACE INTO user_auth_perms (user_id, item_id, type) VALUES (?, ?, 2)', array(get_nfilter_request_var('id'), $matches[1])); } else { db_execute_prepared('DELETE FROM user_auth_perms WHERE user_id = ? AND item_id = ? AND type = 2', array(get_nfilter_request_var('id'), $matches[1])); } } } header('Location: user_admin.php?action=user_edit&header=false&tab=permstr&id=' . get_nfilter_request_var('id')); exit; } elseif (isset_request_var('selected_items')) { if (get_nfilter_request_var('drp_action') == '2') { /* copy */ /* ================= input validation ================= */ get_filter_request_var('selected_items'); get_filter_request_var('new_realm'); /* ==================================================== */ $new_username = get_nfilter_request_var('new_username'); $new_realm = get_nfilter_request_var('new_realm', 0); $template_user = db_fetch_row_prepared('SELECT username, realm FROM user_auth WHERE id = ?', array(get_nfilter_request_var('selected_items'))); $overwrite = array( 'full_name' => get_nfilter_request_var('new_fullname') ); if ($new_username != '') { if (cacti_sizeof(db_fetch_assoc_prepared('SELECT username FROM user_auth WHERE username = ? AND realm = ?', array($new_username, $new_realm)))) { raise_message(19); } else { if (user_copy($template_user['username'], $new_username, $template_user['realm'], $new_realm, false, $overwrite) === false) { raise_message(2); } else { raise_message(1); } } } } else { $selected_items = sanitize_unserialize_selected_items(get_nfilter_request_var('selected_items')); if ($selected_items != false) { if (get_nfilter_request_var('drp_action') == '1') { // delete for ($i=0;($i $val) { if (preg_match('/^chk_([0-9]+)$/', $var, $matches)) { /* ================= input validation ================= */ input_validate_input_number($matches[1]); /* ==================================================== */ if (get_nfilter_request_var('drp_action') != '2') { $user_list .= '
  • ' . html_escape(db_fetch_cell_prepared('SELECT username FROM user_auth WHERE id = ?', array($matches[1]))) . '
  • '; } $user_array[$i] = $matches[1]; $i++; } } top_header(); form_start('user_admin.php'); html_start_box($user_actions[get_nfilter_request_var('drp_action')], '60%', '', '3', 'center', ''); if (isset($user_array) && cacti_sizeof($user_array)) { if ((get_nfilter_request_var('drp_action') == '1') && (cacti_sizeof($user_array))) { // delete print "

    " . __('Click \'Continue\' to delete the selected User(s).') . "

    "; $save_html = ""; } $user_id = ''; if ((get_nfilter_request_var('drp_action') == '2') && (cacti_sizeof($user_array))) { // copy $user_id = $user_array[0]; $user_realm = db_fetch_cell_prepared('SELECT realm FROM user_auth WHERE id = ?', array($user_id)); print "

    " . __('Click \'Continue\' to copy the selected User to a new User below.') . "

    " . __('Template Username:') . " " . html_escape(db_fetch_cell_prepared('SELECT username FROM user_auth WHERE id = ?', array($user_id))) . "

    " . __('Username:') . " "; print form_text_box('new_username', '', '', 25); print "

    " . __('Full Name:') . " "; print form_text_box('new_fullname', '', '', 35); print "

    " . __('Realm:') ." "; print form_dropdown('new_realm', $auth_realms, '', '', $user_realm, '', 0); print "

    "; $save_html = " "; } if ((get_nfilter_request_var('drp_action') == '3') && (cacti_sizeof($user_array))) { // enable print "

    " . __('Click \'Continue\' to enable the selected User(s).'). "

    "; $save_html = " "; } if ((get_nfilter_request_var('drp_action') == '4') && (cacti_sizeof($user_array))) { // disable print "

    " . __('Click \'Continue\' to disable the selected User(s).') . "

    "; $save_html = " "; } if ((get_nfilter_request_var('drp_action') == '5') && (cacti_sizeof($user_array))) { // batch copy $usernames = db_fetch_assoc('SELECT id, username FROM user_auth WHERE realm = 0 ORDER BY username'); print "

    " . __('Click \'Continue\' to overwrite the User(s) settings with the selected template User settings and permissions. The original users Full Name, Password, Realm and Enable status will be retained, all other fields will be overwritten from Template User.') . "

    " . __('Template User:') . " "; print form_dropdown('template_user', $usernames, 'username', 'id', '', '', 0); print "

    " . __('User(s) to update:') . "

    "; $save_html = " "; } } else { raise_message(40); header('Location: user_admin.php?header=false'); exit; } print " "; if (get_nfilter_request_var('drp_action') == '2') { // copy print ""; } else { print ""; } print " $save_html "; html_end_box(); form_end(); bottom_footer(); } /* -------------------------- Save Function -------------------------- */ function form_save() { global $settings_user; /* graph permissions */ if ((isset_request_var('save_component_graph_perms')) && (!is_error_message())) { /* ================= input validation ================= */ get_filter_request_var('id'); get_filter_request_var('perm_graphs'); get_filter_request_var('perm_trees'); get_filter_request_var('perm_hosts'); get_filter_request_var('perm_graph_templates'); get_filter_request_var('policy_graphs'); get_filter_request_var('policy_trees'); get_filter_request_var('policy_hosts'); get_filter_request_var('policy_graph_templates'); /* ==================================================== */ $add_button_clicked = false; if (isset_request_var('add_graph_x')) { db_execute_prepared('REPLACE INTO user_auth_perms (user_id,item_id,type) VALUES (?, ?, 1)', array(get_nfilter_request_var('id'), get_nfilter_request_var('perm_graphs'))); $add_button_clicked = true; } elseif (isset_request_var('add_tree_x')) { db_execute_prepared('REPLACE INTO user_auth_perms (user_id,item_id,type) VALUES (?, ?, 2)', array(get_nfilter_request_var('id'), get_nfilter_request_var('perm_trees'))); $add_button_clicked = true; } elseif (isset_request_var('add_host_x')) { db_execute_prepared('REPLACE INTO user_auth_perms (user_id,item_id,type) VALUES (?, ?, 3)', array(get_nfilter_request_var('id'), get_nfilter_request_var('perm_hosts'))); $add_button_clicked = true; } elseif (isset_request_var('add_graph_template_x')) { db_execute_prepared('REPLACE INTO user_auth_perms (user_id,item_id,type) VALUES (?, ?, 4)', array(get_nfilter_request_var('id'), get_nfilter_request_var('perm_graph_templates'))); $add_button_clicked = true; } if ($add_button_clicked == true) { header('Location: user_admin.php?action=user_edit&header=false&tab=graph_perms_edit&id=' . get_nfilter_request_var('id')); exit; } } elseif (isset_request_var('save_component_user')) { /* user management save */ /* ================= input validation ================= */ get_filter_request_var('id'); get_filter_request_var('realm'); get_filter_request_var('policy_hosts'); get_filter_request_var('policy_graphs'); get_filter_request_var('policy_trees'); get_filter_request_var('policy_graph_templates'); /* ==================================================== */ $old_password = db_fetch_cell_prepared('SELECT password FROM user_auth WHERE id = ?', array(get_nfilter_request_var('id'))); if ((get_nfilter_request_var('password') == '') && (get_nfilter_request_var('password_confirm') == '')) { $password = $old_password; } else { $password = compat_password_hash(get_nfilter_request_var('password'), PASSWORD_DEFAULT); if ($password != $old_password) { db_execute_prepared('DELETE FROM user_auth_cache WHERE user_id = ?', array(get_nfilter_request_var('id'))); } } /* check duplicate username */ if (cacti_sizeof(db_fetch_row_prepared('SELECT * FROM user_auth WHERE realm = ? AND username = ? AND id != ?', array(get_nfilter_request_var('realm'), get_nfilter_request_var('username'), get_nfilter_request_var('id'))))) { raise_message(12); } /* check for guest or template user */ $username = db_fetch_cell_prepared('SELECT username FROM user_auth WHERE id = ?', array(get_nfilter_request_var('id'))); $history = db_fetch_cell_prepared('SELECT password_history FROM user_auth WHERE id = ?', array(get_nfilter_request_var('id'))); if ($username != '' && $username != get_nfilter_request_var('username')) { if (is_template_account(get_filter_request_var('id'))) { raise_message(20); } if (get_filter_request_var('id') === get_guest_account()) { raise_message(20); } } /* check to make sure the passwords match; if not error */ if (get_nfilter_request_var('password') != get_nfilter_request_var('password_confirm')) { raise_message(4); } if (get_nfilter_request_var('must_change_password') == 'on' && get_nfilter_request_var('password_change') != 'on') { raise_message('password_change'); } $save['id'] = get_nfilter_request_var('id'); $save['username'] = form_input_validate(get_nfilter_request_var('username'), 'username', "^[A-Za-z0-9\._\\\@\ -]+$", false, 3); $save['full_name'] = form_input_validate(get_nfilter_request_var('full_name'), 'full_name', '', true, 3); $save['password'] = $password; $save['must_change_password'] = form_input_validate(get_nfilter_request_var('must_change_password', ''), 'must_change_password', '', true, 3); $save['password_change'] = form_input_validate(get_nfilter_request_var('password_change', ''), 'password_change', '', true, 3); $save['show_tree'] = form_input_validate(get_nfilter_request_var('show_tree', ''), 'show_tree', '', true, 3); $save['show_list'] = form_input_validate(get_nfilter_request_var('show_list', ''), 'show_list', '', true, 3); $save['show_preview'] = form_input_validate(get_nfilter_request_var('show_preview', ''), 'show_preview', '', true, 3); $save['graph_settings'] = form_input_validate(get_nfilter_request_var('graph_settings', ''), 'graph_settings', '', true, 3); $save['login_opts'] = form_input_validate(get_nfilter_request_var('login_opts'), 'login_opts', '', true, 3); $save['password_history'] = $history; /* force enable/disable on template accounts */ if (read_config_option('admin_user') == get_nfilter_request_var('id')) { $save['enabled'] = 'on'; $save['realm'] = get_nfilter_request_var('realm', 0); } elseif (is_template_account(get_nfilter_request_var('id'))) { $save['enabled'] = ''; $save['realm'] = 0; } else { $save['enabled'] = form_input_validate(get_nfilter_request_var('enabled', ''), 'enabled', '', true, 3); $save['realm'] = get_nfilter_request_var('realm', 0); } $save['email_address'] = form_input_validate(get_nfilter_request_var('email_address', ''), 'email_address', '', true, 3); $save['locked'] = form_input_validate(get_nfilter_request_var('locked', ''), 'locked', '', true, 3); $save['reset_perms'] = mt_rand(); if ($save['locked'] == '') { $save['failed_attempts'] = 0; } $save = api_plugin_hook_function('user_admin_setup_sql_save', $save); if (!is_error_message()) { $user_id = sql_save($save, 'user_auth'); if ($user_id) { raise_message(1); } else { raise_message(2); } } } elseif (isset_request_var('save_component_realm_perms')) { /* ================= input validation ================= */ get_filter_request_var('id'); /* ==================================================== */ db_execute_prepared('DELETE FROM user_auth_realm WHERE user_id = ?', array(get_nfilter_request_var('id'))); foreach ($_POST as $var => $val) { if (preg_match('/^[section]/i', $var)) { if (substr($var, 0, 7) == 'section') { db_execute_prepared('REPLACE INTO user_auth_realm (user_id, realm_id) VALUES (?, ?)', array(get_nfilter_request_var('id'), substr($var, 7))); } } } reset_user_perms(get_nfilter_request_var('id')); raise_message(1); } elseif (isset_request_var('save_component_graph_settings')) { /* ================= input validation ================= */ get_filter_request_var('id'); /* ==================================================== */ save_user_settings(get_request_var('id')); /* reset local settings cache so the user sees the new settings */ kill_session_var('sess_user_config_array'); reset_user_perms(get_request_var('id')); raise_message(1); } elseif (isset_request_var('save_component_graph_perms')) { /* ================= input validation ================= */ get_filter_request_var('id'); get_filter_request_var('policy_hosts'); get_filter_request_var('policy_graphs'); get_filter_request_var('policy_trees'); get_filter_request_var('policy_graph_templates'); /* ==================================================== */ db_execute_prepared('UPDATE user_auth SET policy_graphs = ?, policy_trees = ?, policy_hosts = ?, policy_graph_templates = ? WHERE id = ?', array( get_nfilter_request_var('policy_graphs'), get_nfilter_request_var('policy_trees'), get_nfilter_request_var('policy_hosts'), get_nfilter_request_var('policy_graph_templates'), get_nfilter_request_var('id') ) ); } else { api_plugin_hook('user_admin_user_save'); reset_user_perms(get_filter_request_var('id')); } /* redirect to the appropriate page */ header('Location: user_admin.php?action=user_edit&header=false&id=' . (empty($user_id) ? get_filter_request_var('id') : $user_id)); } function perm_remove() { /* ================= input validation ================= */ get_filter_request_var('id'); get_filter_request_var('user_id'); /* ==================================================== */ if (get_request_var('type') == 'graph') { db_execute_prepared('DELETE FROM user_auth_perms WHERE type = 1 AND user_id = ? AND item_id = ?', array(get_request_var('user_id'), get_request_var('id'))); } elseif (get_request_var('type') == 'tree') { db_execute_prepared('DELETE FROM user_auth_perms WHERE type = 2 AND user_id = ? AND item_id = ?', array(get_request_var('user_id'), get_request_var('id'))); } elseif (get_request_var('type') == 'host') { db_execute_prepared('DELETE FROM user_auth_perms WHERE type = 3 AND user_id = ? AND item_id = ?', array(get_request_var('user_id'), get_request_var('id'))); } elseif (get_request_var('type') == 'graph_template') { db_execute_prepared('DELETE FROM user_auth_perms WHERE type = 4 AND user_id = ? AND item_id = ?', array(get_request_var('user_id'), get_request_var('id'))); } header('Location: user_admin.php?action=user_edit&header=false&tab=graph_perms_edit&id=' . get_request_var('user_id')); } function graph_perms_edit($tab, $header_label) { /* ================= input validation ================= */ get_filter_request_var('id'); /* ==================================================== */ $sql_where = ''; $sql_join = ''; $limit = ''; $sql_having = ''; $policy_array = array( 1 => __('Allow'), 2 => __('Deny') ); if (!isempty_request_var('id')) { $policy = db_fetch_row_prepared('SELECT policy_graphs, policy_trees, policy_hosts, policy_graph_templates FROM user_auth WHERE id = ?', array(get_request_var('id'))); } else { $policy = array( 'policy_graphs' => '1', 'policy_trees' => '1', 'policy_hosts' => '1', 'policy_graph_templates' => '1' ); } switch($tab) { case 'permsg': if (isempty_request_var('id')) { header('Location: user_admin.php&header=false'); } process_graph_request_vars(); graph_filter($header_label); form_start('user_admin.php', 'policy'); $graph_auth_method = read_config_option('graph_auth_method'); if ($graph_auth_method == 1) { $policy_note = __('Note: System Graph Policy is \'Permissive\' meaning the User must have access to at least one of Graph, Device, or Graph Template to gain access to the Graph'); } elseif ($graph_auth_method == 2) { $policy_note = __('Note: System Graph Policy is \'Restrictive\' meaning the User must have access to either the Graph or the Device and Graph Template to gain access to the Graph'); } elseif ($graph_auth_method == 3) { $policy_note = __('Note: System Graph Policy is \'Device\' meaning the User must have access to the Graph or Device to gain access to the Graph'); } else { $policy_note = __('Note: System Graph Policy is \'Graph Template\' meaning the User must have access to the Graph or Graph Template to gain access to the Graph'); } /* box: device permissions */ html_start_box(__('Default Graph Policy'), '100%', '', '3', 'center', ''); ?>
    '> '>

    0)'; } else { $sql_where = 'WHERE (gtg.local_graph_id > 0)'; } if (get_request_var('graph_template_id') == '-1') { /* Show all items */ } elseif (get_request_var('graph_template_id') == '0') { $sql_where .= ($sql_where != '' ? ' AND ':'WHERE ') . ' gtg.graph_template_id=0'; } elseif (!isempty_request_var('graph_template_id')) { $sql_where .= ($sql_where != '' ? ' AND ':'WHERE ') . ' gtg.graph_template_id=' . get_request_var('graph_template_id'); } /** * if viewing just the graphs that the user has access to * we use a custom crafted sql_where clause to calculate * permissions due to the inefficient nature of the HAVING * SQL clause. */ if (get_request_var('associated') == 'false') { $sql_where = get_policy_where($graph_auth_method, $policies, $sql_where); } /** * get the sql join and select to display the policy information * this includes the four graph permission types */ $details = get_policy_join_select($policies); if (cacti_sizeof($details)) { $sql_join = $details['sql_join']; $sql_select = $details['sql_select']; } else { $sql_join = ''; $sql_select = ''; } $graphs = db_fetch_assoc("SELECT gtg.local_graph_id, h.description, h.disabled, h.deleted, gt.name AS template_name, gtg.title_cache, gtg.width, gtg.height, gl.snmp_index, gl.snmp_query_id, $sql_select FROM graph_templates_graph AS gtg INNER JOIN graph_local AS gl ON gl.id = gtg.local_graph_id LEFT JOIN graph_templates AS gt ON gt.id = gl.graph_template_id LEFT JOIN host AS h ON h.id = gl.host_id $sql_join $sql_where ORDER BY gtg.title_cache $limit"); $total_rows = db_fetch_cell("SELECT COUNT(DISTINCT gl.id) FROM graph_templates_graph AS gtg INNER JOIN graph_local AS gl ON gl.id = gtg.local_graph_id LEFT JOIN graph_templates AS gt ON gt.id = gl.graph_template_id LEFT JOIN host AS h ON h.id = gl.host_id $sql_where"); $nav = html_nav_bar('user_admin.php?action=user_edit&tab=permsg&id=' . get_request_var('id'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 11, __('Graphs'), 'page', 'main'); form_start('user_admin.php?tab=permsg&id=' . get_request_var('id'), 'chk'); print $nav; html_start_box('', '100%', '', '3', 'center', ''); $display_text = array(__('Graph Title'), __('ID'), __('Effective Policy')); html_header_checkbox($display_text, false); if (cacti_sizeof($graphs)) { foreach ($graphs as $g) { form_alternate_row('line' . $g['local_graph_id'], true); form_selectable_cell(filter_value($g['title_cache'], get_request_var('filter')), $g['local_graph_id']); form_selectable_cell($g['local_graph_id'], $g['local_graph_id']); form_selectable_cell(get_permission_string($g, $policies), $g['local_graph_id']); form_checkbox_cell($g['title_cache'], $g['local_graph_id']); form_end_row(); } } else { print '' . __('No Matching Graphs Found') . ''; } html_end_box(false); if (cacti_sizeof($graphs)) { print $nav; } form_hidden_box('tab',$tab,''); form_hidden_box('id', get_request_var('id'), ''); form_hidden_box('associate_graph', '1', ''); if ($policy['policy_graphs'] == 1) { $assoc_actions = array( 1 => __('Revoke Access'), 2 => __('Grant Access') ); } else { $assoc_actions = array( 1 => __('Grant Access'), 2 => __('Revoke Access') ); } ?> 0 ? __('Member'):__('Non Member'), $g['id']); form_selectable_cell(($g['id']), $g['id']); form_selectable_cell(($g['policy_graphs'] == 1 ? __('ALLOW'):__('DENY')) . '/' . ($g['policy_hosts'] == 1 ? __('ALLOW'):__('DENY')) . '/' . ($g['policy_graph_templates'] == 1 ? __('ALLOW'):__('DENY')), $g['id']); form_selectable_cell($g['enabled'] == 'on' ? __('Enabled'):__('Disabled'), $g['id']); form_checkbox_cell($g['name'], $g['id']); form_end_row(); } } else { print '' . __('No Matching User Groups Found') . ''; } html_end_box(false); if (cacti_sizeof($groups)) { print $nav; } form_hidden_box('tab',$tab,''); form_hidden_box('id', get_request_var('id'), ''); form_hidden_box('associate_groups', '1', ''); $assoc_actions = array( 1 => __('Assign Membership'), 2 => __('Remove Membership') ); /* draw the dropdown containing a list of available actions for this form */ draw_actions_dropdown($assoc_actions); form_end(); break; case 'permsd': if (isempty_request_var('id')) { header('Location: user_admin.php&header=false'); } process_device_request_vars(); device_filter($header_label); form_start('user_admin.php', 'policy'); html_start_box(__('Default Device Policy'), '100%', '', '3', 'center', ''); ?>
    '> '>
    ' . __('Access Granted') . '', $host['id']); } else { form_selectable_cell('' . __('Access Restricted') . '', $host['id']); } } else { if ($policy['policy_hosts'] == 1) { form_selectable_cell('' . __('Access Restricted') . '', $host['id']); } else { form_selectable_cell('' . __('Access Granted') . '', $host['id']); } } form_selectable_cell((isset($host_graphs[$host['id']]) ? $host_graphs[$host['id']] : 0), $host['id']); form_selectable_cell((isset($host_data_sources[$host['id']]) ? $host_data_sources[$host['id']] : 0), $host['id']); form_selectable_cell(get_colored_device_status(($host['disabled'] == 'on' ? true : false), $host['status']), $host['id']); form_selectable_cell(filter_value($host['hostname'], get_request_var('filter')), $host['id']); form_checkbox_cell($host['description'], $host['id']); form_end_row(); } } else { print '' . __('No Matching Devices Found') . ''; } html_end_box(false); if (cacti_sizeof($hosts)) { print $nav; } form_hidden_box('tab',$tab,''); form_hidden_box('id', get_request_var('id'), ''); form_hidden_box('associate_host', '1', ''); if ($policy['policy_hosts'] == 1) { $assoc_actions = array( 1 => __('Revoke Access'), 2 => __('Grant Access') ); } else { $assoc_actions = array( 1 => __('Grant Access'), 2 => __('Revoke Access') ); } /* draw the dropdown containing a list of available actions for this form */ draw_actions_dropdown($assoc_actions); form_end(); break; case 'permste': if (isempty_request_var('id')) { header('Location: user_admin.php&header=false'); } process_template_request_vars(); template_filter($header_label); form_start('user_admin.php', 'policy'); html_start_box(__('Default Graph Template Policy'), '100%', '', '3', 'center', ''); ?>
    '> '>
    ' . __('Access Granted') . '', $g['id']); } else { form_selectable_cell('' . __('Access Restricted') . '', $g['id']); } } else { if ($policy['policy_graph_templates'] == 1) { form_selectable_cell('' . __('Access Restricted') . '', $g['id']); } else { form_selectable_cell('' . __('Access Granted') . '', $g['id']); } } form_selectable_cell($g['totals'], $g['id']); form_checkbox_cell($g['name'], $g['id']); form_end_row(); } } else { print '' . __('No Matching Graph Templates Found') . ''; } html_end_box(false); if (cacti_sizeof($graphs)) { print $nav; } form_hidden_box('tab',$tab,''); form_hidden_box('id', get_request_var('id'), ''); form_hidden_box('associate_template', '1', ''); if ($policy['policy_graph_templates'] == 1) { $assoc_actions = array( 1 => __('Revoke Access'), 2 => __('Grant Access') ); } else { $assoc_actions = array( 1 => __('Grant Access'), 2 => __('Revoke Access') ); } /* draw the dropdown containing a list of available actions for this form */ draw_actions_dropdown($assoc_actions); form_end(); break; case 'permstr': if (isempty_request_var('id')) { header('Location: user_admin.php&header=false'); } process_tree_request_vars(); tree_filter($header_label); form_start('user_admin.php', 'policy'); html_start_box(__('Default Tree Policy'), '100%', '', '3', 'center', ''); ?>
    '> '>
    ' . __('Access Granted') . '', $t['id']); } else { form_selectable_cell('' . __('Access Restricted') . '', $t['id']); } } else { if ($policy['policy_trees'] == 1) { form_selectable_cell('' . __('Access Restricted') . '', $t['id']); } else { form_selectable_cell('' . __('Access Granted') . '', $t['id']); } } form_checkbox_cell($t['name'], $t['id']); form_end_row(); } } else { print '' . __('No Matching Trees Found') . ''; } html_end_box(false); if (cacti_sizeof($trees)) { print $nav; } form_hidden_box('tab',$tab,''); form_hidden_box('id', get_request_var('id'), ''); form_hidden_box('associate_tree', '1', ''); if ($policy['policy_trees'] == 1) { $assoc_actions = array( 1 => __('Revoke Access'), 2 => __('Grant Access') ); } else { $assoc_actions = array( 1 => __('Grant Access'), 2 => __('Revoke Access') ); } /* draw the dropdown containing a list of available actions for this form */ draw_actions_dropdown($assoc_actions); form_end(); break; } } function user_realms_edit($header_label) { global $user_auth_realms, $user_auth_roles; /* ================= input validation ================= */ get_filter_request_var('id'); /* ==================================================== */ $all_realms = $user_auth_realms; print "
    " . __('User Permissions') . " " . html_escape($header_label) . "
    "; form_start('user_admin.php', 'chk'); html_start_box('', '100%', '', '3', 'center', ''); /* do cacti realms first */ foreach($user_auth_roles as $role_name => $perms) { print "" . html_escape($role_name) . ""; print "
    "; foreach($perms as $realm) { if (isset($user_auth_realms[$realm])) { $set = db_fetch_cell_prepared('SELECT realm_id FROM user_auth_realm WHERE user_id = ? AND realm_id = ?', array(get_request_var('id', 0), $realm)); if ($set) { $old_value = 'on'; } else { $old_value = ''; } if ($realm != 101) { $display = trim(str_replace(array('Plugin ->', 'Plugin ', 'Configure '), '', $user_auth_realms[$realm])); } else { $display = trim($user_auth_realms[$realm]); } $display = trim(str_replace(array('View ', 'Management'), array('', 'Administration'), $display)); unset($all_realms[$realm]); print '
    '; form_checkbox('section' . $realm, $old_value, $display, '', '', '', (!isempty_request_var('id') ? 1 : 0), $display, true); print '
    '; } } print '
    '; } /* external links */ $links = db_fetch_assoc('SELECT * FROM external_links ORDER BY sortorder'); $style_translate = array( 'CONSOLE' => __('Console'), 'TAB' => __('Top Tab'), 'FRONT' => __('Bottom Console'), 'FRONTTOP' => __('Top Console') ); if (cacti_sizeof($links)) { print "" . __('External Link Permissions') . ""; print "
    "; foreach($links as $r) { $realm = $r['id'] + 10000; $set = db_fetch_cell_prepared('SELECT realm_id FROM user_auth_realm WHERE user_id = ? AND realm_id = ?', array(get_request_var('id', 0), $realm)); if ($set) { $old_value = 'on'; } else { $old_value = ''; } unset($all_realms[$realm]); switch($r['style']) { case 'CONSOLE': $description = $style_translate[$r['style']] . ': ' . ($r['extendedstyle'] == '' ? __('External Links') : $r['extendedstyle']) . '/' . $r['title']; break; default: $description = $style_translate[$r['style']] . ': ' . ucfirst($r['title']); break; } print '
    '; form_checkbox('section' . $realm, $old_value, $description, '', '', '', (!isempty_request_var('id') ? 1 : 0), $description, true); print '
    '; } print '
    '; } /* do plugin realms */ $realms = db_fetch_assoc('SELECT pc.directory, pc.name, pr.id AS realm_id, pr.display FROM plugin_config AS pc INNER JOIN plugin_realms AS pr ON pc.directory = pr.plugin ORDER BY pc.name, pr.display'); $i = 0; if (cacti_sizeof($realms)) { foreach($realms as $r) { $realm = $r['realm_id'] + 100; // Skip already set realms foreach($user_auth_roles as $role => $rrealms) { foreach($rrealms as $realm_id) { if ($realm == $realm_id) { unset($all_realms[$realm]); continue 3; } } } $set = db_fetch_cell_prepared('SELECT realm_id FROM user_auth_realm WHERE user_id = ? AND realm_id = ?', array(get_request_var('id', 0), $realm)); if ($set) { $old_value = 'on'; } else { $old_value = ''; } unset($all_realms[$realm]); $local_user_auth_realms = __($user_auth_realms[$realm], $r['directory']); $pos = (strpos($local_user_auth_realms, '->') !== false ? strpos($local_user_auth_realms, '->')+2:0); if ($i == 0) { print "" . __('Plugin Permissions') . ""; print "
    "; $i++; } print '
    '; form_checkbox('section' . $realm, $old_value, trim(substr($local_user_auth_realms, $pos)), '', '', '', (!isempty_request_var('id') ? 1 : 0), $r['display'], true); print '
    '; } if ($i > 0) { print '
    '; } } /* get the old PIA 1.x realms */ if (cacti_sizeof($all_realms)) { print "" . __('Legacy Permissions') . ""; foreach($all_realms as $realm => $name) { $set = db_fetch_cell_prepared('SELECT realm_id FROM user_auth_realm WHERE user_id = ? AND realm_id = ?', array(get_request_var('id', 0), $realm)); if ($set) { $old_value = 'on'; } else { $old_value = ''; } $pos = (strpos($user_auth_realms[$realm], '->') !== false ? strpos($user_auth_realms[$realm], '->')+2:0); print '
    '; form_checkbox('section' . $realm, $old_value, substr($user_auth_realms[$realm], $pos), '', '', '', (!isempty_request_var('id') ? 1 : 0), $r['display'], true); print '
    '; } print ''; } print ''; ?> $tab_fields) { $collapsible = true; print "
    " . $tabs_graphs[$tab_short_name] . ($collapsible ? "
    ":"") . "
    "; $form_array = array(); foreach ($tab_fields as $field_name => $field_array) { $form_array += array($field_name => $tab_fields[$field_name]); if ((isset($field_array['items'])) && (is_array($field_array['items']))) { foreach ($field_array['items'] as $sub_field_name => $sub_field_array) { if (graph_config_value_exists($sub_field_name, get_request_var('id'))) { $form_array[$field_name]['items'][$sub_field_name]['form_id'] = 1; } $form_array[$field_name]['items'][$sub_field_name]['value'] = db_fetch_cell_prepared('SELECT value FROM settings_user WHERE name = ? AND user_id = ?', array($sub_field_name, get_request_var('id'))); } } else { if (graph_config_value_exists($field_name, get_request_var('id'))) { $form_array[$field_name]['form_id'] = 1; } $form_array[$field_name]['value'] = db_fetch_cell_prepared('SELECT value FROM settings_user WHERE name = ? and user_id = ?', array($field_name, get_request_var('id'))); } } draw_edit_form( array( 'config' => array('no_form_tag' => true), 'fields' => $form_array ) ); } html_end_box(true, true); form_hidden_box('id', get_request_var('id'), ''); form_hidden_box('tab', 'settings', ''); form_hidden_box('save_component_graph_settings','1',''); form_save_button('user_admin.php', 'return'); ?> array('regexp' => '/^([a-z_A-Z]+)$/'))); /* ==================================================== */ /* present a tabbed interface */ $tabs = array( 'general' => __('General'), 'realms' => __('Permissions'), 'permsgr' => __('Group Membership'), 'permsg' => __('Graph Perms'), 'permsd' => __('Device Perms'), 'permste' => __('Template Perms'), 'permstr' => __('Tree Perms'), 'settings' => __('User Settings') ); $permission_model = read_config_option('graph_auth_method'); if ($permission_model == 3) { // Device Based unset($tabs['permste']); } elseif ($permission_model == 4) { // Graph Template Based unset($tabs['permsd']); } /* set the default tab */ load_current_session_value('tab', 'sess_user_admin_tab', 'general'); $current_tab = get_nfilter_request_var('tab'); if (!isempty_request_var('id')) { $user = db_fetch_row_prepared('SELECT * FROM user_auth WHERE id = ?', array(get_request_var('id'))); $header_label = __('[edit: %s]', $user['username']); } else { $header_label = __('[new]'); } if (cacti_sizeof($tabs) && !isempty_request_var('id')) { $i = 0; /* draw the tabs */ print "
    "; } switch($current_tab) { case 'general': api_plugin_hook_function('user_admin_edit', (isset($user) ? get_request_var('id') : 0)); form_start('user_admin.php'); html_start_box(__esc('User Management %s', $header_label), '100%', '', '3', 'center', ''); draw_edit_form( array( 'config' => array('no_form_tag' => true), 'fields' => inject_form_variables($fields_user_user_edit_host, (isset($user) ? $user : array())) ) ); html_end_box(); form_save_button('user_admin.php', 'return'); ?> array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1' ), 'realm' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1' ), 'page' => array( 'filter' => FILTER_VALIDATE_INT, 'default' => '1' ), 'filter' => array( 'filter' => FILTER_DEFAULT, 'pageset' => true, 'default' => '' ), 'sort_column' => array( 'filter' => FILTER_CALLBACK, 'default' => 'username', 'options' => array('options' => 'sanitize_search_string') ), 'sort_direction' => array( 'filter' => FILTER_CALLBACK, 'default' => 'ASC', 'options' => array('options' => 'sanitize_search_string') ), ); validate_store_request_vars($filters, 'sess_usera'); /* ================= input validation ================= */ ?>
    '> ' title=''> ' title=''>
    = 0) { if (get_request_var('realm') < 4) { $sql_where .= ($sql_where != '' ? ' AND ':'WHERE ') . ' user_auth.realm = ' . get_request_var('realm'); } else { $sql_where .= ($sql_where != '' ? ' AND ':'WHERE ') . ' user_auth.realm > 3'; } } $total_rows = db_fetch_cell("SELECT COUNT(user_auth.id) FROM user_auth $sql_where"); $sql_order = get_order_string(); $sql_limit = ' LIMIT ' . ($rows*(get_request_var('page')-1)) . ',' . $rows; $user_list = db_fetch_assoc("SELECT id, user_auth.username, full_name, realm, enabled, policy_graphs, policy_hosts, policy_graph_templates, time, max(UNIX_TIMESTAMP(time)) as dtime FROM user_auth LEFT JOIN user_log ON (user_auth.id = user_log.user_id) $sql_where GROUP BY id $sql_order $sql_limit"); $nav = html_nav_bar('user_admin.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 9, __('Users'), 'page', 'main'); form_start('user_admin.php', 'chk'); print $nav; html_start_box('', '100%', '', '3', 'center', ''); $display_text = array( 'username' => array(__('User Name'), 'ASC'), 'id' => array(__('User ID'), 'ASC'), 'full_name' => array(__('Full Name'), 'ASC'), 'enabled' => array(__('Enabled'), 'ASC'), 'realm' => array(__('Realm'), 'ASC'), 'policy_graphs' => array(__('Graph Policy'), 'ASC'), 'policy_hosts' => array(__('Device Policy'), 'ASC'), 'policy_graph_templates' => array(__('Template Policy'), 'ASC'), 'dtime' => array(__('Last Login'), 'DESC') ); html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false); if (cacti_sizeof($user_list)) { foreach ($user_list as $user) { if (empty($user['dtime']) || $user['dtime'] <= 10000) { $last_login = __('N/A'); } else { $last_login = date('l, F d, Y H:i:s ', $user['dtime']); } if ($user['enabled'] == 'on') { $enabled = __('Yes'); } else { $enabled = __('No'); } if (isset($auth_realms[$user['realm']])) { $realm = $auth_realms[$user['realm']]; } else { $realm = __('Unavailable'); } // Check for a disabled removal $disabled = is_template_account($user['id']); if ($_SESSION['sess_user_id'] == $user['id']) { $disabled = true; } form_alternate_row('line' . $user['id'], true, $disabled); form_selectable_cell(filter_value($user['username'], get_request_var('filter'), $config['url_path'] . 'user_admin.php?action=user_edit&tab=general&id=' . $user['id']), $user['id']); form_selectable_cell($user['id'], $user['id']); form_selectable_cell(filter_value($user['full_name'], get_request_var('filter')), $user['id']); form_selectable_cell($enabled, $user['id']); form_selectable_cell($realm, $user['id']); form_selectable_cell(($user['policy_graphs'] == 1 ? __('ALLOW'):__('DENY')), $user['id']); form_selectable_cell(($user['policy_hosts'] == 1 ? __('ALLOW'):__('DENY')), $user['id']); form_selectable_cell(($user['policy_graph_templates'] == 1 ? __('ALLOW'):__('DENY')), $user['id']); form_selectable_cell($last_login, $user['id']); form_checkbox_cell($user['username'], $user['id'], $disabled); form_end_row(); } } else { print '' . __('No Users Found') . ''; } html_end_box(false); if (cacti_sizeof($user_list)) { print $nav; } draw_actions_dropdown($user_actions); form_end(); } function process_graph_request_vars() { /* ================= input validation and session storage ================= */ $filters = array( 'rows' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => read_config_option('num_rows_table') ), 'page' => array( 'filter' => FILTER_VALIDATE_INT, 'default' => '1' ), 'filter' => array( 'filter' => FILTER_DEFAULT, 'pageset' => true, 'default' => '' ), 'graph_template_id' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1', ), 'associated' => array( 'filter' => FILTER_VALIDATE_REGEXP, 'options' => array('options' => array('regexp' => '(true|false)')), 'pageset' => true, 'default' => 'true' ) ); validate_store_request_vars($filters, 'sess_uag'); /* ================= input validation ================= */ } function process_group_request_vars() { /* ================= input validation and session storage ================= */ $filters = array( 'rows' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => read_config_option('num_rows_table') ), 'page' => array( 'filter' => FILTER_VALIDATE_INT, 'default' => '1' ), 'filter' => array( 'filter' => FILTER_DEFAULT, 'pageset' => true, 'default' => '' ), 'associated' => array( 'filter' => FILTER_VALIDATE_REGEXP, 'options' => array('options' => array('regexp' => '(true|false)')), 'pageset' => true, 'default' => 'true' ) ); validate_store_request_vars($filters, 'sess_uagr'); /* ================= input validation ================= */ } function process_device_request_vars() { /* ================= input validation and session storage ================= */ $filters = array( 'rows' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => read_config_option('num_rows_table') ), 'page' => array( 'filter' => FILTER_VALIDATE_INT, 'default' => '1' ), 'filter' => array( 'filter' => FILTER_DEFAULT, 'pageset' => true, 'default' => '' ), 'host_template_id' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1', ), 'associated' => array( 'filter' => FILTER_VALIDATE_REGEXP, 'options' => array('options' => array('regexp' => '(true|false)')), 'pageset' => true, 'default' => 'true' ) ); validate_store_request_vars($filters, 'sess_uad'); /* ================= input validation ================= */ } function process_template_request_vars() { /* ================= input validation and session storage ================= */ $filters = array( 'rows' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => read_config_option('num_rows_table') ), 'page' => array( 'filter' => FILTER_VALIDATE_INT, 'default' => '1' ), 'filter' => array( 'filter' => FILTER_DEFAULT, 'pageset' => true, 'default' => '' ), 'graph_template_id' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1', ), 'associated' => array( 'filter' => FILTER_VALIDATE_REGEXP, 'options' => array('options' => array('regexp' => '(true|false)')), 'pageset' => true, 'default' => 'true' ) ); validate_store_request_vars($filters, 'sess_uate'); /* ================= input validation ================= */ } function process_tree_request_vars() { /* ================= input validation and session storage ================= */ $filters = array( 'rows' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => read_config_option('num_rows_table') ), 'page' => array( 'filter' => FILTER_VALIDATE_INT, 'default' => '1' ), 'filter' => array( 'filter' => FILTER_DEFAULT, 'pageset' => true, 'default' => '' ), 'graph_template_id' => array( 'filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1', ), 'associated' => array( 'filter' => FILTER_VALIDATE_REGEXP, 'options' => array('options' => array('regexp' => '(true|false)')), 'pageset' => true, 'default' => 'true' ) ); validate_store_request_vars($filters, 'sess_uatr'); /* ================= input validation ================= */ } function graph_filter($header_label) { global $config, $item_rows; ?>
    '> > ' title=''> ' title=''>
    '>
    '> > ' title=''> ' title=''>
    '>
    '> > ' title=''> ' title=''>
    '>
    '> > ' title=''> ' title=''>
    '>
    '> > ' title=''> ' title=''>
    '>
    '> > ' title=''> ' title=''>
    '>