function delete_file() { /* [_POST] => Array ( [_database] => biochemistry [_tablename] => equipment_record [_pri_id] => 11 [_attachment_id] => 14 [attachment_name] => [action] => delete_file ) */ $wr = make_where($_POST); //echo $wr; if (strlen($wr) > 0) { //echo $wr; $sql_attachment = 'delete from attachment where id=\'' . $_POST['_attachment_id'] . '\''; $sql_link = 'update `' . $_POST['_tablename'] . '` set attach=\'0\' where ' . $wr; //echo $sql_attachment.'<br>'; //echo $sql_link.'<br>'; $link = mysql_connect('127.0.0.1', $_SESSION['login'], $_SESSION['password']); mysql_select_db('attachment', $link); if (!($result = mysql_query($sql_attachment, $link))) { echo mysql_error(); } else { echo mysql_affected_rows($link) . ' attachment id=' . $_POST['_attachment_id'] . ' deleted in attachment database<br>'; mysql_select_db($_POST['_database'], $link); if (!($result = mysql_query($sql_link, $link))) { echo mysql_error(); } } } }
} else { while (!$rg->EOF) { if ($rg->fields["name"] == "") { $rg->fields["name"] = _("Unknown category"); } $data .= "['" . str_replace("_", " ", $rg->fields["name"]) . "'," . $rg->fields["num_events"] . "],"; $urls .= "'" . $forensic_link . "&category%5B0%5D=" . $rg->fields["cat_id"] . "&category%5B1%5D=" . $rg->fields["id"] . "',"; $rg->MoveNext(); } } $colors = '"#D1E8EF","#ADD8E6","#6FE7FF","#00BFFF","#4169E1","#4682B4","#0000CD","#483D8B","#5355DF","#00008B"'; break; // System status - Last Week // System status - Last Week case "system": $taxonomy = make_where($conn, array("System" => array("Warning", "Emergency", "Critical", "Error", "Notification", "Information", "Debug", "Alert"))); $sqlgraph = str_replace("TAXONOMY", $taxonomy, $query); //print_r($sqlgraph); if (!($rg =& $conn->Execute($sqlgraph))) { print $conn->ErrorMsg(); } else { while (!$rg->EOF) { if ($rg->fields["name"] == "") { $rg->fields["name"] = _("Unknown category"); } $data .= "['" . str_replace("_", " ", $rg->fields["name"]) . "'," . $rg->fields["num_events"] . "],"; $urls .= "'" . $forensic_link . "&category%5B0%5D=" . $rg->fields["cat_id"] . "&category%5B1%5D=" . $rg->fields["id"] . "',"; $rg->MoveNext(); } } $colors = '"#FFFBCF","#EEE8AA","#F0E68C","#FFD700","#FF8C00","#DAA520","#D2691E","#B8860B","#7F631F"';