}
}
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()) {
header("Cache-Control: cache, must-revalidate");
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();
}
