function host() {
global $colors, $device_actions;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("host_template_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("host_status"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_device_current_page");
kill_session_var("sess_device_filter");
kill_session_var("sess_device_host_template_id");
kill_session_var("sess_host_status");
kill_session_var("sess_host_sort_column");
kill_session_var("sess_host_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["host_template_id"]);
unset($_REQUEST["host_status"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
if ((!empty($_SESSION["sess_host_status"])) && (!empty($_REQUEST["host_status"]))) {
if ($_SESSION["sess_host_status"] != $_REQUEST["host_status"]) {
$_REQUEST["page"] = 1;
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_device_current_page", "1");
load_current_session_value("filter", "sess_device_filter", "");
load_current_session_value("host_template_id", "sess_device_host_template_id", "-1");
load_current_session_value("host_status", "sess_host_status", "-1");
load_current_session_value("sort_column", "sess_host_sort_column", "description");
load_current_session_value("sort_direction", "sess_host_sort_direction", "ASC");
html_start_box("<strong>Devices</strong>", "100%", $colors["header"], "3", "center", "host.php?action=edit&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"]);
include("./include/html/inc_device_filter_table.php");
html_end_box();
/* form the 'where' clause for our main sql query */
if (strlen($_REQUEST["filter"])) {
$sql_where = "where (host.hostname like '%%" . $_REQUEST["filter"] . "%%' OR host.description like '%%" . $_REQUEST["filter"] . "%%')";
}else{
$sql_where = "";
}
if ($_REQUEST["host_status"] == "-1") {
/* Show all items */
}elseif ($_REQUEST["host_status"] == "-2") {
$sql_where .= (strlen($sql_where) ? " and host.disabled='on'" : "where host.disabled='on'");
}elseif ($_REQUEST["host_status"] == "-3") {
$sql_where .= (strlen($sql_where) ? " and host.disabled=''" : "where host.disabled=''");
}elseif ($_REQUEST["host_status"] == "-4") {
$sql_where .= (strlen($sql_where) ? " and (host.status!='3' or host.disabled='on')" : "where (host.status!='3' or host.disabled='on')");
}else {
$sql_where .= (strlen($sql_where) ? " and (host.status=" . $_REQUEST["host_status"] . " AND host.disabled = '')" : "where (host.status=" . $_REQUEST["host_status"] . " AND host.disabled = '')");
}
if ($_REQUEST["host_template_id"] == "-1") {
/* Show all items */
}elseif ($_REQUEST["host_template_id"] == "0") {
$sql_where .= (strlen($sql_where) ? " and host.host_template_id=0" : "where host.host_template_id=0");
}elseif (!empty($_REQUEST["host_template_id"])) {
$sql_where .= (strlen($sql_where) ? " and host.host_template_id=" . $_REQUEST["host_template_id"] : "where host.host_template_id=" . $_REQUEST["host_template_id"]);
}
html_start_box("", "100%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("select
COUNT(host.id)
from host
$sql_where");
$sortby = $_REQUEST["sort_column"];
if ($sortby=="hostname") {
$sortby = "INET_ATON(hostname)";
}
$host_graphs = array_rekey(db_fetch_assoc("SELECT host_id, count(*) as graphs FROM graph_local GROUP BY host_id"), "host_id", "graphs");
$host_data_sources = array_rekey(db_fetch_assoc("SELECT host_id, count(*) as data_sources FROM data_local GROUP BY host_id"), "host_id", "data_sources");
$sql_query = "SELECT
host.id,
host.disabled,
host.status,
host.hostname,
host.description,
host.min_time,
host.max_time,
host.cur_time,
host.avg_time,
host.availability
FROM host
$sql_where
ORDER BY " . $sortby . " " . $_REQUEST["sort_direction"] . "
LIMIT " . (read_config_option("num_rows_device")*($_REQUEST["page"]-1)) . "," . read_config_option("num_rows_device");
//print $sql_query;
$hosts = db_fetch_assoc($sql_query);
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, "host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"]);
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='9'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='left' class='textHeaderDark'>
<strong><< "; if ($_REQUEST["page"] > 1) { $nav .= "<a class='linkOverDark' href='host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"] . "&page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . ((read_config_option("num_rows_device")*($_REQUEST["page"]-1))+1) . " to " . ((($total_rows < read_config_option("num_rows_device")) || ($total_rows < (read_config_option("num_rows_device")*$_REQUEST["page"]))) ? $total_rows : (read_config_option("num_rows_device")*$_REQUEST["page"])) . " of $total_rows [$url_page_select]
</td>\n
<td align='right' class='textHeaderDark'>
<strong>"; if (($_REQUEST["page"] * read_config_option("num_rows_device")) < $total_rows) { $nav .= "<a class='linkOverDark' href='host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"] . "&page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * read_config_option("num_rows_device")) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
print $nav;
$display_text = array(
"description" => array("Description", "ASC"),
"nosort1" => array("Graphs", "ASC"),
"nosort2" => array("Data Sources", "ASC"),
"status" => array("Status", "ASC"),
"hostname" => array("Hostname", "ASC"),
"cur_time" => array("Current (ms)", "DESC"),
"avg_time" => array("Average (ms)", "DESC"),
"availability" => array("Availability", "ASC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($hosts) > 0) {
foreach ($hosts as $host) {
form_alternate_row_color($colors["alternate"], $colors["light"], $i, 'line' . $host["id"]); $i++;
form_selectable_cell("<a class='linkEditMain' href='host.php?action=edit&id=" . $host["id"] . "'>" .
(strlen($_REQUEST["filter"]) ? eregi_replace("(" . preg_quote($_REQUEST["filter"]) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["description"]) : $host["description"]) . "</a>", $host["id"], 250);
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((strlen($_REQUEST["filter"]) ? eregi_replace("(" . preg_quote($_REQUEST["filter"]) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["hostname"]) : $host["hostname"]), $host["id"]);
form_selectable_cell(round(($host["cur_time"]), 2), $host["id"]);
form_selectable_cell(round(($host["avg_time"]), 2), $host["id"]);
form_selectable_cell(round($host["availability"], 2), $host["id"]);
form_checkbox_cell($host["description"], $host["id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No Hosts</em></td></tr>";
}
html_end_box(false);
/* add a list of tree names to the actions dropdown */
add_tree_names_to_actions_array();
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
}
function mactrack_format_device_row($device, $actions = false)
{
global $config, $colors, $mactrack_device_types;
/* viewer level */
if ($actions) {
$row = "<a href='" . htmlspecialchars($config['url_path'] . "plugins/mactrack/mactrack_interfaces.php?device_id=" . $device['device_id'] . "&issues=0&page=1") . "'><img src='" . $config['url_path'] . "plugins/mactrack/images/view_interfaces.gif' alt='' onMouseOver='style.cursor=\"pointer\"' title='View Interfaces' align='middle' border='0'></a>";
/* admin level */
if (mactrack_authorized(2121)) {
if ($device["disabled"] == '') {
$row .= "<img id='r_" . $device["device_id"] . "' src='" . $config['url_path'] . "plugins/mactrack/images/rescan_device.gif' alt='' onMouseOver='style.cursor=\"pointer\"' onClick='scan_device(" . $device["device_id"] . ")' title='Rescan Device' align='middle' border='0'>";
} else {
$row .= "<img src='" . $config['url_path'] . "plugins/mactrack/images/view_none.gif' alt='' align='middle' border='0'>";
}
}
print "<td style='width:40px;'>" . $row . "</td>";
//, $device["device_id"]);
}
form_selectable_cell("<a class='linkEditMain' href='mactrack_devices.php?action=edit&device_id=" . $device['device_id'] . "'>" . (strlen($_REQUEST['filter']) ? preg_replace("/(" . preg_quote($_REQUEST['filter']) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $device['device_name']) : $device['device_name']) . "</a>", $device["device_id"]);
form_selectable_cell($device["site_name"], $device["device_id"]);
form_selectable_cell(get_colored_device_status($device["disabled"] == "on" ? true : false, $device["snmp_status"]), $device["device_id"]);
form_selectable_cell(strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $device["hostname"]) : $device["hostname"], $device["device_id"]);
form_selectable_cell($device["device_type"] == '' ? 'Not Detected' : $device["device_type"], $device["device_id"]);
form_selectable_cell($device["scan_type"] == "1" ? "N/A" : $device["ips_total"], $device["device_id"]);
form_selectable_cell($device["scan_type"] == "3" ? "N/A" : $device["ports_total"], $device["device_id"]);
form_selectable_cell($device["scan_type"] == "3" ? "N/A" : $device["ports_active"], $device["device_id"]);
form_selectable_cell($device["scan_type"] == "3" ? "N/A" : $device["ports_trunk"], $device["device_id"]);
form_selectable_cell($device["scan_type"] == "3" ? "N/A" : $device["macs_active"], $device["device_id"]);
form_selectable_cell(number_format($device["last_runduration"], 1), $device["device_id"]);
form_checkbox_cell($device["device_name"], $device["device_id"]);
form_end_row();
}
function hosts($header_label)
{
global $assoc_actions, $item_rows;
/* ================= input validation and session storage ================= */
$filters = array('rows' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'page' => array('filter' => FILTER_VALIDATE_INT, 'default' => '1'), 'filter' => array('filter' => FILTER_CALLBACK, 'pageset' => true, 'default' => '', 'options' => array('options' => 'sanitize_search_string')), 'sort_column' => array('filter' => FILTER_CALLBACK, 'default' => 'description', 'options' => array('options' => 'sanitize_search_string')), 'sort_direction' => array('filter' => FILTER_CALLBACK, 'default' => 'ASC', 'options' => array('options' => 'sanitize_search_string')), 'associated' => array('filter' => FILTER_CALLBACK, 'default' => 'true', 'options' => array('options' => 'sanitize_search_string')), 'host_template_id' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'));
validate_store_request_vars($filters, 'sess_nlh');
/* ================= input validation ================= */
/* if the number of rows is -1, set it to the default */
if (get_request_var('rows') == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = get_request_var('rows');
}
html_start_box(__('Associated Devices') . ' ' . htmlspecialchars($header_label), '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td>
<form id='form_devices' method='post' action='notify_lists.php'>
<table class='filterTable'>
<tr>
<td>
<?php
print __('Search');
?>
</td>
<td>
<input type='text' id='filter' size='25' value='<?php
print htmlspecialchars(get_request_var('filter'));
?>
' onChange='applyFilter()'>
</td>
<td>
<?php
print __('Type');
?>
</td>
<td>
<select id='host_template_id' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('host_template_id') == '-1') {
?>
selected<?php
}
?>
><?php
print __('Any');
?>
</option>
<option value='0'<?php
if (get_request_var('host_template_id') == '0') {
?>
selected<?php
}
?>
><?php
print __('None');
?>
</option>
<?php
$host_templates = db_fetch_assoc('select id,name from host_template order by name');
if (sizeof($host_templates) > 0) {
foreach ($host_templates as $host_template) {
print "<option value='" . $host_template['id'] . "'";
if (get_request_var('host_template_id') == $host_template['id']) {
print ' selected';
}
print '>' . htmlspecialchars($host_template['name']) . "</option>\n";
}
}
?>
</select>
</td>
<td>
<?php
print __('Devices');
?>
</td>
<td>
<select id='rows' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('rows') == '-1') {
?>
selected<?php
}
?>
><?php
print __('Default');
?>
</option>
<?php
if (sizeof($item_rows) > 0) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if (get_request_var('rows') == $key) {
print ' selected';
}
print '>' . htmlspecialchars($value) . "</option>\n";
}
}
?>
</select>
</td>
<td>
<input type='checkbox' id='associated' onChange='applyFilter()' <?php
print get_request_var('associated') == 'true' || get_request_var('associated') == 'on' ? 'checked' : '';
?>
>
</td>
<td>
<label for='associated'><?php
print __('Associated');
?>
</label>
</td>
<td>
<input type='button' value='<?php
print __('Go');
?>
' onClick='applyFilter()' title='<?php
print __('Set/Refresh Filters');
?>
'>
</td>
<td nowrap>
<input type='button' name='clearf' value='<?php
print __('Clear');
?>
' onClick='clearFilter()' title='<?php
print __('Clear Filters');
?>
'>
</td>
</tr>
</table>
<input type='hidden' id='page' value='<?php
print get_filter_request_var('page');
?>
'>
<input type='hidden' name='action' value='edit'>
<input type='hidden' id='id' value='<?php
print get_filter_request_var('id');
?>
'>
</form>
<script type='text/javascript'>
function applyFilter() {
strURL = '?header=false&action=edit&id=<?php
print get_request_var('id');
?>
'
strURL += '&rows=' + $('#rows').val();
strURL += '&host_template_id=' + $('#host_template_id').val();
strURL += '&associated=' + $('#associated').is(':checked');
strURL += '&filter=' + $('#filter').val();
loadPageNoHeader(strURL);
}
function clearFilter() {
strURL = 'notify_lists.php?header=false&action=edit&id=<?php
print get_request_var('id');
?>
&clearf=true'
loadPageNoHeader(strURL);
}
$(function() {
$('#form_devices').submit(function(event) {
event.preventDefault();
applyFilter();
});
});
</script>
</td>
</tr>
<?php
html_end_box();
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var('filter'))) {
$sql_where = "WHERE (host.hostname LIKE '%" . get_request_var('filter') . "%' OR host.description LIKE '%" . get_request_var('filter') . "%')";
} else {
$sql_where = '';
}
if (get_request_var('host_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var('host_template_id') == '0') {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' host.host_template_id=0';
} elseif (!isempty_request_var('host_template_id')) {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' host.host_template_id=' . get_request_var('host_template_id');
}
if (get_request_var('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' (host.thold_send_email>1 AND host.thold_host_email=' . get_request_var('id') . ')';
}
$total_rows = db_fetch_cell("select\n\t\tCOUNT(host.id)\n\t\tfrom host\n\t\t{$sql_where}");
$host_graphs = array_rekey(db_fetch_assoc('SELECT host_id, count(*) as graphs FROM graph_local GROUP BY host_id'), 'host_id', 'graphs');
$host_data_sources = array_rekey(db_fetch_assoc('SELECT host_id, count(*) as data_sources FROM data_local GROUP BY host_id'), 'host_id', 'data_sources');
$sql_query = "SELECT *\n\t\tFROM host {$sql_where}\n\t\tLIMIT " . $rows * (get_request_var('page') - 1) . ',' . $rows;
$hosts = db_fetch_assoc($sql_query);
$nav = html_nav_bar('notify_lists.php?action=edit&id=' . get_request_var('id'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 10, __('Devices'), 'page', 'main');
form_start('notify_lists.php', 'chk');
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array(__('Description'), __('ID'), __('Associated Lists'), __('Graphs'), __('Data Sources'), __('Status'), __('Hostname'));
html_header_checkbox($display_text);
if (sizeof($hosts)) {
foreach ($hosts as $host) {
form_alternate_row('line' . $host['id'], true);
form_selectable_cell(filter_value($host['description'], get_request_var('filter')), $host['id'], 250);
form_selectable_cell(round($host['id'], 2), $host['id']);
if ($host['thold_send_email'] == 0) {
form_selectable_cell('<span style="color:blue;font-weight:bold;">' . __('Disabled') . '</span>', $host['id']);
} elseif ($host['thold_send_email'] == 1) {
form_selectable_cell('<span style="color:purple;font-weight:bold;">' . __('Global List') . '</span>', $host['id']);
} elseif ($host['thold_host_email'] == get_request_var('id')) {
if ($host['thold_send_email'] == 2) {
form_selectable_cell('<span style="color:green;font-weight:bold;">' . __('Current List Only') . '</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">' . __('Current and Global List(s)') . '</span>', $host['id']);
}
} elseif ($host['thold_host_email'] == '0') {
form_selectable_cell('<span style="color:green;font-weight:bold;">' . __('None') . '</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">' . db_fetch_cell('SELECT name FROM plugin_notification_lists WHERE id=' . get_request_var('id')) . '</span>', $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 '<tr><td><em>' . __('No Associated Devices Found') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($hosts)) {
print $nav;
}
form_hidden_box('tab', 'hosts', '');
form_hidden_box('id', get_request_var('id'), '');
form_hidden_box('save_associate', '1', '');
draw_actions_dropdown($assoc_actions);
form_end();
}
function tholds_old()
{
global $colors, $assoc_actions, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("host_template_id"));
input_validate_input_number(get_request_var_request("rows"));
input_validate_input_number(get_request_var_request("page"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var_request("filter"));
}
/* clean up associated string */
if (isset($_REQUEST["associated"])) {
$_REQUEST["associated"] = sanitize_search_string(get_request_var_request("associated"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clearf"])) {
kill_session_var("sess_nlh_current_page");
kill_session_var("sess_nlh_filter");
kill_session_var("sess_nlh_host_template_id");
kill_session_var("sess_nlh_rows");
kill_session_var("sess_nlh_associated");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["associated"]);
unset($_REQUEST["host_template_id"]);
unset($_REQUEST["rows"]);
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_nlh_current_page", "1");
load_current_session_value("filter", "sess_nlh_filter", "");
load_current_session_value("associated", "sess_nlh_associated", "true");
load_current_session_value("host_template_id", "sess_nlh_host_template_id", "-1");
load_current_session_value("rows", "sess_nlh_rows", read_config_option("num_rows_device"));
/* if the number of rows is -1, set it to the default */
if ($_REQUEST["rows"] == -1) {
$_REQUEST["rows"] = read_config_option("num_rows_device");
}
?>
<script type="text/javascript">
<!--
function applyViewDeviceFilterChange(objForm) {
strURL = '?action=edit&id=<?php
print get_request_var_request('id');
?>
&rows=' + objForm.rows.value;
strURL = strURL + '&host_template_id=' + objForm.host_template_id.value;
strURL = strURL + '&associated=' + objForm.associated.checked;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
function clearViewDeviceFilterChange(objForm) {
strURL = '?action=edit&id=<?php
print get_request_var_request('id');
?>
&clearf=true'
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>Associated Devices</strong>", "100%", $colors["header"], "3", "center", "");
?>
<tr bgcolor="#<?php
print $colors["panel"];
?>
">
<td>
<form name="form_devices" method="post" action="notify_lists.php">
<table cellpadding="0" cellspacing="0">
<tr>
<td nowrap style='white-space: nowrap;' width="50">
Type:
</td>
<td width="1">
<select name="host_template_id" onChange="applyViewDeviceFilterChange(document.form_devices)">
<option value="-1"<?php
if (get_request_var_request("host_template_id") == "-1") {
?>
selected<?php
}
?>
>Any</option>
<option value="0"<?php
if (get_request_var_request("host_template_id") == "0") {
?>
selected<?php
}
?>
>None</option>
<?php
$host_templates = db_fetch_assoc("select id,name from host_template order by name");
if (sizeof($host_templates) > 0) {
foreach ($host_templates as $host_template) {
print "<option value='" . $host_template["id"] . "'";
if (get_request_var_request("host_template_id") == $host_template["id"]) {
print " selected";
}
print ">" . htmlspecialchars($host_template["name"]) . "</option>\n";
}
}
?>
</select>
</td>
<td nowrap style='white-space: nowrap;' width="20">
Search:
</td>
<td width="1">
<input type="text" name="filter" size="20" value="<?php
print htmlspecialchars(get_request_var_request("filter"));
?>
" onChange="applyViewDeviceFilterChange(document.form_devices)">
</td>
<td nowrap style='white-space: nowrap;' width="50">
Rows:
</td>
<td width="1">
<select name="rows" onChange="applyViewDeviceFilterChange(document.form_devices)">
<option value="-1"<?php
if (get_request_var_request("rows") == "-1") {
?>
selected<?php
}
?>
>Default</option>
<?php
if (sizeof($item_rows) > 0) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if (get_request_var_request("rows") == $key) {
print " selected";
}
print ">" . htmlspecialchars($value) . "</option>\n";
}
}
?>
</select>
</td>
<td>
<input type='checkbox' name='associated' id='associated' onChange='applyViewDeviceFilterChange(document.form_devices)' <?php
print $_REQUEST['associated'] == 'true' || $_REQUEST['associated'] == 'on' ? 'checked' : '';
?>
>
</td>
<td>
<label for='associated'>Associated</label>
</td>
<td nowrap>
<input type="button" value="Go" onClick='applyViewDeviceFilterChange(document.form_devices)' title="Set/Refresh Filters">
</td>
<td nowrap>
<input type="button" name="clearf" value="Clear" onClick='clearViewDeviceFilterChange(document.form_devices)' title="Clear Filters">
</td>
</tr>
</table>
<input type='hidden' name='page' value='1'>
<input type='hidden' name='tab' value='hosts'>
<input type='hidden' name='action' value='edit'>
<input type='hidden' name='id' value='<?php
print get_request_var_request('id');
?>
'>
</form>
</td>
</tr>
<?php
html_end_box();
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request("filter"))) {
$sql_where = "WHERE (host.hostname LIKE '%%" . get_request_var_request("filter") . "%%' OR host.description LIKE '%%" . get_request_var_request("filter") . "%%')";
} else {
$sql_where = "";
}
if (get_request_var_request("host_template_id") == "-1") {
/* Show all items */
} elseif (get_request_var_request("host_template_id") == "0") {
$sql_where .= (strlen($sql_where) ? " AND " : "WHERE ") . " host.host_template_id=0";
} elseif (!empty($_REQUEST["host_template_id"])) {
$sql_where .= (strlen($sql_where) ? " AND " : "WHERE ") . " host.host_template_id=" . get_request_var_request("host_template_id");
}
if (get_request_var_request("associated") == "false") {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? " AND " : "WHERE ") . " (host.thold_send_email>1 AND host.thold_host_email=" . get_request_var_request("id") . ")";
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='notify_lists.php?action=edit&tab=hosts&id=" . get_request_var_request("id") . "'>\n";
html_start_box("", "100%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("SELECT\n\t\tCOUNT(*)\n\t\tFROM host\n\t\t{$sql_where}");
$host_graphs = array_rekey(db_fetch_assoc("SELECT host_id, count(*) as graphs FROM graph_local GROUP BY host_id"), "host_id", "graphs");
$host_data_sources = array_rekey(db_fetch_assoc("SELECT host_id, count(*) as data_sources FROM data_local GROUP BY host_id"), "host_id", "data_sources");
$sql_query = "SELECT * \n\t\tFROM host {$sql_where} \n\t\tLIMIT " . get_request_var_request("rows") * (get_request_var_request("page") - 1) . "," . get_request_var_request("rows");
$hosts = db_fetch_assoc($sql_query);
/* generate page list */
if ($total_rows > 0) {
$url_page_select = get_page_list(get_request_var_request("page"), MAX_DISPLAY_PAGES, get_request_var_request("rows"), $total_rows, "notify_lists.php?action=edit&tab=hosts&id=" . get_request_var_request('id'));
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t\t<td colspan='8'>\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\n\t\t\t\t\t\t\t\t<strong><< ";
if (get_request_var_request("page") > 1) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("notify_lists.php?action=edit&id=" . get_request_var_request("id") . "&page=" . (get_request_var_request("page") - 1)) . "'>";
}
$nav .= "Previous";
if (get_request_var_request("page") > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\n\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\t\tShowing Rows " . (get_request_var_request("rows") * (get_request_var_request("page") - 1) + 1) . " to " . ($total_rows < read_config_option("num_rows_device") || $total_rows < get_request_var_request("rows") * get_request_var_request("page") ? $total_rows : get_request_var_request("rows") * get_request_var_request("page")) . " of {$total_rows} [{$url_page_select}]\n\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\t\t<strong>";
if (get_request_var_request("page") * get_request_var_request("rows") < $total_rows) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("notify_lists.php?action=edit&id=" . get_request_var_request("id") . "&page=" . (get_request_var_request("page") + 1)) . "'>";
}
$nav .= "Next";
if (get_request_var_request("page") * get_request_var_request("rows") < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\n\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n";
} else {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t\t<td colspan='8'>\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\t\tNo Rows Found\n\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t</td>\n\t\t\t</tr>\n";
}
print $nav;
$display_text = array("Description", "ID", "Associated Lists", "Graphs", "Data Sources", "Status", "Hostname");
html_header_checkbox($display_text);
$i = 0;
if (sizeof($hosts)) {
foreach ($hosts as $host) {
form_alternate_row_color($colors["alternate"], $colors["light"], $i, 'line' . $host["id"]);
$i++;
form_selectable_cell(strlen(get_request_var_request("filter")) ? preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", htmlspecialchars($host["description"])) : htmlspecialchars($host["description"]), $host["id"], 250);
form_selectable_cell(round($host["id"], 2), $host["id"]);
if ($host['thold_send_email'] == 0) {
form_selectable_cell('<span style="color:blue;font-weight:bold;">Disabled</span>', $host['id']);
} elseif ($host['thold_send_email'] == 1) {
form_selectable_cell('<span style="color:purple;font-weight:bold;">Global List</span>', $host['id']);
} elseif ($host['thold_host_email'] == get_request_var_request('id')) {
if ($host['thold_send_email'] == 2) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Current List Only</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Current and Global List(s)</span>', $host['id']);
}
} elseif ($host['thold_host_email'] == '0') {
form_selectable_cell('<span style="color:green;font-weight:bold;">None</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">' . db_fetch_cell("SELECT name FROM plugin_notification_lists WHERE id=" . get_request_var_request('id')) . '</span>', $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(strlen(get_request_var_request("filter")) ? preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", htmlspecialchars($host["hostname"])) : htmlspecialchars($host["hostname"]), $host["id"]);
form_checkbox_cell($host["description"], $host["id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print "<tr><td><em>No Associated Hosts Found</em></td></tr>";
}
html_end_box(false);
form_hidden_box("action", "edit");
form_hidden_box("id", get_request_var_request("id"));
form_hidden_box("save_associate", "1");
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($assoc_actions);
print "</form>\n";
}
function device() {
global $colors, $item_rows;
require(CACTI_BASE_PATH . "/include/device/device_arrays.php");
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("template_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("status"));
input_validate_input_number(get_request_var_request("rows"));
input_validate_input_number(get_request_var_request("poller"));
input_validate_input_number(get_request_var_request("site"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_device_current_page");
kill_session_var("sess_device_filter");
if (!substr_count($_SERVER["REQUEST_URI"], "/device_templates.php")) {
kill_session_var("sess_device_template_id");
}
kill_session_var("sess_device_status");
kill_session_var("sess_device_rows");
kill_session_var("sess_device_poller");
kill_session_var("sess_device_site");
kill_session_var("sess_device_sort_column");
kill_session_var("sess_device_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
if (!substr_count($_SERVER["REQUEST_URI"], "/device_templates.php")) {
unset($_REQUEST["template_id"]);
}
unset($_REQUEST["status"]);
unset($_REQUEST["poller"]);
unset($_REQUEST["site"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
/* let's see if someone changed an important setting */
$changed = FALSE;
$changed += check_changed("filter", "sess_device_filter");
$changed += check_changed("template_id", "sess_device_template_id");
$changed += check_changed("status", "sess_device_status");
$changed += check_changed("rows", "sess_device_rows");
$changed += check_changed("poller", "sess_device_poller");
$changed += check_changed("site", "sess_device_site");
$changed += check_changed("device_id", "sess_ds_device_id");
if ($changed) {
$_REQUEST["page"] = "1";
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_device_current_page", "1");
load_current_session_value("filter", "sess_device_filter", "");
load_current_session_value("template_id", "sess_device_template_id", "-1");
load_current_session_value("status", "sess_device_status", "-1");
load_current_session_value("rows", "sess_device_rows", "-1");
load_current_session_value("poller", "sess_device_poller", "-1");
load_current_session_value("site", "sess_device_site", "-1");
load_current_session_value("sort_column", "sess_device_sort_column", "description");
load_current_session_value("sort_direction", "sess_device_sort_direction", "ASC");
?>
<script type="text/javascript">
<!--
function clearDeviceFilterChange(objForm) {
<?php print (isset($_REQUEST["tab"]) ? "strURL = '?template_id=" . $_REQUEST["template_id"] . "&id=" . $_REQUEST["template_id"] . "&action=edit&action=edit&tab=" . $_REQUEST["tab"] . "';" : "strURL = '?template_id=-1';");?>
strURL = strURL + '&filter=';
strURL = strURL + '&rows=-1';
document.location = strURL;
}
function applyDeviceFilterChange(objForm) {
if (objForm.template_id.value) {
strURL = '?template_id=' + objForm.template_id.value;
strURL = strURL + '&filter=' + objForm.filter.value;
}else{
strURL = '?filter=' + objForm.filter.value;
}
strURL = strURL + '&status=' + objForm.status.value;
strURL = strURL + '&rows=' + objForm.rows.value;
strURL = strURL + '&poller=' + objForm.poller.value;
strURL = strURL + '&site=' + objForm.site.value;
<?php print (isset($_REQUEST["tab"]) ? "strURL = strURL + '&id=' + objForm.template_id.value + '&action=edit&action=edit&tab=" . $_REQUEST["tab"] . "';" : "");?>
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>" . __("Devices") . "</strong>", "100", $colors["header"], "3", "center", "devices.php?action=edit&template_id=" . $_REQUEST["template_id"] . "&status=" . $_REQUEST["status"], true);
?>
<tr class='rowAlternate2'>
<td>
<form action="devices.php" name="form_devices" method="post">
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Type:");?>
</td>
<td class="w1">
<select name="template_id" onChange="applyDeviceFilterChange(document.form_devices)">
<option value="-1"<?php if (get_request_var_request("template_id") == "-1") {?> selected<?php }?>><?php print __("Any");?></option>
<option value="0"<?php if (get_request_var_request("template_id") == "0") {?> selected<?php }?>><?php print __("None");?></option>
<?php
$device_templates = db_fetch_assoc("select id,name from device_template order by name");
if (sizeof($device_templates) > 0) {
foreach ($device_templates as $device_template) {
print "<option value='" . $device_template["id"] . "'"; if (get_request_var_request("template_id") == $device_template["id"]) { print " selected"; } print ">" . $device_template["name"] . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw50">
<?php print __("Status:");?>
</td>
<td class="w1">
<select name="status" onChange="applyDeviceFilterChange(document.form_devices)">
<option value="-1"<?php if (get_request_var_request("status") == "-1") {?> selected<?php }?>><?php print __("Any");?></option>
<option value="-3"<?php if (get_request_var_request("status") == "-3") {?> selected<?php }?>><?php print __("Enabled");?></option>
<option value="-2"<?php if (get_request_var_request("status") == "-2") {?> selected<?php }?>><?php print __("Disabled");?></option>
<option value="-4"<?php if (get_request_var_request("status") == "-4") {?> selected<?php }?>><?php print __("Not Up");?></option>
<option value="3"<?php if (get_request_var_request("status") == "3") {?> selected<?php }?>><?php print __("Up");?></option>
<option value="1"<?php if (get_request_var_request("status") == "1") {?> selected<?php }?>><?php print __("Down");?></option>
<option value="2"<?php if (get_request_var_request("status") == "2") {?> selected<?php }?>><?php print __("Recovering");?></option>
<option value="0"<?php if (get_request_var_request("status") == "0") {?> selected<?php }?>><?php print __("Unknown");?></option>
</select>
</td>
<td class="nw50">
<?php print __("Rows:");?>
</td>
<td class="w1">
<select name="rows" onChange="applyDeviceFilterChange(document.form_devices)">
<option value="-1"<?php if (get_request_var_request("rows") == "-1") {?> selected<?php }?>><?php print __("Default");?></option>
<?php
if (sizeof($item_rows) > 0) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'"; if (get_request_var_request("rows") == $key) { print " selected"; } print ">" . $value . "</option>\n";
}
}
?>
</select>
</td>
</tr>
</table>
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Site:");?>
</td>
<td class="w1">
<select name="site" onChange="applyDeviceFilterChange(document.form_devices)">
<option value="-1"<?php if (get_request_var_request("site") == "-1") {?> selected<?php }?>><?php print __("All");?></option>
<option value="0"<?php if (get_request_var_request("site") == "0") {?> selected<?php }?>><?php print __("Not Defined");?></option>
<?php
$sites = db_fetch_assoc("select id,name from sites order by name");
if (sizeof($sites)) {
foreach ($sites as $site) {
print "<option value='" . $site["id"] . "'"; if (get_request_var_request("site") == $site["id"]) { print " selected"; } print ">" . $site["name"] . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw50">
<?php print __("Poller:");?>
</td>
<td class="w1">
<select name="poller" onChange="applyDeviceFilterChange(document.form_devices)">
<option value="-1"<?php if (get_request_var_request("poller") == "-1") {?> selected<?php }?>><?php print __("All");?></option>
<option value="0"<?php if (get_request_var_request("poller") == "0") {?> selected<?php }?>><?php print __("System Default");?></option>
<?php
$pollers = db_fetch_assoc("select id,description AS name from poller order by description");
if (sizeof($pollers)) {
foreach ($pollers as $poller) {
print "<option value='" . $poller["id"] . "'"; if (get_request_var_request("poller") == $poller["id"]) { print " selected"; } print ">" . $poller["name"] . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw50">
<?php print __("Search:");?>
</td>
<td class="w1">
<input type="text" name="filter" size="20" value="<?php print $_REQUEST["filter"];?>">
</td>
<td class="nw120">
<input type="submit" Value="<?php print __("Go");?>" name="go" align="middle">
<input type="button" Value="<?php print __("Clear");?>" name="clear_x" align="middle" onClick="clearDeviceFilterChange(document.form_devices)">
</td>
</tr>
</table>
<div><input type='hidden' name='page' value='1'></div>
</form>
</td>
</tr>
<?php
html_end_box(false);
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request("filter"))) {
$sql_where = "where (device.hostname like '%%" . $_REQUEST["filter"] . "%%' OR device.description like '%%" . $_REQUEST["filter"] . "%%')";
}else{
$sql_where = "";
}
if (get_request_var_request("status") == "-1") {
/* Show all items */
}elseif (get_request_var_request("status") == "-2") {
$sql_where .= (strlen($sql_where) ? " and device.disabled='on'" : "where device.disabled='on'");
}elseif (get_request_var_request("status") == "-3") {
$sql_where .= (strlen($sql_where) ? " and device.disabled=''" : "where device.disabled=''");
}elseif (get_request_var_request("status") == "-4") {
$sql_where .= (strlen($sql_where) ? " and (device.status!='3' or device.disabled='on')" : "where (device.status!='3' or device.disabled='on')");
}else {
$sql_where .= (strlen($sql_where) ? " and (device.status=" . $_REQUEST["status"] . " AND device.disabled = '')" : "where (device.status=" . $_REQUEST["status"] . " AND device.disabled = '')");
}
if (get_request_var_request("template_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("template_id") == "0") {
$sql_where .= (strlen($sql_where) ? " and device.device_template_id=0" : "where device.device_template_id=0");
}elseif (!empty($_REQUEST["template_id"])) {
$sql_where .= (strlen($sql_where) ? " and device.device_template_id=" . $_REQUEST["template_id"] : "where device.device_template_id=" . $_REQUEST["template_id"]);
}
if (get_request_var_request("poller") == "-1") {
/* Show all items */
}elseif (get_request_var_request("poller") == "0") {
$sql_where .= (strlen($sql_where) ? " and device.poller_id=0" : "where device.poller_id=0");
}elseif (!empty($_REQUEST["poller"])) {
$sql_where .= (strlen($sql_where) ? " and device.poller_id=" . $_REQUEST["poller"] : "where device.poller_id=" . $_REQUEST["poller"]);
}
if (get_request_var_request("site") == "-1") {
/* Show all items */
}elseif (get_request_var_request("site") == "0") {
$sql_where .= (strlen($sql_where) ? " and device.site_id=0" : "where device.site_id=0");
}elseif (!empty($_REQUEST["site"])) {
$sql_where .= (strlen($sql_where) ? " and device.site_id=" . $_REQUEST["site"] : "where device.site_id=" . $_REQUEST["site"]);
}
html_start_box("", "100", $colors["header"], "0", "center", "");
$total_rows = db_fetch_cell("select
COUNT(device.id)
from device
$sql_where");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_device");
}else{
$rows = get_request_var_request("rows");
}
$sortby = $_REQUEST["sort_column"];
if ($sortby=="hostname") {
$sortby = "INET_ATON(hostname)";
}
$device_graphs = array_rekey(db_fetch_assoc("SELECT device_id, count(*) as graphs FROM graph_local GROUP BY device_id"), "device_id", "graphs");
$device_data_sources = array_rekey(db_fetch_assoc("SELECT device_id, count(*) as data_sources FROM data_local GROUP BY device_id"), "device_id", "data_sources");
$sql_query = "SELECT device.*, poller.description AS poller, sites.name AS site
FROM device
LEFT JOIN poller
ON device.poller_id=poller.id
LEFT JOIN sites
ON device.site_id=sites.id
$sql_where
ORDER BY " . $sortby . " " . get_request_var_request("sort_direction") . "
LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows;
//print $sql_query;
$devices = db_fetch_assoc($sql_query);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 13, "devices.php");
print $nav;
html_end_box(false);
$display_text = array(
"description" => array(__("Description"), "ASC"),
"device.hostname" => array(__("Hostname"), "ASC"),
"id" => array(__("ID"), "ASC"),
"nosort1" => array(__("Graphs"), "ASC"),
"nosort2" => array(__("Data Sources"), "ASC"),
"status" => array(__("Status"), "ASC"),
"status_event_count" => array(__("Event Count"), "ASC"),
"cur_time" => array(__("Current (ms)"), "DESC"),
"avg_time" => array(__("Average (ms)"), "DESC"),
"availability" => array(__("Availability"), "ASC"),
"polling_time" => array(__("Poll Time"), "DESC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($devices) > 0) {
foreach ($devices as $device) {
$spanextra = "";
if($device["disabled"] != CHECKED && $device["status"] == DEVICE_DOWN) {
$date = __date("D, " . date_time_format() . " T", strtotime($device['status_fail_date']));
$spanextra = 'title="' . __("Down since %s with error: '%s'", $date, $device['status_last_error']) . '"';
}
form_alternate_row_color('line' . $device["id"], true);
form_selectable_cell("<a style='white-space:nowrap;' class='linkEditMain' href='" . htmlspecialchars("devices.php?action=edit&id=" . $device["id"]) . "'>" .
(strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $device["description"]) : $device["description"]) . "</a>", $device["id"]);
form_selectable_cell((strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $device["hostname"]) : $device["hostname"]), $device["id"]);
form_selectable_cell(round(($device["id"]), 2), $device["id"]);
form_selectable_cell((isset($device_graphs[$device["id"]]) ? $device_graphs[$device["id"]] : 0), $device["id"]);
form_selectable_cell((isset($device_data_sources[$device["id"]]) ? $device_data_sources[$device["id"]] : 0), $device["id"]);
form_selectable_cell( "<span $spanextra>".get_colored_device_status(($device["disabled"] == CHECKED ? true : false), $device["status"]) . "</span>", $device["id"]);
form_selectable_cell(round(($device["status_event_count"]), 2), $device["id"]);
form_selectable_cell(round(($device["cur_time"]), 2), $device["id"]);
form_selectable_cell(round(($device["avg_time"]), 2), $device["id"]);
form_selectable_cell(round($device["availability"], 2), $device["id"]);
form_selectable_cell(round($device["polling_time"], 2), $device["id"]);
form_checkbox_cell($device["description"], $device["id"]);
form_end_row();
}
form_end_table();
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No Hosts") . "</em></td></tr>";
}
print "</table>\n";
/* add a list of tree names to the actions dropdown */
$device_actions = array_merge($device_actions, api_tree_add_tree_names_to_actions_array());
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
print "</form>\n";
}
function mactrack_view_devices() {
global $title, $report, $colors, $mactrack_search_types, $mactrack_device_types, $rows_selector, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("site_id"));
input_validate_input_number(get_request_var_request("device_id"));
input_validate_input_number(get_request_var_request("type_id"));
input_validate_input_number(get_request_var_request("device_type_id"));
input_validate_input_number(get_request_var_request("status"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"]) || isset($_REQUEST["reset"])) {
kill_session_var("sess_mactrack_view_device_current_page");
kill_session_var("sess_mactrack_view_device_filter");
kill_session_var("sess_mactrack_view_device_site_id");
kill_session_var("sess_mactrack_view_device_type_id");
kill_session_var("sess_mactrack_view_device_rows");
kill_session_var("sess_mactrack_view_device_device_type_id");
kill_session_var("sess_mactrack_view_device_status");
kill_session_var("sess_mactrack_view_device_sort_column");
kill_session_var("sess_mactrack_view_device_sort_direction");
$_REQUEST["page"] = 1;
if (isset($_REQUEST["clear_x"])) {
unset($_REQUEST["filter"]);
unset($_REQUEST["site_id"]);
unset($_REQUEST["type_id"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["device_type_id"]);
unset($_REQUEST["status"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
}else{
/* if any of the settings changed, reset the page number */
$changed = 0;
$changed += mactrack_check_changed("filter", "sess_mactrack_view_device_filter");
$changed += mactrack_check_changed("site_id", "sess_mactrack_view_device_site_id");
$changed += mactrack_check_changed("rows", "sess_mactrack_view_device_rows");
$changed += mactrack_check_changed("type_id", "sess_mactrack_view_device_type_id");
$changed += mactrack_check_changed("device_type_id", "sess_mactrack_view_device_device_type_id");
$changed += mactrack_check_changed("status", "sess_mactrack_view_device_status");
if ($changed) {
$_REQUEST["page"] = "1";
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_mactrack_view_device_current_page", "1");
load_current_session_value("filter", "sess_mactrack_view_device_filter", "");
load_current_session_value("site_id", "sess_mactrack_view_device_site_id", "-1");
load_current_session_value("type_id", "sess_mactrack_view_device_type_id", "-1");
load_current_session_value("device_type_id", "sess_mactrack_view_device_device_type_id", "-1");
load_current_session_value("status", "sess_mactrack_view_device_status", "-1");
load_current_session_value("rows", "sess_mactrack_view_device_rows", "-1");
load_current_session_value("sort_column", "sess_mactrack_view_device_sort_column", "site_name");
load_current_session_value("sort_direction", "sess_mactrack_view_device_sort_direction", "ASC");
if ($_REQUEST["rows"] == -1) {
$row_limit = read_config_option("num_rows_mactrack");
}elseif ($_REQUEST["rows"] == -2) {
$row_limit = 999999;
}else{
$row_limit = $_REQUEST["rows"];
}
if (defined("URL_PATH")) {
$webroot = URL_PATH;
}else{
$webroot = $config["url_path"];
}
mactrack_tabs();
mactrack_view_header();
mactrack_device_filter2();
mactrack_view_footer();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$devices = mactrack_view_get_device_records($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT
COUNT(mac_track_devices.device_id)
FROM mac_track_sites
RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id
LEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id)
$sql_where");
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_view_devices.php?report=devices");
if (isset($config["base_path"])) {
if ($total_rows > 0) {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='13'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='left' class='textHeaderDark'>
<strong><< "; if ($_REQUEST["page"] > 1) { $nav .= "<a class='linkOverDark' href='mactrack_view_devices.php?report=devices&page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . ($total_rows == 0 ? "None" : (($row_limit*($_REQUEST["page"]-1))+1) . " to " . ((($total_rows < $row_limit) || ($total_rows < ($row_limit*$_REQUEST["page"]))) ? $total_rows : ($row_limit*$_REQUEST["page"])) . " of $total_rows [$url_page_select]") . "
</td>\n
<td align='right' class='textHeaderDark'>
<strong>"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "<a class='linkOverDark' href='mactrack_view_devices.php?report=devices&page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
}else{
$nav = "<tr bgcolor='#" . $colors["header"] . "' class='noprint'>
<td colspan='22'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='center' class='textHeaderDark'>
No Rows Found
</td>\n
</tr>
</table>
</td>
</tr>\n";
}
}else{
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 13, "mactrack_view_sites.php");
}
print $nav;
$display_text = array(
"nosort" => array("Actions", ""),
"device_name" => array("Device Name", "ASC"),
"site_name" => array("Site Name", "ASC"),
"snmp_status" => array("Status", "ASC"),
"hostname" => array("Hostname", "ASC"),
"device_type" => array("Device Type", "ASC"),
"ips_total" => array("Total IP's", "DESC"),
"ports_total" => array("User Ports", "DESC"),
"ports_active" => array("User Ports Up", "DESC"),
"ports_trunk" => array("Trunk Ports", "DESC"),
"macs_active" => array("Active Macs", "DESC"),
"vlans_total" => array("Total VLAN's", "DESC"),
"last_runduration" => array("Last Duration", "DESC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($devices) > 0) {
foreach ($devices as $device) {
$hostinfo["hostname"] = $device["hostname"];
$hostinfo["user"] = $device["user_name"];
switch($device["term_type"]) {
case 0:
$hostinfo["transport"] = "none";
break;
case 1:
$hostinfo["transport"] = "telnet";
break;
case 2:
$hostinfo["transport"] = "ssh";
break;
case 3:
$hostinfo["transport"] = "http";
break;
case 4:
$hostinfo["transport"] = "https";
break;
}
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width=100>
<?php if (mactrack_authorized(2121)) {?>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_devices.php?action=edit&device_id=" . $device['device_id'];?>' title='Edit Device'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/edit_object.png'></a>
<?php api_plugin_hook_function('remote_link', $hostinfo); } ?>
<?php if ($device["host_id"] > 0) {?>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_graphs.php?action=preview&report=graphs&style=selective&graph_list=&host_id=" . $device["host_id"] . "&graph_template_id=0&filter=";?>' title='View Graphs'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_graphs.gif'></a>
<?php }else{?>
<img title='Device Not Mapped to Cacti Device' border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_graphs_disabled.gif'>
<?php }?>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_macs.php?report=macs&reset&device_id=-1&scan_date=3&site_id=" . $_REQUEST["site_id"] . "&device_id=" . $device['device_id'];?>' title='View MAC Addresses'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_macs.gif'></a>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_interfaces.php?report=interfaces&reset&site=" . $_REQUEST["site_id"] . "&device=" . $device['device_id'];?>' title='View Interfaces'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_interfaces.gif'></a>
</td>
<td width=150>
<?php print "<strong>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $device["device_name"]) : $device["device_name"]) . "</strong>";?>
</td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $device["site_name"]) : $device["site_name"]);?></td>
<td><?php print get_colored_device_status(($device["disabled"] == "on" ? true : false), $device["snmp_status"]);?></td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $device["hostname"]) : $device["hostname"]);?></td>
<td><?php print $device["device_type"];?></td>
<td><?php print ($device["scan_type"] == "1" ? "N/A" : $device["ips_total"]);?></td>
<td><?php print ($device["scan_type"] == "3" ? "N/A" : $device["ports_total"]);?></td>
<td><?php print ($device["scan_type"] == "3" ? "N/A" : $device["ports_active"]);?></td>
<td><?php print ($device["scan_type"] == "3" ? "N/A" : $device["ports_trunk"]);?></td>
<td><?php print ($device["scan_type"] == "3" ? "N/A" : $device["macs_active"]);?></td>
<td><?php print ($device["scan_type"] == "3" ? "N/A" : $device["vlans_total"]);?></td>
<td><?php print number_format($device["last_runduration"], 1);?></td>
</tr>
<?php
}
}else{
print "<tr><td colspan='10'><em>No MacTrack Devices</em></td></tr>";
}
print $nav;
html_end_box(false);
mactrack_display_stats();
}
function hmib_devices()
{
global $config, $item_rows;
/* ================= input validation and session storage ================= */
$filters = array('rows' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'page' => array('filter' => FILTER_VALIDATE_INT, 'default' => '1'), 'template' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'process' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'status' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'type' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'sort_column' => array('filter' => FILTER_CALLBACK, 'default' => 'description', '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_hmib_devices');
/* ================= input validation ================= */
?>
<script type='text/javascript'>
function applyFilter(objForm) {
strURL = '?action=devices';
strURL += '&type=' + $('#type').val();
strURL += '&status=' + $('#status').val();
strURL += '&process=' + $('#process').val();
strURL += '&template=' + $('#template').val();
strURL += '&filter=' + $('#filter').val();
strURL += '&rows=' + $('#rows').val();
strURL += '&page=' + $('#page').val();
strURL += '&header=false';
loadPageNoHeader(strURL);
}
function clearFilter() {
strURL = '?action=devices&clear=true&header=false';
loadPageNoHeader(strURL);
}
$(function() {
$('#devices').submit(function(event) {
event.preventDefault();
applyFilter();
});
});
</script>
<?php
html_start_box(__('Device Filter'), '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td>
<form id='devices' action='hmib.php?action=devices'>
<table class='filterTable'>
<tr>
<td style='white-space:nowrap;width:55px;'>
<?php
print __('OS Type');
?>
</td>
<td>
<select id='type' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('type') == '-1') {
?>
selected<?php
}
?>
><?php
print __('All');
?>
</option>
<?php
$types = db_fetch_assoc("SELECT DISTINCT id, CONCAT_WS('', name, ' [', version, ']') AS name\n\t\t\t\t\t\t\t\tFROM plugin_hmib_hrSystemTypes AS hrst\n\t\t\t\t\t\t\t\tINNER JOIN plugin_hmib_hrSystem AS hrs\n\t\t\t\t\t\t\t\tON hrst.id=hrs.host_type\n\t\t\t\t\t\t\t\tWHERE name!='' ORDER BY name");
if (sizeof($types)) {
foreach ($types as $t) {
echo "<option value='" . $t['id'] . "' " . (get_request_var('type') == $t['id'] ? 'selected' : '') . '>' . $t['name'] . '</option>';
}
}
?>
</select>
</td>
<td>
<?php
print __('Template');
?>
</td>
<td>
<select id='template' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('template') == '-1') {
?>
selected<?php
}
?>
><?php
print __('All');
?>
</option>
<?php
$templates = db_fetch_assoc('SELECT DISTINCT ht.id, ht.name
FROM host_template AS ht
INNER JOIN host
ON ht.id=host.host_template_id
INNER JOIN plugin_hmib_hrSystem AS hrs
ON host.id=hrs.host_id
ORDER BY name');
if (sizeof($templates)) {
foreach ($templates as $t) {
echo "<option value='" . $t['id'] . "' " . (get_request_var('template') == $t['id'] ? 'selected' : '') . '>' . $t['name'] . '</option>';
}
}
?>
</select>
</td>
<td>
<?php
print __('Process');
?>
</td>
<td>
<select id='process' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('process') == '-1') {
?>
selected<?php
}
?>
><?php
print __('All');
?>
</option>
<?php
$processes = db_fetch_assoc("SELECT DISTINCT name FROM plugin_hmib_hrSWRun WHERE name!='' ORDER BY name");
if (sizeof($processes)) {
foreach ($processes as $p) {
echo "<option value='" . $p['name'] . "' " . (get_request_var('process') == $p['name'] ? 'selected' : '') . '>' . $p['name'] . '</option>';
}
}
?>
</select>
</td>
<td>
<input type='button' onClick='applyFilter(document.devices)' value='<?php
print __('Go');
?>
'>
</td>
<td>
<input type='button' onClick='clearFilter()' value='<?php
print __('Clear');
?>
'>
</td>
</tr>
</table>
<table class='filterTable'>
<tr>
<td style='width:55px;'>
<?php
print __('Search');
?>
</td>
<td>
<input type='textbox' size='25' id='filter' value='<?php
print get_request_var('filter');
?>
'>
</td>
<td>
<?php
print __('Status');
?>
</td>
<td>
<select id='status' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('type') == '-1') {
?>
selected<?php
}
?>
><?php
print __('All');
?>
</option>
<?php
$statuses = db_fetch_assoc('SELECT DISTINCT status
FROM host
INNER JOIN plugin_hmib_hrSystem
ON host.id=plugin_hmib_hrSystem.host_id');
$statuses = array_merge($statuses, array('-2' => array('status' => '-2')));
if (sizeof($statuses)) {
foreach ($statuses as $s) {
switch ($s['status']) {
case '0':
$status = __('Unknown');
break;
case '1':
$status = __('Down');
break;
case '2':
$status = __('Recovering');
break;
case '3':
$status = __('Up');
break;
case '-2':
$status = __('Disabled');
break;
}
echo "<option value='" . $s['status'] . "' " . (get_request_var('status') == $s['status'] ? 'selected' : '') . '>' . $status . '</option>';
}
}
?>
</select>
</td>
<td>
<?php
print __('Devices');
?>
</td>
<td>
<select id='rows' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('rows') == '-1') {
?>
selected<?php
}
?>
><?php
print __('Default');
?>
</option>
<?php
if (sizeof($item_rows)) {
foreach ($item_rows as $key => $name) {
echo "<option value='" . $key . "' " . (get_request_var('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
}
}
?>
</select>
</td>
</tr>
</table>
<input type='hidden' id='page' value='<?php
print get_request_var('page');
?>
'>
</form>
</td>
</tr>
<?php
html_end_box();
if (get_request_var('rows') == '-1') {
$num_rows = read_config_option('num_rows_table');
} else {
$num_rows = get_request_var('rows');
}
$limit = ' LIMIT ' . $num_rows * (get_request_var('page') - 1) . ',' . $num_rows;
$sql_where = '';
if (get_request_var('template') != '-1') {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' host.host_template_id=' . get_request_var('template');
}
if (get_request_var('status') != '-1') {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' hrs.host_status=' . get_request_var('status');
}
if (get_request_var('type') != '-1') {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' hrs.host_type=' . get_request_var('type');
}
if (get_request_var('process') != '' && get_request_var('process') != '-1') {
$sql_join = 'INNER JOIN plugin_hmib_hrSWRun AS hrswr ON host.id=hrswr.host_id';
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . " hrswr.name='" . get_request_var('process') . "'";
} else {
$sql_join = '';
}
if (get_request_var('filter') != '') {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . " host.description LIKE '%" . get_request_var('filter') . "%' OR\n\t\t\thost.hostname LIKE '%" . get_request_var('filter') . "%'";
}
$sql = "SELECT hrs.*, host.hostname, host.description, host.disabled\n\t\tFROM plugin_hmib_hrSystem AS hrs\n\t\tINNER JOIN host ON host.id=hrs.host_id\n\t\t{$sql_join}\n\t\t{$sql_where}\n\t\tORDER BY " . get_request_var('sort_column') . ' ' . get_request_var('sort_direction') . ' ' . $limit;
$rows = db_fetch_assoc($sql);
$total_rows = db_fetch_cell("SELECT COUNT(*)\n\t\tFROM plugin_hmib_hrSystem AS hrs\n\t\tINNER JOIN host ON host.id=hrs.host_id\n\t\t{$sql_join}\n\t\t{$sql_where}");
$nav = html_nav_bar('hmib.php?action=devices', MAX_DISPLAY_PAGES, get_request_var('page'), $num_rows, $total_rows, 16, __('Devices'), 'page', 'main');
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('nosort' => array('display' => __('Actions'), 'sort' => 'ASC', 'align' => 'left'), 'description' => array('display' => __('Hostname'), 'sort' => 'ASC', 'align' => 'left'), 'host_status' => array('display' => __('Status'), 'sort' => 'DESC', 'align' => 'right'), 'uptime' => array('display' => __('Uptime(d:h:m)'), 'sort' => 'DESC', 'align' => 'right'), 'users' => array('display' => __('Users'), 'sort' => 'DESC', 'align' => 'right'), 'cpuPercent' => array('display' => __('CPU %'), 'sort' => 'DESC', 'align' => 'right'), 'numCpus' => array('display' => __('CPUs'), 'sort' => 'DESC', 'align' => 'right'), 'processes' => array('display' => __('Processes'), 'sort' => 'DESC', 'align' => 'right'), 'memSize' => array('display' => __('Total Mem'), 'sort' => 'DESC', 'align' => 'right'), 'memUsed' => array('display' => __('Used Mem'), 'sort' => 'DESC', 'align' => 'right'), 'swapSize' => array('display' => __('Total Swap'), 'sort' => 'DESC', 'align' => 'right'), 'swapUsed' => array('display' => __('Used Swap'), 'sort' => 'DESC', 'align' => 'right'));
html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false, 'hmib.php?action=devices');
/* set some defaults */
$url = $config['url_path'] . 'plugins/hmib/hmib.php';
$proc = $config['url_path'] . 'plugins/hmib/images/cog.png';
$host = $config['url_path'] . 'plugins/hmib/images/server.png';
$hardw = $config['url_path'] . 'plugins/hmib/images/view_hardware.gif';
$inven = $config['url_path'] . 'plugins/hmib/images/view_inventory.gif';
$storage = $config['url_path'] . 'plugins/hmib/images/drive.png';
$dashboard = $config['url_path'] . 'plugins/hmib/images/view_dashboard.gif';
$graphs = $config['url_path'] . 'plugins/hmib/images/view_graphs.gif';
$nographs = $config['url_path'] . 'plugins/hmib/images/view_graphs_disabled.gif';
$htdq = db_fetch_cell("SELECT id \n\t\tFROM snmp_query \n\t\tWHERE hash='137aeab842986a76cf5bdef41b96c9a3'");
$hcpudq = db_fetch_cell("SELECT id \n\t\tFROM snmp_query \n\t\tWHERE hash='0d1ab53fe37487a5d0b9e1d3ee8c1d0d'");
$hugt = db_fetch_cell("SELECT id \n\t\tFROM graph_templates \n\t\tWHERE hash='e8462bbe094e4e9e814d4e681671ea82'");
$hpgt = db_fetch_cell("SELECT id \n\t\tFROM graph_templates \n\t\tWHERE hash='62205afbd4066e5c4700338841e3901e'");
if (sizeof($rows)) {
foreach ($rows as $row) {
$days = intval($row['uptime'] / (60 * 60 * 24 * 100));
$remainder = $row['uptime'] % (60 * 60 * 24 * 100);
$hours = intval($remainder / (60 * 60 * 100));
$remainder = $remainder % (60 * 60 * 100);
$minutes = intval($remainder / (60 * 100));
$found = db_fetch_cell('SELECT COUNT(*) FROM graph_local WHERE host_id=' . $row['host_id']);
form_alternate_row();
echo "<td width='120'>";
//echo "<a style='padding:1px;' href='" . htmlspecialchars("$url?action=dashboard&reset=1&device=" . $row["host_id"]) . "'><img src='$dashboard' title='View Dashboard' align='absmiddle'></a>";
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=storage&reset=1&device=" . $row['host_id']) . "'><img src='{$storage}' title='" . __('View Storage') . "' align='absmiddle' alt=''></a>";
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=hardware&reset=1&device=" . $row['host_id']) . "'><img src='{$hardw}' title='" . __('View Hardware') . "' align='absmiddle' alt=''></a>";
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=running&reset=1&device=" . $row['host_id']) . "'><img src='{$proc}' title='" . __('View Processes') . "' align='absmiddle' alt=''></a>";
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=software&reset=1&device=" . $row['host_id']) . "'><img src='{$inven}' title='" . __('View Software Inventory') . "' align='absmiddle' alt=''></a>";
if ($found) {
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=graphs&reset=1&host_id=" . $row['host_id'] . "&style=selective&graph_add=&graph_list=&graph_template_id=0&filter=") . "'><img src='{$graphs}' title='" . __('View Graphs') . "' align='absmiddle' alt=''></a>";
} else {
echo "<img src='{$nographs}' title='" . __('No Graphs Defined') . "' align='absmiddle' alt=''>";
}
$graph_cpu = hmib_get_graph_url($hcpudq, 0, $row['host_id'], '', $row['numCpus'], false);
$graph_cpup = hmib_get_graph_url($hcpudq, 0, $row['host_id'], '', round($row['cpuPercent'], 2) . ' %', false);
$graph_users = hmib_get_graph_template_url($hugt, 0, $row['host_id'], $row['host_status'] < 2 ? 'N/A' : $row['users'], false);
$graph_aproc = hmib_get_graph_template_url($hpgt, 0, $row['host_id'], $row['host_status'] < 2 ? 'N/A' : $row['processes'], false);
if (api_plugin_user_realm_auth('host.php')) {
$host_url = "<a href='" . htmlspecialchars($config['url_path'] . 'host.php?action=edit&id=' . $row['host_id']) . "' title='" . __('Edit Device') . "'>" . $row['hostname'] . '</a>';
} else {
$host_url = $row['hostname'];
}
echo '</td>';
echo "<td class='nowrap left'>" . $row['description'] . ' [' . $host_url . ']' . '</td>';
echo "<td class='nowrap right'>" . get_colored_device_status($row['disabled'] == 'on' ? true : false, $row['host_status']) . '</td>';
echo "<td class='nowrap right'>" . hmib_format_uptime($days, $hours, $minutes) . '</td>';
echo "<td class='nowrap right'>" . $graph_users . '</td>';
echo "<td class='nowrap right'>" . ($row['host_status'] < 2 ? 'N/A' : $graph_cpup) . '</td>';
echo "<td class='nowrap right'>" . ($row['host_status'] < 2 ? 'N/A' : $graph_cpu) . '</td>';
echo "<td class='nowrap right'>" . $graph_aproc . '</td>';
echo "<td class='nowrap right'>" . hmib_memory($row['memSize']) . '</td>';
echo "<td class='nowrap right'>" . ($row['host_status'] < 2 ? 'N/A' : round($row['memUsed'], 0)) . ' %</td>';
echo "<td class='nowrap right'>" . hmib_memory($row['swapSize']) . '</td>';
echo "<td class='nowrap right'>" . ($row['host_status'] < 2 ? 'N/A' : round($row['swapUsed'], 0)) . ' %</td>';
}
echo '</tr>';
} else {
print '<tr><td><em>' . __('No Devices Found') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($rows)) {
print $nav;
}
}
function thold_hosts($header_label)
{
global $assoc_actions, $item_rows;
/* ================= input validation and session storage ================= */
get_filter_request_var('id');
$filters = array('rows' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'page' => array('filter' => FILTER_VALIDATE_INT, 'default' => '1'), 'filter' => array('filter' => FILTER_CALLBACK, 'pageset' => true, 'default' => '', 'options' => array('options' => 'sanitize_search_string')), 'sort_column' => array('filter' => FILTER_CALLBACK, 'default' => 'description', 'options' => array('options' => 'sanitize_search_string')), 'sort_direction' => array('filter' => FILTER_CALLBACK, 'default' => 'ASC', 'options' => array('options' => 'sanitize_search_string')), 'host_template_id' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'associated' => array('filter' => FILTER_CALLBACK, 'default' => 'true', 'options' => array('options' => 'sanitize_search_string')));
validate_store_request_vars($filters, 'sess_maint');
/* ================= input validation ================= */
/* if the number of rows is -1, set it to the default */
if (get_request_var('rows') == '-1') {
$rows = read_config_option('num_rows_table');
} else {
$rows = get_request_var('rows');
}
?>
<script type='text/javascript'>
function applyFilter() {
strURL = 'maint.php?tab=hosts&action=edit&id=<?php
print get_request_var('id');
?>
'
strURL += '&rows=' + $('#rows').val();
strURL += '&host_template_id=' + $('#host_template_id').val();
strURL += '&associated=' + $('#associated').is(':checked');
strURL += '&filter=' + $('#filter').val();
strURL += '&header=false';
loadPageNoHeader(strURL);
}
function clearFilter() {
strURL = 'maint.php?tab=hosts&action=edit&id=<?php
print get_request_var('id');
?>
&clear=true&header=false'
loadPageNoHeader(strURL);
}
</script>
<?php
html_start_box(__('Associated Devices %s', htmlspecialchars($header_label)), '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td>
<form name='form_devices' method='post' action='maint.php?action=edit&tab=hosts'>
<table class='filterTable'>
<tr>
<td>
<?php
print __('Search');
?>
</td>
<td>
<input type='text' id='filter' size='25' value='<?php
print htmlspecialchars(get_request_var('filter'));
?>
' onChange='applyFilter()'>
</td>
<td>
<?php
print __('Type');
?>
</td>
<td>
<select id='host_template_id' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('host_template_id') == '-1') {
?>
selected<?php
}
?>
><?php
print __('Any');
?>
</option>
<option value='0'<?php
if (get_request_var('host_template_id') == '0') {
?>
selected<?php
}
?>
><?php
print __('None');
?>
</option>
<?php
$host_templates = db_fetch_assoc('SELECT DISTINCT ht.id, ht.name
FROM host_template AS ht
INNER JOIN host AS h
ON h.host_template_id=ht.id
ORDER BY ht.name');
if (sizeof($host_templates) > 0) {
foreach ($host_templates as $host_template) {
print "<option value='" . $host_template['id'] . "'";
if (get_request_var('host_template_id') == $host_template['id']) {
print ' selected';
}
print '>' . htmlspecialchars($host_template['name']) . "</option>\n";
}
}
?>
</select>
</td>
<td>
<?php
print __('Devices');
?>
</td>
<td>
<select id='rows' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('rows') == '-1') {
?>
selected<?php
}
?>
><?php
print __('Default');
?>
</option>
<?php
if (sizeof($item_rows) > 0) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if (get_request_var('rows') == $key) {
print ' selected';
}
print '>' . htmlspecialchars($value) . "</option>\n";
}
}
?>
</select>
</td>
<td>
<input type='checkbox' id='associated' onChange='applyFilter()' <?php
print get_request_var('associated') == 'true' || get_request_var('associated') == 'on' ? 'checked' : '';
?>
>
</td>
<td>
<label for='associated'><?php
print __('Associated');
?>
</label>
</td>
<td>
<input type='button' value='<?php
print __('Go');
?>
' onClick='applyFilter()' title='<?php
print __('Set/Refresh Filters');
?>
'>
</td>
<td>
<input type='button' name='clear' value='<?php
print __('Clear');
?>
' onClick='clearFilter()' title='<?php
print __('Clear Filters');
?>
'>
</td>
</tr>
</table>
<input type='hidden' id='page' value='<?php
print get_request_var('page');
?>
'>
<input type='hidden' id='id' value='<?php
print get_request_var('id');
?>
'>
</form>
</td>
</tr>
<?php
html_end_box();
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var('filter'))) {
$sql_where = "WHERE (h.hostname LIKE '%" . get_request_var('filter') . "%' \n\t\t\tOR h.description LIKE '%" . get_request_var('filter') . "%')";
} else {
$sql_where = '';
}
if (get_request_var('host_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var('host_template_id') == '0') {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' h.host_template_id=0';
} elseif (!isempty_request_var('host_template_id')) {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' h.host_template_id=' . get_request_var('host_template_id');
}
if (get_request_var('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' type=1 AND schedule=' . get_request_var('id');
}
if (get_request_var('id')) {
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(DISTINCT h.id)\n\t\t\tFROM host AS h\n\t\t\tLEFT JOIN (SELECT DISTINCT host_id FROM thold_data) AS td \n\t\t\tON h.id=td.host_id\n\t\t\tLEFT JOIN plugin_maint_hosts AS pmh\n\t\t\tON h.id=pmh.host\n\t\t\tAND pmh.schedule=" . get_request_var('id') . "\n\t\t\t{$sql_where}");
} else {
$total_rows = 0;
}
$sortby = get_request_var('sort_column');
if ($sortby == 'hostname') {
$sortby = 'INET_ATON(hostname)';
}
if (get_request_var('id')) {
$sql_query = 'SELECT h.*, pmh.type, graphs, data_sources, tholds,
(SELECT schedule FROM plugin_maint_hosts WHERE host=h.id AND schedule=' . get_request_var('id') . ") AS associated \n\t\t\tFROM host as h\n\t\t\tLEFT JOIN (SELECT COUNT(id) AS tholds, host_id FROM thold_data GROUP BY host_id) AS td\n\t\t\tON td.host_id=h.id\n\t\t\tLEFT JOIN (SELECT COUNT(id) AS graphs, host_id FROM graph_local GROUP BY host_id) AS gl\n\t\t\tON gl.host_id=h.id\n\t\t\tLEFT JOIN (SELECT COUNT(id) AS data_sources, host_id FROM data_local GROUP BY host_id) AS dl\n\t\t\ton dl.host_id=h.id\n\t\t\tLEFT JOIN plugin_maint_hosts AS pmh\n\t\t\tON pmh.host=h.id\n\t\t\tAND pmh.schedule=" . get_request_var('id') . "\n\t\t\t{$sql_where} \n\t\t\tGROUP BY h.id\n\t ORDER BY " . $sortby . ' ' . get_request_var('sort_direction') . '
LIMIT ' . $rows * (get_request_var('page') - 1) . ',' . $rows;
$hosts = db_fetch_assoc($sql_query);
} else {
$hosts = array();
}
$display_text = array('description' => array('display' => __('Description'), 'align' => 'left', 'sort' => 'ASC'), 'id' => array('display' => __('ID'), 'align' => 'right', 'sort' => 'asc'), 'nosort' => array('display' => __('Associated Schedules'), 'align' => 'left', 'sort' => ''), 'graphs' => array('display' => __('Graphs'), 'align' => 'right', 'sort' => 'desc'), 'data_sources' => array('display' => __('Data Sources'), 'align' => 'right', 'sort' => 'desc'), 'tholds' => array('display' => __('Thresholds'), 'align' => 'right', 'sort' => 'desc'), 'nosort1' => array('display' => __('Status'), 'align' => 'center', 'sort' => ''), 'hostname' => array('display' => __('Hostname'), 'align' => 'left', 'sort' => 'desc'));
/* generate page list */
$nav = html_nav_bar('maint.php?action=edit&tab=hosts&id=' . get_request_var('id'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 13, __('Devices'), 'page', 'main');
form_start('maint.php', 'chk');
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false, 'maint.php?action=edit&tab=hosts&id=' . get_request_var('id'));
if (sizeof($hosts)) {
foreach ($hosts as $host) {
form_alternate_row('line' . $host['id']);
form_selectable_cell(strlen(get_request_var('filter')) ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['description'])) : htmlspecialchars($host['description']), $host['id'], 250);
form_selectable_cell(number_format_i18n($host['id']), $host['id'], '', 'text-align:right');
if ($host['associated'] != '') {
$names = '<span class="deviceUp">' . __('Current Schedule') . '</span>';
} else {
$names = '';
}
if (sizeof($lists = db_fetch_assoc('SELECT name FROM plugin_maint_schedules INNER JOIN plugin_maint_hosts ON plugin_maint_schedules.id=plugin_maint_hosts.schedule WHERE type=1 AND host=' . $host['id'] . ' AND plugin_maint_schedules.id != ' . get_request_var('id')))) {
foreach ($lists as $name) {
$names .= (strlen($names) ? ', ' : '') . "<span class='deviceRecovering'>" . $name['name'] . '</span>';
}
}
if ($names == '') {
form_selectable_cell('<span class="deviceUnknown">' . __('No Schedules') . '</span>', $host['id']);
} else {
form_selectable_cell($names, $host['id']);
}
form_selectable_cell(number_format_i18n($host['graphs']), $host['id'], '', 'text-align:right');
form_selectable_cell(number_format_i18n($host['data_sources']), $host['id'], '', 'text-align:right');
form_selectable_cell(number_format_i18n($host['tholds']), $host['id'], '', 'text-align:right');
form_selectable_cell(get_colored_device_status($host['disabled'] == 'on' ? true : false, $host['status']), $host['id'], '', 'text-align:center');
form_selectable_cell(strlen(get_request_var('filter')) ? preg_replace('/(' . preg_quote(get_request_var('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['hostname'])) : htmlspecialchars($host['hostname']), $host['id']);
form_checkbox_cell($host['description'], $host['id']);
form_end_row();
}
} else {
print "<tr><td colspan='8'><em>" . __('No Associated Devices Found') . "</em></td></tr>";
}
html_end_box(false);
if (sizeof($hosts)) {
print $nav;
}
form_hidden_box('id', get_request_var('id'), '');
form_hidden_box('save_hosts', '1', '');
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($assoc_actions);
form_end();
}
function host()
{
$current_page = get_get_var_number("page", "1");
$menu_items = array("remove" => "Remove", "duplicate" => "Duplicate", "enable" => "Enable", "disable" => "Disable", "clear_stats" => "Clear Statistics", "change_snmp_opts" => "Change SNMP Options", "change_avail_opts" => "Change Availability Options", "change_poller" => "Change Poller");
$filter_array = array();
/* search field: device template */
if (isset_get_var("search_device_template")) {
$filter_array["=host_template_id"] = get_get_var("search_device_template");
}
/* search field: device status */
if (isset_get_var("search_status")) {
$filter_array["=status"] = get_get_var("search_status");
}
/* search field: filter (searches device description and hostname) */
if (isset_get_var("search_filter")) {
$filter_array["%filter"] = array("hostname" => get_get_var("search_filter"), "description" => get_get_var("search_filter"));
}
/* get a list of all devices on this page */
$devices = api_device_list($filter_array, "description", "asc", read_config_option("num_rows_device") * ($current_page - 1), read_config_option("num_rows_device"));
/* get the total number of devices on all pages */
$total_rows = api_device_total_get($filter_array);
/* generate page list */
$url_string = build_get_url_string(array("search_device_template", "search_status", "search_filter"));
$url_page_select = get_page_list($current_page, MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, "devices.php" . $url_string . ($url_string == "" ? "?" : "&") . "page=|PAGE_NUM|");
form_start("devices.php");
$box_id = "1";
html_start_box("<strong>" . _("Devices") . "</strong>", "devices.php?action=edit", $url_page_select);
html_header_checkbox(array(_("Description"), _("Status"), _("Hostname"), _("Current (ms)"), _("Average (ms)"), _("Availability")), $box_id);
$i = 0;
if (sizeof($devices) > 0) {
foreach ($devices as $host) {
?>
<tr class="item" id="box-<?php
echo $box_id;
?>
-row-<?php
echo $host["id"];
?>
" onClick="display_row_select('<?php
echo $box_id;
?>
',document.forms[0],'box-<?php
echo $box_id;
?>
-row-<?php
echo $host["id"];
?>
', 'box-<?php
echo $box_id;
?>
-chk-<?php
echo $host["id"];
?>
')" onMouseOver="display_row_hover('box-<?php
echo $box_id;
?>
-row-<?php
echo $host["id"];
?>
')" onMouseOut="display_row_clear('box-<?php
echo $box_id;
?>
-row-<?php
echo $host["id"];
?>
')">
<td class="title">
<a onClick="display_row_block('box-<?php
echo $box_id;
?>
-row-<?php
echo $host["id"];
?>
')" href="devices.php?action=edit&id=<?php
echo $host["id"];
?>
"><span id="box-<?php
echo $box_id;
?>
-text-<?php
echo $host["id"];
?>
"><?php
echo html_highlight_words(get_get_var("search_filter"), $host["description"]);
?>
</span></a>
</td>
<td>
<?php
echo get_colored_device_status($host["disabled"] == "on" ? true : false, $host["status"]);
?>
</td>
<td>
<?php
echo html_highlight_words(get_get_var("search_filter"), $host["hostname"]);
?>
</td>
<td>
<?php
echo round($host["cur_time"], 2);
?>
</td>
<td>
<?php
echo round($host["avg_time"], 2);
?>
</td>
<td>
<?php
echo round($host["availability"], 2);
?>
%
</td>
<td class="checkbox" align="center">
<input type='checkbox' name='box-<?php
echo $box_id;
?>
-chk-<?php
echo $host["id"];
?>
' id='box-<?php
echo $box_id;
?>
-chk-<?php
echo $host["id"];
?>
' title="<?php
echo $host["description"];
?>
">
</td>
</tr>
<?php
}
} else {
?>
<tr class="empty">
<td colspan="6">
No devices found.
</td>
</tr>
<?php
}
html_box_toolbar_draw($box_id, "0", "6", sizeof($filter_array) == 0 ? HTML_BOX_SEARCH_INACTIVE : HTML_BOX_SEARCH_ACTIVE, $url_page_select);
html_end_box(false);
html_box_actions_menu_draw($box_id, "0", $menu_items);
html_box_actions_area_create($box_id);
form_hidden_box("action_post", "device_list");
form_end();
/* fill in the list of available device templates for the search dropdown */
$search_device_templates = array();
$search_device_templates["-1"] = "Any";
$search_device_templates["0"] = "None";
$search_device_templates += array_rekey(api_device_template_list(), "id", "name");
/* fill in the list of available host status types for the search dropdown */
$search_host_status_types = array();
$search_host_status_types["-1"] = "Any";
$search_host_status_types["-2"] = "Disabled";
$search_host_status_types += api_device_status_type_list();
?>
<script language="JavaScript">
<!--
function action_area_handle_type(box_id, type, parent_div, parent_form) {
if (type == 'remove') {
parent_div.appendChild(document.createTextNode('Are you sure you want to remove these devices?'));
parent_div.appendChild(action_area_generate_selected_rows(box_id));
parent_div.appendChild(action_area_generate_input('radio', 'box-' + box_id + '-remove_type', '1'));
parent_div.appendChild(document.createTextNode('Leave all graphs and data sources untouched. Data sources will be disabled however.'));
parent_div.appendChild(action_area_generate_break());
_elm_rt_input = action_area_generate_input('radio', 'box-' + box_id + '-remove_type', '2');
_elm_rt_input.checked = true;
parent_div.appendChild(_elm_rt_input);
parent_div.appendChild(document.createTextNode("Delete all associated graphs and data sources."));
action_area_update_header_caption(box_id, 'Remove Device');
action_area_update_submit_caption(box_id, 'Remove');
action_area_update_selected_rows(box_id, parent_form);
}else if (type == 'duplicate') {
parent_div.appendChild(document.createTextNode('Are you sure you want to duplicate these devices?'));
parent_div.appendChild(action_area_generate_selected_rows(box_id));
parent_div.appendChild(action_area_generate_input('text', 'box-' + box_id + '-action-area-txt1', ''));
action_area_update_header_caption(box_id, 'Duplicate Devices');
action_area_update_submit_caption(box_id, 'Duplicate');
action_area_update_selected_rows(box_id, parent_form);
}else if (type == 'enable') {
parent_div.appendChild(document.createTextNode('Are you sure you want to enable these devices?'));
parent_div.appendChild(action_area_generate_selected_rows(box_id));
action_area_update_header_caption(box_id, 'Enable Devices');
action_area_update_submit_caption(box_id, 'Enable');
action_area_update_selected_rows(box_id, parent_form);
}else if (type == 'disable') {
parent_div.appendChild(document.createTextNode('Are you sure you want to disable these devices?'));
parent_div.appendChild(action_area_generate_selected_rows(box_id));
action_area_update_header_caption(box_id, 'Disable Devices');
action_area_update_submit_caption(box_id, 'Disable');
action_area_update_selected_rows(box_id, parent_form);
}else if (type == 'clear_stats') {
parent_div.appendChild(document.createTextNode('Are you sure you want to clear polling statistics for these devices?'));
parent_div.appendChild(action_area_generate_selected_rows(box_id));
action_area_update_header_caption(box_id, 'Clear Polling Statistics');
action_area_update_submit_caption(box_id, 'Clear');
action_area_update_selected_rows(box_id, parent_form);
}else if (type == 'search') {
_elm_dt_input = action_area_generate_select('box-' + box_id + '-search_device_template');
<?php
echo get_js_dropdown_code('_elm_dt_input', $search_device_templates, isset_get_var("search_device_template") ? get_get_var("search_device_template") : "-1");
?>
_elm_ds_input = action_area_generate_select('box-' + box_id + '-search_status');
<?php
echo get_js_dropdown_code('_elm_ds_input', $search_host_status_types, isset_get_var("search_status") ? get_get_var("search_status") : "-1");
?>
_elm_ht_input = action_area_generate_input('text', 'box-' + box_id + '-search_filter', '<?php
echo get_get_var("search_filter");
?>
');
_elm_ht_input.size = '30';
parent_div.appendChild(action_area_generate_search_field(_elm_dt_input, 'Device Template', true, false));
parent_div.appendChild(action_area_generate_search_field(_elm_ds_input, 'Device Status', false, false));
parent_div.appendChild(action_area_generate_search_field(_elm_ht_input, 'Filter', false, true));
action_area_update_header_caption(box_id, 'Search');
action_area_update_submit_caption(box_id, 'Search');
}
}
-->
</script>
<?php
}
function mactrack_format_device_row($device, $actions = false)
{
global $config, $mactrack_device_types;
/* viewer level */
if ($actions) {
$row = "<a href='" . htmlspecialchars($config['url_path'] . 'plugins/mactrack/mactrack_interfaces.php?device_id=' . $device['device_id'] . '&issues=0&page=1') . "'><img src='" . $config['url_path'] . "plugins/mactrack/images/view_interfaces.gif' alt='' title='" . __('View Interfaces') . "' align='middle' border='0'></a>";
/* admin level */
if (api_user_realm_auth('mactrack_sites.php')) {
if ($device['disabled'] == '') {
$row .= "<img id='r_" . $device['device_id'] . "' src='" . $config['url_path'] . "plugins/mactrack/images/rescan_device.gif' alt='' onClick='scan_device(" . $device['device_id'] . ")' title='" . __('Rescan Device') . "' align='middle' border='0'>";
} else {
$row .= "<img src='" . $config['url_path'] . "plugins/mactrack/images/view_none.gif' alt='' align='middle' border='0'>";
}
}
print "<td style='width:40px;'>" . $row . "</td>";
}
form_selectable_cell(filter_value($device['device_name'], get_request_var('filter'), "mactrack_devices.php?action=edit&device_id=" . $device['device_id']), $device['device_id']);
form_selectable_cell($device['site_name'], $device['device_id']);
form_selectable_cell(get_colored_device_status($device['disabled'] == 'on' ? true : false, $device['snmp_status']), $device['device_id']);
form_selectable_cell(filter_value($device['hostname'], get_request_var('filter')), $device['device_id']);
form_selectable_cell($device['device_type'] == '' ? __('Not Detected') : $device['device_type'], $device['device_id']);
form_selectable_cell($device['scan_type'] == '1' ? __('N/A') : $device['ips_total'], $device['device_id']);
form_selectable_cell($device['scan_type'] == '3' ? __('N/A') : $device['ports_total'], $device['device_id']);
form_selectable_cell($device['scan_type'] == '3' ? __('N/A') : $device['ports_active'], $device['device_id']);
form_selectable_cell($device['scan_type'] == '3' ? __('N/A') : $device['ports_trunk'], $device['device_id']);
form_selectable_cell($device['scan_type'] == '3' ? __('N/A') : $device['macs_active'], $device['device_id']);
form_selectable_cell(number_format($device['last_runduration'], 1), $device['device_id']);
form_checkbox_cell($device['device_name'], $device['device_id']);
form_end_row();
}
function mactrack_view_devices()
{
global $title, $report, $mactrack_search_types, $mactrack_device_types, $rows_selector, $config, $item_rows;
mactrack_device_request_validation();
if (get_request_var('rows') == -1) {
$row_limit = read_config_option('num_rows_table');
} elseif (get_request_var('rows') == -2) {
$row_limit = 999999;
} else {
$row_limit = get_request_var('rows');
}
$webroot = $config['url_path'] . '/plugins/mactrack/';
mactrack_tabs();
html_start_box($title, '100%', '', '3', 'center', '');
mactrack_device_filter2();
html_end_box();
$sql_where = '';
$devices = mactrack_view_get_device_records($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT\n\t\tCOUNT(mac_track_devices.device_id)\n\t\tFROM mac_track_sites\n\t\tRIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id\n\t\tLEFT JOIN mac_track_device_types ON (mac_track_device_types.device_type_id=mac_track_devices.device_type_id)\n\t\t{$sql_where}");
$nav = html_nav_bar('mactrack_view_devices.php?report=devices', MAX_DISPLAY_PAGES, get_request_var('page'), $row_limit, $total_rows, 13, __('Devices'));
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('nosort' => array(__('Actions'), ''), 'device_name' => array(__('Device Name'), 'ASC'), 'site_name' => array(__('Site Name'), 'ASC'), 'snmp_status' => array(__('Status'), 'ASC'), 'hostname' => array(__('Hostname'), 'ASC'), 'device_type' => array(__('Device Type'), 'ASC'), 'ips_total' => array(__('Total IP\'s'), 'DESC'), 'ports_total' => array(__('User Ports'), 'DESC'), 'ports_active' => array(__('User Ports Up'), 'DESC'), 'ports_trunk' => array(__('Trunk Ports'), 'DESC'), 'macs_active' => array(__('Active Macs'), 'DESC'), 'vlans_total' => array(__('Total VLAN\'s'), 'DESC'), 'last_runduration' => array(__('Last Duration'), 'DESC'));
html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'));
$i = 0;
if (sizeof($devices) > 0) {
foreach ($devices as $device) {
$hostinfo['hostname'] = $device['hostname'];
$hostinfo['user'] = $device['user_name'];
switch ($device['term_type']) {
case 0:
$hostinfo['transport'] = 'none';
break;
case 1:
$hostinfo['transport'] = 'telnet';
break;
case 2:
$hostinfo['transport'] = 'ssh';
break;
case 3:
$hostinfo['transport'] = 'http';
break;
case 4:
$hostinfo['transport'] = 'https';
break;
}
form_alternate_row();
?>
<td width=100>
<?php
if (api_user_realm_auth('mactrack_sites.php')) {
?>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_devices.php?action=edit&device_id=' . $device['device_id']);
?>
' title='<?php
print __('Edit Device');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/edit_object.png'></a>
<?php
api_plugin_hook_function('remote_link', $hostinfo);
}
?>
<?php
if ($device['host_id'] > 0) {
?>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_view_graphs.php?action=preview&report=graphs&style=selective&graph_list=&host=' . $device['host_id'] . '&graph_template_id=0&filter=');
?>
' title='<?php
print __('View Graphs');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/view_graphs.gif'></a>
<?php
} else {
?>
<img title='<?php
print __('Device Not Mapped to Cacti Device');
?>
' border='0' src='<?php
print $webroot;
?>
images/view_graphs_disabled.gif'>
<?php
}
?>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_view_macs.php?report=macs&reset&device_id=-1&scan_date=3&site_id=' . get_request_var('site_id') . '&device_id=' . $device['device_id']);
?>
' title='<?php
print __('View MAC Addresses');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/view_macs.gif'></a>
<a href='<?php
print htmlspecialchars($webroot . 'mactrack_view_interfaces.php?report=interfaces&reset&site=' . get_request_var('site_id') . '&device=' . $device['device_id']);
?>
' title='<?php
print __('View Interfaces');
?>
'><img border='0' src='<?php
print $webroot;
?>
images/view_interfaces.gif'></a>
</td>
<td class='hyperLink'>
<?php
print filter_value($device['device_name'], get_request_var('filter'));
?>
</td>
<td><?php
print filter_value($device['site_name'], get_request_var('filter'));
?>
<td><?php
print get_colored_device_status($device['disabled'] == 'on' ? true : false, $device['snmp_status']);
?>
</td>
<td><?php
print filter_value($device['hostname'], get_request_var('filter'));
?>
<td><?php
print $device['device_type'];
?>
</td)>
<td><?php
print $device['scan_type'] == '1' ? __('N/A') : number_format_i18n($device['ips_total']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['ports_total']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['ports_active']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['ports_trunk']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['macs_active']);
?>
</td>
<td><?php
print $device['scan_type'] == '3' ? __('N/A') : number_format_i18n($device['vlans_total']);
?>
</td>
<td><?php
print number_format($device['last_runduration'], 1);
?>
</td>
</tr>
<?php
}
} else {
print '<tr><td colspan="10"><em>' . __('No MacTrack Devices') . '</em></td></tr>';
}
html_end_box(false);
if (sizeof($devices)) {
print $nav;
mactrack_display_stats();
}
}
function host()
{
global $colors, $device_actions;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("host_template_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("host_status"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_device_current_page");
kill_session_var("sess_device_filter");
kill_session_var("sess_device_host_template_id");
kill_session_var("sess_host_status");
kill_session_var("sess_host_sort_column");
kill_session_var("sess_host_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["host_template_id"]);
unset($_REQUEST["host_status"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
if (!empty($_SESSION["sess_host_status"]) && !empty($_REQUEST["host_status"])) {
if ($_SESSION["sess_host_status"] != $_REQUEST["host_status"]) {
$_REQUEST["page"] = 1;
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_device_current_page", "1");
load_current_session_value("filter", "sess_device_filter", "");
load_current_session_value("host_template_id", "sess_device_host_template_id", "-1");
load_current_session_value("host_status", "sess_host_status", "-1");
load_current_session_value("sort_column", "sess_host_sort_column", "description");
load_current_session_value("sort_direction", "sess_host_sort_direction", "ASC");
html_start_box("<strong>Devices</strong>", "98%", $colors["header"], "3", "center", "host.php?action=edit&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"]);
include "./include/html/inc_device_filter_table.php";
html_end_box();
/* form the 'where' clause for our main sql query */
$sql_where = "where (host.hostname like '%%" . $_REQUEST["filter"] . "%%' OR host.description like '%%" . $_REQUEST["filter"] . "%%')";
if ($_REQUEST["host_status"] == "-1") {
/* Show all items */
} elseif ($_REQUEST["host_status"] == "-2") {
$sql_where .= " and host.disabled='on'";
} elseif ($_REQUEST["host_status"] == "-3") {
$sql_where .= " and host.disabled=''";
} else {
$sql_where .= " and (host.status=" . $_REQUEST["host_status"] . " AND host.disabled = '')";
}
if ($_REQUEST["host_template_id"] == "-1") {
/* Show all items */
} elseif ($_REQUEST["host_template_id"] == "0") {
$sql_where .= " and host.host_template_id=0";
} elseif (!empty($_REQUEST["host_template_id"])) {
$sql_where .= " and host.host_template_id=" . $_REQUEST["host_template_id"];
}
html_start_box("", "98%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("select\n\t\tCOUNT(host.id)\n\t\tfrom host\n\t\t{$sql_where}");
$sortby = $_REQUEST["sort_column"];
if ($sortby == "hostname") {
$sortby = "INET_ATON(hostname)";
}
$hosts = db_fetch_assoc("SELECT\n\t\thost.id,\n\t\thost.disabled,\n\t\thost.status,\n\t\thost.hostname,\n\t\thost.description,\n\t\thost.min_time,\n\t\thost.max_time,\n\t\thost.cur_time,\n\t\thost.avg_time,\n\t\thost.availability\n\t\tFROM host\n\t\t{$sql_where}\n\t\tORDER BY " . $sortby . " " . $_REQUEST["sort_direction"] . "\n\t\tLIMIT " . read_config_option("num_rows_device") * ($_REQUEST["page"] - 1) . "," . read_config_option("num_rows_device"));
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, "host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"]);
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t<td colspan='7'>\n\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\n\t\t\t\t\t\t\t<strong><< ";
if ($_REQUEST["page"] > 1) {
$nav .= "<a class='linkOverDark' href='host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"] . "&page=" . ($_REQUEST["page"] - 1) . "'>";
}
$nav .= "Previous";
if ($_REQUEST["page"] > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\tShowing Rows " . (read_config_option("num_rows_device") * ($_REQUEST["page"] - 1) + 1) . " to " . ($total_rows < read_config_option("num_rows_device") || $total_rows < read_config_option("num_rows_device") * $_REQUEST["page"] ? $total_rows : read_config_option("num_rows_device") * $_REQUEST["page"]) . " of {$total_rows} [{$url_page_select}]\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\n\t\t\t\t\t\t\t<strong>";
if ($_REQUEST["page"] * read_config_option("num_rows_device") < $total_rows) {
$nav .= "<a class='linkOverDark' href='host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&host_status=" . $_REQUEST["host_status"] . "&page=" . ($_REQUEST["page"] + 1) . "'>";
}
$nav .= "Next";
if ($_REQUEST["page"] * read_config_option("num_rows_device") < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t</td>\n\t\t</tr>\n";
print $nav;
$display_text = array("description" => array("Description", "ASC"), "status" => array("Status", "ASC"), "hostname" => array("Hostname", "ASC"), "cur_time" => array("Current (ms)", "DESC"), "avg_time" => array("Average (ms)", "DESC"), "availability" => array("Availability", "ASC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($hosts) > 0) {
foreach ($hosts as $host) {
form_alternate_row_color($colors["alternate"], $colors["light"], $i);
$i++;
?>
<td width=250>
<a class="linkEditMain" href="host.php?action=edit&id=<?php
print $host["id"];
?>
"><?php
print eregi_replace("(" . preg_quote($_REQUEST["filter"]) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["description"]);
?>
</a>
</td>
<td><?php
print get_colored_device_status($host["disabled"] == "on" ? true : false, $host["status"]);
?>
</td>
<td><?php
print eregi_replace("(" . preg_quote($_REQUEST["filter"]) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["hostname"]);
?>
</td>
<td><?php
print round($host["cur_time"], 2);
?>
</td>
<td><?php
print round($host["avg_time"], 2);
?>
</td>
<td><?php
print round($host["availability"], 2);
?>
%</td>
<td style="<?php
print get_checkbox_style();
?>
" width="1%" align="right">
<input type='checkbox' style='margin: 0px;' name='chk_<?php
print $host["id"];
?>
' title="<?php
print $host["description"];
?>
">
</td>
</tr>
<?php
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print "<tr><td><em>No Hosts</em></td></tr>";
}
html_end_box(false);
/* add a list of tree names to the actions dropdown */
add_tree_names_to_actions_array();
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
}
function graph_perms_edit($tab, $header_label)
{
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request('id'));
/* ==================================================== */
$sql_where = '';
$sql_join = '';
$limit = '';
$sql_having = '';
$policy_array = array(1 => 'Allow', 2 => 'Deny');
if (!empty($_REQUEST['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_request('id')));
} else {
$policy = array('policy_graphs' => '1', 'policy_trees' => '1', 'policy_hosts' => '1', 'policy_graph_templates' => '1');
}
switch ($tab) {
case 'permsg':
process_graph_request_vars();
graph_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Graph Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Graph Policy for this User</td>
<td width="10">
<?php
form_dropdown('policy_graphs', $policy_array, '', '', $policy['policy_graphs'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_admin.php?action=user_edit&tab=permsg&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$user = $_SESSION['sess_user_id'];
if (read_config_option('graph_auth_method') == 1) {
$sql_operator = 'OR';
} else {
$sql_operator = 'AND';
}
$limit = 'LIMIT ' . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
/* get policies for all groups and user */
$policies = db_fetch_assoc_prepared("SELECT uag.id, 'group' AS type, uag.name, \n\t\t\tpolicy_graphs, policy_hosts, policy_graph_templates \n\t\t\tFROM user_auth_group AS uag\n\t\t\tINNER JOIN user_auth_group_members AS uagm\n\t\t\tON uag.id = uagm.group_id\n\t\t\tWHERE uag.enabled = 'on' AND uagm.user_id = ?", array($user));
$policies[] = db_fetch_row_prepared("SELECT id, 'user' AS type, 'user' AS name, \n\t\t\tpolicy_graphs, policy_hosts, policy_graph_templates \n\t\t\tFROM user_auth WHERE id = ?", array($user));
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (gtg.title_cache LIKE '%%" . get_request_var_request('filter') . "%%' AND gtg.local_graph_id > 0)";
} else {
$sql_where = 'WHERE (gtg.local_graph_id > 0)';
}
if (get_request_var_request('graph_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var_request('graph_template_id') == '0') {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' gtg.graph_template_id=0';
} elseif (!empty($_REQUEST['graph_template_id'])) {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' gtg.graph_template_id=' . get_request_var_request('graph_template_id');
}
$i = 1;
$user_perm = '';
$sql_select = '';
foreach ($policies as $policy) {
if ($policy['type'] == 'user' && $user_perm == '') {
$user_perm = $i;
}
if (get_request_var_request('associated') == 'false') {
if ($policy['policy_graphs'] == 1) {
$sql_having .= (strlen($sql_having) ? ' OR' : '') . " (user{$i} IS NULL";
} else {
$sql_having .= (strlen($sql_having) ? ' OR' : '') . " (user{$i}=" . $policy['id'];
}
}
$sql_join .= 'LEFT JOIN user_auth_' . ($policy['type'] == 'user' ? '' : 'group_') . "perms AS uap{$i} ON (gl.id=uap{$i}.item_id AND uap{$i}.type=1) ";
$sql_select .= (strlen($sql_select) ? ', ' : '') . "uap{$i}." . $policy['type'] . "_id AS user{$i}";
$i++;
if (get_request_var_request('associated') == 'false') {
if ($policy['policy_hosts'] == 1) {
$sql_having .= " OR (user{$i} IS NULL";
} else {
$sql_having .= " OR (user{$i}=" . $policy['id'];
}
}
$sql_join .= 'LEFT JOIN user_auth_' . ($policy['type'] == 'user' ? '' : 'group_') . "perms AS uap{$i} ON (gl.host_id=uap{$i}.item_id AND uap{$i}.type=3) ";
$sql_select .= (strlen($sql_select) ? ', ' : '') . "uap{$i}." . $policy['type'] . "_id AS user{$i}";
$i++;
if (get_request_var_request('associated') == 'false') {
if ($policy['policy_graph_templates'] == 1) {
$sql_having .= " {$sql_operator} user{$i} IS NULL))";
} else {
$sql_having .= " {$sql_operator} user{$i}=" . $policy['id'] . '))';
}
}
$sql_join .= 'LEFT JOIN user_auth_' . ($policy['type'] == 'user' ? '' : 'group_') . "perms AS uap{$i} ON (gl.graph_template_id=uap{$i}.item_id AND uap{$i}.type=4) ";
$sql_select .= (strlen($sql_select) ? ', ' : '') . "uap{$i}." . $policy['type'] . "_id AS user{$i}";
$i++;
}
if (strlen($sql_having)) {
$sql_having = 'HAVING ' . $sql_having;
}
$graphs = db_fetch_assoc("SELECT gtg.local_graph_id, h.description, gt.name AS template_name, \n\t\t\tgtg.title_cache, gtg.width, gtg.height, gl.snmp_index, gl.snmp_query_id,\n\t\t\t{$sql_select}\n\t\t\tFROM graph_templates_graph AS gtg \n\t\t\tINNER JOIN graph_local AS gl \n\t\t\tON gl.id = gtg.local_graph_id \n\t\t\tLEFT JOIN graph_templates AS gt \n\t\t\tON gt.id = gl.graph_template_id \n\t\t\tLEFT JOIN host AS h \n\t\t\tON h.id = gl.host_id \n\t\t\t{$sql_join}\n\t\t\t{$sql_where}\n\t\t\t{$sql_having}\n\t\t\tORDER BY gtg.title_cache\n\t\t\t{$limit}");
$total_rows = db_fetch_cell("SELECT COUNT(*)\n\t\t\tFROM (\n\t\t\t\tSELECT {$sql_select}\n\t\t\t\tFROM graph_templates_graph AS gtg \n\t\t\t\tINNER JOIN graph_local AS gl \n\t\t\t\tON gl.id = gtg.local_graph_id \n\t\t\t\tLEFT JOIN graph_templates AS gt \n\t\t\t\tON gt.id = gl.graph_template_id \n\t\t\t\tLEFT JOIN host AS h \n\t\t\t\tON h.id = gl.host_id \n\t\t\t\t{$sql_join}\n\t\t\t\t{$sql_where}\n\t\t\t\t{$sql_having}\n\t\t\t) AS rows");
//print '<pre>';print_r($graphs);print '</pre>';
$nav = html_nav_bar('user_admin.php?action=user_edit&tab=permsg&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Graphs', 'page', 'main');
print $nav;
$display_text = array('Graph Title', 'ID', 'Effective Policy');
html_header_checkbox($display_text, false);
if (sizeof($graphs)) {
foreach ($graphs as $g) {
form_alternate_row('line' . $g['local_graph_id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($g['title_cache'])) : htmlspecialchars($g['title_cache']), $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();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Graphs Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'user_edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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');
}
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($assoc_actions);
print '</form>';
break;
case 'permsgr':
process_group_request_vars();
group_filter($header_label);
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE ((uag.name LIKE '%" . get_request_var_request('filter') . "%') OR (uag.description LIKE '%" . get_request_var_request('filter') . "%'))";
} else {
$sql_where = '';
}
if (get_request_var_request('associated') != 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' uagm.user_id=' . get_request_var_request('id', 0);
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_admin.php?action=user_edit&tab=permsd&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(uag.id)\n\t\t\tFROM user_auth_group AS uag\n\t\t\tLEFT JOIN user_auth_group_members AS uagm\n\t\t\tON uag.id = uagm.group_id\n\t\t\t{$sql_where}");
$sql_query = "SELECT uag.*, uagm.user_id\n\t\t\tFROM user_auth_group AS uag\n\t\t\tLEFT JOIN user_auth_group_members AS uagm\n\t\t\tON uag.id = uagm.group_id\n\t\t\t{$sql_where} \n\t\t\tORDER BY name\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$groups = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_admin.php?action=user_edit&tab=permsgr&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Devices', 'page', 'main');
print $nav;
$display_text = array('Name', 'Description', 'Member', 'ID', 'Policies (Graph/Device/Template)', 'Enabled');
html_header_checkbox($display_text, false);
if (sizeof($groups)) {
foreach ($groups as $g) {
form_alternate_row('line' . $g['id'], true);
form_selectable_cell("<a class='linkEditMain' href='user_group_admin.php?action=edit&id=" . $g['id'] . "'>" . (strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($g['name'])) : htmlspecialchars($g['name'])) . '</a>', $g['id']);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($g['description'])) : htmlspecialchars($g['description']), $g['id']);
form_selectable_cell($g['user_id'] > 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();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching User Groups Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'user_edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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);
print '</form>';
break;
case 'permsd':
process_device_request_vars();
device_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Device Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Device Policy for this User</td>
<td width="10">
<?php
form_dropdown('policy_hosts', $policy_array, '', '', $policy['policy_hosts'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (host.hostname LIKE '%%" . get_request_var_request('filter') . "%%' OR host.description LIKE '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('host_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var_request('host_template_id') == '0') {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' host.host_template_id=0';
} elseif (!empty($_REQUEST['host_template_id'])) {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' host.host_template_id=' . get_request_var_request('host_template_id');
}
if (get_request_var_request('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' user_auth_perms.user_id=' . get_request_var_request('id', 0);
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_admin.php?action=user_edit&tab=permsd&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(host.id)\n\t\t\tFROM host\n\t\t\tLEFT JOIN user_auth_perms \n\t\t\tON (host.id = user_auth_perms.item_id AND user_auth_perms.type = 3)\n\t\t\t{$sql_where}");
$host_graphs = array_rekey(db_fetch_assoc('SELECT host_id, count(*) as graphs FROM graph_local GROUP BY host_id'), 'host_id', 'graphs');
$host_data_sources = array_rekey(db_fetch_assoc('SELECT host_id, count(*) as data_sources FROM data_local GROUP BY host_id'), 'host_id', 'data_sources');
$sql_query = "SELECT host.*, user_auth_perms.user_id\n\t\t\tFROM host \n\t\t\tLEFT JOIN user_auth_perms \n\t\t\tON (host.id = user_auth_perms.item_id AND user_auth_perms.type = 3)\n\t\t\t{$sql_where} \n\t\t\tORDER BY description\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$hosts = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_admin.php?action=user_edit&tab=permsd&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Devices', 'page', 'main');
print $nav;
$display_text = array('Description', 'ID', 'Effective Policy', 'Graphs', 'Data Sources', 'Status', 'Hostname');
html_header_checkbox($display_text, false);
if (sizeof($hosts)) {
foreach ($hosts as $host) {
form_alternate_row('line' . $host['id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['description'])) : htmlspecialchars($host['description']), $host['id']);
form_selectable_cell(round($host['id'], 2), $host['id']);
if (empty($host['user_id']) || $host['user_id'] == NULL) {
if ($policy['policy_hosts'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $host['id']);
}
} else {
if ($policy['policy_hosts'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $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(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['hostname'])) : htmlspecialchars($host['hostname']), $host['id']);
form_checkbox_cell($host['description'], $host['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Devices Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'user_edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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);
print '</form>';
break;
case 'permste':
process_template_request_vars();
template_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Graph Template Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Graph Template Policy for this User</td>
<td width="10">
<?php
form_dropdown('policy_graph_templates', $policy_array, '', '', $policy['policy_graph_templates'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (gt.name LIKE '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' (user_auth_perms.type=4 AND user_auth_perms.user_id=' . get_request_var_request('id', 0) . ')';
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_admin.php?action=user_edit&tab=permste&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(gt.id)\n\t\t\tFROM graph_templates AS gt\n\t\t\tINNER JOIN graph_local AS gl\n\t\t\tON gt.id = gl.graph_template_id\n\t\t\tLEFT JOIN user_auth_perms \n\t\t\tON (gt.id = user_auth_perms.item_id AND user_auth_perms.type = 4)\n\t\t\t{$sql_where}\n\t\t\tGROUP BY gl.graph_template_id");
$sql_query = "SELECT gt.id, gt.name, count(*) AS totals, user_auth_perms.user_id\n\t\t\tFROM graph_templates AS gt\n\t\t\tINNER JOIN graph_local AS gl\n\t\t\tON gt.id = gl.graph_template_id\n\t\t\tLEFT JOIN user_auth_perms \n\t\t\tON (gt.id = user_auth_perms.item_id AND user_auth_perms.type = 4)\n\t\t\t{$sql_where} \n\t\t\tGROUP BY gl.graph_template_id\n\t\t\tORDER BY name\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$graphs = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_admin.php?action=user_edit&tab=permste&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Graph Templates', 'page', 'main');
print $nav;
$display_text = array('Template Name', 'ID', 'Effective Policy', 'Total Graphs');
html_header_checkbox($display_text, false);
if (sizeof($graphs)) {
foreach ($graphs as $g) {
form_alternate_row('line' . $g['id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($g['name'])) : htmlspecialchars($g['name']), $g['id']);
form_selectable_cell($g['id'], $g['id']);
if (empty($g['user_id']) || $g['user_id'] == NULL) {
if ($policy['policy_graph_templates'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $g['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $g['id']);
}
} else {
if ($policy['policy_graph_templates'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $g['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $g['id']);
}
}
form_selectable_cell($g['totals'], $g['id']);
form_checkbox_cell($g['name'], $g['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Graph Templates Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'user_edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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);
print '</form>';
break;
case 'permstr':
process_tree_request_vars();
tree_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Tree Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Tree Policy for this User</td>
<td width="10">
<?php
form_dropdown('policy_trees', $policy_array, '', '', $policy['policy_trees'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (gt.name LIKE '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('associated') == 'false') {
/* showing all rows */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' (user_auth_perms.type=2 AND user_auth_perms.user_id=' . get_request_var_request('id', 0) . ')';
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_admin.php?action=user_edit&tab=permstr&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(gt.id)\n\t\t\tFROM graph_tree AS gt\n\t\t\tLEFT JOIN user_auth_perms \n\t\t\tON (gt.id = user_auth_perms.item_id AND user_auth_perms.type = 2)\n\t\t\t{$sql_where}");
$sql_query = "SELECT gt.id, gt.name, user_auth_perms.user_id\n\t\t\tFROM graph_tree AS gt\n\t\t\tLEFT JOIN user_auth_perms \n\t\t\tON (gt.id = user_auth_perms.item_id AND user_auth_perms.type = 2)\n\t\t\t{$sql_where} \n\t\t\tORDER BY name\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$trees = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_admin.php?action=user_edit&tab=permstr&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Trees', 'page', 'main');
print $nav;
$display_text = array('Tree Name', 'ID', 'Effective Policy');
html_header_checkbox($display_text, false);
if (sizeof($trees)) {
foreach ($trees as $t) {
form_alternate_row('line' . $t['id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($t['name'])) : htmlspecialchars($t['name']), $t['id']);
form_selectable_cell($t['id'], $t['id']);
if (empty($t['user_id']) || $t['user_id'] == NULL) {
if ($policy['policy_graphs'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $t['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $t['id']);
}
} else {
if ($policy['policy_graphs'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $t['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $t['id']);
}
}
form_checkbox_cell($t['name'], $t['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Trees Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'user_edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('id'), '');
form_hidden_box('associate_tree', '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);
print '</form>';
break;
}
}
function host()
{
global $colors, $device_actions, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("host_template_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("host_status"));
input_validate_input_number(get_request_var_request("host_rows"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_device_current_page");
kill_session_var("sess_device_filter");
kill_session_var("sess_device_host_template_id");
kill_session_var("sess_host_status");
kill_session_var("sess_host_rows");
kill_session_var("sess_host_sort_column");
kill_session_var("sess_host_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["host_template_id"]);
unset($_REQUEST["host_status"]);
unset($_REQUEST["host_rows"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
if (!empty($_SESSION["sess_host_status"]) && !empty($_REQUEST["host_status"])) {
if ($_SESSION["sess_host_status"] != $_REQUEST["host_status"]) {
$_REQUEST["page"] = 1;
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_device_current_page", "1");
load_current_session_value("filter", "sess_device_filter", "");
load_current_session_value("host_template_id", "sess_device_host_template_id", "-1");
load_current_session_value("host_status", "sess_host_status", "-1");
load_current_session_value("host_rows", "sess_host_rows", read_config_option("num_rows_device"));
load_current_session_value("sort_column", "sess_host_sort_column", "description");
load_current_session_value("sort_direction", "sess_host_sort_direction", "ASC");
/* if the number of rows is -1, set it to the default */
if ($_REQUEST["host_rows"] == -1) {
$_REQUEST["host_rows"] = read_config_option("num_rows_device");
}
?>
<script type="text/javascript">
<!--
function applyViewDeviceFilterChange(objForm) {
strURL = '?host_status=' + objForm.host_status.value;
strURL = strURL + '&host_template_id=' + objForm.host_template_id.value;
strURL = strURL + '&host_rows=' + objForm.host_rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>Devices</strong>", "100%", $colors["header"], "3", "center", "host.php?action=edit&host_template_id=" . get_request_var_request("host_template_id") . "&host_status=" . get_request_var_request("host_status"));
?>
<tr bgcolor="<?php
print $colors["panel"];
?>
">
<form name="form_devices">
<td>
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td nowrap style='white-space: nowrap;' width="50">
Type:
</td>
<td width="1">
<select name="host_template_id" onChange="applyViewDeviceFilterChange(document.form_devices)">
<option value="-1"<?php
if (get_request_var_request("host_template_id") == "-1") {
?>
selected<?php
}
?>
>Any</option>
<option value="0"<?php
if (get_request_var_request("host_template_id") == "0") {
?>
selected<?php
}
?>
>None</option>
<?php
$host_templates = db_fetch_assoc("select id,name from host_template order by name");
if (sizeof($host_templates) > 0) {
foreach ($host_templates as $host_template) {
print "<option value='" . $host_template["id"] . "'";
if (get_request_var_request("host_template_id") == $host_template["id"]) {
print " selected";
}
print ">" . $host_template["name"] . "</option>\n";
}
}
?>
</select>
</td>
<td nowrap style='white-space: nowrap;' width="50">
Status:
</td>
<td width="1">
<select name="host_status" onChange="applyViewDeviceFilterChange(document.form_devices)">
<option value="-1"<?php
if (get_request_var_request("host_status") == "-1") {
?>
selected<?php
}
?>
>Any</option>
<option value="-3"<?php
if (get_request_var_request("host_status") == "-3") {
?>
selected<?php
}
?>
>Enabled</option>
<option value="-2"<?php
if (get_request_var_request("host_status") == "-2") {
?>
selected<?php
}
?>
>Disabled</option>
<option value="-4"<?php
if (get_request_var_request("host_status") == "-4") {
?>
selected<?php
}
?>
>Not Up</option>
<option value="3"<?php
if (get_request_var_request("host_status") == "3") {
?>
selected<?php
}
?>
>Up</option>
<option value="1"<?php
if (get_request_var_request("host_status") == "1") {
?>
selected<?php
}
?>
>Down</option>
<option value="2"<?php
if (get_request_var_request("host_status") == "2") {
?>
selected<?php
}
?>
>Recovering</option>
<option value="0"<?php
if (get_request_var_request("host_status") == "0") {
?>
selected<?php
}
?>
>Unknown</option>
</select>
</td>
<td nowrap style='white-space: nowrap;' width="20">
Search:
</td>
<td width="1">
<input type="text" name="filter" size="20" value="<?php
print get_request_var_request("filter");
?>
">
</td>
<td nowrap style='white-space: nowrap;' width="50">
Rows per Page:
</td>
<td width="1">
<select name="host_rows" onChange="applyViewDeviceFilterChange(document.form_devices)">
<option value="-1"<?php
if (get_request_var_request("host_rows") == "-1") {
?>
selected<?php
}
?>
>Default</option>
<?php
if (sizeof($item_rows) > 0) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if (get_request_var_request("host_rows") == $key) {
print " selected";
}
print ">" . $value . "</option>\n";
}
}
?>
</select>
</td>
<td nowrap>
<input type="image" src="images/button_go.gif" alt="Go" border="0" align="absmiddle">
<input type="image" src="images/button_clear.gif" name="clear" alt="Clear" border="0" align="absmiddle">
</td>
</tr>
</table>
</td>
<input type='hidden' name='page' value='1'>
</form>
</tr>
<?php
html_end_box();
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request("filter"))) {
$sql_where = "where (host.hostname like '%%" . get_request_var_request("filter") . "%%' OR host.description like '%%" . get_request_var_request("filter") . "%%')";
} else {
$sql_where = "";
}
if (get_request_var_request("host_status") == "-1") {
/* Show all items */
} elseif (get_request_var_request("host_status") == "-2") {
$sql_where .= strlen($sql_where) ? " and host.disabled='on'" : "where host.disabled='on'";
} elseif (get_request_var_request("host_status") == "-3") {
$sql_where .= strlen($sql_where) ? " and host.disabled=''" : "where host.disabled=''";
} elseif (get_request_var_request("host_status") == "-4") {
$sql_where .= strlen($sql_where) ? " and (host.status!='3' or host.disabled='on')" : "where (host.status!='3' or host.disabled='on')";
} else {
$sql_where .= strlen($sql_where) ? " and (host.status=" . get_request_var_request("host_status") . " AND host.disabled = '')" : "where (host.status=" . get_request_var_request("host_status") . " AND host.disabled = '')";
}
if (get_request_var_request("host_template_id") == "-1") {
/* Show all items */
} elseif (get_request_var_request("host_template_id") == "0") {
$sql_where .= strlen($sql_where) ? " and host.host_template_id=0" : "where host.host_template_id=0";
} elseif (!empty($_REQUEST["host_template_id"])) {
$sql_where .= strlen($sql_where) ? " and host.host_template_id=" . get_request_var_request("host_template_id") : "where host.host_template_id=" . get_request_var_request("host_template_id");
}
html_start_box("", "100%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("select\n\t\tCOUNT(host.id)\n\t\tfrom host\n\t\t{$sql_where}");
$sortby = get_request_var_request("sort_column");
if ($sortby == "hostname") {
$sortby = "INET_ATON(hostname)";
}
$host_graphs = array_rekey(db_fetch_assoc("SELECT host_id, count(*) as graphs FROM graph_local GROUP BY host_id"), "host_id", "graphs");
$host_data_sources = array_rekey(db_fetch_assoc("SELECT host_id, count(*) as data_sources FROM data_local GROUP BY host_id"), "host_id", "data_sources");
$sql_query = "SELECT *\n\t\tFROM host\n\t\t{$sql_where}\n\t\tORDER BY " . $sortby . " " . get_request_var_request("sort_direction") . "\n\t\tLIMIT " . get_request_var_request("host_rows") * (get_request_var_request("page") - 1) . "," . get_request_var_request("host_rows");
$hosts = db_fetch_assoc($sql_query);
/* generate page list */
$url_page_select = get_page_list(get_request_var_request("page"), MAX_DISPLAY_PAGES, get_request_var_request("host_rows"), $total_rows, "host.php?filter=" . get_request_var_request("filter") . "&host_template_id=" . get_request_var_request("host_template_id") . "&host_status=" . get_request_var_request("host_status"));
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t<td colspan='11'>\n\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\n\t\t\t\t\t\t\t<strong><< ";
if (get_request_var_request("page") > 1) {
$nav .= "<a class='linkOverDark' href='host.php?filter=" . get_request_var_request("filter") . "&host_template_id=" . get_request_var_request("host_template_id") . "&host_status=" . get_request_var_request("host_status") . "&page=" . (get_request_var_request("page") - 1) . "'>";
}
$nav .= "Previous";
if (get_request_var_request("page") > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\tShowing Rows " . (get_request_var_request("host_rows") * (get_request_var_request("page") - 1) + 1) . " to " . ($total_rows < read_config_option("num_rows_device") || $total_rows < get_request_var_request("host_rows") * get_request_var_request("page") ? $total_rows : get_request_var_request("host_rows") * get_request_var_request("page")) . " of {$total_rows} [{$url_page_select}]\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\n\t\t\t\t\t\t\t<strong>";
if (get_request_var_request("page") * get_request_var_request("host_rows") < $total_rows) {
$nav .= "<a class='linkOverDark' href='host.php?filter=" . get_request_var_request("filter") . "&host_template_id=" . get_request_var_request("host_template_id") . "&host_status=" . get_request_var_request("host_status") . "&page=" . (get_request_var_request("page") + 1) . "'>";
}
$nav .= "Next";
if (get_request_var_request("page") * get_request_var_request("host_rows") < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t</td>\n\t\t</tr>\n";
print $nav;
$display_text = array("description" => array("Description", "ASC"), "id" => array("ID", "ASC"), "nosort1" => array("Graphs", "ASC"), "nosort2" => array("Data Sources", "ASC"), "status" => array("Status", "ASC"), "status_event_count" => array("Event Count", "ASC"), "hostname" => array("Hostname", "ASC"), "cur_time" => array("Current (ms)", "DESC"), "avg_time" => array("Average (ms)", "DESC"), "availability" => array("Availability", "ASC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
$i = 0;
if (sizeof($hosts) > 0) {
foreach ($hosts as $host) {
form_alternate_row_color($colors["alternate"], $colors["light"], $i, 'line' . $host["id"]);
$i++;
form_selectable_cell("<a class='linkEditMain' href='host.php?action=edit&id=" . $host["id"] . "'>" . (strlen(get_request_var_request("filter")) ? eregi_replace("(" . preg_quote(get_request_var_request("filter")) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["description"]) : $host["description"]) . "</a>", $host["id"], 250);
form_selectable_cell(round($host["id"], 2), $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(round($host["status_event_count"], 2), $host["id"]);
form_selectable_cell(strlen(get_request_var_request("filter")) ? eregi_replace("(" . preg_quote(get_request_var_request("filter")) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["hostname"]) : $host["hostname"], $host["id"]);
form_selectable_cell(round($host["cur_time"], 2), $host["id"]);
form_selectable_cell(round($host["avg_time"], 2), $host["id"]);
form_selectable_cell(round($host["availability"], 2), $host["id"]);
form_checkbox_cell($host["description"], $host["id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print "<tr><td><em>No Hosts</em></td></tr>";
}
html_end_box(false);
/* add a list of tree names to the actions dropdown */
add_tree_names_to_actions_array();
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
print "</form>\n";
}
function mikrotik_devices()
{
global $config, $colors, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("status"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up sort_direction */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* clean up filter string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
if (isset($_REQUEST["reset"])) {
kill_session_var("sess_mikrotik_device_sort_column");
kill_session_var("sess_mikrotik_device_sort_direction");
kill_session_var("sess_mikrotik_device_status");
kill_session_var("sess_mikrotik_device_filter");
kill_session_var("sess_mikrotik_device_rows");
kill_session_var("sess_mikrotik_device_current_page");
} elseif (isset($_REQUEST["clear"])) {
kill_session_var("sess_mikrotik_device_sort_column");
kill_session_var("sess_mikrotik_device_sort_direction");
kill_session_var("sess_mikrotik_device_status");
kill_session_var("sess_mikrotik_device_filter");
kill_session_var("sess_mikrotik_device_rows");
kill_session_var("sess_mikrotik_device_current_page");
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
unset($_REQUEST["status"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["page"]);
} else {
/* if any of the settings changed, reset the page number */
$changed = false;
$changed += mikrotik_check_changed("status", "sess_mikrotik_device_status");
$changed += mikrotik_check_changed("fitler", "sess_mikrotik_device_filter");
$changed += mikrotik_check_changed("rows", "sess_mikrotik_device_rows");
if ($changed) {
$_REQUEST["page"] = "1";
}
}
load_current_session_value("page", "sess_mikrotik_device_current_page", "1");
load_current_session_value("rows", "sess_mikrotik_device_rows", "-1");
load_current_session_value("sort_column", "sess_mikrotik_device_sort_column", "description");
load_current_session_value("sort_direction", "sess_mikrotik_device_sort_direction", "ASC");
load_current_session_value("status", "sess_mikrotik_device_status", "-1");
load_current_session_value("filter", "sess_mikrotik_device_filter", "");
?>
<script type="text/javascript">
<!--
function applyHostFilter(objForm) {
strURL = '?action=devices';
strURL = strURL + '&status=' + objForm.status.value;
strURL = strURL + '&filter=' + objForm.filter.value;
strURL = strURL + '&rows=' + objForm.rows.value;
document.location = strURL;
}
function clearHosts() {
strURL = '?action=devices&clear=';
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>Device Filter</strong>", "100%", $colors["header"], "3", "center", "");
?>
<tr bgcolor="#<?php
print $colors["panel"];
?>
">
<td>
<form name="devices" action="mikrotik.php?action=devices">
<table cellpadding="0" cellspacing="0">
<tr>
<td nowrap style='white-space: nowrap;' width="60">
Status:
</td>
<td width="1">
<select name="status" onChange="applyHostFilter(document.devices)">
<option value="-1"<?php
if (get_request_var_request("type") == "-1") {
?>
selected<?php
}
?>
>All</option>
<?php
$statuses = db_fetch_assoc("SELECT DISTINCT status\n\t\t\t\t\t\t\t\tFROM host\n\t\t\t\t\t\t\t\tINNER JOIN plugin_mikrotik_system\n\t\t\t\t\t\t\t\tON host.id=plugin_mikrotik_system.host_id");
$statuses = array_merge($statuses, array("-2" => array("status" => "-2")));
if (sizeof($statuses)) {
foreach ($statuses as $s) {
switch ($s["status"]) {
case "0":
$status = "Unknown";
break;
case "1":
$status = "Down";
break;
case "2":
$status = "Recovering";
break;
case "3":
$status = "Up";
break;
case "-2":
$status = "Disabled";
break;
}
echo "<option value='" . $s["status"] . "' " . (get_request_var_request("status") == $s["status"] ? "selected" : "") . ">" . $status . "</option>";
}
}
?>
</select>
</td>
<td nowrap style='white-space: nowrap;' width="60">
Rows:
</td>
<td width="1">
<select name="rows" onChange="applyHostFilter(document.devices)">
<option value="-1"<?php
if (get_request_var_request("rows") == "-1") {
?>
selected<?php
}
?>
>Default</option>
<?php
if (sizeof($item_rows)) {
foreach ($item_rows as $key => $name) {
echo "<option value='" . $key . "' " . (get_request_var_request("rows") == $key ? "selected" : "") . ">" . $name . "</option>";
}
}
?>
</select>
</td>
<td nowrap style='white-space: nowrap;' width="60">
Search:
</td>
<td>
<input type='text' size='40' name='filter' value='<?php
print get_request_var_request("filter");
?>
'>
</td>
<td nowrap>
<input type="button" onClick="applyHostFilter(document.devices)" value="Go" border="0">
</td>
<td nowrap>
<input type="button" onClick="clearHosts()" value="Clear" name="clear" border="0">
</td>
</tr>
</table>
<input type='hidden' name='action' value='devices'>
</form>
</td>
</tr>
<?php
html_end_box();
html_start_box("", "100%", $colors["header"], "3", "center", "");
if ($_REQUEST["rows"] == "-1") {
$num_rows = read_config_option("num_rows_device");
} else {
$num_rows = get_request_var_request("rows");
}
$limit = " LIMIT " . $num_rows * (get_request_var_request("page") - 1) . "," . $num_rows;
$sql_where = "";
if ($_REQUEST["status"] != "-1") {
$sql_where .= (strlen($sql_where) ? " AND" : "WHERE") . " hrs.host_status=" . $_REQUEST["status"];
}
$sql_join = "";
if ($_REQUEST["filter"] != "") {
$sql_where .= (strlen($sql_where) ? " AND" : "WHERE") . " host.description LIKE '%" . $_REQUEST["filter"] . "%' OR\n\t\t\thost.hostname LIKE '%" . $_REQUEST["filter"] . "%'";
}
$sql = "SELECT hrs.*, host.hostname, host.description, host.disabled\n\t\tFROM plugin_mikrotik_system AS hrs\n\t\tINNER JOIN host ON host.id=hrs.host_id\n\t\t{$sql_join}\n\t\t{$sql_where}\n\t\tORDER BY " . get_request_var_request("sort_column") . " " . get_request_var_request("sort_direction") . " " . $limit;
//echo $sql;
$rows = db_fetch_assoc($sql);
$total_rows = db_fetch_cell("SELECT COUNT(*)\n\t\tFROM plugin_mikrotik_system AS hrs\n\t\tINNER JOIN host ON host.id=hrs.host_id\n\t\t{$sql_join}\n\t\t{$sql_where}");
if ($total_rows > 0) {
/* generate page list */
$url_page_select = get_page_list(get_request_var_request("page"), MAX_DISPLAY_PAGES, $num_rows, $total_rows, "mikrotik.php" . "?action=devices");
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t<td colspan='16'>\n\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\n\t\t\t\t\t\t\t<strong><< ";
if (get_request_var_request("page") > 1) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("mikrotik.php" . "?action=devices&page=" . (get_request_var_request("page") - 1)) . "'>";
}
$nav .= "Previous";
if (get_request_var_request("page") > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\tShowing Rows " . ($num_rows * (get_request_var_request("page") - 1) + 1) . " to " . ($total_rows < $num_rows || $total_rows < $num_rows * get_request_var_request("page") ? $total_rows : $num_rows * get_request_var_request("page")) . " of {$total_rows} [{$url_page_select}]\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\n\t\t\t\t\t\t\t<strong>";
if (get_request_var_request("page") * $num_rows < $total_rows) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("mikrotik.php" . "?action=devices&page=" . (get_request_var_request("page") + 1)) . "'>";
}
$nav .= "Next";
if (get_request_var_request("page") * $num_rows < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t</td>\n\t\t</tr>\n";
} else {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t<td colspan='16'>\n\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\tNo Rows Found\n\t\t\t\t\t\t</td>\n\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t</td>\n\t\t</tr>\n";
}
print $nav;
$display_text = array("nosort" => array("Actions", array("ASC", "left")), "description" => array("Name", array("ASC", "left")), "host_status" => array("Status", array("DESC", "right")), "uptime" => array("Uptime(d:h:m)", array("DESC", "right")), "users" => array("Users", array("DESC", "right")), "cpuPercent" => array("CPU %", array("DESC", "right")), "numCpus" => array("CPUs", array("DESC", "right")), "processes" => array("Processes", array("DESC", "right")), "memSize" => array("Total Mem", array("DESC", "right")), "memUsed" => array("Used Mem", array("DESC", "right")), "diskSize" => array("Total Disk", array("DESC", "right")), "diskUsed" => array("Used Disk", array("DESC", "right")));
mikrotik_header_sort($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"), "action=devices");
/* set some defaults */
$url = $config["url_path"] . "plugins/mikrotik/mikrotik.php";
$users = $config["url_path"] . "plugins/mikrotik/images/view_users.gif";
$host = $config["url_path"] . "plugins/mikrotik/images/view_hosts.gif";
$trees = $config["url_path"] . "plugins/mikrotik/images/view_trees.gif";
$dashboard = $config["url_path"] . "plugins/mikrotik/images/view_dashboard.gif";
$graphs = $config["url_path"] . "plugins/mikrotik/images/view_graphs.gif";
$nographs = $config["url_path"] . "plugins/mikrotik/images/view_graphs_disabled.gif";
$hcpudq = read_config_option("mikrotik_dq_host_cpu");
$i = 0;
if (sizeof($rows)) {
foreach ($rows as $row) {
$days = intval($row["uptime"] / (60 * 60 * 24 * 100));
$remainder = $row["uptime"] % (60 * 60 * 24 * 100);
$hours = intval($remainder / (60 * 60 * 100));
$remainder = $remainder % (60 * 60 * 100);
$minutes = intval($remainder / (60 * 100));
$found = db_fetch_cell("SELECT COUNT(*) FROM graph_local WHERE host_id=" . $row["host_id"]);
form_alternate_row_color($colors["alternate"], $colors["light"], $i);
$i++;
echo "<td width='100' align='left'>";
//echo "<a style='padding:1px;' href='" . htmlspecialchars("$url?action=dashboard&reset=1&device=" . $row["host_id"]) . "'><img src='$dashboard' title='View Dashboard' align='absmiddle' border='0'></a>";
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=users&reset=1&device=" . $row["host_id"]) . "'><img src='{$users}' title='View Users' align='absmiddle' border='0'></a>";
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=trees&reset=1&device=" . $row["host_id"]) . "'><img src='{$trees}' title='View Queue Trees' align='absmiddle' border='0'></a>";
if ($found) {
echo "<a style='padding:1px;' href='" . htmlspecialchars("{$url}?action=graphs&reset=1&host=" . $row["host_id"] . "&style=selective&graph_add=&graph_list=&graph_template_id=0&filter=") . "'><img src='{$graphs}' title='View Graphs' align='absmiddle' border='0'></a>";
} else {
echo "<img src='{$nographs}' title='No Graphs Defined' align='absmiddle' border='0'>";
}
$graph_cpu = mikrotik_get_graph_url($hcpudq, $row["host_id"], "", $row["numCpus"], false);
$graph_cpup = mikrotik_get_graph_template_url(read_config_option("mikrotik_gt_cpu"), $row["host_id"], round($row["cpuPercent"], 2), false);
$graph_users = mikrotik_get_graph_template_url(read_config_option("mikrotik_gt_users"), $row["host_id"], $row["users"], false);
$graph_aproc = mikrotik_get_graph_template_url(read_config_option("mikrotik_gt_processes"), $row["host_id"], $row["host_status"] < 2 ? "N/A" : $row["processes"], false);
$graph_disk = mikrotik_get_graph_template_url(read_config_option("mikrotik_gt_disk"), $row["host_id"], $row["host_status"] < 2 ? "N/A" : round($row["diskUsed"], 2), false);
$graph_mem = mikrotik_get_graph_template_url(read_config_option("mikrotik_gt_memory"), $row["host_id"], $row["host_status"] < 2 ? "N/A" : round($row["memUsed"], 2), false);
$graph_upt = mikrotik_get_graph_template_url(read_config_option("mikrotik_gt_uptime"), $row["host_id"], $row["host_status"] < 2 ? "N/A" : mikrotik_format_uptime($days, $hours, $minutes), false);
if (api_plugin_user_realm_auth('host.php')) {
$host_url = "<a href='" . htmlspecialchars($config["url_path"] . "host.php?action=edit&id=" . $row["host_id"]) . "' title='Edit Hosts'>" . $row["hostname"] . "</a>";
} else {
$host_url = $row["hostname"];
}
echo "</td>";
echo "<td style='white-space:nowrap;' align='left' width='200'><strong>" . $row["description"] . "</strong> [" . $host_url . "]" . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . get_colored_device_status($row["disabled"] == "on" ? true : false, $row["host_status"]) . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . $graph_upt . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . $graph_users . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . ($row["host_status"] < 2 ? "N/A" : $graph_cpup) . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . ($row["host_status"] < 2 ? "N/A" : $graph_cpu) . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . $graph_aproc . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . mikrotik_memory($row["memSize"]) . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . $graph_mem . " %</td>";
echo "<td style='white-space:nowrap;' align='right'>" . mikrotik_memory($row["diskSize"]) . "</td>";
echo "<td style='white-space:nowrap;' align='right'>" . $graph_disk . " %</td>";
}
echo "</tr>";
print $nav;
} else {
print "<tr><td><em>No Devices Found</em></td></tr>";
}
html_end_box();
}
function host() {
global $colors, $device_actions;
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_device_current_page");
kill_session_var("sess_device_filter");
kill_session_var("sess_device_host_template_id");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["host_template_id"]);
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_device_current_page", "1");
load_current_session_value("filter", "sess_device_filter", "");
load_current_session_value("host_template_id", "sess_device_host_template_id", "-1");
html_start_box("<strong>Devices</strong>", "98%", $colors["header"], "3", "center", "host.php?action=edit&host_template_id=" . $_REQUEST["host_template_id"]);
include("./include/html/inc_device_filter_table.php");
html_end_box();
/* form the 'where' clause for our main sql query */
$sql_where = "where host.description like '%%" . $_REQUEST["filter"] . "%%'";
if ($_REQUEST["host_template_id"] == "-1") {
/* Show all items */
}elseif ($_REQUEST["host_template_id"] == "0") {
$sql_where .= " and host.host_template_id=0";
}elseif (!empty($_REQUEST["host_template_id"])) {
$sql_where .= " and host.host_template_id=" . $_REQUEST["host_template_id"];
}
html_start_box("", "98%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("select
COUNT(host.id)
from host
$sql_where");
$hosts = db_fetch_assoc("select
host.id,
host.disabled,
host.status,
host.hostname,
host.description,
host.min_time,
host.max_time,
host.cur_time,
host.avg_time,
host.availability
from host
$sql_where
order by host.description
limit " . (read_config_option("num_rows_device")*($_REQUEST["page"]-1)) . "," . read_config_option("num_rows_device"));
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, "host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"]);
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='7'>
<table width='100%' cellspacing='0' cellpadding='0' border='0'>
<tr>
<td align='left' class='textHeaderDark'>
<strong><< "; if ($_REQUEST["page"] > 1) { $nav .= "<a class='linkOverDark' href='host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . ((read_config_option("num_rows_device")*($_REQUEST["page"]-1))+1) . " to " . ((($total_rows < read_config_option("num_rows_device")) || ($total_rows < (read_config_option("num_rows_device")*$_REQUEST["page"]))) ? $total_rows : (read_config_option("num_rows_device")*$_REQUEST["page"])) . " of $total_rows [$url_page_select]
</td>\n
<td align='right' class='textHeaderDark'>
<strong>"; if (($_REQUEST["page"] * read_config_option("num_rows_device")) < $total_rows) { $nav .= "<a class='linkOverDark' href='host.php?filter=" . $_REQUEST["filter"] . "&host_template_id=" . $_REQUEST["host_template_id"] . "&page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * read_config_option("num_rows_device")) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
print $nav;
html_header_checkbox(array("Description", "Status", "Hostname", "Current (ms)", "Average (ms)", "Availability"));
$i = 0;
if (sizeof($hosts) > 0) {
foreach ($hosts as $host) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width=200>
<a class="linkEditMain" href="host.php?action=edit&id=<?php print $host["id"];?>"><?php print eregi_replace("(" . preg_quote($_REQUEST["filter"]) . ")", "<span style='background-color: #F8D93D;'>\\1</span>", $host["description"]);?></a>
</td>
<td>
<?php print get_colored_device_status(($host["disabled"] == "on" ? true : false), $host["status"]);?>
</td>
<td>
<?php print $host["hostname"];?>
</td>
<td>
<?php print round(($host["cur_time"]), 2);?>
</td>
<td>
<?php print round(($host["avg_time"]), 2);?>
</td>
<td>
<?php print round($host["availability"], 2);?>%
</td>
<td style="<?php print get_checkbox_style();?>" width="1%" align="right">
<input type='checkbox' style='margin: 0px;' name='chk_<?php print $host["id"];?>' title="<?php print $host["description"];?>">
</td>
</tr>
<?php
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No Hosts</em></td></tr>";
}
html_end_box(false);
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
}
function mikrotik_devices()
{
global $config, $colors, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request('status'));
input_validate_input_number(get_request_var_request('page'));
input_validate_input_number(get_request_var_request('rows'));
/* ==================================================== */
/* clean up sort_column */
if (isset($_REQUEST['sort_column'])) {
$_REQUEST['sort_column'] = sanitize_search_string(get_request_var_request('sort_column'));
}
/* clean up sort_direction */
if (isset($_REQUEST['sort_direction'])) {
$_REQUEST['sort_direction'] = sanitize_search_string(get_request_var_request('sort_direction'));
}
/* clean up filter string */
if (isset($_REQUEST['filter'])) {
$_REQUEST['filter'] = sanitize_search_string(get_request_var_request('filter'));
}
if (isset($_REQUEST['reset'])) {
kill_session_var('sess_mikrotik_device_sort_column');
kill_session_var('sess_mikrotik_device_sort_direction');
kill_session_var('sess_mikrotik_device_status');
kill_session_var('sess_mikrotik_device_filter');
kill_session_var('sess_default_rows');
kill_session_var('sess_mikrotik_device_current_page');
} elseif (isset($_REQUEST['clear'])) {
kill_session_var('sess_mikrotik_device_sort_column');
kill_session_var('sess_mikrotik_device_sort_direction');
kill_session_var('sess_mikrotik_device_status');
kill_session_var('sess_mikrotik_device_filter');
kill_session_var('sess_default_rows');
kill_session_var('sess_mikrotik_device_current_page');
unset($_REQUEST['sort_column']);
unset($_REQUEST['sort_direction']);
unset($_REQUEST['status']);
unset($_REQUEST['filter']);
unset($_REQUEST['rows']);
unset($_REQUEST['page']);
} else {
/* if any of the settings changed, reset the page number */
$changed = false;
$changed += mikrotik_check_changed('status', 'sess_mikrotik_device_status');
$changed += mikrotik_check_changed('filter', 'sess_mikrotik_device_filter');
$changed += mikrotik_check_changed('rows', 'sess_default_rows');
if ($changed) {
$_REQUEST['page'] = '1';
}
}
load_current_session_value('page', 'sess_mikrotik_device_current_page', '1');
load_current_session_value('rows', 'sess_default_rows', read_config_option('num_rows_table'));
load_current_session_value('sort_column', 'sess_mikrotik_device_sort_column', 'description');
load_current_session_value('sort_direction', 'sess_mikrotik_device_sort_direction', 'ASC');
load_current_session_value('status', 'sess_mikrotik_device_status', '-1');
load_current_session_value('filter', 'sess_mikrotik_device_filter', '');
?>
<script type='text/javascript'>
function applyFilter() {
strURL = '?action=devices';
strURL += '&status=' + $('#status').val();
strURL += '&filter=' + $('#filter').val();
strURL += '&rows=' + $('#rows').val();
strURL += '&header=false';
loadPageNoHeader(strURL);
}
function clearFilter() {
strURL = '?action=devices&clear=&header=false';
loadPageNoHeader(strURL);
}
$(function() {
$('#form_devices').submit(function(event) {
event.preventDefault();
applyFilter();
});
});
</script>
<?php
html_start_box('<strong>Device Filter</strong>', '100%', $colors['header'], '3', 'center', '');
?>
<tr class='even noprint'>
<td>
<form id='form_devices' action='mikrotik.php?action=devices'>
<table class='filterTable'>
<tr>
<td>
Search
</td>
<td>
<input id='filter' type='text' size='25' value='<?php
print get_request_var_request('filter');
?>
'>
</td>
<td>
Status
</td>
<td>
<select id='status' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var_request('type') == '-1') {
?>
selected<?php
}
?>
>All</option>
<?php
$statuses = db_fetch_assoc('SELECT DISTINCT status
FROM host
INNER JOIN plugin_mikrotik_system
ON host.id=plugin_mikrotik_system.host_id');
$statuses = array_merge($statuses, array('-2' => array('status' => '-2')));
if (sizeof($statuses)) {
foreach ($statuses as $s) {
switch ($s['status']) {
case '0':
$status = 'Unknown';
break;
case '1':
$status = 'Down';
break;
case '2':
$status = 'Recovering';
break;
case '3':
$status = 'Up';
break;
case '-2':
$status = 'Disabled';
break;
}
echo "<option value='" . $s['status'] . "' " . (get_request_var_request('status') == $s['status'] ? 'selected' : '') . '>' . $status . '</option>';
}
}
?>
</select>
</td>
<td>
Devices
</td>
<td>
<select id='rows' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var_request('rows') == '-1') {
?>
selected<?php
}
?>
>Default</option>
<?php
if (sizeof($item_rows)) {
foreach ($item_rows as $key => $name) {
echo "<option value='" . $key . "' " . (get_request_var_request('rows') == $key ? 'selected' : '') . '>' . $name . '</option>';
}
}
?>
</select>
</td>
<td>
<input id='refresh' type='button' onClick='applyFilter()' value='Go'>
</td>
<td>
<input id='clear' type='button' onClick='clearFilter()' value='Clear'>
</td>
</tr>
</table>
<input type='hidden' id='page' name='page' value='<?php
print $_REQUEST['page'];
?>
'>
</form>
</td>
</tr>
<?php
html_end_box();
html_start_box('', '100%', $colors['header'], '3', 'center', '');
if ($_REQUEST['rows'] == '-1') {
$num_rows = read_config_option('num_rows_table');
} else {
$num_rows = get_request_var_request('rows');
}
$limit = ' LIMIT ' . $num_rows * (get_request_var_request('page') - 1) . ',' . $num_rows;
$sql_where = '';
if ($_REQUEST['status'] != '-1') {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . ' hrs.host_status=' . $_REQUEST['status'];
}
$sql_join = '';
if ($_REQUEST['filter'] != '') {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . " h.description LIKE '%" . $_REQUEST['filter'] . "%' OR\n\t\t\th.hostname LIKE '%" . $_REQUEST['filter'] . "%'";
}
$sql = "SELECT hrs.*, h.hostname, h.description, h.disabled, trees.trees, queues.queues\n\t\tFROM plugin_mikrotik_system AS hrs\n\t\tINNER JOIN host AS h \n\t\tON h.id=hrs.host_id\n\t\tLEFT JOIN (SELECT host_id AS hid, count(*) AS trees FROM plugin_mikrotik_trees GROUP BY host_id) AS trees\n\t\tON trees.hid=hrs.host_id\n\t\tLEFT JOIN (SELECT host_id AS hid, count(*) AS queues FROM plugin_mikrotik_queues GROUP BY host_id) AS queues\n\t\tON queues.hid=hrs.host_id\n\t\t{$sql_join}\n\t\t{$sql_where}\n\t\tORDER BY " . get_request_var_request("sort_column") . " " . get_request_var_request("sort_direction") . " " . $limit;
//echo $sql;
$rows = db_fetch_assoc($sql);
$total_rows = db_fetch_cell("SELECT COUNT(*)\n\t\tFROM plugin_mikrotik_system AS hrs\n\t\tINNER JOIN host AS h\n\t\tON h.id=hrs.host_id\n\t\t{$sql_join}\n\t\t{$sql_where}");
$nav = html_nav_bar('mikrotik.php?action=devices', MAX_DISPLAY_PAGES, get_request_var_request('page'), $num_rows, $total_rows, 15, 'Devices', 'page', 'main');
print $nav;
$display_text = array('nosort' => array('display' => 'Actions', 'sort' => 'ASC', 'align' => 'left'), 'description' => array('display' => 'Name', 'sort' => 'ASC', 'align' => 'left'), 'host_status' => array('display' => 'Status', 'sort' => 'DESC', 'align' => 'center'), 'firmwareVersion' => array('display' => 'FW Ver', 'sort' => 'DESC', 'align' => 'right'), 'licVersion' => array('display' => 'Lic Ver', 'sort' => 'DESC', 'align' => 'right'), 'uptime' => array('display' => 'Uptime(d:h:m)', 'sort' => 'DESC', 'align' => 'right'), 'trees' => array('display' => 'Trees', 'sort' => 'DESC', 'align' => 'right'), 'users' => array('display' => 'Users', 'sort' => 'DESC', 'align' => 'right'), 'cpuPercent' => array('display' => 'CPU %', 'sort' => 'DESC', 'align' => 'right'), 'numCpus' => array('display' => 'CPUs', 'sort' => 'DESC', 'align' => 'right'), 'processes' => array('display' => 'Processes', 'sort' => 'DESC', 'align' => 'right'), 'memSize' => array('display' => 'Total Mem', 'sort' => 'DESC', 'align' => 'right'), 'memUsed' => array('display' => 'Used Mem', 'sort' => 'DESC', 'align' => 'right'), 'diskSize' => array('display' => 'Total Disk', 'sort' => 'DESC', 'align' => 'right'), 'diskUsed' => array('display' => 'Used Disk', 'sort' => 'DESC', 'align' => 'right'));
html_header_sort($display_text, get_request_var_request('sort_column'), get_request_var_request('sort_direction'), 'false');
/* set some defaults */
$url = $config['url_path'] . 'plugins/mikrotik/mikrotik.php';
$users = $config['url_path'] . 'plugins/mikrotik/images/view_users.gif';
$usersn = $config['url_path'] . 'plugins/mikrotik/images/view_users_none.gif';
$host = $config['url_path'] . 'plugins/mikrotik/images/view_hosts.gif';
$trees = $config['url_path'] . 'plugins/mikrotik/images/view_trees.gif';
$treesn = $config['url_path'] . 'plugins/mikrotik/images/view_trees_none.gif';
$queues = $config['url_path'] . 'plugins/mikrotik/images/view_queues.gif';
$queuesn = $config['url_path'] . 'plugins/mikrotik/images/view_queues_none.gif';
$interfaces = $config['url_path'] . 'plugins/mikrotik/images/view_interfaces.gif';
$dashboard = $config['url_path'] . 'plugins/mikrotik/images/view_dashboard.gif';
$graphs = $config['url_path'] . 'plugins/mikrotik/images/view_graphs.gif';
$nographs = $config['url_path'] . 'plugins/mikrotik/images/view_graphs_disabled.gif';
$hcpudq = read_config_option('mikrotik_dq_host_cpu');
if (sizeof($rows)) {
foreach ($rows as $row) {
$days = intval($row['uptime'] / (60 * 60 * 24 * 100));
$remainder = $row['uptime'] % (60 * 60 * 24 * 100);
$hours = intval($remainder / (60 * 60 * 100));
$remainder = $remainder % (60 * 60 * 100);
$minutes = intval($remainder / (60 * 100));
$found = db_fetch_cell('SELECT COUNT(*) FROM graph_local WHERE host_id=' . $row['host_id']);
form_alternate_row();
echo "<td style='white-space:nowrap;min-width:115px;text-align:left;'>";
//echo "<a style='padding:1px;' href='" . htmlspecialchars("$url?action=dashboard&reset=1&device=" . $row["host_id"]) . "'><img src='$dashboard' title='View Dashboard' align='absmiddle' border='0'></a>";
if ($row['users'] > 0) {
echo "<a class='hyperLink' href='" . htmlspecialchars("{$url}?action=users&reset=1&device=" . $row['host_id']) . "'><img src='{$users}' title='View Users' align='absmiddle' border='0' alt=''></a>";
} else {
echo "<img style='border:0px;padding:3px;' src='{$usersn}' title='No Users Found' align='absmiddle' alt=''>";
}
if ($row['queues'] > 0) {
echo "<a class='hyperLink' href='" . htmlspecialchars("{$url}?action=queues&reset=1&device=" . $row['host_id']) . "'><img src='{$queues}' title='View Simple Queue' align='absmiddle' border='0' alt=''></a>";
} else {
echo "<img style='border:0px;padding:3px;' src='{$queuesn}' title='No Simple Queues Found' align='absmiddle' alt=''>";
}
if ($row['trees'] > 0) {
echo "<a class='hyperLink' href='" . htmlspecialchars("{$url}?action=trees&reset=1&device=" . $row['host_id']) . "'><img src='{$trees}' title='View Queue Trees' align='absmiddle' border='0' alt=''></a>";
} else {
echo "<img style='border:0px;padding:3px;' src='{$treesn}' title='No Queue Trees Found' align='absmiddle' alt=''>";
}
echo "<a class='hyperLink' href='" . htmlspecialchars("{$url}?action=interfaces&reset=1&device=" . $row['host_id']) . "'><img src='{$interfaces}' title='View Interfaces' align='absmiddle' border='0' alt=''></a>";
if ($found) {
echo "<a class='hyperLink' href='" . htmlspecialchars("{$url}?action=graphs&reset=1&host_id=" . $row['host_id'] . "&style=selective&graph_add=&graph_list=&graph_template_id=0&filter=") . "'><img src='{$graphs}' title='View Graphs' align='absmiddle' border='0' alt=''></a>";
} else {
echo "<img src='{$nographs}' title='No Graphs Defined' align='absmiddle' border='0'>";
}
$graph_cpu = mikrotik_get_graph_url($hcpudq, $row['host_id'], '', $row['numCpus'], false);
$graph_cpup = mikrotik_get_graph_template_url(mikrotik_template_by_hash('7df474393f58bae8e8d6b85f10efad71'), $row['host_id'], round($row['cpuPercent'], 2), false);
$graph_users = mikrotik_get_graph_template_url(mikrotik_template_by_hash('99e37ff13139f586d257ba9a637d7340'), $row['host_id'], empty($rows['users']) ? '-' : $row['users'], false);
$graph_aproc = mikrotik_get_graph_template_url(mikrotik_template_by_hash('e797d967db24fd86341a8aa8c60fa9e0'), $row['host_id'], $row['host_status'] < 2 ? 'N/A' : $row['processes'], false);
$graph_disk = mikrotik_get_graph_template_url(mikrotik_template_by_hash('0ece13b90785aa04d1f554a093685948'), $row['host_id'], $row['host_status'] < 2 ? 'N/A' : round($row['diskUsed'], 2), false);
$graph_mem = mikrotik_get_graph_template_url(mikrotik_template_by_hash('4396ae857c4f9bc5ed1f26b5361e42d9'), $row['host_id'], $row['host_status'] < 2 ? 'N/A' : round($row['memUsed'], 2), false);
$graph_upt = mikrotik_get_graph_template_url(mikrotik_template_by_hash('7d8dc3050621a2cb937cac3895bc5d5b'), $row['host_id'], $row['host_status'] < 2 ? 'N/A' : mikrotik_format_uptime($days, $hours, $minutes), false);
if (api_plugin_user_realm_auth('host.php')) {
$host_url = "<a class='hyperLink' href='" . htmlspecialchars($config['url_path'] . 'host.php?action=edit&id=' . $row['host_id']) . "' title='Edit Hosts'>" . $row['hostname'] . '</a>';
} else {
$host_url = $row['hostname'];
}
echo '</td>';
echo "<td style='text-align:left;white-space:nowrap;'><strong>" . (strlen($_REQUEST['filter']) ? preg_replace('/(' . preg_quote(get_request_var_request('filter'), '/') . ')/i', "<span class='filteredValue'>\\1</span>", $row['description'] . '</strong> [' . $host_url . ']') : $row['description'] . '</strong> [' . $host_url . ']') . '</td>';
echo "<td style='text-align:center;'>" . get_colored_device_status($row['disabled'] == 'on' ? true : false, $row['host_status']) . '</td>';
echo "<td style='text-align:right;'>" . $row['firmwareVersion'] . '</td>';
echo "<td style='text-align:right;'>" . $row['licVersion'] . '</td>';
echo "<td style='text-align:right;'>" . $graph_upt . '</td>';
echo "<td style='text-align:right;'>" . (!empty($row['trees']) ? $row['trees'] : '-') . '</td>';
echo "<td style='text-align:right;'>" . $graph_users . '</td>';
echo "<td style='text-align:right;'>" . ($row['host_status'] < 2 ? 'N/A' : $graph_cpup) . '</td>';
echo "<td style='text-align:right;'>" . ($row['host_status'] < 2 ? 'N/A' : $graph_cpu) . '</td>';
echo "<td style='text-align:right;'>" . $graph_aproc . '</td>';
echo "<td style='text-align:right;'>" . mikrotik_memory($row['memSize']) . '</td>';
echo "<td style='text-align:right;'>" . $graph_mem . ' %</td>';
echo "<td style='text-align:right;'>" . mikrotik_memory($row['diskSize']) . '</td>';
echo "<td style='text-align:right;'>" . $graph_disk . ' %</td>';
form_end_row();
}
print $nav;
} else {
print '<tr><td colspan="5"><em>No Devices Found</em></td></tr>';
}
html_end_box();
}
function host()
{
global $device_actions, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request('host_template_id'));
input_validate_input_number(get_request_var_request('page'));
input_validate_input_number(get_request_var_request('host_status'));
input_validate_input_number(get_request_var_request('rows'));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST['filter'])) {
$_REQUEST['filter'] = sanitize_search_string(get_request_var_request('filter'));
}
/* clean up sort_column */
if (isset($_REQUEST['sort_column'])) {
$_REQUEST['sort_column'] = sanitize_search_string(get_request_var_request('sort_column'));
}
/* clean up search string */
if (isset($_REQUEST['sort_direction'])) {
$_REQUEST['sort_direction'] = sanitize_search_string(get_request_var_request('sort_direction'));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST['clear_x'])) {
kill_session_var('sess_device_current_page');
kill_session_var('sess_device_filter');
kill_session_var('sess_device_host_template_id');
kill_session_var('sess_host_status');
kill_session_var('sess_default_rows');
kill_session_var('sess_host_sort_column');
kill_session_var('sess_host_sort_direction');
unset($_REQUEST['page']);
unset($_REQUEST['filter']);
unset($_REQUEST['host_template_id']);
unset($_REQUEST['host_status']);
unset($_REQUEST['rows']);
unset($_REQUEST['sort_column']);
unset($_REQUEST['sort_direction']);
}
if (!empty($_SESSION['sess_host_status']) && !empty($_REQUEST['host_status'])) {
if ($_SESSION['sess_host_status'] != $_REQUEST['host_status']) {
$_REQUEST['page'] = 1;
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value('page', 'sess_device_current_page', '1');
load_current_session_value('filter', 'sess_device_filter', '');
load_current_session_value('host_template_id', 'sess_device_host_template_id', '-1');
load_current_session_value('host_status', 'sess_host_status', '-1');
load_current_session_value('rows', 'sess_default_rows', read_config_option('num_rows_table'));
load_current_session_value('sort_column', 'sess_host_sort_column', 'description');
load_current_session_value('sort_direction', 'sess_host_sort_direction', 'ASC');
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$_REQUEST['rows'] = read_config_option('num_rows_table');
}
?>
<script type="text/javascript">
<!--
function applyFilter() {
strURL = 'host.php?host_status=' + $('#host_status').val();
strURL = strURL + '&host_template_id=' + $('#host_template_id').val();
strURL = strURL + '&rows=' + $('#rows').val();
strURL = strURL + '&filter=' + $('#filter').val();
strURL = strURL + '&page=' + $('#page').val();
strURL = strURL + '&header=false';
$.get(strURL, function(data) {
$('#main').html(data);
applySkin();
});
}
function clearFilter() {
strURL = 'host.php?clear_x=1&header=false';
$.get(strURL, function(data) {
$('#main').html(data);
applySkin();
});
}
$(function(data) {
$('#refresh').click(function() {
applyFilter();
});
$('#clear').click(function() {
clearFilter();
});
$('#form_devices').submit(function(event) {
event.preventDefault();
applyFilter();
});
});
-->
</script>
<?php
html_start_box('<strong>Devices</strong>', '100%', '', '3', 'center', 'host.php?action=edit&host_template_id=' . htmlspecialchars(get_request_var_request('host_template_id')) . '&host_status=' . htmlspecialchars(get_request_var_request('host_status')));
?>
<tr class='even noprint'>
<td>
<form id='form_devices' name="form_devices" action="host.php">
<table cellpadding="2" cellspacing="0">
<tr>
<td width='50'>
Search
</td>
<td>
<input id='filter' type="text" name="filter" size="25" value="<?php
print htmlspecialchars(get_request_var_request('filter'));
?>
" onChange='applyFilter()'>
</td>
<td>
Template
</td>
<td>
<select id='host_template_id' name="host_template_id" onChange="applyFilter()">
<option value="-1"<?php
if (get_request_var_request('host_template_id') == '-1') {
?>
selected<?php
}
?>
>Any</option>
<option value="0"<?php
if (get_request_var_request('host_template_id') == '0') {
?>
selected<?php
}
?>
>None</option>
<?php
$host_templates = db_fetch_assoc('SELECT id, name FROM host_template ORDER BY name');
if (sizeof($host_templates) > 0) {
foreach ($host_templates as $host_template) {
print "<option value='" . $host_template['id'] . "'";
if (get_request_var_request('host_template_id') == $host_template['id']) {
print ' selected';
}
print '>' . htmlspecialchars($host_template['name']) . "</option>\n";
}
}
?>
</select>
</td>
<td>
Status
</td>
<td>
<select id='host_status' name="host_status" onChange="applyFilter()">
<option value="-1"<?php
if (get_request_var_request('host_status') == '-1') {
?>
selected<?php
}
?>
>Any</option>
<option value="-3"<?php
if (get_request_var_request('host_status') == '-3') {
?>
selected<?php
}
?>
>Enabled</option>
<option value="-2"<?php
if (get_request_var_request('host_status') == '-2') {
?>
selected<?php
}
?>
>Disabled</option>
<option value="-4"<?php
if (get_request_var_request('host_status') == '-4') {
?>
selected<?php
}
?>
>Not Up</option>
<option value="3"<?php
if (get_request_var_request('host_status') == '3') {
?>
selected<?php
}
?>
>Up</option>
<option value="1"<?php
if (get_request_var_request('host_status') == '1') {
?>
selected<?php
}
?>
>Down</option>
<option value="2"<?php
if (get_request_var_request('host_status') == '2') {
?>
selected<?php
}
?>
>Recovering</option>
<option value="0"<?php
if (get_request_var_request('host_status') == '0') {
?>
selected<?php
}
?>
>Unknown</option>
</select>
</td>
<td>
Devices
</td>
<td>
<select id='rows' name="rows" onChange="applyFilter()">
<?php
if (sizeof($item_rows) > 0) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if (get_request_var_request('rows') == $key) {
print ' selected';
}
print '>' . htmlspecialchars($value) . "</option>\n";
}
}
?>
</select>
</td>
<td>
<input type="button" id='refresh' value="Go" title="Set/Refresh Filters">
</td>
<td>
<input type="button" id='clear' name="clear_x" value="Clear" title="Clear Filters">
</td>
</tr>
</table>
<input type='hidden' id='page' name='page' value='<?php
print $_REQUEST['page'];
?>
'>
</form>
</td>
</tr>
<?php
html_end_box();
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "where (host.hostname like '%%" . get_request_var_request('filter') . "%%' OR host.description like '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('host_status') == '-1') {
/* Show all items */
} elseif (get_request_var_request('host_status') == '-2') {
$sql_where .= strlen($sql_where) ? " AND host.disabled='on'" : " WHERE host.disabled='on'";
} elseif (get_request_var_request('host_status') == '-3') {
$sql_where .= strlen($sql_where) ? " AND host.disabled=''" : " WHERE host.disabled=''";
} elseif (get_request_var_request('host_status') == '-4') {
$sql_where .= strlen($sql_where) ? " AND (host.status!='3' OR host.disabled='on')" : " WHERE (host.status!='3' OR host.disabled='on')";
} else {
$sql_where .= strlen($sql_where) ? ' AND (host.status=' . get_request_var_request('host_status') . " AND host.disabled = '')" : 'where (host.status=' . get_request_var_request('host_status') . " AND host.disabled = '')";
}
if (get_request_var_request('host_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var_request('host_template_id') == '0') {
$sql_where .= strlen($sql_where) ? ' AND host.host_template_id=0' : ' WHERE host.host_template_id=0';
} elseif (!empty($_REQUEST['host_template_id'])) {
$sql_where .= strlen($sql_where) ? ' AND host.host_template_id=' . get_request_var_request('host_template_id') : ' WHERE host.host_template_id=' . get_request_var_request('host_template_id');
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='host.php'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\tCOUNT(host.id)\n\t\tFROM host\n\t\t{$sql_where}");
$sortby = get_request_var_request('sort_column');
if ($sortby == 'hostname') {
$sortby = 'INET_ATON(hostname)';
}
$sql_query = "SELECT host.*, graphs, data_sources\n\t\tFROM host\n\t\tLEFT JOIN (SELECT host_id, COUNT(*) AS graphs FROM graph_local GROUP BY host_id) AS gl\n\t\tON host.id=gl.host_id\n\t\tLEFT JOIN (SELECT host_id, COUNT(*) AS data_sources FROM data_local GROUP BY host_id) AS dl\n\t\tON host.id=dl.host_id\n\t\t{$sql_where}\n\t\tGROUP BY host.id\n\t\tORDER BY " . $sortby . ' ' . get_request_var_request('sort_direction') . '
LIMIT ' . get_request_var_request('rows') * (get_request_var_request('page') - 1) . ',' . get_request_var_request('rows');
$hosts = db_fetch_assoc($sql_query);
$nav = html_nav_bar('host.php?filter=' . get_request_var_request('filter') . '&host_template_id=' . get_request_var_request('host_template_id') . '&host_status=' . get_request_var_request('host_status'), MAX_DISPLAY_PAGES, get_request_var_request('page'), get_request_var_request('rows'), $total_rows, 13, 'Devices', 'page', 'main');
print $nav;
$display_text = array('description' => array('display' => 'Device Description', 'align' => 'left', 'sort' => 'ASC', 'tip' => 'The name by which this Device will be referred to.'), 'hostname' => array('display' => 'Hostname', 'align' => 'left', 'sort' => 'ASC', 'tip' => 'Either an IP address, or hostname. If a hostname, it must be resolvable by either DNS, or from your hosts file.'), 'id' => array('display' => 'ID', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The internal database ID for this Device. Useful when performing automation or debugging.'), 'graphs' => array('display' => 'Graphs', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The total number of Graphs generated from this Device.'), 'data_sources' => array('display' => 'Data Sources', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The total number of Data Sources generated from this Device.'), 'status' => array('display' => 'Status', 'align' => 'center', 'sort' => 'ASC', 'tip' => 'The monitoring status of the Device based upon ping results. If this Device is a special type Device, by using the hostname "localhost", or due to the setting to not perform an Availability Check, it will always remain Up. When using cmd.php data collector, a Device with no Graphs, is not pinged by the data collector and will remain in an "Unknown" state.'), 'status_rec_date' => array('display' => 'In State', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The amount of time that this Device has been in its current state.'), 'snmp_sysUpTimeInstance' => array('display' => 'Uptime', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The current amount of time that the host has been up.'), 'polling_time' => array('display' => 'Poll Time', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The the amount of time it takes to collect data from this Device.'), 'cur_time' => array('display' => 'Current (ms)', 'align' => 'right', 'sort' => 'DESC', 'tip' => 'The current ping time in milliseconds to reach the Device.'), 'avg_time' => array('display' => 'Average (ms)', 'align' => 'right', 'sort' => 'DESC', 'tip' => 'The average ping time in milliseconds to reach the Device since the counters were cleared for this Device.'), 'availability' => array('display' => 'Availability', 'align' => 'right', 'sort' => 'ASC', 'tip' => 'The availability percentage based upon ping results insce the counters were cleared for this Device.'));
html_header_sort_checkbox($display_text, get_request_var_request('sort_column'), get_request_var_request('sort_direction'), false);
$i = 0;
if (sizeof($hosts) > 0) {
foreach ($hosts as $host) {
if ($host['disabled'] == '' && ($host['status'] == HOST_RECOVERING || $host['status'] == HOST_UP) && ($host['availability_method'] != AVAIL_NONE && $host['availability_method'] != AVAIL_PING)) {
$snmp_uptime = $host['snmp_sysUpTimeInstance'];
$days = intval($snmp_uptime / (60 * 60 * 24 * 100));
$remainder = $snmp_uptime % (60 * 60 * 24 * 100);
$hours = intval($remainder / (60 * 60 * 100));
$remainder = $remainder % (60 * 60 * 100);
$minutes = intval($remainder / (60 * 100));
$uptime = "{$days} d {$hours} h {$minutes} m";
} else {
$uptime = "N/A";
}
form_alternate_row('line' . $host['id'], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars('host.php?action=edit&id=' . $host['id']) . "'>" . (strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter'), '/') . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['description'])) : htmlspecialchars($host['description'])) . '</a>', $host['id']);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter'), '/') . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['hostname'])) : htmlspecialchars($host['hostname']), $host['id']);
form_selectable_cell($host['id'], $host['id'], '', 'text-align:right');
form_selectable_cell(number_format($host['graphs']), $host['id'], '', 'text-align:right');
form_selectable_cell(number_format($host['data_sources']), $host['id'], '', 'text-align:right');
form_selectable_cell(get_colored_device_status($host['disabled'] == 'on' ? true : false, $host['status']), $host['id'], '', 'text-align:center');
form_selectable_cell(get_timeinstate($host), $host['id'], '', 'text-align:right');
form_selectable_cell($uptime, $host['id'], '', 'text-align:right');
form_selectable_cell(round($host['polling_time'], 2), $host['id'], '', 'text-align:right');
form_selectable_cell(round($host['cur_time'], 2), $host['id'], '', 'text-align:right');
form_selectable_cell(round($host['avg_time'], 2), $host['id'], '', 'text-align:right');
form_selectable_cell(round($host['availability'], 2) . ' %', $host['id'], '', 'text-align:right');
form_checkbox_cell($host['description'], $host['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print "<tr class='tableRow'><td colspan='11'><em>No Devices</em></td></tr>";
}
html_end_box(false);
/* add a list of tree names to the actions dropdown */
add_tree_names_to_actions_array();
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($device_actions);
print "</form>\n";
}
function user_group_graph_perms_edit($tab, $header_label)
{
global $config, $assoc_actions;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request('id'));
/* ==================================================== */
$policy_array = array(1 => 'Allow', 2 => 'Deny');
if (!empty($_REQUEST['id'])) {
$policy = db_fetch_row_prepared('SELECT policy_graphs, policy_trees, policy_hosts, policy_graph_templates FROM user_auth_group WHERE id = ?', array(get_request_var_request('id')));
}
switch ($tab) {
case 'permsg':
process_graph_request_vars();
graph_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_group_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Graph Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='odd'>
<td><table cellpadding="2" cellspacing="0"><tr>
<td style="white-space:nowrap;" width="120">Default Graph policy for this User Group</td>
<td width="10">
<?php
form_dropdown('policy_graphs', $policy_array, '', '', $policy['policy_graphs'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (gtg.title_cache LIKE '%%" . get_request_var_request('filter') . "%%' AND gtg.local_graph_id>0)";
} else {
$sql_where = 'WHERE (gtg.local_graph_id>0)';
}
if (get_request_var_request('graph_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var_request('graph_template_id') == '0') {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' gtg.graph_template_id=0';
} elseif (!empty($_REQUEST['graph_template_id'])) {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' gtg.graph_template_id=' . get_request_var_request('graph_template_id');
}
if (get_request_var_request('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' (user_auth_group_perms.type=1 AND user_auth_group_perms.group_id=' . get_request_var_request('id', 0) . ')';
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_group_admin.php?action=edit&tab=permsg&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("select\n\t\t\tCOUNT(gtg.id)\n\t\t\tFROM graph_templates_graph AS gtg\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (gtg.local_graph_id = user_auth_group_perms.item_id AND user_auth_group_perms.type = 1)\n\t\t\t{$sql_where}");
$sql_query = "SELECT gtg.local_graph_id, gtg.title_cache, user_auth_group_perms.group_id\n\t\t\tFROM graph_templates_graph AS gtg\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (gtg.local_graph_id=user_auth_group_perms.item_id AND user_auth_group_perms.type=1)\n\t\t\t{$sql_where} \n\t\t\tORDER BY title_cache\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$graphs = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_group_admin.php?action=edit&tab=permsg&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 7, 'Graphs', 'page', 'main');
print $nav;
$display_text = array('Graph Title', 'ID', 'Effective Policy');
html_header_checkbox($display_text, false);
if (sizeof($graphs)) {
foreach ($graphs as $g) {
form_alternate_row('line' . $g['local_graph_id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($g['title_cache'])) : htmlspecialchars($g['title_cache']), $g['local_graph_id'], 250);
form_selectable_cell($g['local_graph_id'], $g['local_graph_id']);
if (empty($g['group_id']) || $g['group_id'] == NULL) {
if ($policy['policy_graphs'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $g['local_graph_id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $g['local_graph_id']);
}
} else {
if ($policy['policy_graphs'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $g['local_graph_id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $g['local_graph_id']);
}
}
form_checkbox_cell($g['title_cache'], $g['local_graph_id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Graphs Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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');
}
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($assoc_actions);
print '</form>';
break;
case 'permsd':
process_device_request_vars();
device_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_group_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Device Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Graph policy for this User Group</td>
<td width="10">
<?php
form_dropdown('policy_hosts', $policy_array, '', '', $policy['policy_hosts'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (host.hostname LIKE '%%" . get_request_var_request('filter') . "%%' OR host.description LIKE '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('host_template_id') == '-1') {
/* Show all items */
} elseif (get_request_var_request('host_template_id') == '0') {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' host.host_template_id=0';
} elseif (!empty($_REQUEST['host_template_id'])) {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' host.host_template_id=' . get_request_var_request('host_template_id');
}
if (get_request_var_request('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' user_auth_group_perms.group_id=' . get_request_var_request('id', 0);
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_group_admin.php?action=edit&tab=permsd&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(host.id)\n\t\t\tFROM host\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (host.id = user_auth_group_perms.item_id AND user_auth_group_perms.type = 3)\n\t\t\t{$sql_where}");
$host_graphs = array_rekey(db_fetch_assoc('SELECT host_id, count(*) AS graphs FROM graph_local GROUP BY host_id'), 'host_id', 'graphs');
$host_data_sources = array_rekey(db_fetch_assoc('SELECT host_id, count(*) AS data_sources FROM data_local GROUP BY host_id'), 'host_id', 'data_sources');
$sql_query = "SELECT host.*, user_auth_group_perms.group_id\n\t\t\tFROM host \n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (host.id=user_auth_group_perms.item_id AND user_auth_group_perms.type=3)\n\t\t\t{$sql_where} \n\t\t\tORDER BY description\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$hosts = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_group_admin.php?action=edit&tab=permsd&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Devices', 'page', 'main');
print $nav;
$display_text = array('Description', 'ID', 'Effective Policy', 'Graphs', 'Data Sources', 'Status', 'Hostname');
html_header_checkbox($display_text, false);
if (sizeof($hosts)) {
foreach ($hosts as $host) {
form_alternate_row('line' . $host['id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['description'])) : htmlspecialchars($host['description']), $host['id'], 250);
form_selectable_cell(round($host['id'], 2), $host['id']);
if (empty($host['group_id']) || $host['group_id'] == NULL) {
if ($policy['policy_hosts'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $host['id']);
}
} else {
if ($policy['policy_hosts'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $host['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $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(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($host['hostname'])) : htmlspecialchars($host['hostname']), $host['id']);
form_checkbox_cell($host['description'], $host['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Devices Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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);
print "</form>\n";
break;
case 'permste':
process_template_request_vars();
template_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_group_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Graph Template Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Graph Template Template policy for this User Group</td>
<td width="10">
<?php
form_dropdown('policy_graph_templates', $policy_array, '', '', $policy['policy_graph_templates'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (gt.name LIKE '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' (user_auth_group_perms.type=4 AND user_auth_group_perms.group_id=' . get_request_var_request('id', 0) . ')';
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_group_admin.php?action=edit&tab=permste&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(gt.id)\n\t\t\tFROM graph_templates AS gt\n\t\t\tINNER JOIN graph_local AS gl\n\t\t\tON gt.id = gl.graph_template_id\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (gt.id = user_auth_group_perms.item_id AND user_auth_group_perms.type = 4)\n\t\t\t{$sql_where}\n\t\t\tGROUP BY gl.graph_template_id");
$sql_query = "SELECT gt.id, gt.name, count(*) AS totals, user_auth_group_perms.group_id\n\t\t\tFROM graph_templates AS gt\n\t\t\tINNER JOIN graph_local AS gl\n\t\t\tON gt.id = gl.graph_template_id\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (gt.id = user_auth_group_perms.item_id AND user_auth_group_perms.type = 4)\n\t\t\t{$sql_where} \n\t\t\tGROUP BY gl.graph_template_id\n\t\t\tORDER BY name\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$graphs = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_group_admin.php?action=edit&tab=permste&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Graph Templates', 'page', 'main');
print $nav;
$display_text = array('Template Name', 'ID', 'Effective Policy', 'Total Graphs');
html_header_checkbox($display_text, false);
if (sizeof($graphs)) {
foreach ($graphs as $g) {
form_alternate_row('line' . $g['id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($g['name'])) : htmlspecialchars($g['name']), $g['id'], 250);
form_selectable_cell($g['id'], $g['id']);
if (empty($g['group_id']) || $g['group_id'] == NULL) {
if ($policy['policy_graph_templates'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $g['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $g['id']);
}
} else {
if ($policy['policy_graph_templates'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $g['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $g['id']);
}
}
form_selectable_cell($g['totals'], $g['id']);
form_checkbox_cell($g['name'], $g['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Graph Templates Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('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);
print '</form>';
break;
case 'permstr':
process_tree_request_vars();
tree_filter($header_label);
/* print checkbox form for validation */
print "<form name='policy' method='post' action='user_group_admin.php'>\n";
/* box: device permissions */
html_start_box('<strong>Default Tree Policy</strong>', '100%', '', '3', 'center', '');
?>
<tr class='even'>
<td><table cellspacing="0" cellpadding="2"><tr>
<td style="white-space:nowrap;" width="120">Default Tree policy for this User Group</td>
<td width="10">
<?php
form_dropdown('policy_trees', $policy_array, '', '', $policy['policy_trees'], '', '');
?>
</td>
<td>
<input type="submit" name="update_policy" value="Update">
<input type="hidden" name="tab" value="<?php
print $tab;
?>
">
<input type="hidden" name="id" value="<?php
print get_request_var_request('id');
?>
">
</td>
</tr></table></td>
</tr>
<?php
html_end_box();
print "</form>\n";
/* if the number of rows is -1, set it to the default */
if ($_REQUEST['rows'] == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = $_REQUEST['rows'];
}
/* form the 'where' clause for our main sql query */
if (strlen(get_request_var_request('filter'))) {
$sql_where = "WHERE (gt.name LIKE '%%" . get_request_var_request('filter') . "%%')";
} else {
$sql_where = '';
}
if (get_request_var_request('associated') == 'false') {
/* Show all items */
} else {
$sql_where .= (strlen($sql_where) ? ' AND ' : 'WHERE ') . ' (user_auth_group_perms.type=2 AND user_auth_group_perms.group_id=' . get_request_var_request('id', 0) . ')';
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='" . htmlspecialchars('user_group_admin.php?action=edit&tab=permstr&id=' . get_request_var_request('id')) . "'>\n";
html_start_box('', '100%', '', '3', 'center', '');
$total_rows = db_fetch_cell("SELECT\n\t\t\tCOUNT(gt.id)\n\t\t\tFROM graph_tree AS gt\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (gt.id = user_auth_group_perms.item_id AND user_auth_group_perms.type = 2)\n\t\t\t{$sql_where}");
$sql_query = "SELECT gt.id, gt.name, user_auth_group_perms.group_id\n\t\t\tFROM graph_tree AS gt\n\t\t\tLEFT JOIN user_auth_group_perms \n\t\t\tON (gt.id = user_auth_group_perms.item_id AND user_auth_group_perms.type = 2)\n\t\t\t{$sql_where} \n\t\t\tORDER BY name\n\t\t\tLIMIT " . $rows * (get_request_var_request('page') - 1) . ',' . $rows;
$trees = db_fetch_assoc($sql_query);
$nav = html_nav_bar('user_group_admin.php?action=edit&tab=permstr&id=' . get_request_var_request('id'), MAX_DISPLAY_PAGES, get_request_var_request('page'), $rows, $total_rows, 11, 'Trees', 'page', 'main');
print $nav;
$display_text = array('Tree Name', 'ID', 'Effective Policy');
html_header_checkbox($display_text, false);
if (sizeof($trees)) {
foreach ($trees as $t) {
form_alternate_row('line' . $t['id'], true);
form_selectable_cell(strlen(get_request_var_request('filter')) ? preg_replace('/(' . preg_quote(get_request_var_request('filter')) . ')/i', "<span class='filteredValue'>\\1</span>", htmlspecialchars($t['name'])) : htmlspecialchars($t['name']), $t['id'], 250);
form_selectable_cell($t['id'], $t['id']);
if (empty($t['group_id']) || $t['group_id'] == NULL) {
if ($policy['policy_trees'] == 1) {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $t['id']);
} else {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $t['id']);
}
} else {
if ($policy['policy_trees'] == 1) {
form_selectable_cell('<span style="color:red;font-weight:bold;">Access Restricted</span>', $t['id']);
} else {
form_selectable_cell('<span style="color:green;font-weight:bold;">Access Granted</span>', $t['id']);
}
}
form_checkbox_cell($t['name'], $t['id']);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print '<tr><td><em>No Matching Trees Found</em></td></tr>';
}
html_end_box(false);
form_hidden_box('action', 'edit', '');
form_hidden_box('tab', $tab, '');
form_hidden_box('id', get_request_var_request('id'), '');
form_hidden_box('associate_tree', '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);
print '</form>';
break;
}
}
