if ($sub == "2") { echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=system_memory\"> Memory </a></td>\n"; } else { } if ($sub == "8") { echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=system_vendor\"> Vendor </a></td>\n"; } else { } if ($sub == "8") { echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=system_model\"> Model </a></td>\n"; } else { } echo "</tr>\n"; do { $os_name = determine_os($myrow["system_os_name"]); $img = determine_img($myrow["system_os_name"], $myrow["system_system_type"]); if ($bgcolor == "#F1F1F1") { $bgcolor = "#FFFFFF"; } else { $bgcolor = "#F1F1F1"; } echo "<tr>"; if ($show_mac == "y") { echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> <a href=\"system_summary.php?pc=" . $myrow["net_mac_address"] . "&sub=all\">" . $myrow["net_mac_address"] . " </td>\n"; } else { } echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . ip_trans($myrow["net_ip_address"]) . " </td>\n"; echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> <a href=\"system_summary.php?pc=" . $myrow["system_uuid"] . "&sub=all\">" . $myrow["system_name"] . "</a> </td>\n"; if ($show_os == "y") { echo "<td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $os_name . " </td>\n"; } else {
function ConvertSpecialField($myrow, $field, $db, $page) { if (!isset($field["name"])) { return ""; } switch ($field["name"]) { case "system_os_name": return determine_os($myrow[$field["name"]]); case "net_dhcp_lease_obtained": case "net_dhcp_lease_expires": case "net_driver_date": case "ldap_computers_timestamp": case "ldap_users_timestamp": return return_date($myrow[$field["name"]]); case "net_speed": return number_format($myrow[$field["name"]]) . " Mbps"; case "software_first_timestamp": case "software_timestamp": case "system_first_timestamp": case "system_timestamp": case "other_first_timestamp": case "other_timestamp": case "monitor_first_timestamp": case "monitor_timestamp": case "system_audits_timestamp": case "system_last_boot": case "log_timestamp": return return_date_time($myrow[$field["name"]]); case "system_system_type": if ($page == "list") { return determine_img($myrow["system_os_name"], $myrow[$field["name"]]); } else { return $myrow[$field["name"]]; } case "other_type": if ($page == "list") { return "<img src=\"images/o_" . str_replace(" ", "_", $myrow[$field["name"]]) . ".png\" alt=\"\" border=\"0\" width=\"16\" height=\"16\"/>"; } else { return $myrow[$field["name"]]; } case "other_ip_address": return ip_trans($myrow[$field["name"]]); case "delete": return "<img src=\"images/button_delete_out.png\" id=\"button" . rand(0, 999999999) . "\" width=\"58\" height=\"22\" border=\"0\" alt=\"\" />"; case "ldap_user_status": return "<img src='../images/user_" . $myrow[$field["name"]] . ".gif'>"; case "ldap_computer_status": return "<img src='../images/computer_" . $myrow[$field["name"]] . ".gif'>"; case "startup_location": if (substr($myrow[$field["name"]], 0, 2) == "HK") { return __("Registry"); } case "percentage": case "disk_percent": return $myrow[$field["name"]] . " %"; case "system_memory": case "video_adapter_ram": case "hard_drive_size": case "partition_size": case "partition_free_space": case "total_memory": case "pagefile_initial_size": case "pagefile_max_size": return number_format($myrow[$field["name"]]) . " MB"; case "evt_log_file_size": case "evt_log_max_file_size": return number_format($myrow[$field["name"]]) . " KB"; case "video_current_number_colours": return strlen(decbin($myrow[$field["name"]])) + 1 . " Bit"; case "video_current_refresh_rate": return $myrow[$field["name"]] . " Hz"; case "firewall_enabled_domain": case "firewall_enabled_standard": case "firewall_disablenotifications_standard": case "firewall_donotallowexceptions_standard": case "firewall_disablenotifications_domain": case "firewall_donotallowexceptions_domain": if ($myrow[$field["name"]] == "1") { return __("Yes"); } if ($myrow[$field["name"]] == "0") { return __("No"); } return __("Profile Not Detected"); case "other_ip_address": return ($myrow["other_ip_address"] == "" and !isset($_REQUEST["edit"])) ? "Not-Networked" : $myrow[$field["name"]]; case "net_dhcp_server": return $myrow[$field["name"]] == "none" ? __("No") : __("Yes") . " / " . $myrow[$field["name"]]; case "auth_enabled": case "auth_admin": if ($myrow[$field["name"]] == "0") { return __("No"); } if ($myrow[$field["name"]] == "1") { return __("Yes"); } return $myrow[$field["name"]]; case "auth_hash": return "*****"; case "other_linked_pc": if (!isset($_REQUEST["edit"])) { $result = mysql_query("SELECT system_name FROM system WHERE system_uuid='" . $myrow[$field["name"]] . "' AND system_uuid != '' ", $db); return ($myrow3 = mysql_fetch_array($result)) ? $myrow3["system_name"] : $myrow[$field["name"]]; } case "monitor_uuid": if (!isset($_REQUEST["edit"]) or isset($_REQUEST["edit"]) and isset($field["edit"]) and $field["edit"] == "n") { $result = mysql_query("SELECT system_name FROM system WHERE system_uuid = '" . $myrow[$field["name"]] . "' AND system_uuid != '' ", $db); return ($myrow3 = mysql_fetch_array($result)) ? $myrow3["system_name"] : $myrow[$field["name"]]; } default: if (isset($myrow[$field["name"]])) { return $myrow[$field["name"]]; } } return ""; }
$link_separator = "?"; } $link_uri = $link_file . $link_separator . $link_query; } else { $link_uri = $link_file; } //Special field-converting unset($show_value); if ($field["name"] == "system_os_name") { $show_value = determine_os($myrow[$field["name"]]); } elseif ($field["name"] == "system_timestamp") { $show_value = return_date($myrow[$field["name"]]); } elseif ($field["name"] == "software_first_timestamp" or $field["name"] == "software_timestamp" or $field["name"] == "system_first_timestamp" or $field["name"] == "system_audits_timestamp") { $show_value = return_date($myrow[$field["name"]]); } elseif ($field["name"] == "system_system_type") { $show_value = determine_img($myrow["system_os_name"], $myrow[$field["name"]]); } elseif ($field["name"] == "other_ip_address") { if ($myrow[$field["name"]] == "") { $show_value = "Not-Networked"; } else { $show_value = $myrow[$field["name"]]; } } elseif ($field["name"] == "partition_free_space" or $field["name"] == "partition_size") { $show_value = $myrow[$field["name"]] . " " . __("MB"); } else { $show_value = $myrow[$field["name"]]; } if (!isset($field["align"])) { $field["align"] = " "; } $body .= " <td bgcolor=\"" . $bgcolor . "\" style=\"padding-right:10px;\" align=\"" . $field["align"] . "\">\n";
$result = mysql_query($query) or die("Query failed at delete stage. system_man"); $query = "DELETE FROM system_security WHERE ss_uuid = '" . $id . "'"; $result = mysql_query($query) or die("Query failed at delete stage. system_security"); $query = "DELETE FROM tape_drive WHERE tape_drive_uuid = '" . $id . "'"; $result = mysql_query($query) or die("Query failed at delete stage. tape_drive"); $query = "DELETE FROM usb WHERE usb_uuid = '" . $id . "'"; $result = mysql_query($query) or die("Query failed at delete stage. usb"); $query = "DELETE FROM users WHERE users_uuid = '" . $id . "'"; $result = mysql_query($query) or die("Query failed at delete stage. users"); $query = "DELETE FROM video WHERE video_uuid = '" . $id . "'"; $result = mysql_query($query) or die("Query failed at delete stage. video"); $query = "DELETE FROM other WHERE other_linked_pc = '" . $id . "'"; $result = mysql_query($query) or die("Query failed at delete stage. other"); } } $sql = "SELECT system_uuid, net_ip_address, system_name, net_domain, system_os_name, system_system_type, system_timestamp FROM system ORDER BY system_name "; $result = mysql_query($sql, $db); $bgcolor = "#FFFFFF"; echo "<td valign=\"top\">\r\n <div class=\"main_each\">"; if ($myrow = mysql_fetch_array($result)) { echo "<form name=\"DeleteList\" id=\"DeleteList\" method=\"post\" action=\"" . $_SERVER["PHP_SELF"] . "\" >\r\n \r\n <script language=\"JavaScript\" TYPE=\"text/javascript\">\r\n function CheckUncheckAll(form){\r\n if(!form)\r\n return;\r\n var objElements = form.elements;\r\n if(!objElements)\r\n return;\r\n var countElements = objElements.length;\r\n if(!countElements)\r\n return;\r\n else\r\n for (var i = 1; i < countElements; i++){ \r\n eval(\"objElements[\" + i + \"].checked = objElements[1].checked\"); \r\n }\r\n }\r\n </script>\r\n \r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr>\r\n <td class=\"contenthead\">" . __("Delete Systems") . "<br /> </td>\r\n </tr>\r\n </table>\r\n \r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr>\r\n <td width=\"30%\"><input type=\"submit\" name=\"Perform\" id=\"Perform\" value=\"Delete selected systems\" onclick=\"return confirm('Do you really want to DELETE all selected Systems?')\"></td>\r\n <td width=\"70%\"><input type=\"checkbox\" name=\"SetUnset\" id=\"SetUnset\" onClick=\"CheckUncheckAll(this.form);\" />Check/Uncheck all<br /></td> \r\n </tr>\r\n </table>\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tr> </tr>\r\n <tr>\r\n <td></td>\r\n <td class=\"contentsubtitle\">" . __("IP Address") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Hostname") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Domain") . "</td>\r\n <td class=\"contentsubtitle\">" . __("OS") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Type") . "</td>\r\n <td class=\"contentsubtitle\">" . __("Date Audited") . "</td>\r\n </tr>\n"; do { $bgcolor = change_row_color($bgcolor, $bg1, $bg2); echo "<tr style=\"bgcolor:" . $bgcolor . ";\">\r\n <td width=\"5%\"><input type=\"checkbox\" name=" . $myrow["system_uuid"] . " id=" . $myrow["system_uuid"] . " value=" . $myrow["system_uuid"] . "></td>\r\n <td><a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\">" . ip_trans($myrow["net_ip_address"]) . "</a></td>\r\n <td><a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\">" . $myrow["system_name"] . "</a></td>\r\n <td>" . $myrow["net_domain"] . "</td>\r\n <td>" . determine_os($myrow["system_os_name"]) . "</td>\r\n <td>" . determine_img($myrow["system_os_name"], $myrow["system_system_type"]) . "</td>\r\n <td>" . return_date_time($myrow["system_timestamp"]) . "</td>\r\n </tr>\n"; } while ($myrow = mysql_fetch_array($result)); echo " </table>\r\n </form>"; } else { echo "<p class=\"content\">No Systems in database.</p>\n"; } echo "</div>\n"; echo "</td>\n";