='$date1' AND `timestamp`<'$date2' $dhcp_where"; $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); ?>
='$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 "\n"; print "\n"; print "\n"; if (isset($row['auth_id']) and $row['auth_id'] > 0) { print "\n"; } else { print "\n"; } print "\n"; print "\n"; } print "
" . $row['timestamp'] . "" . $row['action'] . "" . $row['mac'] . "" . $row['ip'] . "" . $row['ip'] . "" . $row['dhcp_hostname'] . "
\n"; print_navigation($page_url,$page,$displayed,$count_records[0],$total); require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php"); ?>