I'm guessing you want something like this:
Patch software_register_details.php [code] Index: software_register_details.php =================================================================== --- software_register_details.php (revision 1251) +++ software_register_details.php (working copy) @@ -36,7 +36,7 @@ $sql2 = "SELECT sum(license_purchase_number) as number_purchased FROM "; $sql2 .= "software_licenses, software_register WHERE "; $sql2 .= "license_software_id = software_reg_id AND "; - $sql2 .= "software_title = '" . $myrow['software_title'] . "'"; + $sql2 .= "software_title = '" . mysql_real_escape_string($myrow['software_title']) . "'"; $result2 = mysql_query($sql2, $db); $myrow2 = mysql_fetch_array($result2); @@ -112,7 +112,7 @@ } else {} $bgcolor = "#F1F1F1"; -$sql = "select sys.system_uuid, sys.system_os_name, sys.system_description, sys.net_ip_address, sys.system_name, sw.software_name from "; +$sql = "select sys.system_uuid, sys.system_os_name, sys.system_description, sys.net_ip_address, sys.system_name, sw.software_name, sys.net_user_name from "; $sql .= "software sw, system sys where "; $sql .= "sw.software_name = '" . addslashes($name) . "' AND "; $sql .= "sw.software_uuid = sys.system_uuid AND "; @@ -123,12 +123,13 @@ if ($myrow = mysql_fetch_array($result)){ echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" class=\"content\">\n"; echo "<tr><td class=\"contenthead\" colspan=\"3\"><br />Systems with \"" . $name . "\" installed.</td></tr>\n"; - echo "<tr><td> <b>IP Address</b></td><td> <b>Name</b></td><td> <b>Description</b></td></tr>\n"; + echo "<tr><td> <b>IP Address</b></td><td> <b>Name</b></td><td> <b>Description</b></td><td> <b>Current User</b></td></tr>\n"; do { echo "<tr bgcolor=\"" . $bgcolor . "\">\n"; - echo " <td width=\"33%\"> " . $myrow["net_ip_address"] . " </td>\n"; - echo " <td width=\"33%\"> <a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\" class=\"content\">" . $myrow["system_name"] . "</a> </td>\n"; - echo " <td width=\"33%\"> " . $myrow["system_description"] . "</td>\n"; + echo " <td width=\"20%\"> " . $myrow["net_ip_address"] . " </td>\n"; + echo " <td width=\"25%\"> <a href=\"system.php?pc=" . $myrow["system_uuid"] . "&view=summary\" class=\"content\">" . $myrow["system_name"] . "</a> </td>\n"; + echo " <td width=\"30%\"> " . $myrow["system_description"] . "</td>\n"; + echo " <td width=\"25%\"> " . $myrow["net_user_name"] . "</td>\n"; echo "</tr>\n"; if ($bgcolor == "#F1F1F1") { $bgcolor = "#FFFFFF"; } else { $bgcolor = "#F1F1F1"; } [/code]
Or replace it with the following file after removing the .txt extension.
|