$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);
