\n");
$SQLNumRows = pg_numrows($SQLQueryResults);
echo "
Saved Log Description: " . stripslashes(pgdatatrim(relatedata ($dbsocket,"Syslog_TSave","TSave_Desc","TSave_ID=$saveid"))) . "
\n";
echo "Expires: " . stripslashes(pgdatatrim(relatedata ($dbsocket,"Syslog_TSave","TSave_ExpireDate","TSave_ID=$saveid"))) . "
\n";
openform("viewsaves.php","post",2,1,0);
if ( $SQLNumRows > 0 ) {
$deliverymessage="";
if ( ( $emailaddress != "" ) && ( $action == "EMail Results" ) ) {
$deliverymessage="Report from $REMOTE_USER\n\n";
}
echo "
\n";
echo "Date | Time | Facility | Severity | Host | Message |
\n";
for ( $loop = 0 ; $loop != $SQLNumRows ; $loop++ ) {
$SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or
die(pg_errormessage()."
\n");
$date=stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_date));
$time=stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_time));
$host=stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_host));
$message=stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_message));
$sev=stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_severity));
$severity=verboseseverity(stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_severity)));
$facility=verbosefacility(stripslashes(pgdatatrim($SQLQueryResultsObject->tsavedata_facility)));
if ( ( $sev == 4 ) || ( $sev == 3 ) ) { $fontcolor='#FF8800'; }
if ( $sev <= 2 ) { $fontcolor='#FF0000'; }
echo "$date | $time | $facility | $severity | $host | $message |
\n";
if ( ( $emailaddress != "" ) && ( $action == "EMail Results" ) ) {
$deliverymessage=$deliverymessage . "$date $time $host $facility $severity $message\r\n";
}
}
}
echo "
\n";
if ( ( $emailaddress != "" ) && ( $action == "EMail Results" ) ) {
$results=mail($emailaddress,"SMT EMail",$deliverymessage);
if ( $results ) { echo "Email sent to SMTP server
\n"; }
}
echo "Email Address: ";
formfield("emailaddress","text",3,1,0,40,128);
formfield("saveid","hidden",3,1,0,40,40,$saveid);
formsubmit("EMail Results",3,1,1);
}
pg_freeresult($SQLQueryResults) or
die(pg_errormessage() . "
\n");
closeform();
$endtime=time();
echo "
Page loaded in " . ($endtime - $begintime) . " seconds.
\n";
do_footer();
dbdisconnect($sec_dbsocket);
dbdisconnect($dbsocket);
?>