/>
/>
'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).'