$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo " <tr>\n";
echo " <td align=\"center\" width=\"100\"><a href=\"list_software.php?sub=" . $sub . "&page_count=" . $page_current . "&sort=software_count\"><b>Count</b></a></td>\n";
echo " <td width=\"450\"><a href=\"list_software.php?sub=" . $sub . "&page_count=" . $page_current . "&sort=software_name\"><b>Package Name</b></a></td>\n";
echo " <td align=\"center\" width=\"150\"><b>Google Search</b></td></tr>\n";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo " <tr bgcolor=\"" . $bgcolor . "\">\n";
echo " <td align=\"center\"><a href=\"list_software.php?sub=sw1&name=" . url_clean($myrow["software_name"]) . "\" title=\"Show All Systems with this software\">" . $myrow["software_count"] . "</a></td>\n";
echo " <td>" . $myrow["software_name"] . "</td>\n";
echo " <td align=\"center\"><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . url_clean($myrow["software_name"]) . "%22&btnG=Search\"><img border=0 alt=\"Google Search\" title=\"Google Search\" src=\"images/button_google.gif\" /></a></td>\n";
echo " </tr>\n";
} while ($myrow = mysql_fetch_array($result));
$total = mysql_query($SQL_count, $db);
$num_rows = mysql_num_rows($total);
echo " <tr>\n <td colspan=2><br /><b>Total Software Packages: " . $num_rows . "</b></td>\n";
} else {
echo "<tr><td><br />No Software in database.</td></tr>";
}
if ($count_system != "10000") {
echo " <td align=\"center\"><br />\n";
echo " <a href=\"list_software.php?sub=" . $sub . "&page_count=" . $page_prev . "&sort=" . $sort . "\"><img src=\"" . $but_bac . "\" border=0 alt=\"Previous " . $count_system . " Systems\" title=\"Previous " . $count_system . " Systems\" width=\"16\" height=\"16\" /></a> \n";
echo " <a href=\"list_software.php?sub=" . $sub . "&page_count=0&show_all=1&sort=" . $sort . "\"><img src=\"" . $but_all . "\" border=0 alt=\"All Systems\" title=\"All Systems\" width=\"16\" height=\"16\" /></a> \n";
echo " <a href=\"list_software.php?sub=" . $sub . "&page_count=" . $page_next . "&sort=" . $sort . "\"><img src=\"" . $but_for . "\" border=0 alt=\"Next " . $count_system . " Systems\" title=\"Next " . $count_system . " Systems\" width=\"16\" height=\"16\" /></a>\n";
echo " </td>\n";
} else {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr>\n";
echo "<td width=\"150\" align=\"center\"><b>PCs without patch</b></td>\n";
echo "<td width=\"150\" align=\"center\"><b>Q Number</b></td>\n";
echo "<td width=\"150\" align=\"center\"><b>Link</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 align=\"center\"><a href=\"list_missing_patches.php?sub=sw1&name=" . url_clean($myrow["qno"]) . "\" class=\"content\">" . $myrow["count"] . "</a></td>\n";
echo "<td align=\"center\"><a href=\"list_missing_patches.php?sub=sw2&name=" . url_clean($myrow["qno"]) . "\" class=\"content\">" . $myrow["qno"] . "</a></td>\n";
echo "<td align=\"center\"><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . $myrow["qno"] . "%22&btnG=Search\"><img border=0 alt=\"Google Search\" title=\"Google Search\" src=\"images/button_kb.gif\" /></a></td>\n";
echo "</tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
echo "</div>";
} else {
}
echo "</div>";
} else {
}
echo "<div class=\"main_each\">\n";
$count = 0;
$bgcolor = "#FFFFFF";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr>\n";
include "include.php";
echo "<div class=\"main_each\"><p class=\"contenthead\">Add Package to Software License Register.</p>";
$SQL = "SELECT count(software_name), software_name from software WHERE software_name NOT LIKE '%hotfix%' group by software_name ORDER BY software_name";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\">";
echo "<tr><td>Count</td><td>Package Name</td><td align=\"center\">Click to Add</td></tr>";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">";
echo "<td align=\"center\">" . $myrow["count(software_name)"] . "</td>";
echo "<td> " . $myrow["software_name"] . "</td>";
echo "<td align=\"center\"><a href=\"software_register_add.php?package=" . url_clean($myrow["software_name"]) . "\"><img border=\"0\" src=\"images/button_ok.png\" width=\"16\" height=\"16\" alt=\"\" /></a></td>";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));
} else {
echo "No Software in database.";
}
?>
</table>
</div>
</div>
</body>
</html>
<?php
include "include_png_replace.php";
}
<?php
$sql = "";
$page = "other";
include "include.php";
$SQL = "SELECT * FROM other WHERE other_id = '" . $_GET['other'] . "'";
$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/other_devices/" . url_clean($myrow["other_type"]) . ".png\" width=\"32\" height=\"32\" alt=\"\" /> " . $myrow["other_name"] . "</td></tr>";
echo "<tr><td>Name: </td><td>" . $myrow["other_name"] . "</td></tr>";
echo "<tr><td>Type: </td><td>" . $myrow["other_type"] . "</td></tr>";
$SQL2 = "select * from system WHERE system_uuid = '" . $myrow["other_linked_pc"] . "'";
$result2 = mysql_query($SQL2, $db);
if ($myrow2 = mysql_fetch_array($result2)) {
do {
echo "<tr><td>Associated with PC: </td><td>" . $myrow2["net_ip_address"] . " - " . $myrow2["system_name"] . "</td></tr>\n";
} while ($myrow2 = mysql_fetch_array($result2));
} else {
echo "<tr><td>Associated with PC: </td><td>" . $myrow["other_linked_pc"] . "</td></tr>\n";
}
echo "<tr><td>IP Address: </td><td>" . ip_trans($myrow["other_ip"]) . "</td></tr>\n";
echo "<tr><td>MAC Address: </td><td>" . $myrow["other_mac_address"] . "</td></tr>\n";
echo "<tr><td>Date Discovered: </td><td>" . $myrow["other_date_detected"] . "</td></tr>\n";
echo "<tr><td>Manufacturer: </td><td>" . $myrow["other_manufacturer"] . "</td></tr>\n";
echo "<tr><td>Model Number: </td><td>" . $myrow["other_model"] . "</td></tr>\n";
echo "<tr><td>Serial Number: </td><td>" . $myrow["other_serial"] . "</td></tr>\n";
echo "<tr><td>Physical Location: </td><td>" . $myrow["other_location"] . "</td></tr>\n";
echo "<tr><td>Date of Purchase: (yyyy-mm-dd) </td><td>" . $myrow["other_date_purchase"] . "</td></tr>\n";
echo "</tr>";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td align=\"center\" width=\"100\"><b>Count</b></td>";
echo "<td width=\"100\"><b>Q Number</b></td>";
echo "<td align=\"center\" width=\"150\"><b>KB Article</b></td></tr>";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">";
echo "<td align=\"center\"><a href=\"list_missing_patches.php?sub=sw1&name=" . url_clean($myrow["ss_qno"]) . "\" alt=\"Show All Systems with this software\" title=\"Show All Systems with this software\" class=\"content\">" . $myrow["count(ss_qno)"] . "</a></td>";
echo "<td><a href=\"list_missing_patches.php?sub=sw2&name=" . url_clean($myrow["ss_qno"]) . "\" alt=\"Show Patch Details\" title=\"Show Patch Details\" class=\"content\">" . $myrow["ss_qno"] . "</a></td>";
echo "<td align=\"center\"><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . $myrow["ss_qno"] . "%22&btnG=Search\"><img border=0 alt=\"Google Search\" title=\"Google Search\" src=\"images\\button_kb.gif\"></a></td>";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));
echo "<tr><td colspan=3><br /> </td>";
} else {
echo "No Missing Patches.";
}
if ($count_system != "10000") {
echo "<td align=\"center\"><br />";
echo "<a href=\"list_missing_patches.php?sub=" . $sub . "&page_count=" . $page_prev . "\"><img src=\"images/button_back.png\" border=0 alt=\"Previous " . $count_system . " Systems\" title=\"Previous " . $count_system . " Systems\" width=\"18\" height=\"18\" /></a> ";
echo "<a href=\"list_missing_patches.php?sub=" . $sub . "&page_count=0&show_all=1\"><img src=\"images/button_all.png\" border=0 alt=\"All Systems\" title=\"All Systems\" width=\"16\" height=\"16\" /></a> ";
echo "<a href=\"list_missing_patches.php?sub=" . $sub . "&page_count=" . $page_next . "\"><img src=\"images/button_forward.png\" border=0 alt=\"Next " . $count_system . " Systems\" title=\"Next " . $count_system . " Systems\" width=\"16\" height=\"16\" /></a>";
echo "</td>";
} else {
echo "<td></td>";
if (isset($_GET['sort'])) {
$sort = $_GET['sort'];
} else {
$sort = "other_ip";
}
$SQL = "SELECT * FROM other WHERE other_mac_address IS NULL ORDER BY " . $sort;
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo "<td align=\"center\"><img src=\"images/other_devices/" . url_clean($myrow["other_type"]) . ".png\" width=\"33\" height=\"33\" alt=\"" . $myrow["other_type"] . "\" title=\"" . $myrow["other_type"] . "\" /> </td>\n";
echo "<td> <a href=\"other_summary.php?other=" . $myrow["other_id"] . "&sub=1\">" . $myrow["other_name"] . "</a> </td>\n";
echo "<td> " . $myrow["other_description"] . " </td>\n";
echo "<td> " . $myrow["other_model"] . "</td>\n";
echo "</tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
} else {
}
} else {
}
if ($id == "4") {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr><td align=\"left\" colspan=\"4\" class=\"contenthead\">List All Network Printers.</td></tr>\n";
echo "<tr>\n";
echo "<td> <a href=\"other_list.php?id=4&sort=other_ip&pc=\">IP Address</a> </td>\n";
echo " <td align=\"center\"><b>Google Search</b></td>\n";
echo " <td align=\"center\"><b>KB Article</b>\n </td>\n </tr>\n";
do {
if ($myrow['hotfix_hot_fix_id'] == "File 1") {
} else {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo " <tr bgcolor=\"" . $bgcolor . "\">\n";
echo " <td align=\"center\"><a href=\"list_software_hotfixes.php?sub=sw1&name=" . url_clean($myrow["hotfix_hot_fix_id"]) . "\" title=\"Show All Systems with this hotfix\">" . $myrow["count(hotfix_hot_fix_id)"] . "</a></td>\n";
echo " <td> " . $myrow["hotfix_hot_fix_id"] . " </td>\n";
echo " <td> " . $myrow['hotfix_description'] . " </td>\n";
echo " <td align=\"center\"><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . url_clean($myrow["hotfix_hot_fix_id"]) . "%22&btnG=Search\"><img border=0 alt=\"Google Search\" title=\"Google Search\" src=\"images/button_google.gif\" /></a></td>\n";
echo " <td align=\"center\"><a href=\"http://support.microsoft.com/default.aspx?scid=kb;en-us;" . url_clean($myrow["hotfix_hot_fix_id"]) . "\"><img border=0 alt=\"Knowledge Base Article\" title=\"Knowledge Base Article\" src=\"images/button_kb.gif\" height=\"16\" /></a></td>\n";
echo " </tr>\n";
}
} while ($myrow = mysql_fetch_array($result));
$total = mysql_query($SQL_count, $db);
$num_rows = mysql_num_rows($total);
echo " <tr>\n <td colspan=3><b>Total Hotfixes: " . $num_rows . "</b>\n </td>\n </tr>\n";
} else {
echo "No hotfixes found.";
}
echo "</table>\n";
echo "<table width=\"100%\">\n";
echo " <tr>\n";
if ($count_system != "10000") {
echo " <td align=\"right\">";
echo " <a href=\"list_software_hotfixes.php?sub=" . $sub . "&page_count=" . $page_prev . "\"><img src=\"" . $but_bac . "\" border=\"0\" alt=\"Previous " . $count_system . " Systems\" title=\"Previous " . $count_system . " Systems\" width=\"16\" height=\"16\" /></a> \n";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">";
echo "<td align=left><a href=\"software_register_details.php?id=" . $myrow["software_reg_id"] . "\">" . $myrow["software_title"] . "</a> </td>";
if ($number_purchased == -1) {
echo "<td align=\"center\">Free</td>";
} else {
echo "<td align=\"center\">" . $number_purchased . "</td>";
}
//echo "<td align=\"center\">" . $number_used . "</td>";
/*if ($number_purchased == -1) {
echo "<td align=\"center\"></td>";
} else {
echo "<td align=\"center\">" . $font . $number_audit . "</font></td>";
}*/
echo "<td align=\"center\"><div id=\"s" . $myrow['software_reg_id'] . "\">\n";
echo "<a href=\"#\" onclick=\"sendRequest('" . url_clean($myrow["software_reg_id"]) . "');\"><img border=\"0\" src=\"images/button_fail.png\" width=\"16\" height=\"16\" alt=\"\" /></a>";
echo "</div></td>\n";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
} else {
echo "<p class=\"content\"><span style='float:left;'>No Packages in database.</span><span style='float:right;'><a href=software_register_add.php><b>Add Software</b></a></span></p>";
}
echo "</div>\n";
echo "</td>\n";
?>
<script language="javascript" TYPE="text/javascript">
function createRequestObject() {
var req;
if(window.XMLHttpRequest){
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\" width=\"100%\">\n";
echo "<tr><td class=\"menuhead\"><img src=\"images/inv_software" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />Installed Non-Microsoft Codecs</td></tr>\n";
$bgcolor = "#F1F1F1";
echo "<tr><td>Application Name</td><td>Version</td><td>Publisher</td><td align=\"center\">Google</td></tr>\n";
do {
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo "<td><a href=\"list_software.php?sub=sw1&name=" . url_clean($myrow["software_name"]) . "\">" . $myrow["software_name"] . "</a></td>\n";
echo "<td>" . $myrow["software_version"] . "</td>\n";
echo "<td>";
if ($myrow["software_url"]) {
echo "<a href=\"" . $myrow["software_url"] . "\">" . $myrow["software_publisher"] . "</a></td>\n";
} else {
echo $myrow["software_publisher"] . "</td>\n";
}
echo "<td align=\"center\"><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=" . str_replace("-", "", url_clean($myrow["software_name"])) . "&btnG=Search\"><img border=\"0\" alt=\"Google Search\" title=\"Google Search\" src=\"images/button_google.gif\" width=\"16\" height=\"16\" /></a></td>\n";
echo "</tr>";
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
} else {
echo "<p class=\"menuhead\"><img src=\"images/inv_software" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" /> No Software installed.</p>";
}
echo "</div>";
echo "</body>";
echo "</html> ";
include "include_png_replace.php";
$results = mysql_query($SQL, $db) or die("Error performing query");
if (mysql_num_rows($results) > 0) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr class=\"menuhead\"><td width=\"60%\">Processor</td><td width=\"20%\" align=\"right\">Number</td><td width=\"20%\" align=\"right\">Percentage</td></tr>\n";
while ($row = mysql_fetch_object($results)) {
$SQL2 = "select * from processor WHERE processor_name = '" . $row->processor_name . "'";
$results2 = mysql_query($SQL2, $db) or die("Error performing query");
$percent = round(mysql_num_rows($results2) / $total_processors * 100, 2);
$total_percent = $total_percent + $percent;
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo "<td align=\"left\"><a href=\"statistics.php?sub=s15&proc=" . url_clean($row->processor_name) . "&sort=net_ip_address\">" . $row->processor_name . "</a></td>\n";
echo "<td align=\"right\">" . mysql_num_rows($results2) . " </td>\n";
echo "<td align=\"right\">" . $percent . " </td>\n";
echo "</tr>\n";
}
} else {
echo "<p class=\"contenthead\">Processor Type</p><p>No Processors in database.</p>\n";
}
echo "<tr>\n";
echo "<td align=\"left\">Total Processors</td>\n";
echo "<td align=\"right\">" . $total_processors . " </td>\n";
echo "<td align=\"right\">" . $total_percent . " </td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td align=\"left\">Total Systems</td>\n";
echo "<td align=\"right\">" . $total_pcs . " </td>\n";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\" width=\"100%\">\n";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td><b>System</b></td>\n";
echo "<td><b>Manufacturer</b></td>\n";
echo "<td><b>Model</b></td>\n";
echo "<td><b>Serial</b></td></tr>\n";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo "<td><a href=\"system_summary.php?pc=" . url_clean($myrow["system_uuid"]) . "\" title=\"\">" . $myrow["system_name"] . "</a></td>\n";
echo "<td>" . $myrow["monitor_manufacturer"] . "</td>\n";
echo "<td>" . $myrow["monitor_model"] . "</td>\n";
echo "<td>" . $myrow["monitor_serial"] . "</td>\n";
echo "</tr>\n";
} while ($myrow = mysql_fetch_array($result));
$num_rows = mysql_num_rows($result);
echo "<tr><td colspan=3><br /><b>Total Monitors: " . $num_rows . "</b></td>\n";
} else {
echo "<tr><td><br />No Monitors in database.</td></tr>";
}
echo "</table>";
if ($count_system != "10000") {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\" width=\"100%\">\n";
echo "<td align=\"right\"><br />\n";
echo "<a href=\"list_monitors.php?sub=" . $sub . "&page_count=" . $page_prev . "\"><img src=\"" . $but_bac . "\" border=0 alt=\"Previous " . $count_system . " Systems\" title=\"Previous " . $count_system . " Systems\" width=\"16\" height=\"16\" /></a> \n";
} else {
}
if ($sub == "rs" or $sub == "all") {
$SQL = "SELECT * FROM startup WHERE startup_uuid = '{$pc}' AND startup_timestamp = '{$timestamp}' ORDER BY startup_location, startup_caption";
$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><td class=\"menuhead\" colspan=\"3\"><br /><img src=\"images/inv_startup" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />Run at Startup</td></tr>\n";
$bgcolor = "#FFFFFF";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\"><td><br /><b>Program Name:</b> <a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . url_clean($myrow["startup_caption"]) . "%22&btnG=Search\"><img border=\"0\" alt=\"Google Search\" title=\"Google Search\" src=\"images/button_google.gif\" width=\"16\" height=\"16\" /></a> <a href=\"list_software_startup.php?name=" . url_clean($myrow["startup_caption"]) . "\">" . $myrow["startup_caption"] . "</a></td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td><b>User:</b> " . $myrow["startup_user"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td><b>Location:</b> " . $myrow["startup_location"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td><b>Executable:</b> " . $myrow["startup_command"] . "<br /> </td></tr>\n";
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
} else {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\">";
echo "<tr>";
echo "<td class=\"contenthead\"><img src=\"images/inv_software" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />No Startup Items installed.</td>\n";
echo "</tr>";
echo "</table>";
}
} else {
}
echo "</div>";
echo "<div class=\"main_each\">";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\" width=\"100%\">";
echo "<tr>";
echo "<td align=\"left\" class=\"contenthead\">Currently installed Software for " . $name . "<br /> </td>";
echo "</tr>";
echo "</table>";
$SQL = "SELECT * FROM browser_helper_objects WHERE bho_uuid = '{$pc}' AND bho_timestamp = '{$timestamp}' ORDER BY bho_program_file";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"content\" width=\"700\">";
echo "<tr><td class=\"menuhead\"><img src=\"images/inv_ie" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />Internet Explorer Browser Helper Objects</td></tr>";
$bgcolor = "#F1F1F1";
do {
echo "<tr bgcolor=\"" . $bgcolor . "\"><td><br />";
echo "<a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=%22" . url_clean($myrow["bho_program_file"]) . "%22&btnG=Search\"><img border=\"0\" alt=\"Google Search\" title=\"Google Search\" src=\"images/button_google.gif\" width=\"16\" height=\"16\" /></a>";
echo " <a href=\"list_software_bho.php?sub=sw1&name=" . url_clean($myrow["bho_program_file"]) . "\">" . $myrow["bho_program_file"] . "</a>";
echo " - " . $myrow["bho_status"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td>" . $myrow["bho_code_base"] . "<br /> </td></tr>\n";
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
} while ($myrow = mysql_fetch_array($result));
echo "</table>";
} else {
echo "<p class=\"menuhead\"><img src=\"images/inv_ie" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" /> No IE BHO's installed.</p>";
}
echo "</div>";
echo "</body>";
echo "</html> ";
$SQL = "SELECT * from software_group_names WHERE group_id = '" . $_GET["group"] . "'";
$result = mysql_query($SQL, $db);
$myrow = mysql_fetch_array($result);
$title = "Group Members of Software Group " . $myrow["group_name"];
echo "<div class=\"main_each\">";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr><td class=\"contenthead\" colspan=\"4\">Group Members of " . $myrow["group_name"] . "</td></tr>\n";
echo "<tr>\n";
echo "<td align=\"left\">Software Title</td>\n";
echo "</tr>\n";
$SQL2 = "SELECT group_software_title FROM software_group_members WHERE group_id = '" . $_GET["group"] . "' ORDER BY group_software_title";
$result2 = mysql_query($SQL2, $db);
if ($myrow2 = mysql_fetch_array($result2)) {
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr>\n";
echo "<td align=\"left\" bgcolor=\"" . $bgcolor . "\"> <a href=\"list_software.php?sub=sw1&name=" . url_clean($myrow2["group_software_title"]) . "\" title=\"Show All Systems with this software\" class=\"content\">" . $myrow2["group_software_title"] . "</a> </td>\n";
echo "</tr>";
} while ($myrow2 = mysql_fetch_array($result2));
echo "<tr><td colspan=\"3\"><b>Total Software Titles: " . mysql_num_rows($result2) . "</b><br /> </td></tr>\n";
} else {
}
echo "</table>";
echo "</div>\n";
include "include_png_replace.php";
echo "</body>\n";
echo "</html>\n";
echo "<tr>\n";
echo "<td align=\"left\" class=\"contenthead\">Services Installed for " . $name . "<br /> </td>\n";
echo "</tr>\n";
echo "</table>\n";
$SQL = "SELECT * FROM service WHERE service_uuid = '{$pc}' AND service_timestamp = '{$timestamp}' ORDER BY service_display_name";
$result = mysql_query($SQL, $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n";
echo "<tr><td class=\"menuhead\"><img src=\"images/inv_services" . $pic_style . ".png\" width=\"64\" height=\"64\" alt=\"\" />Installed Services</td></tr>\n";
echo "</table>";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"700\" class=\"content\">\n";
do {
$SQL2 = "SELECT * FROM service_details WHERE sd_display_name = '" . $myrow["service_display_name"] . "'";
$result2 = mysql_query($SQL2, $db);
$myrow2 = mysql_fetch_array($result2);
echo "<tr bgcolor=\"" . $bgcolor . "\"><td valign=\"top\" width=\"100\">Name:</td><td><a href=\"http://www.google.com/search?num=30&hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&q=windows%22" . url_clean($myrow["service_display_name"]) . "%22service&btnG=Search\">" . $myrow["service_display_name"] . "</a></td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td valign=\"top\">Start Mode:</td><td>" . $myrow["service_start_mode"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td valign=\"top\">State:</td><td>" . $myrow["service_state"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td valign=\"top\">Started:</td><td>" . $myrow["service_started"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td valign=\"top\">Executable:</td><td>" . $myrow["service_path_name"] . "</td></tr>\n";
echo "<tr bgcolor=\"" . $bgcolor . "\"><td valign=\"top\">Description:</td><td>" . $myrow2["sd_description"] . "<br /> </td></tr>\n";
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
} while ($myrow = mysql_fetch_array($result));
?>
</table>
<?php
} else {