//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>';