='$date1' AND `timestamp`<'$date2' $log_filter";
$res = mysqli_query($db_link, $countSQL);
$count_records = mysqli_fetch_array($res);
$total=ceil($count_records[0]/$displayed);
if ($page>$total) { $page=$total; }
if ($page<1) { $page=1; }
$start = ($page * $displayed) - $displayed;
print_navigation($page_url,$page,$displayed,$count_records[0],$total);
#speedup paging
$sSQL = "SELECT * FROM (SELECT * FROM worklog WHERE `timestamp`>='$date1' AND `timestamp`<'$date2' $log_filter ) AS W ORDER BY timestamp DESC LIMIT $start,$displayed";
?>
|
|
|
|
|
\n";
print "" . $row['timestamp'] . " | \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[0],$total);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>