} if (isset($_GET['msg']) && $_GET['msg'] != "" && $_GET['msg'] != "undefined") { array_push($sql_filter, " (msg LIKE '%" . htmlentities($_GET['msg'], ENT_QUOTES) . "%') "); } $req_sql_filter = ""; if (isset($sql_filter)) { $req_sql_filter = join(" AND ", $sql_filter); } if ($req_sql_filter != "") { $req = "SELECT * FROM " . $cfg_syslog["db_table_logs"] . " WHERE " . $req_sql_filter . " ORDER BY datetime DESC LIMIT 50"; } else { $req = "SELECT * FROM " . $cfg_syslog["db_table_logs"] . " ORDER BY datetime DESC LIMIT 50"; } $DBRESULT =& $pearDB_syslog->query($req); $buffer = new SyslogXML(); $buffer->startElement("root"); $buffer->writeElement("label_datetime", _("Date / Time"), false); $buffer->writeElement("label_host", _("Host"), false); $buffer->writeElement("label_facility", _("Facility"), false); $buffer->writeElement("label_severity", _("Severity"), false); $buffer->writeElement("label_program", _("Program"), false); $buffer->writeElement("label_msg", _("Message"), false); $style = "list_two"; $priority_color = array('debug' => 'sev_debug', 'info' => 'sev_info', 'notice' => 'sev_notice', 'warning' => 'sev_warning', 'warn' => 'sev_warning', 'error' => 'sev_error', 'err' => 'sev_error', 'critical' => 'sev_critical', 'crit' => 'sev_critical', 'alert' => 'sev_alert', 'emerg' => 'sev_emerg'); if ($DBRESULT->numRows() == 0) { $buffer->startElement("error"); $buffer->writeElement("msg", _("No informations")); $buffer->endElement(); } else { while ($row =& $DBRESULT->fetchRow()) { $buffer->startElement("syslog");
header("Pragma: public"); echo "Start time : " . $start_sql; echo "\n"; echo "End time : " . $end_sql; echo "\n"; echo "\n"; echo "#datetime;host;facility;priority;program;msg;"; echo "\n"; while ($DBRESULT->fetchInto($data)) { echo $data["datetime"] . ";" . $data["host"] . ";" . $data["facility"] . ";" . $data["priority"] . ";" . $data["program"] . ";" . $data["msg"] . ";"; echo "\n"; } } else { if (strcmp($type, "XML") == 0) { $buffer = new SyslogXML(); $buffer->startElement("export"); $buffer->startElement("datetime"); $buffer->writeElement("start", $start_sql); $buffer->writeElement("end", $end_sql); $buffer->endElement(); while ($DBRESULT->fetchInto($data)) { $buffer->startElement("syslog"); $buffer->writeElement("datetime", $data["datetime"]); $buffer->writeElement("host", $data["host"]); $buffer->writeElement("facility", $data["facility"]); $buffer->writeElement("priority", $data["priority"]); $buffer->writeElement("program", $data["program"]); $buffer->writeElement("msg", utf8_decode($data["msg"])); $buffer->endElement(); } $buffer->endElement();