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_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 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 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_view_aggregated_macs() { global $title, $report, $colors, $mactrack_search_types, $rows_selector, $config; global $mactrack_view_agg_macs_actions, $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("port_name_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 search string */ if (isset($_REQUEST["port_name_filter"])) { $_REQUEST["port_name_filter"] = sanitize_search_string(get_request_var("port_name_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"]); } } if (isset($_REQUEST["port_name_filter_type_id"])) { if ($_REQUEST["port_name_filter_type_id"] == 1) { unset($_REQUEST["port_name_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 (isset($_REQUEST["reset"])) { kill_session_var("sess_mactrack_view_macs_current_page"); kill_session_var("sess_mactrack_view_macs_rowstoshow"); kill_session_var("sess_mactrack_view_macs_filter"); kill_session_var("sess_mactrack_view_macs_mac_filter_type_id"); kill_session_var("sess_mactrack_view_macs_mac_filter"); kill_session_var("sess_mactrack_view_macs_port_name_filter_type_id"); kill_session_var("sess_mactrack_view_macs_port_name_filter"); kill_session_var("sess_mactrack_view_macs_ip_filter_type_id"); kill_session_var("sess_mactrack_view_macs_ip_filter"); kill_session_var("sess_mactrack_view_macs_rows_selector"); kill_session_var("sess_mactrack_view_macs_site_id"); kill_session_var("sess_mactrack_view_macs_vlan_id"); kill_session_var("sess_mactrack_view_macs_authorized"); kill_session_var("sess_mactrack_view_macs_device_id"); kill_session_var("sess_mactrack_view_macs_sort_column"); kill_session_var("sess_mactrack_view_macs_sort_direction"); $_REQUEST["page"] = 1; } /* if the user pushed the 'clear' button */ if (isset($_REQUEST["clear_x"])) { kill_session_var("sess_mactrack_view_macs_current_page"); kill_session_var("sess_mactrack_view_macs_rowstoshow"); kill_session_var("sess_mactrack_view_macs_filter"); kill_session_var("sess_mactrack_view_macs_mac_filter_type_id"); kill_session_var("sess_mactrack_view_macs_mac_filter"); kill_session_var("sess_mactrack_view_macs_port_name_filter_type_id"); kill_session_var("sess_mactrack_view_macs_port_name_filter"); kill_session_var("sess_mactrack_view_macs_ip_filter_type_id"); kill_session_var("sess_mactrack_view_macs_ip_filter"); kill_session_var("sess_mactrack_view_macs_rows_selector"); kill_session_var("sess_mactrack_view_macs_site_id"); kill_session_var("sess_mactrack_view_macs_vlan_id"); kill_session_var("sess_mactrack_view_macs_authorized"); kill_session_var("sess_mactrack_view_macs_device_id"); kill_session_var("sess_mactrack_view_macs_sort_column"); kill_session_var("sess_mactrack_view_macs_sort_direction"); $_REQUEST["page"] = 1; unset($_REQUEST["scan_date"]); unset($_REQUEST["mac_filter"]); unset($_REQUEST["mac_filter_type_id"]); unset($_REQUEST["port_name_filter"]); unset($_REQUEST["port_name_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["vlan"]); unset($_REQUEST["authorized"]); 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("scan_date", "sess_mactrack_view_macs_rowstoshow"); $changed += mactrack_check_changed("mac_filter", "sess_mactrack_view_macs_mac_filter"); $changed += mactrack_check_changed("mac_filter_type_id", "sess_mactrack_view_macs_mac_filter_type_id"); $changed += mactrack_check_changed("port_name_filter", "sess_mactrack_view_macs_port_name_filter"); $changed += mactrack_check_changed("port_name_filter_type_id", "sess_mactrack_view_macs_port_name_filter_type_id"); $changed += mactrack_check_changed("ip_filter", "sess_mactrack_view_macs_ip_filter"); $changed += mactrack_check_changed("ip_filter_type_id", "sess_mactrack_view_macs_ip_filter_type_id"); $changed += mactrack_check_changed("filter", "sess_mactrack_view_macs_filter"); $changed += mactrack_check_changed("rows", "sess_mactrack_view_macs_rows_selector"); $changed += mactrack_check_changed("site_id", "sess_mactrack_view_macs_site_id"); $changed += mactrack_check_changed("vlan", "sess_mactrack_view_macs_vlan_id"); $changed += mactrack_check_changed("authorized", "sess_mactrack_view_macs_authorized"); $changed += mactrack_check_changed("device_id", "sess_mactrack_view_macs_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_macs_site_id"]))) { if ($_REQUEST["site_id"] <> $_SESSION["sess_mactrack_view_macs_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_macs_current_page", "1"); load_current_session_value("scan_date", "sess_mactrack_view_macs_rowstoshow", "2"); load_current_session_value("mac_filter", "sess_mactrack_view_macs_mac_filter", ""); load_current_session_value("mac_filter_type_id", "sess_mactrack_view_macs_mac_filter_type_id", "1"); load_current_session_value("port_name_filter", "sess_mactrack_view_macs_port_name_filter", ""); load_current_session_value("port_name_filter_type_id", "sess_mactrack_view_macs_port_name_filter_type_id", "1"); load_current_session_value("ip_filter", "sess_mactrack_view_macs_ip_filter", ""); load_current_session_value("ip_filter_type_id", "sess_mactrack_view_macs_ip_filter_type_id", "1"); load_current_session_value("filter", "sess_mactrack_view_macs_filter", ""); load_current_session_value("rows", "sess_mactrack_view_macs_rows_selector", "-1"); load_current_session_value("site_id", "sess_mactrack_view_macs_site_id", "-1"); load_current_session_value("vlan", "sess_mactrack_view_macs_vlan_id", "-1"); load_current_session_value("authorized", "sess_mactrack_view_macs_authorized", "-1"); load_current_session_value("device_id", "sess_mactrack_view_macs_device_id", "-1"); load_current_session_value("sort_column", "sess_mactrack_view_macs_sort_column", "device_name"); load_current_session_value("sort_direction", "sess_mactrack_view_macs_sort_direction", "ASC"); mactrack_tabs(); mactrack_view_header(); mactrack_mac_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_mac_records($sql_where, TRUE, $row_limit); /* prevent table scans, either a device or site must be selected */ if ($_REQUEST["site_id"] == -1 && $_REQUEST["device_id"] == -1) { $total_rows = 0; }else{ $rows_query_string = "SELECT COUNT(*) FROM mac_track_aggregated_ports LEFT JOIN mac_track_sites ON (mac_track_aggregated_ports.site_id=mac_track_sites.site_id) LEFT JOIN mac_track_oui_database ON (mac_track_oui_database.vendor_mac=mac_track_aggregated_ports.vendor_mac) " . str_replace("mac_track_ports", "mac_track_aggregated_ports", $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_macs.php?report=macs&scan_date=3"); if (isset($config["base_path"])) { if ($total_rows > 0) { $nav = "<tr bgcolor='#" . $colors["header"] . "'> <td colspan='15'> <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_macs.php?report=macs&scan_date=3&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_macs.php?report=macs&scan_date=3&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, 15, "mactrack_view_macs.php?report=macs&scan_date=3"); } print $nav; $display_text = array( "device_name" => array("Switch Name", "ASC"), "hostname" => array("Switch Hostname", "ASC"), "ip_address" => array("ED IP Address", "ASC")); if (strlen(read_config_option("mt_reverse_dns")) > 0) { $display_text["dns_hostname"] = array("ED DNS Hostname", "ASC"); } $display_text=array_merge($display_text,array("mac_address" => array("ED MAC Address", "ASC"), "vendor_name" => array("Vendor Name", "ASC"), "port_number" => array("Port Number", "DESC"), "port_name" => array("Port Name", "ASC"), "vlan_id" => array("VLAN ID", "DESC"), "vlan_name" => array("VLAN Name", "ASC"))); if ($_REQUEST["rows"] == 1) { $display_text["max_scan_date"] = array("Last Scan Date", "DESC"); }else{ $display_text["scan_date"] = array("Last Scan Date", "DESC"); } if ($_REQUEST["scan_date"] == 3) { $display_text["count_rec"] = array("Count", "ASC"); } if (mactrack_check_user_realm(2122)) { html_header_sort_checkbox($display_text, $_REQUEST["sort_column"], $_REQUEST["sort_direction"]); }else{ 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) { if ($port_result["active_last"] == 1) { $color_line_date="<span style='font-weight: bold;'>"; }else{ $color_line_date=""; } $key = str_replace($delim, "_", $port_result["mac_address"]) . "-" . $port_result["device_id"] . $port_result["port_number"] . "-" . $port_result["date_last"]; $key = $port_result["row_id"]; form_alternate_row_color($colors["alternate"], $colors["light"], $i, 'line' . $key); $i++; form_selectable_cell((strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["device_name"]) : $port_result["device_name"]), $key); form_selectable_cell((strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["hostname"]) : $port_result["hostname"]), $key); form_selectable_cell((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"]), $key); if (strlen(read_config_option("mt_reverse_dns")) > 0) { form_selectable_cell((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"]), $key); } form_selectable_cell((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"]), $key); form_selectable_cell((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"]), $key); form_selectable_cell($port_result["port_number"], $key); form_selectable_cell((strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["port_name"]) : $port_result["port_name"]), $key); form_selectable_cell($port_result["vlan_id"], $key); form_selectable_cell((strlen($_REQUEST["filter"]) ? preg_replace("/(" . preg_quote($_REQUEST["filter"]) . ")/i", "<span style='background-color: #F8D93D;'>\\1</span>", $port_result["vlan_name"]) : $port_result["vlan_name"]), $key); form_selectable_cell($color_line_date . $port_result["date_last"], $key); form_selectable_cell($port_result["count_rec"], $key); if (mactrack_check_user_realm(2122)) { form_checkbox_cell($port_result["mac_address"], $key); } 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 Port Results</em></td></tr>"; } } print $nav; html_end_box(false); mactrack_display_stats(); if (mactrack_check_user_realm(2122)) { /* draw the dropdown containing a list of available actions for this form */ mactrack_draw_actions_dropdown($mactrack_view_agg_macs_actions); } }