$div_clean = str_replace('#', '', $div_clean);
$div_clean = str_replace('{', '', $div_clean);
$div_clean = str_replace('}', '', $div_clean);
$div_clean = str_replace('|', '', $div_clean);
$div_clean = str_replace('\\', '', $div_clean);
$div_clean = str_replace('^', '', $div_clean);
$div_clean = str_replace('~', '', $div_clean);
$div_clean = str_replace('[', '', $div_clean);
$div_clean = str_replace(']', '', $div_clean);
$div_clean = str_replace('`', '', $div_clean);
return $div_clean;
}
if (isset($_GET['act'])) {
$package = $_GET['act'];
} else {
$package = '';
}
$sql = "SELECT count(*) AS count FROM software_register WHERE software_title = '{$package}'";
mysql_connect($mysql_server, $mysql_user, $mysql_password) or die("Could not connect");
mysql_select_db($mysql_database) or die("Could not select database");
$result = mysql_query($sql) or die('<td>Insert Failed: ' . mysql_error() . '<br />' . $sql . "</td>");
$myrow = mysql_fetch_array($result);
if ($myrow["count"] == "0") {
$sql = "INSERT INTO software_register (software_title) VALUES ('{$package}')";
$result = mysql_query($sql) or die('<td>Insert Failed: ' . mysql_error() . '<br />' . $sql . "</td>");
$id = mysql_insert_id();
$sql = "INSERT INTO software_licenses (license_software_id, license_purchase_number, license_comments) VALUES ('{$id}', '0', 'OA initial license')";
$result = mysql_query($sql) or die('<td>Insert Failed: ' . mysql_error() . '<br />' . $sql . "</td>");
# echo "Added '$package' to the software register.";
echo "s" . div_clean($package);
}
echo " <tr>\n";
echo " <td><b>Count</b></td>\n";
echo " <td> <b>Package Name</b></td>\n";
echo " <td align=\"center\"><b>Tick to Add</b></td>\n";
echo " </tr>\n";
do {
if ($bgcolor == "#F1F1F1") {
$bgcolor = "#FFFFFF";
} else {
$bgcolor = "#F1F1F1";
}
echo "<tr bgcolor=\"" . $bgcolor . "\">\n";
echo " <td align=left>" . $myrow["count(software_name)"] . "</td>\n";
echo " <td align=left> " . $myrow["software_name"] . "</td>\n";
echo "<td>";
echo "<div id=\"s" . div_clean($myrow["software_name"]) . "\">";
echo "<a href=\"#\" onclick=\"sendRequest('" . url_clean($myrow["software_name"]) . "');\"><img border=\"0\" src=\"images/button_success.png\" width=\"16\" height=\"16\" alt=\"\" /></a>";
echo "</div>\n";
echo "</td>\n";
echo "<td valign=\"top\">\n";
echo "</tr>";
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "No Software in database.";
}
echo "</div>\n";
echo "</td>\n";
?>
<script language="javascript" TYPE="text/javascript">
