//Pagination ****************************
//->Query to get total number of records.
$data_con = new data_abstraction();
$data_con->set_fields("entry_id, ip_address, user, datetime, action, module");
$data_con->set_table("`system_log`");
$data_con->set_where("{$TimeFilter} AND {$UserFilter} AND {$ModuleFilter} AND {$KeywordFilter} AND {$IPAddressFilter}");
$data_con->set_order("entry_id");
if ($result = $data_con->make_query()->result) {
$total_records = $data_con->num_rows;
} else {
die("Error getting log entries: " . $data_con->QUERY);
}
//-> Now instantiate the pagination class and feed it the necessary information.
require 'paged_result_class.php';
$results_per_page = 50;
$pager = new paged_result($total_records, $results_per_page);
$pager->get_page_data($result_pager, $current_page);
$current_page = $pager->current_page;
$data_con->set_limit($pager->offset, $pager->records_per_page);
$html_writer = new html();
$html_writer->draw_header('Security Monitor', $message, $message_type);
require '../javascript/submitenter.php';
?>
<input type="hidden" name="DateTimeOptions" value="<?php
echo $DateTimeOptions;
?>
">
<input type="hidden" name="UserOptions" value="<?php
echo $UserOptions;
?>
">
make_list($filter_string, $arr_fields[$key] . ' ' . $sort_order, ', ', FALSE);
} else {
//invalid field key, ignore
}
if ($filter_string != '') {
$data_con->set_order($filter_string);
}
} else {
if (isset($default_sort_order)) {
$data_con->set_order($default_sort_order);
}
}
$data_con->make_query();
$total_records = $data_con->num_rows;
require_once 'paged_result_class.php';
$pager = new paged_result($total_records, $results_per_page);
$pager->get_page_data($result_pager, $current_page);
$current_page = $pager->current_page;
$data_con->set_limit($pager->offset, $pager->records_per_page);
if (DEBUG_MODE && isset($print_settings) && $print_settings == TRUE) {
echo '<pre>';
echo 'ListView Settings Dump: <br><br>';
echo '<b>$join_clause:</b> <br>' . $join_clause . '<br><br><hr>';
echo '<b>$where_clause:</b> <br>' . $where_clause . '<br><br><hr>';
echo '<b>$lst_fields:</b> <br>' . $lst_fields . '<br><br><hr>';
echo '<b>$arr_fields:</b> <br>';
array_to_source($arr_fields);
echo '<br><br><hr>';
echo '<b>$arr_field_labels:</b> ';
array_to_source($arr_field_labels);
echo '<br><br><hr>';
