2) ? -1 : intval($_GET['show_group']); $forum_page['sort_by'] = (!isset($_GET['sort_by']) || $_GET['sort_by'] != 'username' && $_GET['sort_by'] != 'registered' && ($_GET['sort_by'] != 'num_posts' || !$forum_page['show_post_count'])) ? 'username' : $_GET['sort_by']; $forum_page['sort_dir'] = (!isset($_GET['sort_dir']) || strtoupper($_GET['sort_dir']) != 'ASC' && strtoupper($_GET['sort_dir']) != 'DESC') ? 'ASC' : strtoupper($_GET['sort_dir']); // Create any SQL for the WHERE clause $where_sql = array(); $like_command = ($db_type == 'pgsql') ? 'ILIKE' : 'LIKE'; if ($forum_user['g_search_users'] == '1' && $forum_page['username'] != '') $where_sql[] = 'u.username '.$like_command.' \''.$forum_db->escape(str_replace('*', '%', $forum_page['username'])).'\''; if ($forum_page['show_group'] > -1) $where_sql[] = 'u.group_id='.$forum_page['show_group']; // Fetch user count $query = array( 'SELECT' => 'COUNT(u.id)', 'FROM' => 'users AS u', 'WHERE' => 'u.id > 1 AND u.group_id != '.FORUM_UNVERIFIED ); if (!empty($where_sql)) $query['WHERE'] .= ' AND '.implode(' AND ', $where_sql); ($hook = get_hook('ul_qr_get_user_count')) ? eval($hook) : null; $result = $forum_db->query_build($query) or error(__FILE__, __LINE__); $forum_page['num_users'] = $forum_db->result($result); // Determine the user offset (based on $_GET['p']) $forum_page['num_pages'] = ceil($forum_page['num_users'] / 50); $forum_page['page'] = (!isset($_GET['p']) || !is_numeric($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $forum_page['num_pages']) ? 1 : intval($_GET['p']); $forum_page['start_from'] = 50 * ($forum_page['page'] - 1); $forum_page['finish_at'] = min(($forum_page['start_from'] + 50), ($forum_page['num_users'])); $forum_page['users_searched'] = (($forum_user['g_search_users'] == '1' && $forum_page['username'] != '') || $forum_page['show_group'] > -1); if ($forum_page['num_users'] > 0) $forum_page['items_info'] = generate_items_info( (($forum_page['users_searched']) ? $lang_ul['Users found'] : $lang_ul['Users']), ($forum_page['start_from'] + 1), $forum_page['num_users']); else $forum_page['items_info'] = $lang_ul['Users']; // Generate paging links $forum_page['page_post']['paging'] = '

'.$lang_common['Pages'].' '.paginate($forum_page['num_pages'], $forum_page['page'], $forum_url['users_browse'], $lang_common['Paging separator'], array($forum_page['show_group'], $forum_page['sort_by'], $forum_page['sort_dir'], ($forum_page['username'] != '') ? urlencode($forum_page['username']) : '-')).'

'; // Navigation links for header and page numbering for title/meta description if ($forum_page['page'] < $forum_page['num_pages']) { $forum_page['nav']['last'] = ''; $forum_page['nav']['next'] = ''; } if ($forum_page['page'] > 1) { $forum_page['nav']['prev'] = ''; $forum_page['nav']['first'] = ''; } // Setup main options if (empty($_GET)) $forum_page['main_head_options'] = array(); else $forum_page['main_head_options'] = array( 'new_search' => ''.$lang_ul['Perform new search'].'' ); // Setup form $forum_page['group_count'] = $forum_page['item_count'] = $forum_page['fld_count'] = 0; $forum_page['form_action'] = $base_url.'/userlist.php'; // Setup breadcrumbs $forum_page['crumbs'] = array( array($forum_config['o_board_title'], forum_link($forum_url['index'])), array($lang_common['User list'], forum_link($forum_url['users'])) ); // Setup main heading if ($forum_page['num_pages'] > 1) $forum_page['main_head_pages'] = sprintf($lang_common['Page info'], $forum_page['page'], $forum_page['num_pages']); ($hook = get_hook('ul_pre_header_load')) ? eval($hook) : null; define('FORUM_ALLOW_INDEX', 1); define('FORUM_PAGE', 'userlist'); require FORUM_ROOT.'header.php'; // START SUBST - ob_start(); ($hook = get_hook('ul_main_output_start')) ? eval($hook) : null; ?>

'.implode(' ', $forum_page['main_head_options']).'

'."\n"; ?>

/>

/>

'u.id, u.username, u.title, u.num_posts, u.registered, g.g_id, g.g_user_title', 'FROM' => 'users AS u', 'JOINS' => array( array( 'LEFT JOIN' => 'groups AS g', 'ON' => 'g.g_id=u.group_id' ) ), 'WHERE' => 'u.id > 1 AND u.group_id != '.FORUM_UNVERIFIED, 'ORDER BY' => $forum_page['sort_by'].' '.$forum_page['sort_dir'].', u.id ASC', 'LIMIT' => $forum_page['start_from'].', 50' ); if (!empty($where_sql)) $query['WHERE'] .= ' AND '.implode(' AND ', $where_sql); ($hook = get_hook('ul_qr_get_users')) ? eval($hook) : null; $result = $forum_db->query_build($query) or error(__FILE__, __LINE__); $forum_page['item_count'] = 0; if ($forum_db->num_rows($result)) { ($hook = get_hook('ul_results_pre_header')) ? eval($hook) : null; $forum_page['table_header'] = array(); $forum_page['table_header']['username'] = ''.$lang_ul['Username'].''; $forum_page['table_header']['title'] = ''.$lang_ul['Title'].''; if ($forum_page['show_post_count']) $forum_page['table_header']['posts'] = ''.$lang_ul['Posts'].''; $forum_page['table_header']['registered'] = ''.$lang_ul['Registered'].''; ($hook = get_hook('ul_results_pre_header_output')) ? eval($hook) : null; ?>

fetch_assoc($result)) { ($hook = get_hook('ul_results_row_pre_data')) ? eval($hook) : null; $forum_page['table_row'] = array(); $forum_page['table_row']['username'] = ''; $forum_page['table_row']['title'] = ''; if ($forum_page['show_post_count']) $forum_page['table_row']['posts'] = ''; $forum_page['table_row']['registered'] = ''; ++$forum_page['item_count']; ($hook = get_hook('ul_results_row_pre_data_output')) ? eval($hook) : null; ?>

'.forum_htmlencode($user_data['username']).'	'.get_title($user_data).'	'.forum_number_format($user_data['num_posts']).'	'.format_time($user_data['registered'], 1).'

'.implode(' ', $forum_page['main_foot_options']).'

'; ?>

', $tpl_temp, $tpl_main); ob_end_clean(); // END SUBST - require FORUM_ROOT.'footer.php';