} if ($query1 != '' && $query2 != '' && $columns != '') { $db = new ossim_db(true); $conn = $db->connect(); $curid = 0; $name = str_replace('"', '', $name); $query = "SELECT id FROM custom_report_types WHERE name=\"{$name}\" and file='SIEM/CustomList.php'"; $rs = $conn->Execute($query); if (!$rs) { Av_exception::write_log(Av_exception::DB_ERROR, $conn->ErrorMsg()); } else { if (!$rs->EOF) { $curid = $rs->fields['id']; } } $id = Av_report::get_new_report_module_id($conn); if ($curid > 0) { $sql = "UPDATE custom_report_types SET name=?,type='Custom Security Events',file='SIEM/CustomList.php',inputs='Number of Events:top:text:OSS_DIGIT:25:1000',custom_report_types.sql=? WHERE id=?"; $params = array($name, "{$query1};{$query2};{$columns}", $curid); } else { $sql = "INSERT INTO custom_report_types (id,name,type,file,inputs,custom_report_types.sql) VALUES (?,?,'Custom Security Events','SIEM/CustomList.php','Number of Events:top:text:OSS_DIGIT:25:1000',?)"; $params = array($id, $name, "{$query1};{$query2};{$columns}"); } if ($conn->Execute($sql, $params)) { $msg = $curid > 0 ? _("Report Module") . " <b>'Custom Security Events - {$name}'</b> " . _("successfully updated") : _("Report Module successfully created as") . " <b>'Custom Security Events - {$name}'</b>"; $msg_type = 'nf_success'; } else { Av_exception::write_log(Av_exception::DB_ERROR, $conn->ErrorMsg()); $msg = _("Error creating a new report type."); $msg_type = 'nf_error'; }