$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";
} else {
}
if ($show_type == "y") {
echo " <td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $img . " </td>\n";
} else {
}
if ($show_description == "y") {
echo " <td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $myrow["system_description"] . " </td>\n";
} else {
}
if ($show_domain == "y") {
echo " <td align=\"center\" bgcolor=\"" . $bgcolor . "\"> " . $myrow["net_domain"] . " </td>\n";
} else {
}
if ($show_service_pack == "y") {
echo " <td width=\"120\"><b>IP Address</b></td>\n";
echo " <td width=\"150\"><b>System Name</b></td>\n";
echo " <td width=\"100\"><b>Detected</b></td>\n";
echo " <td><b>Software Title</b></td>\n";
echo "</tr>\n";
do {
$count = $count + 1;
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo " <td>" . ip_trans($myrow["net_ip_address"]) . "</td>\n";
echo " <td><a href=\"system_summary.php?pc=" . $myrow["system_uuid"] . "\">" . $myrow["system_name"] . "</a></td>\n";
echo " <td>" . return_date($myrow["software_first_timestamp"]) . "</td>\n";
echo " <td>" . $myrow["software_name"] . "</td>\n";
echo "</tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
echo "</div>";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr><td colspan=\"3\"><b>Total Packages: " . $count . "</b></td></tr>\n";
echo "</table>";
echo "</div>";
} else {
}
} else {
}
if ($show_patches_not_detected == "y") {
$SQL = "DELETE FROM system_security_temp";
$SQL = "SELECT * FROM printer WHERE printer_id = '" . $_GET['printer'] . "'";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
do {
echo "<div class=\"main_each\">";
echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\" class=\"content\">";
echo "<tr><td colspan=\"2\" class=\"contenthead\"><img src=\"images/inv_printer" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" /> " . $myrow["printer_caption"] . "</td></tr>";
echo "<tr><td>Name: </td><td>" . $myrow["printer_caption"] . "</td></tr>";
echo "<tr><td>Location: </td><td>" . $myrow["printer_location"] . "</td></tr>";
if ($myrow["printer_ip"]) {
echo "<tr><td>Network Address: </td><td>" . ip_trans($myrow["printer_ip"]) . "</td></tr>";
echo "<tr><td>MAC Address: </td><td>" . return_unknown($myrow["printer_mac_address"]) . "</td></tr>\n";
} else {
echo "<tr><td>Attached with PC: </td><td>" . $myrow["printer_system_name"] . "</td></tr>\n";
}
echo "<tr><td>Date Discovered: </td><td>" . return_date($myrow["printer_first_timestamp"]) . "</td></tr>\n";
echo "<tr><td>Manufacturer: </td><td>" . $myrow["printer_manufacturer"] . "</td></tr>\n";
echo "<tr><td>Model Number: </td><td>" . $myrow["printer_model"] . "</td></tr>\n";
echo "<tr><td>Serial Number: </td><td>" . $myrow["printer_serial"] . "</td></tr>\n";
echo "<tr><td>Physical Location: </td><td>" . $myrow["printer_location"] . "</td></tr>\n";
echo "<tr><td>Date of Purchase: (yyyy-mm-dd) </td><td>" . $myrow["printer_date_purchased"] . "</td></tr>\n";
echo "<tr><td>Dollar Value: </td><td>\$" . $myrow["printer_value"] . "</td></tr>\n";
echo "<tr><td valign=\"top\">Description: </td><td>" . $myrow["printer_description"] . "</td></tr>\n";
echo "<tr><td><form action=\"printer_edit.php?printer=" . $_GET['printer'] . "\" method=\"post\"><input name=\"Submit\" value=\" Edit \" type=\"submit\" class=\"content\" /></form></td></tr>\n";
$SQL2 = "SELECT * from nmap_other_ports WHERE nmap_other_id = '" . $myrow["printer_mac_address"] . "' ORDER BY nmap_port_number";
$result2 = mysql_query($SQL2, $db);
if ($myrow2 = mysql_fetch_array($result2)) {
echo "<tr><td class=\"contenthead\" colspan=\"2\"><br /><img src=\"images/inv_nmap" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" /> Nmap detected open ports</td></tr>\n";
echo "<tr><td>Port Number</td><td>Port Name</td></tr>\n";
do {
echo "<tr bgcolor=\"" . $bgcolor . "\"><td>" . $myrow2["nmap_port_number"] . "</td><td>" . $myrow2["nmap_port_name"] . "</td></tr>";
$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 {
$show_value = $myrow[$field["name"]];
}
if (!isset($field["align"])) {
$field["align"] = " ";
{
$date = explode(".", $date);
return date("r", strtotime($date[0] . "." . $date[1] . ".20" . $date[2]));
}
$Rss = new CRss();
$Rss->Title = "Новости казино";
$Rss->Link = "http://azartsoft.co.cc/";
$Rss->Copyright = "© 2009 azartsoft.co.cc";
$Rss->Description = "Новостная RSS рассылка казино";
$Rss->Category = "Азартные игры онлайн";
$Rss->Language = "ru";
$Rss->ManagingEditor = "*****@*****.**";
$Rss->WebMaster = "*****@*****.**";
$Rss->LastBuildDate = date("r");
$line = mysql_fetch_row(mysql_query("select data FROM news ORDER by data\ndesc Limit 0,1"));
$Rss->LastBuildDate = return_date($line[0]);
$Rss->PubDate = $Rss->LastBuildDate;
$Rss->PrintHeader();
$result = mysql_query("select * from news ORDER BY `id` DESC ", $full_base);
while ($row = mysql_fetch_array($result)) {
// для каждой записи выведем
$Title = maxsite_str_word($row['news']);
$Description = str_replace("<br>", "\r\n", $row['news']);
$Link = "http://azartsoft.co.cc/";
$PubDate = return_date($row['data']);
$Category = "Новости сайта";
$Rss->PrintBody($Title, $Link, $Description, $Category, $PubDate);
}
$Rss->PrintFooter();
?>
$row_f = mysqli_fetch_array($table_id_f);
?>
<tr>
<td>Filter</td>
<td><?php
echo return_device_data($row_f['device_id'], $row_f['device_name'], $row_f['device_thumb_url'], false);
?>
</td>
</tr>
<?php
}
?>
<tr>
<td>Date & time</td>
<td><?php
echo return_date($row['observation_datetime'], null, 'line');
?>
</td>
</tr>
<tr>
<td>Magnification</td>
<td><?php
echo return_magnification($dbc, $observation_id, 'observation', strtolower($row['device_type_name']));
?>
</td>
</tr>
<tr>
<td>Level</td>
<td><?php
echo return_level_data($row['level_id'], $row['level_description'], null);
?>
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 "";
}
function GetDetectedSoftwareData($id)
{
global $db, $days_software_detected;
$tr_class = 'npb_highlight_row';
$sql = "SELECT sw.software_name, sw.software_first_timestamp, sys.system_name, sys.system_uuid, sys.net_ip_address ";
$sql .= "FROM software sw, system sys ";
$sql .= "WHERE sw.software_first_timestamp >= '" . adjustdate(0, 0, -$days_software_detected) . "000000' ";
$sql .= "AND sys.system_first_timestamp < '" . adjustdate(0, 0, -$days_software_detected) . "000000' ";
$sql .= "AND sw.software_name NOT LIKE '%Hotfix%' AND sw.software_name NOT LIKE '%Service Pack%' AND sw.software_name NOT REGEXP '[KB|Q][0-9]{6,}' ";
$sql .= "AND sw.software_timestamp = sys.system_timestamp ";
$sql .= "AND sw.software_uuid = sys.system_uuid ";
$sql .= "ORDER BY sw.software_name";
$result = mysql_query($sql, $db) or die(mysql_error());
$count = mysql_numrows($result);
echo "<div class='npb_content_data' id='" . $id . "' style='display: none;'>";
if ($myrow = mysql_fetch_array($result)) {
echo "<table>";
echo " <tr>";
echo "\t\t<th>" . __("IP Address") . "</td>";
echo " \t<th>" . __("Hostname") . "</td>";
echo " \t<th>" . __("Date Audited") . "</td>";
echo " \t<th>" . __("Software") . "</td>";
echo "</tr>";
do {
echo "<tr class='" . alternate_tr_class($tr_class) . "'>";
echo "\t<td>" . ip_trans($myrow["net_ip_address"]) . "</td>";
echo "\t<td><a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\">" . $myrow["system_name"] . "</a></td>";
echo "\t<td>" . return_date($myrow["software_first_timestamp"]) . "</td>";
echo "\t<td>" . $myrow["software_name"] . "</td>";
echo "\t</tr>";
} while ($myrow = mysql_fetch_array($result));
}
echo "</table>";
echo "</div>";
echo "<p class='npb_section_summary'>" . __("Packages") . ": " . $count . "</p>";
return;
}
function return_observation_list($dbc, $max_observations, $id, $select_type)
{
$return_data;
$return_data .= '<table>
<tr>' . "\n" . '
<th>Date</th>' . "\n" . '
<th>Observed By</th>' . "\n" . '
<th>Level</th>' . "\n" . '
<th>Messier</th>' . "\n" . '
<th>NGC</th>' . "\n" . '
<th>Name</th>' . "\n";
if ($select_type != 'astronomical_object') {
$return_data .= '<th>Type</th>' . "\n";
}
$return_data .= '<th>Device used</th>' . "\n";
if (isset($_SESSION['user_id'])) {
$return_data .= '<th>Loc</th>' . "\n";
}
$return_data .= '<!--<th>Links</th>-->' . "\n" . '
</tr>' . "\n";
$query = 'SELECT observations.observation_id, observations.observation_datetime, observations.level_id, observations.latitude, observations.longitude, observations.notes, astronomical_objects.object_id, astronomical_objects.object_name, astronomical_objects.object_thumb_url, astronomical_objects.object_url_wikipedia, astronomical_objects_types.object_type_name, astronomical_objects_types.object_type_thumb_url, astronomical_objects_types.object_type_url_wikipedia, users.user_id, users.user_first_name, users.user_surname, users.user_avatar_url, observations_levels.level_description, devices.device_id, devices.device_name, devices.device_thumb_url
FROM observations
INNER JOIN users
USING (user_id)
INNER JOIN astronomical_objects
USING (object_id)
INNER JOIN observations_levels
USING (level_id)
INNER JOIN devices
USING (device_id)
INNER JOIN astronomical_objects_types
USING (object_type_id)';
if ($select_type == 'user' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE user_id=' . $id;
} else {
if ($select_type == 'device' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE device_id=' . $id;
} else {
if ($select_type == 'eyepiece_device' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE eyepiece_device_id=' . $id;
} else {
if ($select_type == 'filter_device' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE filter_device_id=' . $id;
} else {
if ($select_type == 'astronomical_object' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE object_id=' . $id;
}
}
}
}
}
$query .= ' ORDER BY observations.observation_datetime DESC';
if (is_int($max_observations)) {
$query .= ' LIMIT 0,' . $max_observations;
}
$table_id = mysqli_query($dbc, $query);
if (mysqli_num_rows($table_id) == 0) {
$return_data .= '<tr><td></td><td>No observations yet</td><td></td><td></td><td></td><td></td>';
if ($select_type != 'astronomical_object' && !is_int(intval($id)) && $id <= 0) {
$return_data .= '<td></td>';
}
if (isset($_SESSION['user_id'])) {
$return_data .= '<td></td>';
}
$return_data .= '<td></td><td></td></tr>';
}
while ($row = mysqli_fetch_array($table_id)) {
$return_data .= '<tr>' . "\n";
$return_data .= '<td>';
$return_data .= return_date($row['observation_datetime'], $row['observation_id'], null);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_user_observation_data($row['user_id'], $row['user_first_name'], $row['user_avatar_url'], 'default');
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_level_data($row['level_id'], $row['level_description'], $row['notes']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$query = 'SELECT list_object_number FROM astronomical_objects_lists_objects WHERE list_id=1 AND object_id=' . $row['object_id'];
$table_id_messier = mysqli_query($dbc, $query);
$row_messier = mysqli_fetch_array($table_id_messier);
$return_data .= return_messier_number($row_messier['list_object_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$query = 'SELECT list_object_number FROM astronomical_objects_lists_objects WHERE list_id=3 AND object_id=' . $row['object_id'];
$table_id_ngc = mysqli_query($dbc, $query);
$row_ngc = mysqli_fetch_array($table_id_ngc);
$return_data .= return_ngc_number($row_ngc['list_object_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_name_data($row['object_id'], $row['object_name'], $row['object_url_wikipedia'], $row['object_thumb_url']);
$return_data .= '</td>' . "\n";
if ($select_type != 'astronomical_object') {
$return_data .= '<td>';
$return_data .= return_object_type_data($row['object_type_name'], $row['object_type_url_wikipedia'], $row['object_type_thumb_url'], '');
$return_data .= '</td>' . "\n";
}
$return_data .= '<td>';
$return_data .= return_device_data($row['device_id'], $row['device_name'], $row['device_thumb_url'], false);
$return_data .= '</td>' . "\n";
if (isset($_SESSION['user_id'])) {
$return_data .= '<td>';
$return_data .= return_location_icon($row['latitude'], $row['longitude']);
$return_data .= '</td>' . "\n";
}
//echo '<td><a href="' . $row['object_url_wikipedia'] . '"><img src="images/link_wiki.png" /></a></td>' . "\n";
$return_data .= '</tr>' . "\n";
}
$return_data .= '</table>' . "\n";
return $return_data;
}
