function user() {
global $colors, $user_actions;
require(CACTI_BASE_PATH . "/include/auth/auth_arrays.php");
/* ================= input validation ================= */
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("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up sort_direction 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_user_admin_current_page");
kill_session_var("sess_user_admin_filter");
kill_session_var("sess_user_admin_sort_column");
kill_session_var("sess_user_admin_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_user_admin_current_page", "1");
load_current_session_value("filter", "sess_user_admin_filter", "");
load_current_session_value("sort_column", "sess_user_admin_sort_column", "username");
load_current_session_value("sort_direction", "sess_user_admin_sort_direction", "ASC");
html_start_box("<strong>" . __('User Management') . "</strong>", "100", $colors["header"], "3", "center", "user_admin.php?action=user_edit", true);
?>
<tr class='rowAlternate2'>
<td>
<form name="form_user_admin" action="user_admin.php">
<table cellpadding="0" cellspacing="0">
<tr>
<td class="nw50">
<?php print __("Search:");?>
</td>
<td class="w1">
<input type="text" name="filter" size="40" value="<?php print $_REQUEST["filter"];?>">
</td>
<td class="nw120">
<input type="submit" Value="<?php echo __('Go');?>" name="go" align="middle">
<input type="submit" Value="<?php echo __('Clear');?>" name="clear_x" align="middle">
</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 (user_auth.username LIKE '%" . get_request_var_request("filter") . "%' OR user_auth.full_name LIKE '%" . get_request_var_request("filter") . "%')";
}else{
$sql_where = "";
}
html_start_box("", "100", $colors["header"], "0", "center", "");
$total_rows = db_fetch_cell("SELECT
COUNT(user_auth.id)
FROM user_auth
$sql_where");
$user_list = db_fetch_assoc("SELECT
id,
user_auth.username,
full_name,
realm,
enabled,
policy_graphs,
time,
max(time) as dtime
FROM user_auth
LEFT JOIN user_log ON (user_auth.id = user_log.user_id)
$sql_where
GROUP BY id
ORDER BY " . get_request_var_request("sort_column") . " " . get_request_var_request("sort_direction") .
" LIMIT " . (read_config_option("num_rows_device") * (get_request_var_request("page") - 1)) . "," . read_config_option("num_rows_device"));
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, 7, "user_admin.php");
print $nav;
html_end_box(false);
$display_text = array(
"username" => array(__("User Name"), "ASC"),
"full_name" => array(__("Full Name"), "ASC"),
"enabled" => array(__("Enabled"), "ASC"),
"realm" => array(__("Realm"), "ASC"),
"policy_graphs" => array(__("Default Graph Policy"), "ASC"),
"dtime" => array(__("Last Login"), "DESC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($user_list) > 0) {
foreach ($user_list as $user) {
if (empty($user["dtime"]) || ($user["dtime"] == "12/31/1969")) {
$last_login = "******";
}else{
$last_login = strftime("%A, %B %d, %Y %H:%M:%S ", strtotime($user["dtime"]));;
}
if ($user["enabled"] == CHECKED) {
$enabled = __("Yes");
}else{
$enabled = __("No");
}
form_alternate_row_color('line' . $user["id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("user_admin.php?action=user_edit&id=" . $user["id"]) . "'>" .
(strlen(get_request_var_request("filter")) ? preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span class=\"filter\">\\1</span>", $user["username"]) : $user["username"]) . "</a>"
, $user["id"]);
form_selectable_cell((strlen(get_request_var_request("filter")) ? preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span class=\"filter\">\\1</span>", $user["full_name"]) : $user["full_name"]), $user["id"]);
form_selectable_cell($enabled, $user["id"]);
form_selectable_cell($auth_realms[$user["realm"]], $user["id"]);
form_selectable_cell($graph_policy_array[$user["policy_graphs"]], $user["id"]);
form_selectable_cell($last_login, $user["id"]);
form_checkbox_cell($user["username"], $user["id"]);
form_end_row();
}
form_end_table();
print $nav;
}else{
print "<tr><td><em>" . __("No Users") ."</em></td></tr>";
}
print "</table>\n"; # end table of html_header_sort_checkbox
draw_actions_dropdown($user_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
function utilities_view_poller_cache() {
global $colors, $poller_actions, $item_rows;
define("MAX_DISPLAY_PAGES", 21);
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("device_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("rows"));
input_validate_input_number(get_request_var_request("poller_action"));
/* ==================================================== */
/* clean up search filter */
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 sort direction */
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_poller_cache_current_page");
kill_session_var("sess_poller_cache_rows");
kill_session_var("sess_poller_cache_device_id");
kill_session_var("sess_poller_cache_poller_action");
kill_session_var("sess_poller_cache_filter");
unset($_REQUEST["page"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["device_id"]);
unset($_REQUEST["poller_action"]);
}
if ((!empty($_SESSION["sess_poller_cache_action"])) && (!empty($_REQUEST["poller_action"]))) {
if ($_SESSION["sess_poller_cache_poller_action"] != $_REQUEST["poller_action"]) {
$_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_poller_cache_current_page", "1");
load_current_session_value("rows", "sess_poller_cache_rows", "-1");
load_current_session_value("device_id", "sess_poller_cache_device_id", "-1");
load_current_session_value("poller_action", "sess_poller_cache_poller_action", "-1");
load_current_session_value("filter", "sess_poller_cache_filter", "");
load_current_session_value("sort_column", "sess_poller_cache_sort_column", "data_template_data.name_cache");
load_current_session_value("sort_direction", "sess_poller_cache_sort_direction", "ASC");
$_REQUEST['page_referrer'] = 'view_poller_cache';
load_current_session_value('page_referrer', 'page_referrer', 'view_poller_cache');
?>
<script type="text/javascript">
<!--
$().ready(function() {
$("#device").autocomplete("./lib/ajax/get_devices_brief.php", { max: 8, highlight: false, scroll: true, scrollHeight: 300 });
$("#device").result(function(event, data, formatted) {
if (data) {
$(this).parent().find("#device_id").val(data[1]);
applyPItemFilterChange(document.form_pollercache);
}else{
$(this).parent().find("#device_id").val(0);
}
});
});
function applyPItemFilterChange(objForm) {
if (objForm.device_id.value) {
strURL = '?device_id=' + objForm.device_id.value;
strURL = strURL + '&filter=' + objForm.filter.value;
}else{
strURL = '?filter=' + objForm.filter.value;
}
strURL = strURL + '&poller_action=' + objForm.poller_action.value;
strURL = strURL + '&rows=' + objForm.rows.value;
strURL = strURL + '&action=view_poller_cache';
strURL = strURL + '&page=1';
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>" . __("Poller Cache Items") . "</strong>", "100", $colors["header"], "3", "center", "", true);
?>
<tr class='rowAlternate2'>
<td>
<form name="form_pollercache" action="utilities.php">
<table cellpadding="0" cellspacing="0">
<tr>
<td class="nw50">
<?php print __("Host:");?>
</td>
<td class="w1">
<?php
if (isset($_REQUEST["device_id"])) {
$hostname = db_fetch_cell("SELECT description as name FROM device WHERE id=".$_REQUEST["device_id"]." ORDER BY description,hostname");
} else {
$hostname = "";
}
?>
<input class="ac_field" type="text" id="device" size="30" value="<?php print $hostname; ?>">
<input type="hidden" id="device_id">
</td>
<td class="nw50">
<?php print __("Action:");?>
</td>
<td class="w1">
<select name="poller_action" onChange="applyPItemFilterChange(document.form_pollercache)">
<option value="-1"<?php if (get_request_var_request('poller_action') == '-1') {?> selected<?php }?>><?php print __("Any");?></option>
<option value="0"<?php if (get_request_var_request('poller_action') == '0') {?> selected<?php }?>><?php print __("SNMP");?></option>
<option value="1"<?php if (get_request_var_request('poller_action') == '1') {?> selected<?php }?>><?php print __("Script");?></option>
<option value="2"<?php if (get_request_var_request('poller_action') == '2') {?> selected<?php }?>><?php print __("Script Server");?></option>
</select>
</td>
<td class="nw120">
<input type="submit" Value="<?php print __("Go");?>" name="go" align="middle">
<input type="submit" Value="<?php print __("Clear");?>" name="clear_x" align="middle">
</td>
</tr>
</table>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="nw50">
<?php print __("Search:");?>
</td>
<td class="w1">
<input type="text" name="filter" size="40" value="<?php print $_REQUEST["filter"];?>">
</td>
<td class="nw50">
<?php print __("Rows:");?>
</td>
<td class="w1">
<select name="rows" onChange="applyPItemFilterChange(document.form_pollercache)">
<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 ">" . $value . "</option>\n";
}
}
?>
</select>
</td>
</tr>
</table>
<div><input type='hidden' name='page' value='1'></div>
<div><input type='hidden' name='action' value='view_poller_cache'></div>
</form>
</td>
</tr>
<?php
html_end_box(false);
/* form the 'where' clause for our main sql query */
$sql_where = "WHERE poller_item.local_data_id=data_template_data.local_data_id";
if (get_request_var_request("poller_action") == "-1") {
/* Show all items */
}else {
$sql_where .= " AND poller_item.action='" . $_REQUEST["poller_action"] . "'";
}
if (get_request_var_request("device_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("device_id") == "0") {
$sql_where .= " AND poller_item.device_id=0";
}elseif (!empty($_REQUEST["device_id"])) {
$sql_where .= " AND poller_item.device_id=" . $_REQUEST["device_id"];
}
if (strlen(get_request_var_request("filter"))) {
$sql_where .= " AND (data_template_data.name_cache LIKE '%%" . $_REQUEST["filter"] . "%%'
OR device.description LIKE '%%" . get_request_var_request("filter") . "%%'
OR poller_item.arg1 LIKE '%%" . get_request_var_request("filter") . "%%'
OR poller_item.hostname LIKE '%%" . get_request_var_request("filter") . "%%'
OR poller_item.rrd_path LIKE '%%" . get_request_var_request("filter") . "%%')";
}
html_start_box("", "100", $colors["header"], "0", "center", "");
$total_rows = db_fetch_cell("SELECT
COUNT(*)
FROM data_template_data
RIGHT JOIN (poller_item
LEFT JOIN device
ON poller_item.device_id=device.id)
ON data_template_data.local_data_id=poller_item.local_data_id
$sql_where");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_data_source");
}else{
$rows = get_request_var_request("rows");
}
$poller_sql = "SELECT
poller_item.*,
data_template_data.name_cache,
device.description
FROM data_template_data
RIGHT JOIN (poller_item
LEFT JOIN device
ON poller_item.device_id=device.id)
ON data_template_data.local_data_id=poller_item.local_data_id
$sql_where
ORDER BY " . get_request_var_request("sort_column") . " " . get_request_var_request("sort_direction") . ", action ASC
LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows;
// print $poller_sql;
$poller_cache = db_fetch_assoc($poller_sql);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 7, "utilities.php?action=view_poller_cache");
print $nav;
html_end_box(false);
$display_text = array(
"data_template_data.name_cache" => array(__("Data Source Name"), "ASC"),
"" => array(__("Details"), "ASC"));
html_header_sort($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($poller_cache) > 0) {
foreach ($poller_cache as $item) {
form_alternate_row_color();
?>
<td width="375">
<a class="linkEditMain" href="<?php print htmlspecialchars("data_sources.php?action=ds_edit&id=" . $item["local_data_id"]);?>"><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $item["name_cache"]) : $item["name_cache"]);?></a>
</td>
<td>
<?php
if ($item["action"] == 0) {
if ($item["snmp_version"] != 3) {
$details =
__("SNMP Version:") . " " . $item["snmp_version"] . ", " .
__("Community:") . " " . $item["snmp_community"] . ", " .
__("OID:") . " " . (strlen(get_request_var_request("filter")) ? (preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span class=\"filter\">\\1</span>", $item["arg1"])) : $item["arg1"]);
}else{
$details =
__("SNMP Version:") . " " . $item["snmp_version"] . ", " .
__("User:"******" " . $item["snmp_username"] . ", " .
__("OID:") . " " . $item["arg1"];
}
}elseif ($item["action"] == 1) {
$details = __("Script:") . " " . (strlen(get_request_var_request("filter")) ? (preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span class=\"filter\">\\1</span>", $item["arg1"])) : $item["arg1"]);
}else{
$details = __("Script Server:") . " " . (strlen(get_request_var_request("filter")) ? (preg_replace("/(" . preg_quote(get_request_var_request("filter")) . ")/i", "<span class=\"filter\">\\1</span>", $item["arg1"])) : $item["arg1"]);
}
print $details;
?>
</td>
<?php
form_end_row();
form_alternate_row_color();
?>
<td>
</td>
<td>
RRD: <?php print $item["rrd_path"];?>
</td>
<?php
form_end_row();
}
form_end_table();
print $nav;
}else{
print "<tr><td><em>" . __("No Records Found") . "</em></td></tr>\n";
}
print "</table>\n";
}
function mactrack_site() {
global $colors, $site_actions, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("site_id"));
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["detail"])) {
$_REQUEST["detail"] = sanitize_search_string(get_request_var("detail"));
}
/* 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_mactrack_sites_current_page");
kill_session_var("sess_mactrack_sites_detail");
kill_session_var("sess_mactrack_sites_device_type_id");
kill_session_var("sess_mactrack_sites_site_id");
kill_session_var("sess_mactrack_sites_rows");
kill_session_var("sess_mactrack_sites_filter");
kill_session_var("sess_mactrack_sites_sort_column");
kill_session_var("sess_mactrack_sites_sort_direction");
$_REQUEST["page"] = 1;
unset($_REQUEST["filter"]);
unset($_REQUEST["device_type_id"]);
unset($_REQUEST["site_id"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["detail"]);
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("device_type_id", "sess_mactrack_sites_device_type_id");
$changed += mactrack_check_changed("site_id", "sess_mactrack_sites_site_id");
$changed += mactrack_check_changed("rows", "sess_mactrack_sites_rows");
$changed += mactrack_check_changed("filter", "sess_mactrack_sites_filter");
$changed += mactrack_check_changed("detail", "sess_mactrack_sites_detail");
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_sites_current_page", "1");
load_current_session_value("detail", "sess_mactrack_sites_detail", "false");
load_current_session_value("device_type_id", "sess_mactrack_sites_device_type_id", "-1");
load_current_session_value("site_id", "sess_mactrack_sites_site_id", "-1");
load_current_session_value("rows", "sess_mactrack_sites_rows", "-1");
load_current_session_value("filter", "sess_mactrack_sites_filter", "");
load_current_session_value("sort_column", "sess_mactrack_sites_sort_column", "site_name");
load_current_session_value("sort_direction", "sess_mactrack_sites_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"];
}
html_start_box("<strong>MacTrack Site Filters</strong>", "100%", $colors["header"], "3", "center", "mactrack_sites.php?action=edit");
mactrack_site_filter();
html_end_box();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$sites = mactrack_site_get_site_records($sql_where, $row_limit);
if ($_REQUEST["detail"] == "false") {
$total_rows = db_fetch_cell("SELECT
COUNT(mac_track_sites.site_id)
FROM mac_track_sites
$sql_where");
}else{
$total_rows = db_fetch_cell("SELECT count(*)
FROM (mac_track_device_types
RIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id))
RIGHT JOIN mac_track_sites ON (mac_track_devices.site_id = mac_track_sites.site_id)
$sql_where
GROUP BY mac_track_sites.site_name, mac_track_device_types.device_type_id");
}
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_sites.php"));
if ($_REQUEST["detail"] == "false") {
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 9, "mactrack_sites.php?filter=" . $_REQUEST["filter"]);
}else{
if ($total_rows > 0) {
$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='mactrack_sites.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($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_sites.php?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";
}
}
print $nav;
$display_text = array(
"site_name" => array("Site Name", "ASC"),
"total_devices" => array("Devices", "DESC"),
"total_ips" => array("Total IP's", "DESC"),
"total_user_ports" => array("User Ports", "DESC"),
"total_oper_ports" => array("User Ports Up", "DESC"),
"total_macs" => array("MACS Found", "DESC"),
"total_device_errors" => array("Device Errors", "DESC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i, 'line' . $site["site_id"]); $i++;
form_selectable_cell("<a class='linkEditMain' href='mactrack_sites.php?action=edit&site_id=" . $site["site_id"] . "'>". (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["site_name"]) : $site["site_name"]) . "</a>", $site["site_id"]);
form_selectable_cell(number_format($site["total_devices"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_ips"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_user_ports"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_oper_ports"]), $site["site_id"]);
form_selectable_cell(number_format($site["total_macs"]), $site["site_id"]);
form_selectable_cell($site["total_device_errors"], $site["site_id"]);
form_checkbox_cell($site["site_name"], $site["site_id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No MacTrack Sites</em></td></tr>";
}
html_end_box(false);
}else{
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 10, "mactrack_sites.php?filter=" . $_REQUEST["filter"]);
}else{
if ($total_rows > 0) {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='10'>
<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_sites.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($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_sites.php?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";
}
}
print $nav;
$display_text = array(
"site_name" => array("Site Name", "ASC"),
"vendor" => array("Vendor", "ASC"),
"description" => array("Device Type", "DESC"),
"total_devices" => array("Total Devices", "DESC"),
"sum_ips_total" => array("Total IP's", "DESC"),
"sum_ports_total" => array("Total User Ports", "DESC"),
"sum_ports_active" => array("Total Oper Ports", "DESC"),
"sum_ports_trunk" => array("Total Trunks", "DESC"),
"sum_macs_active" => array("MACS Found", "DESC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width=200>
<a class='linkEditMain' href='mactrack_sites.php?action=edit&site_id=<?php print $site["site_id"];?>'><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["site_name"]) : $site["site_name"]);?></a>
</td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["vendor"]) : $site["vendor"]);?></td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["description"]) : $site["description"]);?></td>
<td><?php print number_format($site["total_devices"]);?></td>
<td><?php print number_format($site["sum_ips_total"]);?></td>
<td><?php print number_format($site["sum_ports_total"]);?></td>
<td><?php print number_format($site["sum_ports_active"]);?></td>
<td><?php print number_format($site["sum_ports_trunk"]);?></td>
<td><?php print number_format($site["sum_macs_active"]);?></td>
</tr>
<?php
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No MacTrack Sites</em></td></tr>";
}
html_end_box(false);
}
/* draw the dropdown containing a list of available actions for this form */
if ($_REQUEST["detail"] == "false") {
mactrack_draw_actions_dropdown($site_actions);
}
}
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 poller() {
global $colors, $poller_actions, $item_rows;
/* ================= input validation ================= */
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 sort_direction 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_poller_current_page");
kill_session_var("sess_poller_rows");
kill_session_var("sess_poller_filter");
kill_session_var("sess_poller_sort_column");
kill_session_var("sess_poller_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
?>
<script type="text/javascript">
<!--
function applyFilterChange(objForm) {
strURL = '?rows=' + objForm.rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
-->
</script>
<?php
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_poller_current_page", "1");
load_current_session_value("rows", "sess_poller_rows", "-1");
load_current_session_value("filter", "sess_poller_filter", "");
load_current_session_value("sort_column", "sess_poller_sort_column", "description");
load_current_session_value("sort_direction", "sess_poller_sort_direction", "ASC");
display_output_messages();
html_start_box("<strong>" . __("Pollers") . "</strong>", "100", $colors["header"], "3", "center", "pollers.php?action=edit", true);
?>
<tr class='rowAlternate2'>
<td>
<form name="form_pollers" action="pollers.php">
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Search:");?>
</td>
<td class="w1">
<input type="text" name="filter" size="40" value="<?php print $_REQUEST["filter"];?>">
</td>
<td class="nw50">
<?php print __("Rows:");?>
</td>
<td class="w1">
<select name="rows" onChange="applyFilterChange(document.form_pollers)">
<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 ">" . $value . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw120">
<input type="submit" Value="<?php print __("Go");?>" name="go" align="middle">
<input type="submit" Value="<?php print __("Clear");?>" name="clear_x" align="middle">
</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 ($_REQUEST["filter"] != "") {
$sql_where = "WHERE (p.description LIKE '%%" . $_REQUEST["filter"] . "%%')";
}else{
$sql_where = "";
}
html_start_box("", "100", $colors["header"], "0", "center", "");
$total_rows = db_fetch_cell("SELECT
COUNT(*)
FROM poller
$sql_where");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_device");
}else{
$rows = get_request_var_request("rows");
}
$poller_list = db_fetch_assoc("SELECT p.*,
sum(CASE WHEN h.poller_id IS NOT NULL THEN 1 ELSE NULL END) AS total_devices
FROM poller AS p
LEFT JOIN device AS h ON h.poller_id=p.id
$sql_where
GROUP BY p.id
ORDER BY " . get_request_var_request('sort_column') . " " . get_request_var_request('sort_direction') .
" LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 7, "pollers.php");
print $nav;
html_end_box(false);
$display_text = array(
"description" => array(__("Description"), "ASC"),
"id" => array(__("ID"), "ASC"),
"total_devices" => array(__("Devices"), "DESC"),
"nosort2" => array(__("Poller Items"), "DESC"),
"hostname" => array(__("Hostname"), "ASC"),
"nosort1" => array(__("Status"), ""),
"last_update" => array(__("Last Updated"), "ASC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($poller_list) > 0) {
foreach ($poller_list as $poller) {
form_alternate_row_color('line' . $poller["id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("pollers.php?action=edit&id=" . $poller["id"]) . "'>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $poller["description"]) : $poller["description"]) . "</a>", $poller["id"]);
form_selectable_cell($poller["id"], $poller["id"]);
form_selectable_cell($poller["total_devices"], $poller["id"]);
form_selectable_cell(db_fetch_cell("SELECT count(*) FROM poller_item WHERE poller_id=" . $poller["id"]), $poller["id"]);
form_selectable_cell($poller["hostname"], $poller["id"]);
form_selectable_cell(get_colored_poller_status(($poller["disabled"] == CHECKED ? true : false), $poller["last_update"]), $poller["id"]);
form_selectable_cell($poller["last_update"], $poller["id"]);
form_checkbox_cell($poller["description"], $poller["id"]);
form_end_row();
}
form_end_table();
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No Pollers Defined") . "</em></td></tr>\n";
}
print "</table>\n"; # end table of html_header_sort_checkbox
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($poller_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
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_maca() {
global $colors, $maca_actions, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("mac_id"));
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"])) {
kill_session_var("sess_mactrack_maca_current_page");
kill_session_var("sess_mactrack_maca_filter");
kill_session_var("sess_mactrack_maca_rows");
kill_session_var("sess_mactrack_maca_sort_column");
kill_session_var("sess_mactrack_maca_sort_direction");
$_REQUEST["page"] = 1;
unset($_REQUEST["filter"]);
unset($_REQUEST["rows"]);
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_maca_filter");
$changed += mactrack_check_changed("detail", "sess_mactrack_maca_detail");
$changed += mactrack_check_changed("rows", "sess_mactrack_maca_rows");
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_maca_current_page", "1");
load_current_session_value("rows", "sess_mactrack_maca_rows", "-1");
load_current_session_value("filter", "sess_mactrack_maca_filter", "");
load_current_session_value("sort_column", "sess_mactrack_maca_sort_column", "mac_address");
load_current_session_value("sort_direction", "sess_mactrack_maca_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"];
}
html_start_box("<strong>MacTrack MacAuth Filters</strong>", "100%", $colors["header"], "3", "center", "mactrack_macauth.php?action=edit");
mactrack_maca_filter();
html_end_box();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$maca = mactrack_maca_get_maca_records($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT count(*)
FROM mac_track_macauth
$sql_where");
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_macauth.php"));
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 9, "mactrack_macauth.php?filter=" . $_REQUEST["filter"]);
}else{
$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='mactrack_macauth.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($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_macauth.php?page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
}
if ($total_rows) {
print $nav;
}
$display_text = array(
"mac_address" => array("Mac Address", "ASC"),
"" => array("Reason", "ASC"),
"added_date" => array("Added/Modified", "ASC"),
"date_last_seen" => array("By", "ASC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($maca) > 0) {
foreach ($maca as $mac) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width="20%">
<a class="linkEditMain" href="mactrack_macauth.php?action=edit&mac_id=<?php print $mac['mac_id'];?>"><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $mac["mac_address"]) : $mac["mac_address"]);?></a>
</td>
<td width="50%"><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $mac["description"]) : $mac["description"]);?></td>
<td width="20%"><?php print $mac["added_date"];?></td>
<td width="10%"><?php print db_fetch_cell("SELECT full_name FROM user_auth WHERE id='" . $mac["added_by"] . "'");?></td>
<td style="<?php print get_checkbox_style();?>" width="1%" align="right">
<input type='checkbox' style='margin: 0px;' name='chk_<?php print $mac["mac_id"];?>' title="<?php print $mac["name"];?>">
</td>
</tr>
<?php
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td colspan=10><em>No Authorized Mac Addresses</em></td></tr>";
}
html_end_box(false);
/* draw the dropdown containing a list of available actions for this form */
mactrack_draw_actions_dropdown($maca_actions);
}
function site() {
global $colors, $site_actions, $config;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("site_id"));
input_validate_input_number(get_request_var_request("device_template_id"));
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["detail"])) {
$_REQUEST["detail"] = sanitize_search_string(get_request_var("detail"));
}
/* 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_sites_current_page");
kill_session_var("sess_sites_detail");
kill_session_var("sess_sites_site_id");
kill_session_var("sess_sites_device_template_id");
kill_session_var("sess_sites_filter");
kill_session_var("sess_sites_rows");
kill_session_var("sess_sites_sort_column");
kill_session_var("sess_sites_sort_direction");
$_REQUEST["page"] = 1;
unset($_REQUEST["filter"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["site_id"]);
unset($_REQUEST["device_template_id"]);
unset($_REQUEST["detail"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}else{
/* if any of the settings changed, reset the page number */
$changed = 0;
$changed += check_changed("site_id", "sess_sites_site_id");
$changed += check_changed("device_template_id", "sess_sites_device_template_id");
$changed += check_changed("filter", "sess_sites_filter");
$changed += check_changed("rows", "sess_sites_rows");
$changed += check_changed("detail", "sess_sites_detail");
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_sites_current_page", "1");
load_current_session_value("rows", "sess_sites_rows", "-1");
load_current_session_value("detail", "sess_sites_detail", "false");
load_current_session_value("site_id", "sess_sites_site_id", "-1");
load_current_session_value("device_template_id", "sess_sites_device_template_id", "-1");
load_current_session_value("filter", "sess_sites_filter", "");
load_current_session_value("rows", "sess_sites_rows", read_config_option("num_rows_devices"));
load_current_session_value("sort_column", "sess_sites_sort_column", "name");
load_current_session_value("sort_direction", "sess_sites_sort_direction", "ASC");
site_filter();
html_start_box("", "100", $colors["header"], "0", "center", "");
$sql_where = "";
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_device");
}else{
$rows = get_request_var_request("rows");
}
$sites = site_get_site_records($sql_where, $rows);
if (get_request_var_request("detail") == "false") {
$total_rows = db_fetch_cell("SELECT
COUNT(sites.id)
FROM sites
$sql_where");
}else{
$total_rows = sizeof(db_fetch_assoc("SELECT
device_template.id, sites.name
FROM (device_template
RIGHT JOIN device ON (device_template.id=device.device_template_id))
RIGHT JOIN sites ON (device.site_id=sites.id)
$sql_where
GROUP BY sites.name, device_template.id"));
}
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, "sites.php"));
if (get_request_var_request("detail") == "false") {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, 6, "sites.php");
print $nav;
html_end_box(false);
$display_text = array(
"name" => array(__("Site Name"), "ASC"),
"address1" => array(__("Address"), "ASC"),
"city" => array(__("City"), "ASC"),
"state" => array(__("State"), "DESC"),
"country" => array(__("Country"), "DESC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color('line' . $site["id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("sites.php?action=edit&id=" . $site["id"]) . "'>" .
(strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $site["name"]) : $site["name"]) . "</a>", $site["id"], "20%");
form_selectable_cell($site["address1"], $site["id"]);
form_selectable_cell($site["city"], $site["id"]);
form_selectable_cell($site["state"], $site["id"]);
form_selectable_cell($site["country"], $site["id"]);
form_checkbox_cell($site["name"], $site["id"]);
form_end_row();
}
form_end_table();
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No Sites") . "</em></td></tr>";
}
print "</table>\n"; # end table of html_header_sort_checkbox
}else{
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, read_config_option("num_rows_device"), $total_rows, 10, "sites.php");
print $nav;
html_end_box(false);
$display_text = array(
"name" => array(__("Site Name"), "ASC"),
"device_template_name" => array(__("Device Type"), "ASC"),
"total_devices" => array(__("Devices"), "DESC"),
"address1" => array(__("Address"), "ASC"),
"city" => array(__("City"), "ASC"),
"state" => array(__("State"), "DESC"),
"country" => array(__("Country"), "DESC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($site["id"], true); $i++;
form_selectable_cell("<a class='linkEditMain' href='sites.php?action=edit&id=" . $site["id"] . "'>" .
(strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $site["name"]) : $site["name"]) . "</a>", $site["id"], "20%");
form_selectable_cell(preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $site["device_template_name"]), $site["id"]);
form_selectable_cell($site["total_devices"], $site["id"]);
form_selectable_cell($site["address1"], $site["id"]);
form_selectable_cell($site["city"], $site["id"]);
form_selectable_cell($site["state"], $site["id"]);
form_selectable_cell($site["country"], $site["id"]);
form_checkbox_cell($site["name"], $site["id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No Sites") . "</em></td></tr>";
}
print "</table>\n"; # end table of html_header_sort_checkbox
}
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($site_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
function graphs_new() {
global $colors;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("device_id"));
input_validate_input_number(get_request_var_request("graph_type"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
if (!substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
kill_session_var("sess_graphs_new_device_id");
}
kill_session_var("sess_graphs_new_graph_type");
kill_session_var("sess_graphs_new_filter");
if (!substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
unset($_REQUEST["device_id"]);
}
unset($_REQUEST["graph_type"]);
unset($_REQUEST["filter"]);
$changed = true;
}else{
/* if any of the settings changed, reset the page number */
$changed = 0;
$changed += check_changed("device_id", "sess_graphs_new_device_id");
$changed += check_changed("graph_type", "sess_graphs_new_graph_type");
$changed += check_changed("filter", "sess_graphs_new_filter");
}
load_current_session_value("device_id", "sess_graphs_new_device_id", db_fetch_cell("select id from device order by description,hostname limit 1"));
load_current_session_value("graph_type", "sess_graphs_new_graph_type", read_config_option("default_graphs_new_dropdown"));
load_current_session_value("filter", "sess_graphs_new_filter", "");
if (substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
$file = "devices.php?action=edit&tab=newgraphs&id=" . $_REQUEST["device_id"];
$file2 = "devices.php";
}else{
$file = "graphs_new.php?device_id=". $_REQUEST["device_id"];
$file2 = "graphs_new.php";
}
$device = db_fetch_row("select id,description,hostname,device_template_id from device where id=" . $_REQUEST["device_id"]);
$row_limit = read_config_option("num_rows_data_query");
$debug_log = debug_log_return("new_graphs");
?>
<script type="text/javascript">
<!--
function applyGraphsNewFilterChange(objForm) {
strURL = '?action=edit&tab=newgraphs';
strURL = strURL + '&graph_type=' + objForm.graph_type.value;
strURL = strURL + '&device_id=' + objForm.device_id.value;
strURL = strURL + '&filter=' + objForm.filter.value;;
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>" . $device["description"] . "(" . $device["hostname"] . ")</strong> " . db_fetch_cell("select name from device_template where id=" . $device["device_template_id"]), "100", $colors["header"], "3", "center", "");
?>
<tr class='rowAlternate2'>
<td>
<form name="form_graphs_new" method="post" action="<?php print $file2;?>">
<table cellpadding="0" align="left">
<tr>
<?php if (!isset($_REQUEST["tab"])) { ?>
<td class="nw50 textGraphFilter">
Host:
</td>
<td width="1">
<select name="device_id" onChange="applyGraphsNewFilterChange(document.form_graphs_new)">
<?php
$devices = db_fetch_assoc("select id,CONCAT_WS('',description,' (',hostname,')') as name from device order by description,hostname");
if (sizeof($devices) > 0) {
foreach ($devices as $item) {
print "<option value='" . $item["id"] . "'"; if (get_request_var_request("device_id") == $item["id"]) { print " selected"; } print ">" . $item["name"] . "</option>\n";
}
}
?>
</select>
</td>
<?php } ?>
<td class="nw50 textGraphFilter">
<?php print __("Type:");?>
</td>
<td width="1">
<select name="graph_type" onChange="applyGraphsNewFilterChange(document.form_graphs_new)">
<option value="-2"<?php if (get_request_var_request("graph_type") == "-2") {?> selected<?php }?>><?php print __("All");?></option>
<option value="-1"<?php if (get_request_var_request("graph_type") == "-1") {?> selected<?php }?>><?php print __("Graph Template Based");?></option>
<?php
$snmp_queries = db_fetch_assoc("SELECT
snmp_query.id,
snmp_query.name,
snmp_query.xml_path
FROM (snmp_query,device_snmp_query)
WHERE device_snmp_query.snmp_query_id=snmp_query.id
AND device_snmp_query.device_id=" . $device["id"] . "
ORDER BY snmp_query.name");
if (sizeof($snmp_queries) > 0) {
foreach ($snmp_queries as $query) {
print "<option value='" . $query["id"] . "'"; if (get_request_var_request("graph_type") == $query["id"]) { print " selected"; } print ">" . $query["name"] . "</option>\n";
}
}
?>
</select>
</td>
<td style="white-space:nowrap;width:1%;" class="textInfo" align="center" valign="top">
<?php if (!isset($_REQUEST["tab"])) { ?><span class="tabedit">*</span><a href="devices.php?action=edit&id=<?php print $_REQUEST["device_id"];?>"><?php print __("Edit this Host");?></a><br><?php } ?>
<?php api_plugin_hook('graphs_new_top_links'); ?>
</td>
</tr>
</table>
<?php if (get_request_var_request("graph_type") > 0) {?>
<table cellpadding="0" align="left">
<tr>
<td class="nw50 textGraphFilter">
Search:
</td>
<td class="nw200">
<input type="text" name="filter" size="30" width="200" value="<?php print $_REQUEST["filter"];?>">
</td>
<td align="left" class="nw120">
<input type="submit" name="go" value="<?php print __("Go");?>" align="middle">
<input type="submit" name="clear_x" value="<?php print __("Clear");?>" align="middle">
<input type="hidden" name="action" value="edit">
<input type="hidden" name="tab" value="newgraphs">
</td>
</tr>
</table>
<?php }else{
form_hidden_box("filter", get_request_var_request("filter"), "");
}?>
</form>
</td>
</tr>
<?php
html_end_box(false);
$total_rows = sizeof(db_fetch_assoc("select graph_template_id from device_graph where device_id=" . $_REQUEST["device_id"]));
$i = 0;
if (get_request_var_request("graph_type") > 0) {
load_current_session_value("page" . get_request_var_request("graph_type"), "sess_graphs_new_page" . get_request_var_request("graph_type"), "1");
}else if (get_request_var_request("graph_type") == -2) {
foreach($snmp_queries as $query) {
load_current_session_value("page" . $query["id"], "sess_graphs_new_page" . $query["id"], "1");
}
}
print "<form name='chk' method='post' action='" . $file2 . "'>";
if (get_request_var_request("graph_type") < 0) {
$graph_templates = db_fetch_assoc("SELECT
graph_templates.id AS graph_template_id,
graph_templates.name AS graph_template_name
FROM (device_graph,graph_templates)
WHERE device_graph.graph_template_id=graph_templates.id
AND device_graph.device_id=" . $_REQUEST["device_id"] . "
ORDER BY graph_templates.name");
$template_graphs = db_fetch_assoc("SELECT
graph_local.graph_template_id
FROM (graph_local,device_graph)
WHERE graph_local.graph_template_id=device_graph.graph_template_id
AND graph_local.device_id=device_graph.device_id
AND graph_local.device_id=" . $device["id"] . "
GROUP BY graph_local.graph_template_id");
if (sizeof($template_graphs) > 0) {
print "<script type='text/javascript'>\n<!--\n";
print "var gt_created_graphs = new Array(";
$cg_ctr = 0;
foreach ($template_graphs as $template_graph) {
print (($cg_ctr > 0) ? "," : "") . "'" . $template_graph["graph_template_id"] . "'";
$cg_ctr++;
}
print ")\n";
print "//-->\n</script>\n";
} else {
print "<script type='text/javascript'>\nvar gt_created_graphs = new Array()\n</script>\n";
}
print "<script type='text/javascript'>gt_update_deps(1);</script>\n";
print "<script type='text/javascript'>\nvar created_graphs = new Array()\n</script>\n";
html_start_box("<strong>" . __("Graph Templates") . "</strong>", "100", $colors["header"], "3", "center", "");
print " <tr class='rowSubHeader'>
<td class='textSubHeaderDark'>" . __("Graph Template Name") . "</td>
<td class='rowSubHeader' width='1%' align='center' style='" . get_checkbox_style() . "'><input type='checkbox' style='margin: 0px;' name='all_cg' title='" . __("Select All") . "' onClick='SelectAll(\"cg\",this.checked);gt_update_selection_indicators();'></td>\n
</tr>\n";
/* create a row for each graph template associated with the device template */
if (sizeof($graph_templates) > 0) {
foreach ($graph_templates as $graph_template) {
$query_row = $graph_template["graph_template_id"];
print "<tr id='gt_line$query_row' bgcolor='#" . (($i % 2 == 0) ? "ffffff" : $colors["light"]) . "'>"; $i++;
print " <td onClick='gt_select_line(" . $graph_template["graph_template_id"] . ");'><span id='gt_text$query_row" . "_0'>
<strong>" . __("Create:") . "</strong> " . $graph_template["graph_template_name"] . "</span>
</td>
<td align='right'>
<input type='checkbox' name='cg_$query_row' id='cg_$query_row' onClick='gt_update_selection_indicators();'>
</td>
</tr>";
}
}
$available_graph_templates = db_fetch_assoc("SELECT
graph_templates.id, graph_templates.name
FROM snmp_query_graph RIGHT JOIN graph_templates
ON (snmp_query_graph.graph_template_id = graph_templates.id)
WHERE (((snmp_query_graph.name) Is Null)) ORDER BY graph_templates.name");
/* create a row at the bottom that lets the user create any graph they choose */
print " <tr bgcolor='#" . (($i % 2 == 0) ? "ffffff" : $colors["light"]) . "'>
<td colspan='2' width='60' nowrap>
<strong>" . __("Create:") . "</strong> ";
form_dropdown("cg_g", $available_graph_templates, "name", "id", "", "(Select a graph type to create)", "", "textArea");
print " </td>
</tr>";
html_end_box();
}
if ($_REQUEST["graph_type"] != -1) {
$snmp_queries = db_fetch_assoc("SELECT
snmp_query.id,
snmp_query.name,
snmp_query.xml_path
FROM (snmp_query,device_snmp_query)
WHERE device_snmp_query.snmp_query_id=snmp_query.id
AND device_snmp_query.device_id=" . $device["id"] .
($_REQUEST["graph_type"] != -2 ? " AND snmp_query.id=" . $_REQUEST["graph_type"] : '') . "
ORDER BY snmp_query.name");
if (sizeof($snmp_queries) > 0) {
foreach ($snmp_queries as $snmp_query) {
unset($total_rows);
if (isset($_REQUEST["page" . $snmp_query["id"]])) {
$page = $_REQUEST["page" . $snmp_query["id"]];
}elseif (!$changed) {
$page = $_REQUEST["page" . $snmp_query["id"]];
}else{
$page = 1;
}
$xml_array = get_data_query_array($snmp_query["id"]);
$num_input_fields = 0;
$num_visible_fields = 0;
if ($xml_array != false) {
/* loop through once so we can find out how many input fields there are */
reset($xml_array["fields"]);
while (list($field_name, $field_array) = each($xml_array["fields"])) {
if ($field_array["direction"] == "input") {
$num_input_fields++;
if (!isset($total_rows)) {
$total_rows = db_fetch_cell("SELECT count(*) FROM device_snmp_cache WHERE device_id=" . $device["id"] . " and snmp_query_id=" . $snmp_query["id"] . " AND field_name='$field_name'");
}
}
}
}
if (!isset($total_rows)) {
$total_rows = 0;
}
$snmp_query_graphs = db_fetch_assoc("SELECT snmp_query_graph.id,snmp_query_graph.name FROM snmp_query_graph WHERE snmp_query_graph.snmp_query_id=" . $snmp_query["id"] . " ORDER BY snmp_query_graph.name");
if (sizeof($snmp_query_graphs) > 0) {
print "<script type='text/javascript'>\n<!--\n";
foreach ($snmp_query_graphs as $snmp_query_graph) {
$created_graphs = db_fetch_assoc("SELECT DISTINCT
data_local.snmp_index
FROM (data_local,data_template_data)
LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id)
LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id)
WHERE data_local.id=data_template_data.local_data_id
AND data_input_fields.type_code='output_type'
AND data_input_data.value='" . $snmp_query_graph["id"] . "'
AND data_local.device_id=" . $device["id"]);
print "created_graphs[" . $snmp_query_graph["id"] . "] = new Array(";
$cg_ctr = 0;
if (sizeof($created_graphs) > 0) {
foreach ($created_graphs as $created_graph) {
print (($cg_ctr > 0) ? "," : "") . "'" . encode_data_query_index($created_graph["snmp_index"]) . "'";
$cg_ctr++;
}
}
print ")\n";
}
print "//-->\n</script>\n";
}
html_start_box_dq($snmp_query["name"], $snmp_query["id"], $device["id"], $num_input_fields+1, "100", $colors["header"], "0", "center");
if ($xml_array != false) {
$html_dq_header = "";
$snmp_query_indexes = array();
reset($xml_array["fields"]);
/* if there is a where clause, get the matching snmp_indexes */
$sql_where = "";
if (strlen(get_request_var_request("filter"))) {
$sql_where = "";
$indexes = db_fetch_assoc("SELECT DISTINCT snmp_index
FROM device_snmp_cache
WHERE field_value LIKE '%%" . get_request_var_request("filter") . "%%'
AND snmp_query_id=" . $snmp_query["id"] . "
AND device_id=" . $device["id"]);
if (sizeof($indexes)) {
foreach($indexes as $index) {
if (strlen($sql_where)) {
$sql_where .= ", '" . $index["snmp_index"] . "'";
}else{
$sql_where .= " AND snmp_index IN('" . $index["snmp_index"] . "'";
}
}
$sql_where .= ")";
}
}
if ((strlen(get_request_var_request("filter")) == 0) ||
((strlen(get_request_var_request("filter"))) && (sizeof($indexes)))) {
/* determine the sort order */
if (isset($xml_array["index_order_type"])) {
if ($xml_array["index_order_type"] == "numeric") {
$sql_order = "ORDER BY CAST(snmp_index AS unsigned)";
}else if ($xml_array["index_order_type"] == "alphabetic") {
$sql_order = "ORDER BY snmp_index";
}else if ($xml_array["index_order_type"] == "natural") {
$sql_order = "ORDER BY INET_ATON(snmp_index)";
}else{
$sql_order = "";
}
}else{
$sql_order = "";
}
/* get the unique field values from the database */
$field_names = db_fetch_assoc("SELECT DISTINCT field_name
FROM device_snmp_cache
WHERE device_id=" . $device["id"] . "
AND snmp_query_id=" . $snmp_query["id"]);
/* build magic query */
$sql_query = "SELECT device_id, snmp_query_id, snmp_index";
$num_visible_fields = sizeof($field_names);
$i = 0;
if (sizeof($field_names) > 0) {
foreach($field_names as $column) {
$field_name = $column["field_name"];
$sql_query .= ", MAX(CASE WHEN field_name='$field_name' THEN field_value ELSE NULL END) AS '$field_name'";
$i++;
}
}
$sql_query .= " FROM device_snmp_cache
WHERE device_id=" . $device["id"] . "
AND snmp_query_id=" . $snmp_query["id"] . "
$sql_where
GROUP BY device_id, snmp_query_id, snmp_index
$sql_order
LIMIT " . ($row_limit*($page-1)) . "," . $row_limit;
$rows_query = "SELECT device_id, snmp_query_id, snmp_index FROM device_snmp_cache
WHERE device_id=" . $device["id"] . "
AND snmp_query_id=" . $snmp_query["id"] . "
$sql_where
GROUP BY device_id, snmp_query_id, snmp_index";
$snmp_query_indexes = db_fetch_assoc($sql_query);
$total_rows = sizeof(db_fetch_assoc($rows_query));
if (($page-1) * $row_limit > $total_rows) {
$page = 1;
$_REQUEST["page" . $query["id"]] = $page;
load_current_session_value("page" . $query["id"], "sess_graphs_new_page" . $query["id"], "1");
}
if (substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
$file = "devices.php?action=edit&tab=newgraphs&id=" . $_REQUEST["device_id"];
$file2 = "devices.php";
}else{
$file = "graphs_new.php?device_id=". $_REQUEST["device_id"];
$file2 = "graphs_new.php";
}
if ($total_rows > $row_limit) {
/* generate page list navigation */
$nav = html_create_nav($page, MAX_DISPLAY_PAGES, $row_limit, $total_rows, 40, $file, "page" . $snmp_query["id"]);
print $nav;
}
while (list($field_name, $field_array) = each($xml_array["fields"])) {
if ($field_array["direction"] == "input") {
foreach($field_names as $row) {
if ($row["field_name"] == $field_name) {
# $html_dq_header .= "<td height='1' style='padding:0px 5px 0px 5px;' onMousemove='doColResize(this,event)' onMouseover='doColResize(this,event)' onMouseup='doneColResize()'><strong><font color='#" . $colors["header_text"] . "'>" . $field_array["name"] . "</font></strong></td>\n";
$html_dq_header .= "<th style='padding:0px 5px 0px 5px;' onMousemove='doColResize(this,event)' onMouseover='doColResize(this,event)' onMouseup='doneColResize()' class='textSubHeaderDark'><strong><font color='#" . $colors["header_text"] . "'>" . $field_array["name"] . "</font></strong></th>\n";
break;
}
}
}
}
if (!sizeof($snmp_query_indexes)) {
print "<tr class='rowAlternate1'><td>" . __("This data query returned 0 rows, perhaps there was a problem executing this data query. You can %s run this data query in debug mode %s to get more information.", "<a href='" . htmlspecialchars("devices.php?action=query_verbose&id=" . $snmp_query["id"] . "&device_id=" . $device["id"]) . "'>", "</a>") . "</td></tr>\n";
}else{
print "<tr class='rowSubHeader'>
$html_dq_header
<td class='rowSubHeader' width='1%' align='center' style='" . get_checkbox_style() . "'><input type='checkbox' style='margin: 0px;' name='all_" . $snmp_query["id"] . "' title='" . __("Select All") ."' onClick='SelectAll(\"sg_" . $snmp_query["id"] . "\",this.checked);dq_update_selection_indicators();'></td>\n
</tr>\n";
}
$row_counter = 0;
$column_counter = 0;
$fields = array_rekey($field_names, "field_name", "field_name");
if (sizeof($snmp_query_indexes) > 0) {
foreach($snmp_query_indexes as $row) {
$query_row = $snmp_query["id"] . "_" . encode_data_query_index($row["snmp_index"]);
form_alternate_row_color("line" . $query_row, true);
$column_counter = 0;
reset($xml_array["fields"]);
while (list($field_name, $field_array) = each($xml_array["fields"])) {
if ($field_array["direction"] == "input") {
if (in_array($field_name, $fields)) {
if (isset($row[$field_name])) {
print "<td style='line-height: 1.5em;padding:0px 5px 0px 5px;' onClick='dq_select_line(" . $snmp_query["id"] . ",\"" . encode_data_query_index($row["snmp_index"]) . "\");'><span id='text$query_row" . "_" . $column_counter . "'>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $row[$field_name]) : $row[$field_name]) . "</span></td>";
}else{
print "<td style='line-height: 1.5em;padding:0px 5px 0px 5px;' onClick='dq_select_line(" . $snmp_query["id"] . ",\"" . encode_data_query_index($row["snmp_index"]) . "\");'><span id='text$query_row" . "_" . $column_counter . "'></span></td>";
}
$column_counter++;
}
}
}
print "<td style='padding-right: 4px;' align='right'>";
print "<input type='checkbox' name='sg_$query_row' id='sg_$query_row' onClick='dq_update_selection_indicators();'>";
print "</td>";
print "</tr>\n";
$row_counter++;
}
}
if ($total_rows > $row_limit) {
print $nav;
}
}else{
print "<tr class='rowAlternate1'><td colspan='2' style='color: red; font-size: 12px; font-weight: bold;'>" . __("Search Returned no Rows.") . "</td></tr>\n";
}
}else{
print "<tr class='rowAlternate1'><td colspan='2' style='color: red; font-size: 12px; font-weight: bold;'>" . __("Error in data query.") . "</td></tr>\n";
}
/* draw the graph template drop down here */
$data_query_graphs = db_fetch_assoc("select snmp_query_graph.id,snmp_query_graph.name from snmp_query_graph where snmp_query_graph.snmp_query_id=" . $snmp_query["id"] . " order by snmp_query_graph.name");
if (sizeof($data_query_graphs) == 1) {
html_end_box();
form_hidden_box("sgg_" . $snmp_query["id"], $data_query_graphs[0]["id"], "");
}elseif (sizeof($data_query_graphs) > 1) {
html_end_box(FALSE);
print "<table align='center' width='100%'>
<tr>
<td width='1' valign='top'>
<img src='images/arrow.gif' alt='' align='middle'>
</td>
<td align='right'>
<span class=\"italic\">" . __("Select a graph type:") . "</span>
<select name='sgg_" . $snmp_query["id"] . "' id='sgg_" . $snmp_query["id"] . "' onChange='dq_update_deps(" . $snmp_query["id"] . "," . $column_counter . ");'>
"; html_create_list($data_query_graphs,"name","id","0"); print "
</select>
</td>
</tr>
</table>";
}
print "<script type='text/javascript'>dq_update_deps(" . $snmp_query["id"] . "," . ($num_visible_fields) . ");</script>\n";
}
}
}
form_hidden_box("save_component_graph", "1", "");
form_hidden_box("device_id", $device["id"], "0");
form_hidden_box("device_template_id", $device["device_template_id"], "0");
form_save_button_alt("url!" . (isset($_SERVER["HTTP_REFERER"]) ? $_SERVER["HTTP_REFERER"] : ""));
if (!empty($debug_log)) {
debug_log_clear("new_graphs");
?>
<table class='topBoxAlt'>
<tr>
<td class='mono'>
<?php print $debug_log;?>
</td>
</tr>
</table>
<br>
<?php
}
print "<script type='text/javascript'>dq_update_selection_indicators();</script>\n";
print "<script type='text/javascript'>gt_update_selection_indicators();</script>\n";
}
function mactrack_device_type() {
global $colors, $device_types_actions, $mactrack_device_types, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("type_id"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up the vendor string */
if (isset($_REQUEST["vendor"])) {
$_REQUEST["vendor"] = sanitize_search_string(get_request_var("vendor"));
}
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_mactrack_device_type_current_page");
kill_session_var("sess_mactrack_device_type_filter");
kill_session_var("sess_mactrack_device_type_rows");
kill_session_var("sess_mactrack_device_type_vendor");
kill_session_var("sess_mactrack_device_type_type_id");
kill_session_var("sess_mactrack_device_type_sort_column");
kill_session_var("sess_mactrack_device_type_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["vendor"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["type_id"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_mactrack_device_type_current_page", "1");
load_current_session_value("vendor", "sess_mactrack_device_type_vendor", "All");
load_current_session_value("filter", "sess_mactrack_device_type_filter", "");
load_current_session_value("type_id", "sess_mactrack_device_type_type_id", "-1");
load_current_session_value("rows", "sess_mactrack_device_type_rows", "-1");
load_current_session_value("sort_column", "sess_mactrack_device_type_sort_column", "description");
load_current_session_value("sort_direction", "sess_mactrack_device_type_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"];
}
html_start_box("<strong>MacTrack Device Type Filters</strong>", "100%", $colors["header"], "3", "center", "mactrack_device_types.php?action=edit");
mactrack_device_type_filter();
html_end_box();
$sql_where = "";
$device_types = mactrack_get_device_types($sql_where, $row_limit);
html_start_box("", "100%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("SELECT
COUNT(mac_track_device_types.device_type_id)
FROM mac_track_device_types" . $sql_where);
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_device_types.php?");
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 9, "mactrack_device_types.php?filter=" . $_REQUEST["filter"]);
}else{
$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='mactrack_device_types.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($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_device_types.php?page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
}
if ($total_rows) {
print $nav;
}
$display_text = array(
"description" => array("Device Type Description", "ASC"),
"vendor" => array("Devices", "DESC"),
"device_type" => array("Device Type", "DESC"),
"scanning_function" => array("Port Scanner", "ASC"),
"ip_scanning_function" => array("IP Scanner", "ASC"),
"sysDescr_match" => array("sysDescription Match", "DESC"),
"sysObjectID_match" => array("Vendor OID Match", "DESC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($device_types) > 0) {
foreach ($device_types as $device_type) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i, 'line' . $device_type["device_type_id"]); $i++;
form_selectable_cell('<a class="linkEditMain" href="mactrack_device_types.php?action=edit&device_type_id=' . $device_type["device_type_id"] . '">' . $device_type["description"] . '</a>', $device_type["device_type_id"]);
form_selectable_cell($device_type["vendor"], $device_type["device_type_id"]);
form_selectable_cell($mactrack_device_types[$device_type["device_type"]], $device_type["device_type_id"]);
form_selectable_cell($device_type["scanning_function"], $device_type["device_type_id"]);
form_selectable_cell($device_type["ip_scanning_function"], $device_type["device_type_id"]);
form_selectable_cell($device_type["sysDescr_match"], $device_type["device_type_id"]);
form_selectable_cell($device_type["sysObjectID_match"], $device_type["device_type_id"]);
form_checkbox_cell($device_type["description"], $device_type["device_type_id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td colspan='10'><em>No MacTrack Device Types</em></td></tr>";
}
html_end_box(false);
/* draw the dropdown containing a list of available actions for this form */
mactrack_draw_actions_dropdown($device_types_actions);
}
function mactrack_device() {
global $colors, $device_actions, $mactrack_device_types, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("site_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("page"));
input_validate_input_number(get_request_var_request("rows"));
input_validate_input_number(get_request_var_request("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_mactrack_device_current_page");
kill_session_var("sess_mactrack_device_filter");
kill_session_var("sess_mactrack_device_site_id");
kill_session_var("sess_mactrack_device_type_id");
kill_session_var("sess_mactrack_device_rows");
kill_session_var("sess_mactrack_device_device_type_id");
kill_session_var("sess_mactrack_device_status");
kill_session_var("sess_mactrack_device_sort_column");
kill_session_var("sess_mactrack_device_sort_direction");
unset($_REQUEST["page"]);
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"]);
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_mactrack_device_current_page", "1");
load_current_session_value("filter", "sess_mactrack_device_filter", "");
load_current_session_value("site_id", "sess_mactrack_device_site_id", "-1");
load_current_session_value("type_id", "sess_mactrack_device_type_id", "-1");
load_current_session_value("rows", "sess_mactrack_device_rows", "-1");
load_current_session_value("device_type_id", "sess_mactrack_device_device_type_id", "-1");
load_current_session_value("status", "sess_mactrack_device_status", "-1");
load_current_session_value("sort_column", "sess_mactrack_device_sort_column", "site_name");
load_current_session_value("sort_direction", "sess_mactrack_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"];
}
html_start_box("<strong>MacTrack Device Filters</strong>", "100%", $colors["header"], "3", "center", "mactrack_devices.php?action=edit&status=" . $_REQUEST["status"]);
mactrack_device_filter();
html_end_box();
if (isset($_GET["scan"])){
$device_name = db_fetch_cell("SELECT device_name FROM mac_track_devices WHERE device_id=".$_GET['device_id']);
print $_GET["scan"]==1 ? "<span style='font-size: 12px; font-family: monospace; color:#088A08;'><strong>Port Scanning:</strong> Complete. Rescan have been done on device $device_name.</span><br><br>\n" : "<span style='font-size: 12px; font-family: monospace; color:#ff0000'><strong>Port Scanning:</strong> Fail. Device $device_name couldn't be rescanned.</span><br><br>\n";
}
$sql_where = "";
$devices = mactrack_get_devices($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT
COUNT(*)
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_devices.device_type_id=mac_track_device_types.device_type_id
$sql_where");
html_start_box("", "100%", $colors["header"], "3", "center", "");
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_devices.php?filter=" . $_REQUEST["filter"]);
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 13, "mactrack_devices.php?filter=" . $_REQUEST["filter"]);
}else{
$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_devices.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($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_devices.php?page=" . ($_REQUEST["page"]+1) . "'>"; } $nav .= "Next"; if (($_REQUEST["page"] * $row_limit) < $total_rows) { $nav .= "</a>"; } $nav .= " >></strong>
</td>\n
</tr>
</table>
</td>
</tr>\n";
}
if ($total_rows) {
print $nav;
}
$display_text = array(
"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"),
"last_runduration" => array("Last Duration", "DESC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($devices)) {
foreach ($devices as $device) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i, 'line' . $device["device_id"]); $i++;
mactrack_format_device_row($device);
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td colspan='10'><em>No MacTrack Devices</em></td></tr>";
}
html_end_box(false);
/* draw the dropdown containing a list of available actions for this form */
mactrack_draw_actions_dropdown($device_actions);
}
function hmib_host_type()
{
global $colors, $host_types_actions, $hmib_host_types, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up the vendor string */
if (isset($_REQUEST["version"])) {
$_REQUEST["version"] = sanitize_search_string(get_request_var("version"));
}
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"])) {
kill_session_var("sess_hmib_host_type_current_page");
kill_session_var("sess_hmib_host_type_filter");
kill_session_var("sess_hmib_host_type_rows");
kill_session_var("sess_hmib_host_type_version");
kill_session_var("sess_hmib_host_type_sort_column");
kill_session_var("sess_hmib_host_type_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["version"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_hmib_host_type_current_page", "1");
load_current_session_value("version", "sess_hmib_host_type_version", "All");
load_current_session_value("filter", "sess_hmib_host_type_filter", "");
load_current_session_value("rows", "sess_hmib_host_type_rows", "-1");
load_current_session_value("sort_column", "sess_hmib_host_type_sort_column", "name");
load_current_session_value("sort_direction", "sess_hmib_host_type_sort_direction", "ASC");
if ($_REQUEST["rows"] == -1) {
$row_limit = read_config_option("hmib_os_type_rows");
} elseif ($_REQUEST["rows"] == -2) {
$row_limit = 999999;
} else {
$row_limit = $_REQUEST["rows"];
}
html_start_box("<strong>Host MIB OS Type Filters</strong>", "100%", $colors["header"], "3", "center", "hmib_types.php?action=edit");
hmib_host_type_filter();
html_end_box();
$sql_where = "";
$host_types = hmib_get_host_types($sql_where, $row_limit);
html_start_box("", "100%", $colors["header"], "3", "center", "");
$total_rows = db_fetch_cell("SELECT\n\t\tCOUNT(*)\n\t\tFROM plugin_hmib_hrSystemTypes" . $sql_where);
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "hmib_types.php?");
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 9, "hmib_types.php?filter=" . $_REQUEST["filter"]);
} else {
if ($total_rows > 0) {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t\t\t<td colspan='9'>\n\t\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\t<strong><< ";
if ($_REQUEST["page"] > 1) {
$nav .= "<a class='linkOverDark' href='hmib_types.php?page=" . ($_REQUEST["page"] - 1) . "'>";
}
$nav .= "Previous";
if ($_REQUEST["page"] > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\n\t\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\tShowing Rows " . ($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}]\n\t\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\t<strong>";
if ($_REQUEST["page"] * $row_limit < $total_rows) {
$nav .= "<a class='linkOverDark' href='hmib_types.php?page=" . ($_REQUEST["page"] + 1) . "'>";
}
$nav .= "Next";
if ($_REQUEST["page"] * $row_limit < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\n\t\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n";
} else {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\n\t\t\t\t\t<td colspan='9'>\n\t\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\n\t\t\t\t\t\t\t\t\tNo Rows Found\n\t\t\t\t\t\t\t\t</td>\n\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>\n";
}
}
print $nav;
$display_text = array("name" => array("Host Type Name", "ASC"), "version" => array("OS Version", "DESC"), "totals" => array("Hosts", "DESC"), "sysObjectID" => array("SNMP ObjectID", "DESC"), "sysDescrMatch" => array("SNMP Sys Description Match", "ASC"));
html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($host_types) > 0) {
foreach ($host_types as $host_type) {
form_alternate_row_color($colors["alternate"], $colors["light"], $i, 'line' . $host_type["id"]);
$i++;
form_selectable_cell('<a class="linkEditMain" href="hmib_types.php?action=edit&id=' . $host_type["id"] . '">' . $host_type["name"] . '</a>', $host_type["id"]);
form_selectable_cell($host_type["version"], $host_type["id"]);
form_selectable_cell($host_type["totals"], $host_type["id"]);
form_selectable_cell($host_type["sysObjectID"], $host_type["id"]);
form_selectable_cell($host_type["sysDescrMatch"], $host_type["id"]);
form_checkbox_cell($host_type["name"], $host_type["id"]);
form_end_row();
}
/* put the nav bar on the bottom as well */
print $nav;
} else {
print "<tr><td colspan='10'><em>No Host Types Found</em></td></tr>";
}
html_end_box(false);
/* draw the dropdown containing a list of available actions for this form */
hmib_draw_actions_dropdown($host_types_actions);
}
function graph() {
global $colors, $item_rows;
require_once(CACTI_BASE_PATH . "/lib/graph/graph_info.php");
require_once(CACTI_BASE_PATH . "/include/auth/auth_constants.php");
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("device_id"));
input_validate_input_number(get_request_var_request("rows"));
input_validate_input_number(get_request_var_request("template_id"));
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("filter"));
}
/* clean up sort_column string */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up sort_direction 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_graph_current_page");
kill_session_var("sess_graph_filter");
kill_session_var("sess_graph_sort_column");
kill_session_var("sess_graph_sort_direction");
if (!substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
kill_session_var("sess_graph_device_id");
}
kill_session_var("sess_graph_rows");
kill_session_var("sess_graph_template_id");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
if (!substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
unset($_REQUEST["device_id"]);
}
unset($_REQUEST["rows"]);
unset($_REQUEST["template_id"]);
}
/* let's see if someone changed an important setting */
$changed = FALSE;
$changed += check_changed("filter", "sess_ds_filter");
$changed += check_changed("rows", "sess_ds_rows");
$changed += check_changed("device_id", "sess_ds_device_id");
$changed += check_changed("template_id", "sess_ds_template_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_graph_current_page", "1");
load_current_session_value("filter", "sess_graph_filter", "");
load_current_session_value("sort_column", "sess_graph_sort_column", "title_cache");
load_current_session_value("sort_direction", "sess_graph_sort_direction", "ASC");
load_current_session_value("device_id", "sess_graph_device_id", "-1");
load_current_session_value("rows", "sess_graph_rows", "-1");
load_current_session_value("template_id", "sess_graph_template_id", "-1");
?>
<script type="text/javascript">
<!--
$().ready(function() {
$("#device").autocomplete("./lib/ajax/get_devices_brief.php", { max: 8, highlight: false, scroll: true, scrollHeight: 300 });
$("#device").result(function(event, data, formatted) {
if (data) {
$(this).parent().find("#device_id").val(data[1]);
applyGraphsFilterChange(document.form_graph_id);
}else{
$(this).parent().find("#device_id").val(0);
}
});
});
function clearGraphsFilterChange(objForm) {
strURL = '?filter=';
<?php
# called from outside
if (isset($_REQUEST["tab"])) {
# print the tab
print "strURL = strURL + &tab=" . $_REQUEST["tab"] . "';";
# now look for more parameters
if (isset($_REQUEST["device_id"])) {
print "strURL = strURL + '&device_id=" . $_REQUEST["device_id"] . "&id=" . $_REQUEST["device_id"] . "';";
}
if (isset($_REQUEST["template_id"])) {
print "strURL = strURL + '&template_id=" . $_REQUEST["template_id"] . "&id=" . $_REQUEST["template_id"] . "';";
}
}else {
# clear all parms
print "strURL = strURL + '&device_id=-1';";
print "strURL = strURL + '&template_id=-1';";
}
?>
strURL = strURL + '&rows=-1';
document.location = strURL;
}
function applyGraphsFilterChange(objForm) {
strURL = '?filter=' + objForm.filter.value;
// take care of parms provided via autocomplete
// those are passed as objForm.<parm>.value
// instead of $_REQUEST["<parm>"] when called from outside
if (objForm.device_id.value) {
strURL = '?device_id=' + objForm.device_id.value;
}else{
<?php print (isset($_REQUEST["device_id"]) ? "strURL = strURL + '&device_id=" . $_REQUEST["device_id"] . "&id=" . $_REQUEST["device_id"] . "';" : "strURL = strURL + '&device_id=-1';");?>
}
if (objForm.template_id.value) {
strURL = '?template_id=' + objForm.template_id.value;
}else{
<?php print (isset($_REQUEST["template_id"]) ? "strURL = strURL + '&template_id=" . $_REQUEST["template_id"] . "&id=" . $_REQUEST["template_id"] . "';" : "strURL = strURL + '&template_id=-1';");?>
}
strURL = strURL + '&rows=' + objForm.rows.value;
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>" . __("Graph Management") . "</strong>", "100", $colors["header"], "3", "center", "graphs.php?action=graph_edit&device_id=" . $_REQUEST["device_id"], true);
?>
<tr class='rowAlternate2'>
<td>
<form name="form_graph_id" action="graphs.php">
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Host:");?>
</td>
<td width="1">
<?php
if (isset($_REQUEST["device_id"])) {
$hostname = db_fetch_cell("SELECT description as name FROM device WHERE id=".$_REQUEST["device_id"]." ORDER BY description,hostname");
} else {
$hostname = "";
}
?>
<input class="ac_field" type="text" id="device" size="30" value="<?php print $hostname; ?>">
<input type="hidden" id="device_id">
</td>
<td width="70">
<?php print __("Template:");?>
</td>
<td width="1">
<select name="template_id" onChange="applyGraphsFilterChange(document.form_graph_id)">
<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
if (read_config_option("auth_method") != 0) {
$templates = db_fetch_assoc("SELECT DISTINCT graph_templates.id, graph_templates.name
FROM (graph_templates_graph,graph_local)
LEFT JOIN device ON (device.id=graph_local.device_id)
LEFT JOIN graph_templates ON (graph_templates.id=graph_local.graph_template_id)
LEFT JOIN user_auth_perms ON ((graph_templates_graph.local_graph_id=user_auth_perms.item_id and user_auth_perms.type=" . PERM_GRAPHS . " and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . ") OR (device.id=user_auth_perms.item_id and user_auth_perms.type=" . PERM_DEVICES . " and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . ") OR (graph_templates.id=user_auth_perms.item_id and user_auth_perms.type=" . PERM_GRAPH_TEMPLATES . " and user_auth_perms.user_id=" . $_SESSION["sess_user_id"] . "))
WHERE graph_templates_graph.local_graph_id=graph_local.id
AND graph_templates.id IS NOT NULL
" . (empty($sql_where) ? "" : "AND $sql_where") . "
ORDER BY name");
}else{
$templates = db_fetch_assoc("SELECT DISTINCT graph_templates.id, graph_templates.name
FROM graph_templates
ORDER BY name");
}
if (sizeof($templates) > 0) {
foreach ($templates as $template) {
print "<option value='" . $template["id"] . "'"; if (get_request_var_request("template_id") == $template["id"]) { print " selected"; } print ">" . title_trim($template["name"], 40) . "</option>\n";
}
}
?>
</select>
</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="clearGraphsFilterChange(document.form_graph_id)">
</td>
</tr>
</table>
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Search:");?>
</td>
<td>
<input type="text" name="filter" size="40" value="<?php print $_REQUEST["filter"];?>">
</td>
<td class="nw50">
<?php print __("Rows:");?>
</td>
<td width="1">
<select name="rows" onChange="applyGraphsFilterChange(document.form_graph_id)">
<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>
<input type='hidden' name='page' value='1'>
</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 = "AND (graph_templates_graph.title_cache like '%%" . $_REQUEST["filter"] . "%%'" .
" OR graph_templates.name like '%%" . get_request_var_request("filter") . "%%')";
}else{
$sql_where = "";
}
if (get_request_var_request("device_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("device_id") == "0") {
$sql_where .= " AND graph_local.device_id=0";
}elseif (!empty($_REQUEST["device_id"])) {
$sql_where .= " AND graph_local.device_id=" . $_REQUEST["device_id"];
}
if (get_request_var_request("template_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("template_id") == "0") {
$sql_where .= " AND graph_templates_graph.graph_template_id=0";
}elseif (!empty($_REQUEST["template_id"])) {
$sql_where .= " AND graph_templates_graph.graph_template_id=" . $_REQUEST["template_id"];
}
html_start_box("", "100", $colors["header"], "0", "center", "");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_graph");
}else{
$rows = get_request_var_request("rows");
}
$total_rows = db_fetch_cell("SELECT
COUNT(graph_templates_graph.id)
FROM (graph_local,graph_templates_graph)
LEFT JOIN graph_templates ON (graph_local.graph_template_id=graph_templates.id)
WHERE graph_local.id=graph_templates_graph.local_graph_id
$sql_where");
$graph_list = db_fetch_assoc("SELECT
graph_templates_graph.id,
graph_templates_graph.local_graph_id,
graph_templates_graph.height,
graph_templates_graph.width,
graph_templates_graph.title_cache,
graph_templates.name,
graph_local.device_id
FROM (graph_local,graph_templates_graph)
LEFT JOIN graph_templates ON (graph_local.graph_template_id=graph_templates.id)
WHERE graph_local.id=graph_templates_graph.local_graph_id
$sql_where
ORDER BY " . get_request_var_request('sort_column') . " " . get_request_var_request('sort_direction') .
" LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 7, "graphs.php");
print $nav;
html_end_box(false);
$display_text = array(
"title_cache" => array(__("Graph Title"), "ASC"),
"local_graph_id" => array(__("ID"), "ASC"),
"name" => array(__("Template Name"), "ASC"),
"height" => array(__("Size"), "ASC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($graph_list) > 0) {
foreach ($graph_list as $graph) {
$template_name = ((empty($graph["name"])) ? "<em>" . __("None") . "</em>" : $graph["name"]);
form_alternate_row_color('line' . $graph["local_graph_id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("graphs.php?action=graph_edit&id=" . $graph["local_graph_id"] . "' title='" . $graph["title_cache"]) . "'>" . (($_REQUEST["filter"] != "") ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", title_trim($graph["title_cache"], read_config_option("max_title_graph"))) : title_trim($graph["title_cache"], read_config_option("max_title_graph"))) . "</a>", $graph["local_graph_id"]);
form_selectable_cell($graph["local_graph_id"], $graph["local_graph_id"]);
form_selectable_cell((($_REQUEST["filter"] != "") ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $template_name) : $template_name), $graph["local_graph_id"]);
form_selectable_cell($graph["height"] . "x" . $graph["width"], $graph["local_graph_id"]);
form_checkbox_cell($graph["title_cache"], $graph["local_graph_id"]);
form_end_row();
}
form_end_table();
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No Graphs Found") . "</em></td></tr>";
}
print "</table>\n"; # end table of html_header_sort_checkbox
/* add a list of tree names to the actions dropdown */
$graph_actions = array_merge(graph_actions_list(), api_tree_add_tree_names_to_actions_array());
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($graph_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
function mactrack_vmacs() {
global $colors, $site_actions, $config, $item_rows;
/* ================= input validation ================= */
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"])) {
kill_session_var("sess_mactrack_vmacs_current_page");
kill_session_var("sess_mactrack_vmacs_filter");
kill_session_var("sess_mactrack_vmacs_rows");
kill_session_var("sess_mactrack_vmacs_sort_column");
kill_session_var("sess_mactrack_vmacs_sort_direction");
$_REQUEST["page"] = 1;
unset($_REQUEST["filter"]);
unset($_REQUEST["rows"]);
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_vmacs_filter");
$changed += mactrack_check_changed("rows", "sess_mactrack_vmacs_rows");
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_vmacs_current_page", "1");
load_current_session_value("filter", "sess_mactrack_vmacs_filter", "");
load_current_session_value("rows", "sess_mactrack_vmacs_rows", "-1");
load_current_session_value("sort_column", "sess_mactrack_vmacs_sort_column", "vendor_mac");
load_current_session_value("sort_direction", "sess_mactrack_vmacs_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"];
}
html_start_box("<strong>MacTrack Vendor Mac Filter</strong>", "100%", $colors["header"], "3", "center", "");
mactrack_vmac_filter();
html_end_box();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$vmacs = mactrack_vmacs_get_vmac_records($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT
COUNT(*)
FROM mac_track_oui_database
$sql_where");
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_vendormacs.php"));
if (defined("CACTI_VERSION")) {
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, 11, "mactrack_vendormacs.php?filter=" . $_REQUEST["filter"]);
}else{
if ($total_rows > 0) {
$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='mactrack_vendormacs.php?page=" . ($_REQUEST["page"]-1) . "'>"; } $nav .= "Previous"; if ($_REQUEST["page"] > 1) { $nav .= "</a>"; } $nav .= "</strong>
</td>\n
<td align='center' class='textHeaderDark'>
Showing Rows " . (($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_vendormacs.php?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";
}
}
if ($total_rows) {
print $nav;
}
$display_text = array(
"vendor_mac" => array("Vendor MAC", "ASC"),
"vendor_name" => array("Name", "ASC"),
"vendor_address" => array("Address", "ASC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($vmacs) > 0) {
foreach ($vmacs as $vmac) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td class="linkEditMain"><?php print $vmac["vendor_mac"];?></td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $vmac["vendor_name"]) : $vmac["vendor_name"]);?></td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $vmac["vendor_address"]) : $vmac["vendor_address"]);?></td>
</tr>
<?php
}
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>No MacTrack Vendor MACS</em></td></tr>";
}
html_end_box(false);
}
function xaxis() {
global $colors, $xaxis_actions, $item_rows;
/* ================= input validation ================= */
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"])) {
kill_session_var("sess_xaxis_current_page");
kill_session_var("sess_xaxis_filter");
kill_session_var("sess_xaxis_rows");
kill_session_var("sess_xaxis_sort_column");
kill_session_var("sess_xaxis_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
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_xaxis_filter");
$changed += check_changed("rows", "sess_xaxis_rows");
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_xaxis_current_page", "1");
load_current_session_value("filter", "sess_xaxis_filter", "");
load_current_session_value("rows", "sess_xaxis_rows", "-1");
load_current_session_value("sort_column", "sess_xaxis_sort_column", "name");
load_current_session_value("sort_direction", "sess_xaxis_sort_direction", "ASC");
?>
<script type="text/javascript">
<!--
function applyFilterChange(objForm) {
strURL = '?rows=' + objForm.rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>" . __("X-Axis Presets") . "</strong>", "100", $colors["header"], "3", "center", "xaxis_presets.php?action=edit", true);
?>
<tr class='rowAlternate2'>
<td>
<form action="xaxis_presets.php" name="form_xaxis" method="post">
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50"> <?php print __("Search:");?> </td>
<td class="w1"><input type="text" name="filter" size="40"
value="<?php print $_REQUEST["filter"];?>"></td>
<td class="nw50"> <?php print __("Rows:");?> </td>
<td class="w1"><select name="rows"
onChange="applyFilterChange(document.form_xaxis)">
<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 ">" . $value . "</option>\n";
}
}
?>
</select></td>
<td class="nw120"> <input type="submit"
Value="<?php print __("Go");?>" name="go" align="middle"> <input
type="submit" Value="<?php print __("Clear");?>" name="clear_x"
align="middle"></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 (name like '%%" . $_REQUEST["filter"] . "%%')";
}else{
$sql_where = "";
}
html_start_box("", "100", $colors["header"], "0", "center", "");
$total_rows = db_fetch_cell("select
COUNT(id)
from graph_templates_xaxis
$sql_where");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_device");
}else{
$rows = get_request_var_request("rows");
}
$sql_query = "SELECT * " .
"FROM graph_templates_xaxis " .
$sql_where .
" ORDER BY " . get_request_var_request("sort_column") . " " . get_request_var_request("sort_direction") .
" LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows;
//print $sql_query;
$xaxis_array = db_fetch_assoc($sql_query);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 2, "xaxis_presets.php");
print $nav;
html_end_box(false);
$display_text = array(
"name" => array(__("Name"), "ASC"),
);
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($xaxis_array) > 0) {
foreach ($xaxis_array as $xaxis) {
form_alternate_row_color('line' . $xaxis["id"], true);
form_selectable_cell("<a style='white-space:nowrap;' class='linkEditMain' href='" . htmlspecialchars("xaxis_presets.php?action=edit&id=" . $xaxis["id"]) . "'>" .
(strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $xaxis["name"]) : $xaxis["name"]) . "</a>", $xaxis["id"]);
form_checkbox_cell($xaxis["name"], $xaxis["id"]);
form_end_row();
}
form_end_table();
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No X-Axis Presets") . "</em></td></tr>";
}
print "</table>\n";
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($xaxis_actions);
print "</form>\n";
}
function data_source() {
global $colors, $item_rows;
require(CACTI_BASE_PATH . "/include/data_source/data_source_arrays.php");
/* validate request variables */
data_source_validate();
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"])) {
kill_session_var("sess_ds_current_page");
kill_session_var("sess_ds_filter");
kill_session_var("sess_ds_sort_column");
kill_session_var("sess_ds_sort_direction");
kill_session_var("sess_ds_rows");
if (!substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
kill_session_var("sess_ds_device_id");
}
kill_session_var("sess_ds_template_id");
kill_session_var("sess_ds_method_id");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
unset($_REQUEST["rows"]);
if (!substr_count($_SERVER["REQUEST_URI"], "/devices.php")) {
unset($_REQUEST["device_id"]);
}
unset($_REQUEST["template_id"]);
unset($_REQUEST["method_id"]);
$_REQUEST["page"] = 1;
}else{
/* let's see if someone changed an important setting */
$changed = FALSE;
$changed += check_changed("filter", "sess_ds_filter");
$changed += check_changed("rows", "sess_ds_rows");
$changed += check_changed("device_id", "sess_ds_device_id");
$changed += check_changed("template_id", "sess_ds_template_id");
$changed += check_changed("method_id", "sess_ds_method_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_ds_current_page", "1");
load_current_session_value("filter", "sess_ds_filter", "");
load_current_session_value("sort_column", "sess_ds_sort_column", "name_cache");
load_current_session_value("sort_direction", "sess_ds_sort_direction", "ASC");
load_current_session_value("rows", "sess_ds_rows", "-1");
load_current_session_value("device_id", "sess_ds_device_id", "-1");
load_current_session_value("template_id", "sess_ds_template_id", "-1");
load_current_session_value("method_id", "sess_ds_method_id", "-1");
$device = db_fetch_row("select hostname from device where id=" . $_REQUEST["device_id"]);
?>
<script type="text/javascript">
<!--
$().ready(function() {
$("#device").autocomplete("./lib/ajax/get_devices_brief.php", { max: 8, highlight: false, scroll: true, scrollHeight: 300 });
$("#device").result(function(event, data, formatted) {
if (data) {
$(this).parent().find("#device_id").val(data[1]);
applyDSFilterChange(document.form_data_sources);
}else{
$(this).parent().find("#device_id").val(0);
}
});
});
function clearDSFilterChange(objForm) {
strURL = '?filter=';
<?php
# called from outside
if (isset($_REQUEST["tab"])) {
# print the tab
print "strURL = strURL + &tab=" . $_REQUEST["tab"] . "';";
# now look for more parameters
if (isset($_REQUEST["device_id"])) {
print "strURL = strURL + '&device_id=" . $_REQUEST["device_id"] . "&id=" . $_REQUEST["device_id"] . "';";
}
if (isset($_REQUEST["template_id"])) {
print "strURL = strURL + '&template_id=" . $_REQUEST["template_id"] . "&id=" . $_REQUEST["template_id"] . "';";
}
}else {
# clear all parms
print "strURL = strURL + '&device_id=-1';";
print "strURL = strURL + '&template_id=-1';";
}
?>
strURL = strURL + '&rows=-1';
strURL = strURL + '&method_id=-1';
document.location = strURL;
}
function applyDSFilterChange(objForm) {
strURL = '?filter=' + objForm.filter.value;
// take care of parms provided via autocomplete
// those are passed as objForm.<parm>.value
// instead of $_REQUEST["<parm>"] when called from outside
if (objForm.device_id.value) {
strURL = '?device_id=' + objForm.device_id.value;
}else{
<?php print (isset($_REQUEST["device_id"]) ? "strURL = strURL + '&device_id=" . $_REQUEST["device_id"] . "&id=" . $_REQUEST["device_id"] . "';" : "strURL = strURL + '&device_id=-1';");?>
}
if (objForm.template_id.value) {
strURL = '?template_id=' + objForm.template_id.value;
}else{
<?php print (isset($_REQUEST["template_id"]) ? "strURL = strURL + '&template_id=" . $_REQUEST["template_id"] . "&id=" . $_REQUEST["template_id"] . "';" : "strURL = strURL + '&template_id=-1';");?>
}
strURL = strURL + '&rows=' + objForm.rows.value;
strURL = strURL + '&method_id=' + objForm.method_id.value;
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>" . __("Data Sources") . "</strong> " . __("[device:") . " " . (empty($device["hostname"]) ? __("No Host") : $device["hostname"]) . "]", "100", $colors["header"], "3", "center", "data_sources.php?action=data_source_edit&device_id=" . $_REQUEST["device_id"], true);
?>
<tr class='rowAlternate2'>
<td>
<form action="data_sources.php" name="form_data_sources">
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Host:");?>
</td>
<td class="w1">
<?php
if (isset($_REQUEST["device_id"])) {
$hostname = db_fetch_cell("SELECT description as name FROM device WHERE id=".$_REQUEST["device_id"]." ORDER BY description,hostname");
} else {
$hostname = "";
}
?>
<input class="ac_field" type="text" id="device" size="30" value="<?php print $hostname; ?>">
<input type="hidden" id="device_id">
</td>
<td class="nw50">
<?php print __("Template:");?>
</td>
<td class="w1">
<select name="template_id" onChange="applyDSFilterChange(document.form_data_sources)">
<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
$templates = db_fetch_assoc("SELECT DISTINCT data_template.id, data_template.name
FROM data_template
INNER JOIN data_template_data
ON data_template.id=data_template_data.data_template_id
WHERE data_template_data.local_data_id>0
ORDER BY data_template.name");
if (sizeof($templates) > 0) {
foreach ($templates as $template) {
print "<option value='" . $template["id"] . "'"; if (get_request_var_request("template_id") == $template["id"]) { print " selected"; } print ">" . title_trim($template["name"], 40) . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw120">
<input type="submit" value="<?php print __("Go");?>" name="go" align="middle">
<input type="button" value="<?php print __("Clear");?>" name="clear" align="middle" onClick="clearDSFilterChange(document.form_data_sources)">
</td>
</tr>
<tr>
<td class="nw50">
<?php print __("Method:");?>
</td>
<td class="w1">
<select name="method_id" onChange="applyDSFilterChange(document.form_data_sources)">
<option value="-1"<?php if (get_request_var_request("method_id") == "-1") {?> selected<?php }?>><?php print __("Any");?></option>
<option value="0"<?php if (get_request_var_request("method_id") == "0") {?> selected<?php }?>><?php print __("None");?></option>
<?php
$methods = db_fetch_assoc("SELECT DISTINCT data_input.id, data_input.name
FROM data_input
INNER JOIN data_template_data
ON data_input.id=data_template_data.data_input_id
WHERE data_template_data.local_data_id>0
ORDER BY data_input.name");
if (sizeof($methods) > 0) {
foreach ($methods as $method) {
print "<option value='" . $method["id"] . "'"; if (get_request_var_request("method_id") == $method["id"]) { print " selected"; } print ">" . title_trim($method["name"], 40) . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw50">
<?php print __("Rows:");?>
</td>
<td class="w1">
<select name="rows" onChange="applyDSFilterChange(document.form_data_sources)">
<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="1" cellspacing="3">
<tr>
<td class="nw50">
<?php print __("Search:");?>
</td>
<td class="w1">
<input type="text" name="filter" size="40" value="<?php print $_REQUEST["filter"];?>">
</td>
</tr>
</table>
<input type='hidden' name='page' value='1'>
</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_where1 = "AND (data_template_data.name_cache like '%%" . $_REQUEST["filter"] . "%%'" .
" OR data_template_data.local_data_id like '%%" . get_request_var_request("filter") . "%%'" .
" OR data_template.name like '%%" . get_request_var_request("filter") . "%%'" .
" OR data_input.name like '%%" . get_request_var_request("filter") . "%%')";
$sql_where2 = "AND (data_template_data.name_cache like '%%" . $_REQUEST["filter"] . "%%'" .
" OR data_template.name like '%%" . get_request_var_request("filter") . "%%')";
}else{
$sql_where1 = "";
$sql_where2 = "";
}
if (get_request_var_request("device_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("device_id") == "0") {
$sql_where1 .= " AND data_local.device_id=0";
$sql_where2 .= " AND data_local.device_id=0";
}else {
$sql_where1 .= " AND data_local.device_id=" . $_REQUEST["device_id"];
$sql_where2 .= " AND data_local.device_id=" . $_REQUEST["device_id"];
}
if (get_request_var_request("template_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("template_id") == "0") {
$sql_where1 .= " AND data_template_data.data_template_id=0";
$sql_where2 .= " AND data_template_data.data_template_id=0";
}else {
$sql_where1 .= " AND data_template_data.data_template_id=" . $_REQUEST["template_id"];
$sql_where2 .= " AND data_template_data.data_template_id=" . $_REQUEST["template_id"];
}
if (get_request_var_request("method_id") == "-1") {
/* Show all items */
}elseif (get_request_var_request("method_id") == "0") {
$sql_where1 .= " AND data_template_data.data_input_id=0";
$sql_where2 .= " AND data_template_data.data_input_id=0";
}else {
$sql_where1 .= " AND data_template_data.data_input_id=" . $_REQUEST["method_id"];
$sql_where2 .= " AND data_template_data.data_input_id=" . $_REQUEST["method_id"];
}
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_data_source");
}else{
$rows = get_request_var_request("rows");
}
$total_rows = sizeof(db_fetch_assoc("SELECT
data_local.id
FROM (data_local,data_template_data)
LEFT JOIN data_input
ON (data_input.id=data_template_data.data_input_id)
LEFT JOIN data_template
ON (data_local.data_template_id=data_template.id)
WHERE data_local.id=data_template_data.local_data_id
$sql_where1"));
$poller_intervals = array_rekey(db_fetch_assoc("SELECT data_template_data.local_data_id AS id,
Min(data_template_data.rrd_step*rra.steps) AS poller_interval
FROM data_template
INNER JOIN (data_local
INNER JOIN ((data_template_data_rra
INNER JOIN data_template_data ON data_template_data_rra.data_template_data_id=data_template_data.id)
INNER JOIN rra ON data_template_data_rra.rra_id = rra.id) ON data_local.id = data_template_data.local_data_id) ON data_template.id = data_template_data.data_template_id
$sql_where2
GROUP BY data_template_data.local_data_id"), "id", "poller_interval");
$dssql = "SELECT
data_template_data.local_data_id,
data_template_data.name_cache,
data_template_data.active,
data_input.name as data_input_name,
data_template.name as data_template_name,
data_local.device_id
FROM (data_local,data_template_data)
LEFT JOIN data_input
ON (data_input.id=data_template_data.data_input_id)
LEFT JOIN data_template
ON (data_local.data_template_id=data_template.id)
WHERE data_local.id=data_template_data.local_data_id
$sql_where1
ORDER BY ". get_request_var_request('sort_column') . " " . get_request_var_request('sort_direction') .
" LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows;
$data_sources = db_fetch_assoc($dssql);
html_start_box("", "100", $colors["header"], "0", "center", "");
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 7, "data_sources.php");
print $nav;
html_end_box(false);
$display_text = array(
"name_cache" => array(__("Name"), "ASC"),
"local_data_id" => array(__("ID"),"ASC"),
"data_input_name" => array(__("Data Input Method"), "ASC"),
"nosort" => array(__("Poller Interval"), "ASC"),
"active" => array(__("Active"), "ASC"),
"data_template_name" => array(__("Template Name"), "ASC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($data_sources) > 0) {
foreach ($data_sources as $data_source) {
$data_source = api_plugin_hook_function('data_sources_table', $data_source);
$data_template_name = ((empty($data_source["data_template_name"])) ? "<em>" . __("None") . "</em>" : $data_source["data_template_name"]);
$data_input_name = ((empty($data_source["data_input_name"])) ? "<em>" . __("External") . "</em>" : $data_source["data_input_name"]);
$poller_interval = ((isset($poller_intervals[$data_source["local_data_id"]])) ? $poller_intervals[$data_source["local_data_id"]] : 0);
form_alternate_row_color('line' . $data_source["local_data_id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("data_sources.php?action=data_source_edit&id=" . $data_source["local_data_id"]) . "' title='" . htmlspecialchars($data_source["name_cache"]) . "'>" . (($_REQUEST["filter"] != "") ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", title_trim(htmlentities($data_source["name_cache"], ENT_NOQUOTES, "UTF-8"), read_config_option("max_title_data_source"))) : title_trim(htmlentities($data_source["name_cache"], ENT_NOQUOTES, "UTF-8"), read_config_option("max_title_data_source"))) . "</a>", $data_source["local_data_id"]);
form_selectable_cell($data_source['local_data_id'], $data_source['local_data_id']);
form_selectable_cell((($_REQUEST["filter"] != "") ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $data_input_name) : $data_input_name), $data_source["local_data_id"]);
form_selectable_cell(get_poller_interval($poller_interval), $data_source["local_data_id"]);
form_selectable_cell(($data_source['active'] == CHECKED ? "Yes" : "No"), $data_source["local_data_id"]);
form_selectable_cell((($_REQUEST["filter"] != "") ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $data_source['data_template_name']) : $data_source['data_template_name']), $data_source["local_data_id"]);
form_checkbox_cell($data_source["name_cache"], $data_source["local_data_id"]);
form_end_row();
}
form_end_table();
/* put the nav bar on the bottom as well */
print $nav;
}else{
print "<tr><td><em>" . __("No Data Sources") . "</em></td></tr>";
}
print "</table>\n"; # end table of html_header_sort_checkbox
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($ds_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
function mactrack_view_ip_ranges() {
global $title, $colors, $config, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("site_id"));
input_validate_input_number(get_request_var_request("page"));
/* ==================================================== */
/* 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 (isset($_REQUEST["reset"])) {
kill_session_var("sess_mactrack_view_ips_rows_selector");
kill_session_var("sess_mactrack_view_ips_current_page");
kill_session_var("sess_mactrack_view_ips_sort_column");
kill_session_var("sess_mactrack_view_ips_sort_row");
$_REQUEST["page"] = 1;
}
/* if any of the settings changed, reset the page number */
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"]) || isset($_REQUEST["reset"])) {
kill_session_var("sess_mactrack_view_ips_rows_selector");
kill_session_var("sess_mactrack_view_ips_current_page");
kill_session_var("sess_mactrack_view_ips_sort_column");
kill_session_var("sess_mactrack_view_ips_sort_row");
$_REQUEST["page"] = 1;
if (isset($_REQUEST["clear_x"])) {
unset($_REQUEST["rows"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
}else{
$changed = 0;
$changed += mactrack_check_changed("site_id", "sess_mactrack_view_ips_site_id");
$changed += mactrack_check_changed("rows", "sess_mactrack_view_ips_rows");
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_ips_current_page", "1");
load_current_session_value("site_id", "sess_mactrack_view_ips_site_id", "-1");
load_current_session_value("rows", "sess_mactrack_view_ips_rows", "-1");
load_current_session_value("sort_column", "sess_mactrack_view_ips_sort_column", "site_name");
load_current_session_value("sort_direction", "sess_mactrack_view_ips_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_ips_filter();
mactrack_view_footer();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$ip_ranges = mactrack_view_get_ip_range_records($sql_where, $row_limit);
$total_rows = db_fetch_cell("SELECT
COUNT(mac_track_ip_ranges.ip_range)
FROM mac_track_ip_ranges
INNER JOIN mac_track_sites ON (mac_track_ip_ranges.site_id=mac_track_sites.site_id)
$sql_where");
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_view_ips.php"));
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_ips.php?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_ips.php?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", ""),
"site_name" => array("Site Name", "ASC"),
"ip_range" => array("IP Range", "ASC"),
"ips_current" => array("Current IP Addresses", "DESC"),
"ips_current_date" => array("Current Date", "DESC"),
"ips_max" => array("Maximum IP Addresses", "DESC"),
"ips_max_date" => array("Maximum Date", "DESC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($ip_ranges) > 0) {
foreach ($ip_ranges as $ip_range) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width=80>
<a href='<?php print htmlspecialchars($webroot . "plugins/mactrack/mactrack_sites.php?action=edit&site_id=" . $ip_range['site_id']);?>' title='Edit Site'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/edit_object.png'></a>
<a href='<?php print htmlspecialchars($webroot . "plugins/mactrack/mactrack_view_macs.php?report=macs&reset&ip_filter_type_id=3&ip_filter=" . $ip_range["ip_range"] . "." . "&device_id=-1&scan_date=3&site_id=" . $ip_range['site_id']);?>' title='View MAC Addresses'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_macs.gif'></a>
<a href='<?php print htmlspecialchars($webroot . "plugins/mactrack/mactrack_view_arp.php?report=arp&reset&ip_filter_type_id=3&ip_filter=" . $ip_range["ip_range"] . "." . "&device_id=-1&scan_date=3&site_id=" . $ip_range['site_id']);?>' title='View IP Addresses'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_ipaddresses.gif'></a>
</td>
<td width=200>
<?php print "<strong>" . $ip_range["site_name"] . "</strong>";?>
</td>
<td><?php print $ip_range["ip_range"] . ".*";?></td>
<td><?php print number_format($ip_range["ips_current"]);?></td>
<td><?php print $ip_range["ips_current_date"];?></td>
<td><?php print number_format($ip_range["ips_max"]);?></td>
<td><?php print $ip_range["ips_max_date"];?></td>
</tr>
<?php
}
}else{
print "<tr><td colspan='10'><em>No MacTrack Site IP Ranges Found</em></td></tr>";
}
print $nav;
html_end_box(false);
mactrack_display_stats();
}
function template() {
global $colors, $graph_template_actions, $item_rows;
/* ================= input validation ================= */
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 string */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up sort_direction 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_graph_template_current_page");
kill_session_var("sess_graph_template_rows");
kill_session_var("sess_graph_template_filter");
kill_session_var("sess_graph_template_sort_column");
kill_session_var("sess_graph_template_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
?>
<script type="text/javascript">
<!--
function applyFilterChange(objForm) {
strURL = '?rows=' + objForm.rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
//-->
</script>
<?php
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_graph_template_current_page", "1");
load_current_session_value("rows", "sess_graph_template_rows", "-1");
load_current_session_value("filter", "sess_graph_template_filter", "");
load_current_session_value("sort_column", "sess_graph_template_sort_column", "name");
load_current_session_value("sort_direction", "sess_graph_template_sort_direction", "ASC");
html_start_box("<strong>" . __("Graph Templates") . "</strong>", "100", $colors["header"], "3", "center", "graph_templates.php?action=template_edit", true);
?>
<tr class='rowAlternate2'>
<td>
<form name="form_graph_template"
action='<?php print basename($_SERVER["PHP_SELF"]);?>'>
<table cellpadding="0" cellspacing="3">
<tr>
<td class="nw50"> <?php print __("Search:");?> </td>
<td class="w1"><input type="text" name="filter" size="40"
value="<?php print $_REQUEST["filter"];?>"></td>
<td class="nw50"> <?php print __("Rows:");?> </td>
<td class="w1"><select name="rows"
onChange="applyFilterChange(document.form_graph_template)">
<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 ">" . $value . "</option>\n";
}
}
?>
</select></td>
<td style='white-space: nowrap; width: 120px;'> <input
type="submit" Value="<?php print __("Go");?>" name="go"
align="middle"> <input type="submit"
Value="<?php print __("Clear");?>" name="clear_x" align="middle">
<div><input type='hidden' name='page' value='1'></div>
</td>
</tr>
</table>
</form>
</td>
</tr>
<?php
html_end_box(false);
/* form the 'where' clause for our main sql query */
if ($_REQUEST["filter"] != "") {
$sql_where = "WHERE (graph_templates.name LIKE '%%" . $_REQUEST["filter"] . "%%')
OR graph_templates.description LIKE '%%" . get_request_var_request("filter") . "%%'";
}else{
$sql_where = "";
}
html_start_box("", "100", $colors["header"], "0", "center", "");
$total_rows = db_fetch_cell("SELECT
COUNT(graph_templates.id)
FROM graph_templates
$sql_where");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_device");
}else{
$rows = get_request_var_request("rows");
}
$template_list = db_fetch_assoc("SELECT *
FROM graph_templates
$sql_where
ORDER BY " . get_request_var_request('sort_column') . " " . get_request_var_request('sort_direction') .
" LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 7, "graph_templates.php");
print $nav;
html_end_box(false);
$display_text = array(
"name" => array(__("Template Title"), "ASC"),
"description" => array(__("Description"), "ASC"),
"nosort" => array(__("Image"), "")
);
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($template_list) > 0) {
foreach ($template_list as $template) {
form_alternate_row_color('line' . $template["id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("graph_templates.php?action=template_edit&id=" . $template["id"]) . "'>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $template["name"]) : $template["name"]) . "</a>", $template["id"]);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("graph_templates.php?action=template_edit&id=" . $template["id"]) . "'>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $template["description"]) : $template["description"]) . "</a>", $template["id"]);
form_selectable_cell("<img src='" . $template["image"] . "'>", $template["id"]);
form_checkbox_cell($template["name"], $template["id"]);
form_end_row();
}
form_end_table();
print $nav;
}else{
print "<tr><td><em>" . __("No Graph Templates") . "</em></td></tr>\n";
}
print "</table>\n"; # end table of html_header_sort_checkbox
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($graph_template_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
function data() {
global $colors, $di_actions, $item_rows;
require(CACTI_BASE_PATH . "/include/data_input/data_input_arrays.php");
/* ================= input validation ================= */
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"])) {
kill_session_var("sess_data_input_current_page");
kill_session_var("sess_data_input_rows");
kill_session_var("sess_data_input_filter");
kill_session_var("sess_data_input_sort_column");
kill_session_var("sess_data_input_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
}
?>
<script type="text/javascript">
<!--
function applyFilterChange(objForm) {
strURL = '?rows=' + objForm.rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
-->
</script>
<?php
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_data_input_current_page", "1");
load_current_session_value("rows", "sess_data_input_rows", "-1");
load_current_session_value("filter", "sess_data_input_filter", "");
load_current_session_value("sort_column", "sess_data_input_sort_column", "name");
load_current_session_value("sort_direction", "sess_data_input_sort_direction", "ASC");
html_start_box("<strong>" . __("Data Input Methods") . "</strong>", "100", $colors["header"], "3", "center", "data_input.php?action=edit", true);
?>
<tr class="rowAlternate2 noprint">
<td class="noprint">
<form name="form_graph_id" action="data_input.php">
<table cellpadding="0" cellspacing="3">
<tr class="noprint">
<td class="nw50">
<?php print __("Search:");?>
</td>
<td width="1">
<input type="text" name="filter" size="40" value="<?php print $_REQUEST["filter"];?>">
</td>
<td class="nw50">
<?php print __("Rows:");?>
</td>
<td width="1">
<select name="rows" onChange="applyFilterChange(document.form_graph_id)">
<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 ">" . $value . "</option>\n";
}
}
?>
</select>
</td>
<td class="nw120">
<input type="submit" Value="<?php print __("Go");?>" name="go" align="middle">
<input type="submit" Value="<?php print __("Clear");?>" name="clear_x" align="middle">
</td>
</tr>
</table>
<div><input type='hidden' name='page' value='1'></div>
</form>
</td>
</tr>
<?php
html_end_box(FALSE);
html_start_box("", "100", $colors["header"], "0", "center", "");
/* form the 'where' clause for our main sql query */
$sql_where = "WHERE (data_input.name like '%%" . $_REQUEST["filter"] . "%%')";
$sql_where .= " AND (data_input.name!='Get Script Data (Indexed)'
AND data_input.name!='Get Script Server Data (Indexed)'
AND data_input.name!='Get SNMP Data'
AND data_input.name!='Get SNMP Data (Indexed)')";
$total_rows = db_fetch_cell("SELECT
count(*)
FROM data_input
$sql_where");
if (get_request_var_request("rows") == "-1") {
$rows = read_config_option("num_rows_device");
}else{
$rows = get_request_var_request("rows");
}
$data_inputs = db_fetch_assoc("SELECT *
FROM data_input
$sql_where
ORDER BY " . get_request_var_request('sort_column') . " " . get_request_var_request('sort_direction') . "
LIMIT " . ($rows*(get_request_var_request("page")-1)) . "," . $rows);
/* generate page list navigation */
$nav = html_create_nav($_REQUEST["page"], MAX_DISPLAY_PAGES, $rows, $total_rows, 7, "data_input.php");
print $nav;
html_end_box(FALSE);
$display_text = array(
"name" => array(__("Name"), "ASC"),
"type_id" => array(__("Data Input Method"), "ASC"));
html_header_sort_checkbox($display_text, get_request_var_request("sort_column"), get_request_var_request("sort_direction"));
if (sizeof($data_inputs) > 0) {
foreach ($data_inputs as $data_input) {
/* hide system types */
form_alternate_row_color('line' . $data_input["id"], true);
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("data_input.php?action=edit&id=" . $data_input["id"]) . "'>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span class=\"filter\">\\1</span>", $data_input["name"]) : $data_input["name"]) . "</a>", $data_input["id"]);
form_selectable_cell($input_types{$data_input["type_id"]}, $data_input["id"]);
form_checkbox_cell($data_input["name"], $data_input["id"]);
form_end_row();
}
form_end_table();
print $nav;
}else{
print "<tr><td><em>" . __("No Data Input Methods") . "</em></td></tr>";
}
print "</table>\n"; # end table of html_header_sort_checkbox
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($di_actions);
print "</form>\n"; # end form of html_header_sort_checkbox
}
function mactrack_view_sites() {
global $title, $colors, $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("page"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["detail"])) {
$_REQUEST["detail"] = sanitize_search_string(get_request_var("detail"));
}
/* 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_sites_current_page");
kill_session_var("sess_mactrack_view_sites_detail");
kill_session_var("sess_mactrack_view_sites_device_type_id");
kill_session_var("sess_mactrack_view_sites_site_id");
kill_session_var("sess_mactrack_view_sites_filter");
kill_session_var("sess_mactrack_view_sites_rows");
kill_session_var("sess_mactrack_view_sites_sort_column");
kill_session_var("sess_mactrack_view_sites_sort_direction");
$_REQUEST["page"] = 1;
if (isset($_REQUEST["clear_x"])) {
unset($_REQUEST["filter"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["device_type_id"]);
unset($_REQUEST["site_id"]);
unset($_REQUEST["detail"]);
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("device_type_id", "sess_mactrack_view_sites_device_type_id");
$changed += mactrack_check_changed("site_id", "sess_mactrack_view_sites_site_id");
$changed += mactrack_check_changed("filter", "sess_mactrack_view_sites_filter");
$changed += mactrack_check_changed("rows", "sess_mactrack_view_sites_rows");
$changed += mactrack_check_changed("detail", "sess_mactrack_view_sites_detail");
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_sites_current_page", "1");
load_current_session_value("detail", "sess_mactrack_view_sites_detail", "false");
load_current_session_value("device_type_id", "sess_mactrack_view_sites_device_type_id", "-1");
load_current_session_value("site_id", "sess_mactrack_view_sites_site_id", "-1");
load_current_session_value("filter", "sess_mactrack_view_sites_filter", "");
load_current_session_value("rows", "sess_mactrack_view_sites_rows", "-1");
load_current_session_value("sort_column", "sess_mactrack_view_sites_sort_column", "site_name");
load_current_session_value("sort_direction", "sess_mactrack_view_sites_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_site_filter();
mactrack_view_footer();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
$sites = mactrack_view_get_site_records($sql_where, $row_limit);
if ($_REQUEST["detail"] == "false") {
$total_rows = db_fetch_cell("SELECT
COUNT(mac_track_sites.site_id)
FROM mac_track_sites
$sql_where");
}else{
$total_rows = sizeof(db_fetch_assoc("SELECT
mac_track_device_types.device_type_id, mac_track_sites.site_name
FROM (mac_track_device_types
RIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id))
RIGHT JOIN mac_track_sites ON (mac_track_devices.site_id = mac_track_sites.site_id)
$sql_where
GROUP BY mac_track_sites.site_name, mac_track_device_types.device_type_id"));
}
/* generate page list */
$url_page_select = str_replace("&page", "?page", get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_view_sites.php"));
if (isset($config["base_path"])) {
if ($total_rows > 0) {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>
<td colspan='11'>
<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_sites.php?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_sites.php?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, 11, "mactrack_view_sites.php");
}
print $nav;
if ($_REQUEST["detail"] == "false") {
$display_text = array(
"nosort" => array("Actions", ""),
"site_name" => array("Site Name", "ASC"),
"total_devices" => array("Devices", "DESC"),
"total_ips" => array("Total IP's", "DESC"),
"total_user_ports" => array("User Ports", "DESC"),
"total_oper_ports" => array("User Ports Up", "DESC"),
"total_macs" => array("MACS Found", "DESC"),
"total_device_errors" => array("Device Errors", "DESC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i,'row_' . $site["site_id"]); $i++;
?>
<td width=140>
<?php
if (mactrack_authorized(2121)) {
echo "<a href='" . $webroot . "plugins/mactrack/mactrack_sites.php?action=edit&site_id=" . $site['site_id'] . "' title='Edit Site'><img border='0' src='" . $webroot . "plugins/mactrack/images/edit_object.png'></a>";
echo "<a href='#'><img id='r_" . $site["site_id"] . "' src='" . $config['url_path'] . "plugins/mactrack/images/rescan_site.gif' alt='' onMouseOver='style.cursor=\"pointer\"' onClick='site_scan(" . $site["site_id"] . ")' title='Rescan Site' border='0'></a>";
}
?>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_devices.php?report=devices&reset&site_id=" . $site['site_id'];?>' title='View Devices'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_devices.gif'></a>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_ips.php?report=ips&reset&site_id=" . $site['site_id'];?>' title='View IP Ranges'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_networks.gif'></a>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_arp.php?report=arp&reset&site_id=" . $site['site_id'];?>' title='View IP Addresses'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_ipaddresses.gif'></a>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_macs.php?report=macs&reset&device_id=-1&scan_date=3&site_id=" . $site['site_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=" . $site['site_id'];?>' title='View Interfaces'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_interfaces.gif'></a>
</td>
<td width=200>
<?php print "<strong>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["site_name"]) : $site["site_name"]) . "</strong>";?>
</td>
<td><?php print number_format($site["total_devices"]);?></td>
<td><?php print number_format($site["total_ips"]);?></td>
<td><?php print number_format($site["total_user_ports"]);?></td>
<td><?php print number_format($site["total_oper_ports"]);?></td>
<td><?php print number_format($site["total_macs"]);?></td>
<td><?php print ($site["total_device_errors"]);?></td>
</tr>
<?php
}
}else{
print "<tr><td colspan='10'><em>No MacTrack Sites</em></td></tr>";
}
print $nav;
html_end_box(false);
mactrack_display_stats();
}else{
$display_text = array(
"nosort" => array("Actions", ""),
"site_name" => array("Site Name", "ASC"),
"vendor" => array("Vendor", "ASC"),
"description" => array("Device Type", "DESC"),
"total_devices" => array("Total Devices", "DESC"),
"sum_ips_total" => array("Total IP's", "DESC"),
"sum_ports_total" => array("Total User Ports", "DESC"),
"sum_ports_active" => array("Total Oper Ports", "DESC"),
"sum_ports_trunk" => array("Total Trunks", "DESC"),
"sum_macs_active" => array("MACS Found", "DESC"));
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
$i = 0;
if (sizeof($sites) > 0) {
foreach ($sites as $site) {
form_alternate_row_color($colors["alternate"],$colors["light"],$i); $i++;
?>
<td width=100>
<?php
if (mactrack_authorized(2121)) {
echo "<a href='" . $webroot . "plugins/mactrack/mactrack_sites.php?action=edit&site_id=" . $site['site_id'] . "' title='Edit Site'><img border='0' src='" . $webroot . "plugins/mactrack/images/edit_object.png'></a>";
}
?>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_devices.php?report=devices&site_id=" . $site['site_id'] . "&device_type_id=" . $site['device_type_id'];?>&type_id=-1&status=-1&filter=' title='View Devices'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_devices.gif'></a>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_ips.php?report=ips&reset&site_id=" . $site['site_id'];?>' title='View IP Ranges'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_networks.gif'></a>
<a href='<?php print $webroot . "plugins/mactrack/mactrack_view_macs.php?report=macs&reset&device_id=-1&scan_date=3&site_id=" . $site['site_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=" . $site['site_id'];?>' title='View Interfaces'><img border='0' src='<?php print $webroot;?>plugins/mactrack/images/view_interfaces.gif'></a>
</td>
<td width=200>
<?php print "<strong>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["site_name"]) : $site["site_name"]) . "</strong>";?>
</td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["vendor"]) : $site["vendor"]);?></td>
<td><?php print (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $site["description"]) : $site["description"]);?></td>
<td><?php print number_format($site["total_devices"]);?></td>
<td><?php print ($site["device_type"] == "1" ? "N/A" : number_format($site["sum_ips_total"]));?></td>
<td><?php print ($site["device_type"] == "3" ? "N/A" : number_format($site["sum_ports_total"]));?></td>
<td><?php print ($site["device_type"] == "3" ? "N/A" : number_format($site["sum_ports_active"]));?></td>
<td><?php print ($site["device_type"] == "3" ? "N/A" : number_format($site["sum_ports_trunk"]));?></td>
<td><?php print ($site["device_type"] == "3" ? "N/A" : number_format($site["sum_macs_active"]));?></td>
</tr>
<?php
}
}else{
print "<tr><td colspan='10'><em>No MacTrack Sites</em></td></tr>";
}
print $nav;
html_end_box(false);
mactrack_display_stats();
}
print "<div id='response'></div>";
}
function mactrack_view_ips() {
global $title, $report, $colors, $mactrack_search_types, $rows_selector, $config;
global $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("mac_filter_type_id"));
input_validate_input_number(get_request_var_request("ip_filter_type_id"));
input_validate_input_number(get_request_var_request("rows"));
input_validate_input_number(get_request_var_request("authorized"));
input_validate_input_number(get_request_var_request("vlan"));
input_validate_input_number(get_request_var_request("page"));
/* ==================================================== */
/* clean up filter string */
if (isset($_REQUEST["ip_filter"])) {
$_REQUEST["ip_filter"] = sanitize_search_string(get_request_var("ip_filter"));
}
/* clean up search string */
if (isset($_REQUEST["mac_filter"])) {
$_REQUEST["mac_filter"] = sanitize_search_string(get_request_var("mac_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 (isset($_REQUEST["mac_filter_type_id"])) {
if ($_REQUEST["mac_filter_type_id"] == 1) {
unset($_REQUEST["mac_filter"]);
}
}
/* clean up search string */
if (isset($_REQUEST["scan_date"])) {
$_REQUEST["scan_date"] = sanitize_search_string(get_request_var("scan_date"));
}
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
if (isset($_REQUEST["ip_filter_type_id"])) {
if ($_REQUEST["ip_filter_type_id"] == 1) {
unset($_REQUEST["ip_filter"]);
}
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear_x"]) || isset($_REQUEST["reset"])) {
kill_session_var("sess_mactrack_view_ipads_current_page");
kill_session_var("sess_mactrack_view_ipads_filter");
kill_session_var("sess_mactrack_view_ipads_mac_filter_type_id");
kill_session_var("sess_mactrack_view_ipads_mac_filter");
kill_session_var("sess_mactrack_view_ipads_ip_filter_type_id");
kill_session_var("sess_mactrack_view_ipads_ip_filter");
kill_session_var("sess_mactrack_view_ipads_rows_selector");
kill_session_var("sess_mactrack_view_ipads_site_id");
kill_session_var("sess_mactrack_view_ipads_device_id");
kill_session_var("sess_mactrack_view_ipads_sort_column");
kill_session_var("sess_mactrack_view_ipads_sort_direction");
$_REQUEST["page"] = 1;
if (isset($_REQUEST["clear_x"])) {
unset($_REQUEST["mac_filter"]);
unset($_REQUEST["mac_filter_type_id"]);
unset($_REQUEST["ip_filter"]);
unset($_REQUEST["ip_filter_type_id"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["site_id"]);
unset($_REQUEST["device_id"]);
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("mac_filter", "sess_mactrack_view_ipads_filter");
$changed += mactrack_check_changed("mac_filter_type_id", "sess_mactrack_view_ipads_mac_filter_type_id");
$changed += mactrack_check_changed("ip_filter", "sess_mactrack_view_ipads_mac_ip_filter");
$changed += mactrack_check_changed("ip_filter_type_id", "sess_mactrack_view_ipads_ip_filter_type_id");
$changed += mactrack_check_changed("filter", "sess_mactrack_view_ipads_ip_filter");
$changed += mactrack_check_changed("rows", "sess_mactrack_view_ipads_rows_selector");
$changed += mactrack_check_changed("site_id", "sess_mactrack_view_ipads_site_id");
$changed += mactrack_check_changed("device_id", "sess_mactrack_view_ipads_device_id");
if ($changed) {
$_REQUEST["page"] = "1";
}
}
/* reset some things if the user has made changes */
if ((!empty($_REQUEST["site_id"]))&&(!empty($_SESSION["sess_mactrack_view_ipads_site_id"]))) {
if ($_REQUEST["site_id"] <> $_SESSION["sess_mactrack_view_ipads_site_id"]) {
$_REQUEST["device_id"] = "-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_ipads_current_page", "1");
load_current_session_value("mac_filter", "sess_mactrack_view_ipads_mac_filter", "");
load_current_session_value("mac_filter_type_id", "sess_mactrack_view_ipads_mac_filter_type_id", "1");
load_current_session_value("ip_filter", "sess_mactrack_view_ipads_ip_filter", "");
load_current_session_value("ip_filter_type_id", "sess_mactrack_view_ipads_ip_filter_type_id", "1");
load_current_session_value("filter", "sess_mactrack_view_ipads_filter", "");
load_current_session_value("rows", "sess_mactrack_view_ipads_rows_selector", "-1");
load_current_session_value("site_id", "sess_mactrack_view_ipads_site_id", "-1");
load_current_session_value("device_id", "sess_mactrack_view_ipads_device_id", "-1");
load_current_session_value("sort_column", "sess_mactrack_view_ipads_sort_column", "device_name");
load_current_session_value("sort_direction", "sess_mactrack_view_ipads_sort_direction", "ASC");
mactrack_tabs();
mactrack_view_header();
mactrack_ip_address_filter();
mactrack_view_footer();
html_start_box("", "100%", $colors["header"], "3", "center", "");
$sql_where = "";
if ($_REQUEST["rows"] == -1) {
$row_limit = read_config_option("num_rows_mactrack");
}elseif ($_REQUEST["rows"] == -2) {
$row_limit = 999999;
}else{
$row_limit = $_REQUEST["rows"];
}
$port_results = mactrack_view_get_ip_records($sql_where, TRUE, $row_limit);
/* prevent table scans, either a device or site must be selected */
if (!strlen($sql_where)) {
$total_rows = 0;
}elseif ($_REQUEST["rows"] == 1) {
$rows_query_string = "SELECT
COUNT(mac_track_ips.device_id)
FROM mac_track_ips
LEFT JOIN mac_track_sites ON (mac_track_ips.site_id=mac_track_sites.site_id)
LEFT JOIN mac_track_oui_database ON (mac_track_oui_database.vendor_mac=SUBSTRING(mac_track_ips.mac_address,1,8))
$sql_where";
$total_rows = db_fetch_cell($rows_query_string);
}else{
$rows_query_string = "SELECT
COUNT(DISTINCT device_id, mac_address, port_number, ip_address)
FROM mac_track_ips
LEFT JOIN mac_track_sites ON (mac_track_ips.site_id=mac_track_sites.site_id)
LEFT JOIN mac_track_oui_database ON (mac_track_oui_database.vendor_mac=SUBSTRING(mac_track_ips.mac_address,1,8))
$sql_where";
$total_rows = db_fetch_cell($rows_query_string);
}
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $row_limit, $total_rows, "mactrack_view_arp.php?report=arp");
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_arp.php?report=arp&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_arp.php?report=arp&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, $_REQUEST["rows"], $total_rows, 13, "mactrack_view_arp.php?report=arp");
}
print $nav;
if (strlen(read_config_option("mt_reverse_dns")) > 0) {
if ($_REQUEST["rows"] == 1) {
$display_text = array(
"device_name" => array("Switch Name", "ASC"),
"hostname" => array("Switch Hostname", "ASC"),
"ip_address" => array("ED IP Address", "ASC"),
"dns_hostname" => array("ED DNS Hostname", "ASC"),
"mac_address" => array("ED MAC Address", "ASC"),
"vendor_name" => array("Vendor Name", "ASC"),
"port_number" => array("Port Number", "DESC"));
}else{
$display_text = array(
"device_name" => array("Switch Name", "ASC"),
"hostname" => array("Switch Hostname", "ASC"),
"ip_address" => array("ED IP Address", "ASC"),
"dns_hostname" => array("ED DNS Hostname", "ASC"),
"mac_address" => array("ED MAC Address", "ASC"),
"vendor_name" => array("Vendor Name", "ASC"),
"port_number" => array("Port Number", "DESC"));
}
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
}else{
if ($_REQUEST["rows"] == 1) {
$display_text = array(
"device_name" => array("Switch Name", "ASC"),
"hostname" => array("Switch Hostname", "ASC"),
"ip_address" => array("ED IP Address", "ASC"),
"mac_address" => array("ED MAC Address", "ASC"),
"vendor_name" => array("Vendor Name", "ASC"),
"port_number" => array("Port Number", "DESC"));
}else{
$display_text = array(
"device_name" => array("Switch Device", "ASC"),
"hostname" => array("Switch Hostname", "ASC"),
"ip_address" => array("ED IP Address", "ASC"),
"mac_address" => array("ED MAC Address", "ASC"),
"vendor_name" => array("Vendor Name", "ASC"),
"port_number" => array("Port Number", "DESC"));
}
html_header_sort($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]);
}
$i = 0;
$delim = read_config_option("mt_mac_delim");
if (sizeof($port_results) > 0) {
foreach ($port_results as $port_result) {
form_alternate_row_color($colors["alternate"], $colors["light"], $i); $i++;
echo "<td>" . $port_result["device_name"] . "</td>";
echo "<td>" . $port_result["hostname"] . "</td>";
echo "<td>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["ip_address"]) : $port_result["ip_address"]) . "</td>";
if (strlen(read_config_option("mt_reverse_dns")) > 0) {
echo "<td>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["dns_hostname"]) : $port_result["dns_hostname"]) . "</td>";
}
echo "<td>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["mac_address"]) : $port_result["mac_address"]) . "</td>";
echo "<td>" . (strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["vendor_name"]) : $port_result["vendor_name"]) . "</td>";
echo "<td>" . $port_result["port_number"] . "</td>";
form_end_row();
}
}else{
if ($_REQUEST["site_id"] == -1 && $_REQUEST["device_id"] == -1) {
print "<tr><td colspan='10'><em>You must choose a Site, Device or other search criteria</em></td></tr>";
}else{
print "<tr><td colspan='10'><em>No MacTrack IP Results</em></td></tr>";
}
}
print $nav;
html_end_box(false);
mactrack_display_stats();
}
