$TimeEnd = cobalt_htmlentities($TimeEnd); $Username = cobalt_htmlentities($Username); $Module = cobalt_htmlentities($Module); $Keyword = cobalt_htmlentities($Keyword); $IPAddress = cobalt_htmlentities($IPAddress); } if (!isset($start)) { $start = 0; } //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';
?> </td></tr> <tr><td colspan=2> <input type=button name=CHECK value="CHECK ALL" class="button1" onClick="checkAll();"> <input type=button name=UNCHECK value="UNCHECK ALL" class="button1" onClick="uncheckAll();"> </td></tr> <?php $data_con = new data_abstraction(); $data_con->set_fields('a.link_id, a.descriptive_title AS `Module_Name`'); $data_con->set_table('user_links a, user_passport_groups b'); if ($passportGroup != "All Groups") { $data_con->set_where("a.passport_group_id = b.passport_group_id AND b.passport_group_id='{$passportGroup}'"); } elseif ($passportGroup == "All Groups") { $data_con->set_where("a.passport_group_id = b.passport_group_id AND b.passport_group_id!=''"); } $data_con->set_order('a.descriptive_title'); $result = $data_con->make_query()->result; $numrows = $data_con->num_rows; $data_con->close_db(); echo '<input type="hidden" name="numLinks" value="' . $numrows . '">'; for ($a = 0; $a < $numrows; $a += 2) { if ($a % 4 == 0) { $class = 'listRowOddNoHighlight'; } else { $class = 'listRowEvenNoHighlight'; } $info = $result->fetch_assoc(); extract($info); $data_con = new data_abstraction(); $data_con->set_fields('username'); $data_con->set_table('user_passport');
} } $html = new html(); $html->draw_header('Change Skin', $message); $html->display_info('Changing the System Skin does not affect functionality.<br>All changes are merely aesthetic.'); echo '<div class="container"> <fieldset class="container_invisible"> <fieldset class="top"> Skin (UI Theme) Management </fieldset> <fieldset class="middle"> <table class="input_form">'; echo '<tr><td class="label">System Skin:</td><td> <select name="skin_id">'; $data_con = new data_abstraction(); $data_con->set_fields('skin_id AS new_skin_id, skin_name'); $data_con->set_table('system_skins'); $data_con->set_order('skin_name'); $result = $data_con->make_query()->result; $numrows = $data_con->num_rows; if ($data_con->error) { echo die($data_con->error); } $data_con->close_db(); for ($a = 0; $a < $numrows; $a++) { $data = $result->fetch_assoc(); extract($data); $selected = ''; if ($skin_name == $_SESSION['skin']) { $selected = 'selected'; } echo "<option value='{$new_skin_id}' {$selected}> {$skin_name} </option>"; }
$data_con->set_where("username='******' AND link_id='" . quote_smart($module) . "'"); $data_con->make_query(); $obj_role->set_where("username='******'"); $obj_role->make_query(); } $data_con->close_db(); $obj_role->close_db(); } else { $message = "Please select at least one user."; } } $data_con = new data_abstraction(); $data_con->set_fields('username'); $data_con->set_table('user_passport'); $data_con->set_where("link_id='" . quote_smart($module) . "'"); $data_con->set_order('username'); if ($result = $data_con->make_query()->result) { $arrUser = array(); $showUsers = TRUE; $numUsers = $data_con->num_rows; for ($a = 0; $a < $numUsers; $a++) { $data = $result->fetch_assoc(); extract($data); $arrUser[] = $username; } } } $html_writer = new html(); $html_writer->draw_header('Set User Passports', $message, $message_type); ?>
$dbh_citizen = new request(); $dbh_citizen->execute_query("SELECT status FROM validate WHERE status = 'wait list'"); $result2 = $dbh_citizen->result; $hi = array(); while ($row2 = $result2->fetch_assoc()) { extract($row2); $hi[] = $row1['status']; } $results = count($hi); $html->display_tip('There are: ' . $results . ' Wait listed citizen'); $menu_links = ''; $data_con = new data_abstraction(); $data_con->set_fields('a.link_id, a.descriptive_title, a.target, a.description, c.passport_group, a.icon as link_icon, c.icon as `group_icon`'); $data_con->set_table('user_links a, user_passport b, user_passport_groups c'); $data_con->set_where("a.link_id=b.link_id AND b.username='******'user']) . "' AND a.passport_group_id=c.passport_group_id AND a.show_in_tasklist='Yes' AND a.status='On'"); $data_con->set_order('c.priority DESC, c.passport_group, a.priority DESC, a.descriptive_title'); if ($result = $data_con->make_query()->result) { while ($data = $result->fetch_assoc()) { extract($data); $menu_links[$passport_group]['title'][] = $descriptive_title; $menu_links[$passport_group]['target'][] = $target; $menu_links[$passport_group]['link_id'][] = $link_id; $menu_links[$passport_group]['description'][] = $description; $menu_links[$passport_group]['link_icon'][] = $link_icon; $menu_links[$passport_group]['group_icon'][] = $group_icon; } $result->close(); } else { die("Fatal error: cannot retrieve modules"); } unset($data_con);