='$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 paging
$sSQL = "SELECT * FROM (SELECT * FROM worklog WHERE ts>='$date1' AND ts<'$date2' $log_filter ) AS W ORDER BY ts DESC LIMIT $displayed OFFSET $start";
?>
|
|
|
|
|
\n";
print "" . $row['ts'] . " | \n";
print "" . $row['customer'] . " | \n";
$msg_level = 'INFO';
if ($row['level'] == L_ERROR) { $msg_level='ERROR'; }
if ($row['level'] == L_WARNING) { $msg_level='WARNING'; }
if ($row['level'] == L_DEBUG) { $msg_level='DEBUG'; }
if ($row['level'] == L_VERBOSE) { $msg_level='VERBOSE'; }
print "" . $row['ip'] . " | \n";
print "" . $msg_level . " | \n";
$print_msg = expand_log_str($db_link, $row['message']);
print "" . $print_msg . " | \n";
print "\n";
}
print "
\n";
print_navigation($page_url,$page,$displayed,$count_records,$total);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>