die(error_info_theme($lang_module['error_group_not_found'])); } $row = $db->sql_fetchrow($result); $group_title = $row['title']; if (!empty($row['users'])) { $page = $nv_Request->get_int('page', 'get', 0); $all_page = count(explode(",", $row['users'])); $per_page = 10; $users_in_group = array(); $users_in_group['caption'] = sprintf($lang_module['users_in_group_caption'], $group_title, $all_page); $users_in_group['thead'] = array("UserId", $lang_global['nickname'], $lang_global['full_name'], $lang_global['email'], $lang_global['regdate'], $lang_global['last_login']); $users_in_group['action'] = NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=edit&userid="; $base_url = NV_BASE_ADMINURL . "index.php?" . NV_NAME_VARIABLE . "=" . $module_name . "&" . NV_OP_VARIABLE . "=groups_users&group_id=" . $group_id; $query = "SELECT `userid`, `username`, `email`, `full_name`, `regdate`, `last_login` \r\n FROM `" . NV_USERS_GLOBALTABLE . "` \r\n WHERE `userid` IN (" . $row['users'] . ") \r\n ORDER BY `username` ASC \r\n LIMIT " . $page . "," . $per_page; $result = $db->sql_query($query); while ($row = $db->sql_fetchrow($result)) { $users_in_group['row'][$row['userid']]['username'] = $row['username']; $users_in_group['row'][$row['userid']]['full_name'] = $row['full_name']; $users_in_group['row'][$row['userid']]['email'] = nv_EncodeEmail($row['email']); $users_in_group['row'][$row['userid']]['regdate'] = nv_date("l, d/m/Y H:i", $row['regdate']); $users_in_group['row'][$row['userid']]['last_login'] = !empty($row['last_login']) ? nv_date("l, d/m/Y H:i", $row['last_login']) : $lang_global['never']; $users_in_group['row'][$row['userid']]['onclick'] = array("nv_group_exclude_user(" . $group_id . ", " . $row['userid'] . ")", sprintf($lang_module['exclude_user'], $row['full_name'], $group_title)); } $users_in_group['generate_page'] = nv_generate_page($base_url, $all_page, $per_page, $page, true, true, 'nv_urldecode_ajax', 'list_users'); $contents = main_list_users_theme($users_in_group); include NV_ROOTDIR . "/includes/header.php"; echo $contents; include NV_ROOTDIR . "/includes/footer.php"; } else { die(error_info_theme($lang_module['error_users_not_found'])); }
break; default: $search_query = preg_replace('/\\s+/', '_', nv_EncString($search_query)); $search_query = $db->dblikeescape(strtolower($search_query)); $query .= " WHERE (`username` LIKE '%" . $search_query . "%' OR `full_name` LIKE '%" . $search_query . "%')"; } $base_url .= "&search_option=" . $search_option . "&search_query=" . rawurlencode($search_query); } if (!empty($users)) { $query .= !empty($search_query) ? " AND" : " WHERE"; $query .= " `userid` NOT IN (" . $users . ")"; } $result = $db->sql_query($query); $all_page = $db->sql_numrows($result); if (empty($all_page)) { die(error_info_theme($lang_module['search_not_result'])); } $page = $nv_Request->get_int('page', 'get', 0); $per_page = 10; switch ($search_option) { case 1: $query .= " ORDER BY `email` ASC LIMIT " . $page . "," . $per_page; break; case 2: $query .= " ORDER BY `userid` ASC LIMIT " . $page . "," . $per_page; break; default: $query .= " ORDER BY `username` ASC LIMIT " . $page . "," . $per_page; } $result = $db->sql_query($query); $search_result = array();