0) {
$dev_ips=get_device_ips($db_link,$f_id);
$log_filter=' and ip IN (';
foreach ($dev_ips as $index => $ip) {
$log_filter=$log_filter."'".$ip."',";
}
$log_filter = preg_replace('/\,$/', '',$log_filter);
$log_filter = $log_filter .")";
}
?>
='$date1' AND ts<'$date2' $log_filter";
$count_records = get_single_field($db_link,$countSQL);
$total=ceil($count_records/$displayed);
if ($page>$total) { $page=$total; }
if ($page<1) { $page=1; }
$start = ($page * $displayed) - $displayed;
print_navigation($page_url,$page,$displayed,$count_records,$total);
#speedup pageing
$sSQL = "SELECT * FROM (SELECT * FROM remote_syslog WHERE ts>='$date1' AND ts<'$date2' $log_filter) as R ORDER BY ts DESC LIMIT $displayed OFFSET $start";
?>
|
|
|
\n";
print "" . $row['ts'] . " | \n";
print "" . $row['ip'] . " | \n";
print "" . $row['message'] . " | \n";
print "\n";
}
}
print "
\n";
print_navigation($page_url,$page,$displayed,$count_records,$total);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>