= ? AND ts < ?" . $log_filter;
$count_records = get_single_field($db_link, $countSQL, $params);
$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 ts,customer,message,level FROM worklog as S JOIN (SELECT id FROM worklog WHERE ts>=? AND ts $log_filter
ORDER BY id DESC
LIMIT $displayed OFFSET $start) AS I ON S.id = I.id";
$params[]=$displayed;
$params[]=$start;
$userlog = get_records_sql($db_link, $sSQL, $params);
?>
|
|
|
|
\n";
print "" . $row['ts'] . " | \n";
print "" . $row['customer'] . " | \n";
$msg_level = 'INFO';
if ($row['level'] == L_ERROR) { $msg_level='ERROR'; }
if ($row['level'] == L_DEBUG) { $msg_level='DEBUG'; }
if ($row['level'] == L_VERBOSE) { $msg_level='VERBOSE'; }
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");
?>