<?php /* Spiros Ioannou 2009 , sivann _at_ gmail.com */ if (!isset($initok)) { echo "do not run this script directly"; exit; } //form variables $formvars = array("itemtypeid", "function", "manufacturerid", "label", "warrinfo", "model", "sn", "sn2", "sn3", "locationid", "locareaid", "origin", "warrantymonths", "purchasedate", "purchprice", "dnsname", "userid", "comments", "maintenanceinfo", "ispart", "hd", "cpu", "cpuno", "corespercpu", "ram", "rackmountable", "rackid", "rackposition", "rackposdepth", "usize", "status", "macs", "ipv4", "ipv6", "remadmip", "panelport", "switchid", "switchport", "ports"); /* delete item */ if (isset($_GET['delid'])) { //first handle file associations //get a list of files associated with us $f = itemid2files($delid, $dbh); for ($fids = array(), $c = 0; $c < count($f); $c++) { array_push($fids, $f[$c]['id']); } //remove file links $sql = "DELETE from item2file where itemid={$delid}"; $sth = db_exec($dbh, $sql); //for each file: check if others link to it, and if not remove it: for ($c = 0; $c < count($fids); $c++) { $nlinks = countfileidlinks($fids[$c], $dbh); if ($nlinks == 0) { delfile($fids[$c], $dbh); } } //delete invoice links $sql = "DELETE from item2inv where itemid=" . $_GET['delid']; $sth = db_exec($dbh, $sql); //delete software links
echo " <option {$s} value='{$i}'>{$i}</option>\n"; } ?> </select> </td> </tr> </table> </td> </tr> <?php //Associated files // $f = itemid2files($id, $dbh); $flnk = showfiles($f); $f2 = itemid2invoicefiles($id, $dbh); $flnk .= showfiles($f2, 'fileslist2', 0, 'File of related invoice'); $f3 = itemid2contractfiles($id, $dbh); $flnk .= showfiles($f3, 'fileslist3', 0, 'File of related contract'); ?> <tr> <td class='tdtop' colspan=1> <!-- related item & software links --> <h3><?php te("Associations Overview"); ?> </h3> <div style='text-align:center'>