$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">