: 
='$date1' AND `timestamp`<'$date2' $dhcp_where";
$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);
?>
|
|
|
|
|
='$date1' and `timestamp`<'$date2' $dhcp_where ORDER BY `id` DESC LIMIT $start,$displayed) AS I ON D.id = I.id";
$userlog = get_records_sql($db_link, $sSQL);
foreach ($userlog as $row) {
if ($row['action'] == "old") { $row['action'] = WEB_log_dhcp_old.": "; }
if ($row['action'] == "add") { $row['action'] = WEB_log_dhcp_add.": "; }
if ($row['action'] == "del") { $row['action'] = WEB_log_dhcp_del.": "; }
$l_msg = $row['action'] . " " . $row['mac'] . " " . $row['ip'];
print "\n";
print "| " . $row['timestamp'] . " | \n";
print "" . $row['action'] . " | \n";
print "" . $row['mac'] . " | \n";
if (isset($row['auth_id']) and $row['auth_id'] > 0) {
print "" . $row['ip'] . " | \n";
} else {
print "" . $row['ip'] . " | \n";
}
print "" . $row['dhcp_hostname'] . " | \n";
print "
\n";
}
print "
\n";
print_navigation($page_url,$page,$displayed,$count_records[0],$total);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>