if (strpos(strtoupper($myrow["net_ip_address"]), $search) !== false) {
$search_field = "IP Address";
$search_result = $myrow["net_ip_address"];
} else {
if (strpos(strtoupper($myrow["net_ip_address"]), $search_padded) !== false) {
$search_field = "IP Address";
$search_result = ip_trans($myrow["net_ip_address"]);
}
}
$bgcolor = change_row_color($bgcolor, $bg1, $bg2);
$result_set[] = array($myrow["system_name"], $myrow["system_uuid"], ip_trans($myrow["net_ip_address"]), $search_field, $search_result);
} while ($myrow = mysql_fetch_array($result));
} else {
}
// Search for IP address into "other" table
$search_padded = ip_trans_to($search);
$sql = "SELECT DISTINCT other_network_name, other_id, other_ip_address ";
$sql .= "FROM other WHERE ";
$sql .= "other_ip_address LIKE '%{$search}%' OR ";
$sql .= "other_ip_address LIKE '%{$search_padded}%'";
$result = mysql_query($sql, $db);
if ($myrow = mysql_fetch_array($result)) {
do {
if (strpos(strtoupper($myrow["other_ip_address"]), $search) !== false) {
$search_field = "Device IP Address";
$search_result = $myrow["other_ip_address"];
} else {
if (strpos(strtoupper($myrow["other_ip_address"]), $search_padded) !== false) {
$search_field = "Device IP Address";
$search_result = ip_trans($myrow["other_ip_address"]);
}
if ($uuid == "" and $mac != "00:00:00:00:00:00") {
// Insert into other table
$sql = "INSERT INTO other (other_network_name, other_ip_address, other_mac_address, ";
$sql .= "other_description, other_manufacturer, other_type, ";
$sql .= "other_timestamp, other_first_timestamp) VALUES (";
$sql .= "'{$name}','" . ip_trans_to($ip_address) . "','{$mac}',";
$sql .= "'{$running}','{$manufacturer}','{$device_type}',";
$sql .= "'{$timestamp}','{$timestamp}')";
$result = mysql_query($sql) or die('Insert Failed: <br />' . $sql . '<br />' . mysql_error());
$uuid = mysql_insert_id();
$process = "new_other";
echo $sql . "<br />";
} else {
}
if ($process == "other_mac") {
$sql = "UPDATE other SET other_ip_address = '" . ip_trans_to($ip_address) . "', ";
$sql .= "other_mac_address = '{$mac}', other_timestamp = '{$timestamp}' ";
$sql .= "WHERE other_id = '{$uuid}'";
$result = mysql_query($sql) or die('Insert Failed: <br />' . $sql . '<br />' . mysql_error());
//$uuid = mysql_insert_id();
$process = "update_other";
echo $sql . "<br />\n";
} else {
}
if ($process != "") {
// Process the file
echo "UUID: " . $uuid . "<br />";
echo "Process: " . $process . "<br />";
$sql = "DELETE FROM nmap_ports WHERE nmap_other_id = '" . $uuid . "'";
echo $sql . "<br />\n";
$result = mysql_query($sql) or die('Delete Failed: <br />' . $sql . '<br />' . mysql_error());
<?php
$page = "other";
include "include_config.php";
include "include_functions.php";
include "include_lang.php";
mysql_connect($mysql_server, $mysql_user, $mysql_password) or die("Could not connect");
mysql_select_db($mysql_database) or die("Could not select database");
if (isset($_REQUEST["view"]) and isset($_REQUEST["category"])) {
//Other-System ------------------------------------------------------------------------------
if ($_REQUEST["view"] == "other_system" and $_REQUEST["category"] == "summary" or $_REQUEST["view"] == "printer" and $_REQUEST["category"] == "summary") {
$sql = "UPDATE other SET other_network_name = '" . $_REQUEST['other_network_name'] . "',";
$sql .= " other_ip_address = '" . ip_trans_to($_REQUEST['other_ip_address']) . "',";
$sql .= " other_mac_address = '" . $_REQUEST['other_mac_address'] . "',";
$sql .= " other_p_port_name = '" . $_REQUEST['other_p_port_name'] . "',";
$sql .= " other_description = '" . $_REQUEST['other_description'] . "',";
$sql .= " other_serial = '" . $_REQUEST['other_serial'] . "',";
$sql .= " other_manufacturer = '" . $_REQUEST['other_manufacturer'] . "',";
$sql .= " other_model='" . $_REQUEST['other_model'] . "',";
$sql .= " other_type='" . $_REQUEST['other_type'] . "',";
$sql .= " other_location='" . $_REQUEST['other_location'] . "',";
$sql .= " other_date_purchased='" . $_REQUEST['other_date_purchased'] . "',";
$sql .= " other_value='" . $_REQUEST['other_value'] . "',";
$sql .= " other_linked_pc='" . $_REQUEST['other_linked_pc'] . "' ";
$sql .= " WHERE other_id='" . $_REQUEST['other'] . "'";
$url = "./system.php?other=" . $_REQUEST["other"] . "&view=" . $_REQUEST["view"] . " ";
//Monitor ------------------------------------------------------------------------------------
} elseif ($_REQUEST["view"] == "monitor" and $_REQUEST["category"] == "summary") {
$sql = "UPDATE monitor SET ";
$sql .= " monitor_uuid = '" . $_REQUEST['monitor_uuid'] . "', ";
$sql .= " monitor_date_purchased = '" . $_REQUEST['monitor_date_purchased'] . "', ";
