$list = sumo_get_table_header($table['data']['group2accesspoints']);
while ($tab = $rs->FetchRow()) {
$style = sumo_alternate_str('tab-row-on', 'tab-row-off');
$query = "SELECT id,node,path,name FROM " . SUMO_TABLE_ACCESSPOINTS . "\n\t\t\t WHERE (\n\t\t\t \t\t usergroup LIKE '" . $tab['usergroup'] . "' \n\t\t\t\t\t OR usergroup LIKE '" . $tab['usergroup'] . ";%'\n\t\t\t\t\t OR usergroup LIKE '%;" . $tab['usergroup'] . "'\n\t\t\t\t\t OR usergroup LIKE '%;" . $tab['usergroup'] . ";%'\n\t\t\t\t\t )\n\t\t\t ORDER BY node,name,path";
$rs2 = $SUMO['DB']->Execute($query);
$ap = "<table width='100%'>";
$a = 0;
while ($tab2 = $rs2->FetchRow()) {
$style2 = sumo_alternate_str('tab-row-on', 'tab-row-off', $tab['usergroup']);
$tab2['name'] = sumo_get_accesspoint_name($tab2['name'], $_COOKIE['language']);
$ap .= "<tr>" . "<td width='100%' class='" . $style2 . "' nowrap>" . "<a href='javascript:sumo_ajax_get(\"accesspoints\",\"?module=accesspoints&action=edit&id=" . $tab2['id'] . "\");'>" . $tab2['name'] . "</a>" . "</td>" . "<td class='" . $style2 . "'>" . "<a href='javascript:sumo_ajax_get(\"accesspoints\",\"?module=accesspoints&action=edit&id=" . $tab2['id'] . "\");'>" . $tab2['path'] . "</a>" . "</td>" . "</tr>\n";
$a++;
}
$ap .= "</table>";
if ($search) {
$tab['usergroup'] = sumo_color_match_string($field['usergroup'][1], $tab['usergroup']);
}
$width = $a > 5 ? " width='450'" : '';
$list .= "<tr>\n" . " <td class='" . $style . "'><b>" . "<a href='javascript:sumo_ajax_get(\"groups\",\"?module=groups&action=edit&id=" . $tab['id'] . "\");'>" . $tab['usergroup'] . "</a>" . "</b>" . "<br>({$a} " . $language['accesspoints'] . ")</td>\n";
if ($_SESSION['relationship']['group2accesspoints']['col'][100]) {
$list .= " <td>" . $ap . "</td>\n";
}
if ($_SESSION['relationship']['group2accesspoints']['col'][101]) {
$list .= " <td style='border-bottom:1px solid #DCDCDC'><img onclick='javascript:window.open(\"services.php?module=relationship&service=relationship&cmd=GET_GROUP2ACCESSPOINTS&id=" . $tab['id'] . "\",\"group2accesspoints\",\"height=200,width=500,resizable=yes,scrollbars=yes\");' " . " src='services.php?module=relationship&service=relationship&cmd=GET_GROUP2ACCESSPOINTS&id=" . $tab['id'] . "' alt=''{$width}></td>\n" . "</tr>\n";
}
}
$list .= "</table>";
$searched = $search ? $_SESSION['search_relationship_group2accesspoints'] : '';
// Template Data
$tpl = array('GET:Theme' => $SUMO['page']['theme'], 'GET:MenuModule' => $tpl['GET:MenuModule'], 'GET:List' => $list, 'GET:TotalRows' => number_format($tot, 0, "", "."), 'GET:StartRow' => number_format($_SESSION['start_relationship_group2accesspoints'], 0, "", "."), 'GET:EndRow' => number_format($_SESSION['start_relationship_group2accesspoints'] + $vis, 0, "", "."), 'GET:PagingResults' => sumo_paging_results($tot, $vis, $_SESSION['rows_relationship_group2accesspoints'], 5, $_SESSION['start_relationship_group2accesspoints'], 'start_relationship_group2accesspoints'), 'GET:TableSettings' => sumo_get_table_settings($table['data']['group2accesspoints']), 'GET:SearchForm' => sumo_get_form_search($searched), 'GET:ExportData' => sumo_get_export_data());
$tpl['GET:Pagination'] = $tot > 0 ? $tpl['GET:StartRow'] . "..." . $tpl['GET:EndRow'] . " " . $language['of'] . " <b>" . $tpl['GET:TotalRows'] . "</b>" : "";
if ($col[4]) {
$list .= " <td class='" . $style . "'><a href='javascript:sumo_ajax_get(\"users.content\",\"?module=users&action=view&id=" . $tab['id'] . "&decoration=false\");' title='" . $language['ViewUser'] . "'>" . $username . "</a></td>\n";
}
if ($col[8]) {
$list .= " <td class='" . $style . "' nowrap>" . $group . "</td>\n";
}
if ($col[9]) {
$list .= " <td class='" . $style . "' nowrap><a href='javascript:sumo_ajax_get(\"network\",\"?module=network&action=view_datasource&id=" . $tab['datasource_id'] . "\");'>" . $tab['datasource_id'] . $datasource[$tab['datasource_id']] . "</a></td>\n";
}
if ($col[13]) {
$list .= " <td class='" . $style . "' align='right' nowrap>" . $tab['email'] . "</td>\n";
}
if ($col[12]) {
$list .= " <td class='" . $style . "' align='right'><img src='themes/" . $SUMO['page']['theme'] . "/images/flags/" . $tab['language'] . ".png'> " . ucfirst($users_lang[$tab['language']]) . "</td>\n";
}
if ($col[10]) {
$list .= " <td class='" . $style . "' align='right'>" . $last_login . "</td>\n";
}
if ($col[15]) {
$list .= " <td class='" . $style . "' align='right'>" . $created . "</td>\n";
}
if ($col[11]) {
$list .= " <td class='" . $style . "' align='right'>" . $expire . "</td>\n";
}
$list .= "</tr>\n";
}
$list .= "</table>";
$searched = $search ? $_SESSION['search_users_list'] : '';
// Template Data
$tpl = array('MESSAGE:H' => $tpl['MESSAGE:H'], 'MESSAGE:M' => $tpl['MESSAGE:M'], 'MESSAGE:L' => $tpl['MESSAGE:L'], 'GET:Theme' => $SUMO['page']['theme'], 'GET:MenuModule' => $tpl['GET:MenuModule'], 'GET:NumUsers' => number_format($users, 0, "", "."), 'GET:NumUsersActive' => number_format($active, 0, "", "."), 'GET:NumSuspendedUsers' => "<a href='javascript:sumo_ajax_get(\"users.content\",\"index.php?start_users_list=0&module=users&action=list&om=0&oc=6&decoration=false\");'>" . number_format($users - $active, 0, "", ".") . "</a>", 'GET:UsersList' => $list, 'GET:TotalRows' => number_format($tot, 0, "", "."), 'GET:StartRow' => number_format($_SESSION['start_users_list'], 0, "", "."), 'GET:EndRow' => number_format($_SESSION['start_users_list'] + $vis, 0, "", "."), 'GET:PagingResults' => sumo_paging_results($tot, $vis, $_SESSION['rows_users_list'], 5, $_SESSION['start_users_list'], 'start_users_list', 'list'), 'GET:TableSettings' => sumo_get_table_settings($table['data']['list']), 'GET:SearchForm' => sumo_get_form_search($searched), 'GET:ExportData' => sumo_get_export_data(), 'LINK:AddUser' => sumo_get_action_icon("", "new", "users.content", "?module=users&action=new&decoration=false"));
$tpl['GET:Pagination'] = $tot > 0 ? $tpl['GET:StartRow'] . "..." . $tpl['GET:EndRow'] . " " . $language['of'] . " <b>" . $tpl['GET:TotalRows'] . "</b>" : "";
if ($col[8]) {
$list .= " <td class='" . $style . "' align='center'><img src='themes/" . $SUMO['page']['theme'] . "/images/modules/accesspoints/" . $pwd_encrypt . ".gif'></td>\n";
}
if ($col[9]) {
$list .= " <td class='" . $style . "' align='center'><img src='themes/" . $SUMO['page']['theme'] . "/images/modules/accesspoints/" . $registration . ".gif'></td>\n";
}
if ($col[10]) {
$list .= " <td class='" . $style . "' align='center'>" . $tab['reg_group'] . "</td>\n";
}
if ($col[11]) {
$list .= " <td class='" . $style . "' align='center'><img src='themes/" . $SUMO['page']['theme'] . "/images/modules/accesspoints/" . $change_pwd . ".gif'></td>\n";
}
if ($col[12]) {
$list .= " <td class='" . $style . "'>" . $theme . "</td>\n";
}
if ($col[13]) {
$list .= " <td class='" . $style . "'>" . $created . "</td>\n";
}
if ($col[14]) {
$list .= " <td class='" . $style . "'>" . $updated . "</td>\n";
}
$list .= "</tr>\n";
}
$list .= "</table>";
} else {
$list = "<div class='no-results'>" . $language['AccesspointsNotFound'] . "</div>";
}
$searched = $search ? $_SESSION['search_accesspoints_list'] : '';
// Template Data
$tpl = array('MESSAGE:H' => $tpl['MESSAGE:H'], 'MESSAGE:M' => $tpl['MESSAGE:M'], 'MESSAGE:L' => $tpl['MESSAGE:L'], 'GET:MenuModule' => $tpl['GET:MenuModule'], 'GET:AccessPointsList' => $list, 'GET:TotalRows' => number_format($tot, 0, "", "."), 'GET:StartRow' => number_format($_SESSION['start_accesspoints_list'], 0, "", "."), 'GET:EndRow' => number_format($_SESSION['start_accesspoints_list'] + $vis, 0, "", "."), 'GET:PagingResults' => sumo_paging_results($tot, $vis, $_SESSION['rows_accesspoints_list'], 5, $_SESSION['start_accesspoints_list'], 'start_accesspoints_list'), 'GET:TableSettings' => sumo_get_table_settings($table['data']['list']), 'GET:SearchForm' => sumo_get_form_search($searched), 'GET:ExportData' => sumo_get_export_data(), 'LINK:AddAccessPoint' => sumo_verify_permissions(5, 'sumo') ? sumo_get_action_icon("", "add", "accesspoints.content", "?module=accesspoints&action=new&decoration=false") : sumo_get_action_icon("", "add"));
$tpl['GET:Pagination'] = $tot > 0 ? $tpl['GET:StartRow'] . "..." . $tpl['GET:EndRow'] . " " . $language['of'] . " <b>" . $tpl['GET:TotalRows'] . "</b>" : "";
if ($col[2]) {
$list .= " <td {$style} align='center'><img src='themes/" . $SUMO['page']['theme'] . "/images/modules/security/priority_" . $tab['priority'] . ".gif' class='log-priority' alt='" . $tab['priority'] . "'></td>\n";
}
if ($col[3]) {
$list .= " <td {$style} align='right'>" . $tab['code'] . "</td>\n";
}
if ($col[4]) {
$list .= " <td {$style} align='right'>" . $node['name'] . "</td>\n";
}
if ($col[5]) {
$list .= " <td {$style} align='right'>" . $tab['ip'] . "</td>\n";
}
if ($col[6]) {
$list .= " <td {$style} align='right'>" . ucwords(strtolower($tab['country_name'])) . "</td>\n";
}
if ($col[7]) {
$list .= " <td {$style} width='100%'>" . $tab['message'] . "</td>\n";
}
if ($col[8]) {
$list .= " <td {$style} align='right'>" . sumo_get_human_date($tab['time'], TRUE, TRUE) . "</td>\n";
}
$list .= "</tr>\n";
}
$list .= "</table>";
} else {
$list = "<div class='no-results'>" . $language['LogsNotFound'] . "</div>";
}
$searched = $search ? $_SESSION['search_security_' . $action] : '';
// Template Data
$tpl = array('MESSAGE:H' => $tpl['MESSAGE:H'], 'MESSAGE:M' => $tpl['MESSAGE:M'], 'MESSAGE:L' => $tpl['MESSAGE:L'], 'GET:MenuModule' => $tpl['GET:MenuModule'], 'GET:MessagesList' => $list, 'GET:TotalRows' => number_format($tot, 0, "", "."), 'GET:StartRow' => number_format($_SESSION['start_security_' . $action], 0, "", "."), 'GET:EndRow' => number_format($_SESSION['start_security_' . $action] + $vis, 0, "", "."), 'GET:PagingResults' => sumo_paging_results($tot, $vis, $_SESSION['rows_security_' . $action], 5, $_SESSION['start_security_' . $action], 'start_security_' . $action), 'GET:TableSettings' => sumo_get_table_settings($table['data'][$action]), 'GET:SearchForm' => sumo_get_form_search($searched), 'GET:ExportData' => sumo_get_export_data(), 'GET:WindowScripts' => 'sumo_unrefresh_window("security");' . 'sumo_refresh_window("security", "' . $action . '", ' . SUMO_TIMER_LOGS . ', "index.php?module=security");');
$tpl['GET:Pagination'] = $tot > 0 ? $tpl['GET:StartRow'] . "..." . $tpl['GET:EndRow'] . " " . $language['of'] . " <b>" . $tpl['GET:TotalRows'] . "</b>" : "";
if ($col[2]) {
$list .= " <td class='" . $style . "'>" . $name . "</td>\n";
}
if ($col[3]) {
$list .= " <td class='" . $style . "'>" . $language[$tab['type']] . "</td>\n";
}
if ($col[4]) {
$list .= " <td class='" . $style . "'>" . $tab['host'] . "</td>\n";
}
if ($col[5]) {
$list .= " <td class='" . $style . "' align='right'>" . $tab['port'] . "</td>\n";
}
if ($col[6]) {
$list .= " <td class='" . $style . "'>" . $tab['username'] . "</td>\n";
}
if ($col[8]) {
$list .= " <td class='" . $style . "'>" . $tab['db_name'] . "</td>\n";
}
if ($col[12]) {
$list .= " <td class='" . $style . "'>" . $tab['enctype'] . "</td>\n";
}
if ($col[13]) {
$list .= " <td class='" . $style . "'>" . $tab['ldap_base'] . "</td>\n";
}
$list .= "</tr>\n";
}
$list .= "</table>";
$searched = $search ? $_SESSION['search_network_dlist'] : '';
// Template Data
$tpl = array('MESSAGE:H' => $tpl['MESSAGE:H'], 'MESSAGE:M' => $tpl['MESSAGE:M'], 'MESSAGE:L' => $tpl['MESSAGE:L'], 'GET:Theme' => $SUMO['page']['theme'], 'GET:MenuModule' => $tpl['GET:MenuModule'], 'GET:DataSourcesList' => $list, 'GET:TotalRows' => number_format($tot, 0, "", "."), 'GET:StartRow' => number_format($_SESSION['start_network_dlist'], 0, "", "."), 'GET:EndRow' => number_format($_SESSION['start_network_dlist'] + $vis, 0, "", "."), 'GET:PagingResults' => sumo_paging_results($tot, $vis, $_SESSION['rows_network_dlist'], 5, $_SESSION['start_network_dlist'], 'start_network_dlist'), 'GET:TableSettings' => sumo_get_table_settings($table['data']['dlist']), 'GET:SearchForm' => sumo_get_form_search($searched), 'GET:ExportData' => sumo_get_export_data('network', 'dlist', 'export_datasource'), 'GET:AddDataSource' => sumo_verify_permissions(4, 'sumo') ? sumo_get_action_icon("network", "add_datasource", "network.content", "?module=network&action=new_datasource&decoration=false") : sumo_get_action_icon("", "add_datasource"), 'BUTTON:TestConnection' => "<input value='" . $language['TestConnection'] . "' type='button' class='button' onclick='javascript:sumo_ajax_get(\"network.content\",\"?module=network&action=dlist&test=1&decoration=false&network_dlist_view_col=0.1" . "\");'>");
$tpl['GET:Pagination'] = $tot > 0 ? $tpl['GET:StartRow'] . "..." . $tpl['GET:EndRow'] . " " . $language['of'] . " <b>" . $tpl['GET:TotalRows'] . "</b>" : "";
