= ? AND ts < ?" . $whereClause;
$count_records = (int)get_single_field($db_link, $countSQL, $params);
$total = ceil($count_records / $displayed);
$page = max(1, min($page, $total));
$start = ($page - 1) * $displayed;
print_navigation($page_url, $page, $displayed, $count_records, $total);
$dataParams = array_merge($params, [$displayed, $start]);
$sSQL = "
SELECT * FROM mac_history
WHERE ts >= ? AND ts < ?" . $whereClause . "
ORDER BY ts DESC
LIMIT ? OFFSET ?
";
$maclog = get_records_sql($db_link, $sSQL, $dataParams);
?>
|
|
|
|
\n";
print "" . get_datetime_display($row['ts']) . " | \n";
print "" . expand_mac($db_link,mac_dotted($row['mac'])) . " | \n";
print "" . get_port($db_link, $row['port_id']) . " | \n";
if (isset($row['auth_id']) and $row['auth_id'] > 0) {
print "" . $row['ip'] . " | \n";
} else {
print "" . $row['ip'] . " | \n";
}
print "\n";
}
print "
\n";
print_navigation($page_url,$page,$displayed,$count_records,$total);
require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
?>