$show_icons = 0;
}
} else {
}
if ($sub == "6" or $sub == "7" or $sub == "10") {
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\" width=\"100%\">\n";
echo "<tr>\n";
echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=sys.net_ip_address\" class=\"content\">IP Address </a></td>\n";
echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=sys.system_name\" class=\"content\">Name</a></td>\n";
echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=cdkey.ms_keys_name\" class=\"content\">Package</a></td>\n";
echo "<td align=\"center\"><a href=\"index.php?sub=" . $sub . "&sort=cdkey.ms_keys_cd_key\" class=\"content\">CD Key</a></td>\n";
echo "</tr>\n";
do {
$os = determine_os($myrow["ms_keys_name"]);
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">";
echo "<td align=\"center\"> " . ip_trans($myrow["net_ip_address"]) . " </td>\n";
echo "<td align=\"center\"> <a href=\"system_summary.php?pc=" . $myrow["net_mac_address"] . "&sub=all\">" . $myrow["system_name"] . "</a> </td>\n";
echo "<td align=\"center\"> " . $myrow["ms_keys_name"] . " </td>\n";
echo "<td align=\"center\"> " . $myrow["ms_keys_cd_key"] . " </td>\n";
echo "</tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
$show_icons = 1;
} else {
} else {
}
if ($show_domain == "y") {
echo " <td align=\"center\"><a href=\"list_workstations.php?sort=net_domain\"> Domain </a></td>\n";
} else {
}
if ($show_service_pack == "y") {
echo " <td align=\"center\"><a href=\"list_workstations.php?sort=system_service_pack\"> Service Pack </a></td>\n";
} else {
}
echo " </tr>\n";
$sql = "select * from system where (system_os_name LIKE 'Microsoft Windows 2000 Professional' OR system_os_name LIKE 'Microsoft Windows XP Professional') ORDER BY " . $sort . " LIMIT " . $page_count . "," . $count_system;
$result = mysql_query($sql, $db);
if ($myrow = mysql_fetch_array($result)) {
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>\n";
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 {
}
if ($show_date_audited == "y") {
echo " <td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . return_date($myrow["system_timestamp"]) . " </td>\n";
function determine_inkscape_img($os, $system_type)
{
// Assume we dont know what this is
$image_folder = "images";
$image = "button_fail.png";
$title = __("Unknown");
// Now we try to find out..
// Does the system_type map to a local PNG
if (is_file($image_folder . "/o_" . $system_type . ".png")) {
$image = "o_" . $system_type . ".png";
$title = __("{$system_type}");
} else {
$system_type = str_replace(" ", "_", $system_type);
$image = "o_" . $system_type . ".png";
// $image="button_fail.png";
$title = __("Unknown " . $system_type);
}
if (!is_file($image_folder . "/o_" . $system_type . ".png")) {
$image = "button_fail.png";
} else {
}
// Does the os map to a local PNG
if (is_file($image_folder . "/o_" . $os . ".png")) {
$image = "o_" . $os . ".png";
$title = __("{$os}");
} else {
$os = str_replace(" ", "_", $os);
$image = "o_" . $os . ".png";
// $image="button_fail.png";
$title = __("Unknown " . $os);
}
if (!is_file($image_folder . "/o_" . $os . ".png")) {
$image = "button_fail.png";
} else {
}
// Lets see if we can work it out from the OS
//
if (ereg("Windows", $os)) {
$image = "computer.png";
$title = determine_os($os);
}
if (ereg("Server", $os)) {
$image = "server.png";
$title = determine_os($os);
}
if (ereg("Laptop|Expansion Chassis|Notebook|Sub Notebook|Portable|Docking Station", $system_type)) {
$image = "laptop.png";
$title = determine_os($os);
}
//Substring match
$systems_substr = array("CentOS" => "CentOS", "Debian" => "Debian", "Fedora" => "Fedora", "Gentoo" => "Gentoo", "Mandrake" => "Mandrake", "Mandriva" => "Mandriva", "Novell" => "Novell", "Red Hat" => "Red Hat", "Slackware" => "Slackware", "Suse" => "Suse", "SuSE" => "SuSE", "SUSE" => "SUSE", "Ubuntu" => "Ubuntu");
reset($systems_substr);
while (list($key, $val) = each($systems_substr)) {
if (substr_count($os, $key)) {
$image = "linux_" . strtolower($val) . ".png";
$title = determine_os($os);
}
}
// If we got here, we must have a .png image, even if it is not what we want.
// So now we will look to see if we can find a scaleable image to give is a better looking output
// In other words, lets take the name of the .png, and replace it with a suitable Tango .svg if it exists.
/*
if (is_file($image_folder."\dell-ultrasharp.svg")){
switch($image){
case "laptop.png" :
$image = "computer-laptop-dell-inspiron.svg";
break;
case "computer.png" :
$image = "computer-dell-dimension-E521.svg";
break;
case "network-server.png" :
$image = "dell-ultrasharp.svg";
break;
}
}
*/
$ret = $image;
return $ret;
}
}
if ($link_query != "") {
$url = parse_url($get_array["file"]);
if (isset($url["query"]) and $url["query"] != "") {
$link_separator = "&";
} else {
$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 {
$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";
