array('label', 'function', 'is_selected') $subActions = array( 'all' => array($txt['view_all_members'], 'MLAll', $context['listing_by'] == 'all'), 'search' => array($txt['mlist_search'], 'MLSearch', $context['listing_by'] == 'search'), ); // Set up the sort links. $context['sort_links'] = array(); foreach ($subActions as $act => $text) { $context['sort_links'][] = array( 'label' => $text[0], 'action' => $act, 'selected' => $text[2], ); } $context['num_members'] = $modSettings['totalMembers']; // Set up the columns... $context['columns'] = array( 'is_online' => array( 'label' => $txt['status'], 'width' => 60, 'class' => 'first_th', 'sort' => array( 'down' => allowedTo('moderate_forum') ? 'IFNULL(lo.log_time, 1) ASC, real_name ASC' : 'CASE WHEN mem.show_online THEN IFNULL(lo.log_time, 1) ELSE 1 END ASC, real_name ASC', 'up' => allowedTo('moderate_forum') ? 'IFNULL(lo.log_time, 1) DESC, real_name DESC' : 'CASE WHEN mem.show_online THEN IFNULL(lo.log_time, 1) ELSE 1 END DESC, real_name DESC' ), ), 'real_name' => array( 'label' => $txt['username'], 'sort' => array( 'down' => 'mem.real_name DESC', 'up' => 'mem.real_name ASC' ), ), 'email_address' => array( 'label' => $txt['email'], 'width' => 25, 'sort' => array( 'down' => allowedTo('moderate_forum') ? 'mem.email_address DESC' : 'mem.hide_email DESC, mem.email_address DESC', 'up' => allowedTo('moderate_forum') ? 'mem.email_address ASC' : 'mem.hide_email ASC, mem.email_address ASC' ), ), 'website_url' => array( 'label' => $txt['website'], 'width' => 70, 'link_with' => 'website', 'sort' => array( 'down' => 'LENGTH(mem.website_url) > 0 ASC, IFNULL(mem.website_url, 1=1) DESC, mem.website_url DESC', 'up' => 'LENGTH(mem.website_url) > 0 DESC, IFNULL(mem.website_url, 1=1) ASC, mem.website_url ASC' ), ), 'icq' => array( 'label' => $txt['icq'], 'width' => 30, 'sort' => array( 'down' => 'LENGTH(mem.icq) > 0 ASC, mem.icq = 0 DESC, mem.icq DESC', 'up' => 'LENGTH(mem.icq) > 0 DESC, mem.icq = 0 ASC, mem.icq ASC' ), ), 'aim' => array( 'label' => $txt['aim'], 'width' => 30, 'sort' => array( 'down' => 'LENGTH(mem.aim) > 0 ASC, IFNULL(mem.aim, 1=1) DESC, mem.aim DESC', 'up' => 'LENGTH(mem.aim) > 0 DESC, IFNULL(mem.aim, 1=1) ASC, mem.aim ASC' ), ), 'yim' => array( 'label' => $txt['yim'], 'width' => 30, 'sort' => array( 'down' => 'LENGTH(mem.yim) > 0 ASC, IFNULL(mem.yim, 1=1) DESC, mem.yim DESC', 'up' => 'LENGTH(mem.yim) > 0 DESC, IFNULL(mem.yim, 1=1) ASC, mem.yim ASC' ), ), 'msn' => array( 'label' => $txt['msn'], 'width' => 30, 'sort' => array( 'down' => 'LENGTH(mem.msn) > 0 ASC, IFNULL(mem.msn, 1=1) DESC, mem.msn DESC', 'up' => 'LENGTH(mem.msn) > 0 DESC, IFNULL(mem.msn, 1=1) ASC, mem.msn ASC' ), ), 'id_group' => array( 'label' => $txt['position'], 'sort' => array( 'down' => 'IFNULL(mg.group_name, 1=1) DESC, mg.group_name DESC', 'up' => 'IFNULL(mg.group_name, 1=1) ASC, mg.group_name ASC' ), ), 'registered' => array( 'label' => $txt['date_registered'], 'sort' => array( 'down' => 'mem.date_registered DESC', 'up' => 'mem.date_registered ASC' ), ), 'posts' => array( 'label' => $txt['posts'], 'width' => 115, 'colspan' => 2, 'default_sort_rev' => true, 'sort' => array( 'down' => 'mem.posts DESC', 'up' => 'mem.posts ASC' ), ) ); $context['colspan'] = 0; $context['disabled_fields'] = isset($modSettings['disabled_profile_fields']) ? array_flip(explode(',', $modSettings['disabled_profile_fields'])) : array(); foreach ($context['columns'] as $key => $column) { if (isset($context['disabled_fields'][$key]) || (isset($column['link_with']) && isset($context['disabled_fields'][$column['link_with']]))) { unset($context['columns'][$key]); continue; } $context['colspan'] += isset($column['colspan']) ? $column['colspan'] : 1; } // Aesthetic stuff. end($context['columns']); $context['columns'][key($context['columns'])]['class'] = 'last_th'; $context['linktree'][] = array( 'url' => $scripturl . '?action=mlist', 'name' => $txt['members_list'] ); $context['can_send_pm'] = allowedTo('pm_send'); $context['can_send_email'] = allowedTo('send_email_to_members'); // Build the memberlist button array. $context['memberlist_buttons'] = array( 'view_all_members' => array('text' => 'view_all_members', 'image' => 'mlist.png', 'lang' => true, 'url' => $scripturl . '?action=mlist' . ';sa=all', 'active'=> true), 'mlist_search' => array('text' => 'mlist_search', 'image' => 'mlist.png', 'lang' => true, 'url' => $scripturl . '?action=mlist' . ';sa=search'), ); // Allow mods to add additional buttons here call_integration_hook('integrate_memberlist_buttons'); // Jump to the sub action. if (isset($subActions[$context['listing_by']])) $subActions[$context['listing_by']][1](); else $subActions['all'][1](); } /** * List all members, page by page, with sorting. * Called from MemberList(). * Can be passed a sort parameter, to order the display of members. * Calls printMemberListRows to retrieve the results of the query. */ function MLAll() { global $txt, $scripturl, $user_info; global $modSettings, $context, $smcFunc; // The chunk size for the cached index. $cache_step_size = 500; // Only use caching if: // 1. there are at least 2k members, // 2. the default sorting method (real_name) is being used, // 3. the page shown is high enough to make a DB filesort unprofitable. $use_cache = $modSettings['totalMembers'] > 2000 && (!isset($_REQUEST['sort']) || $_REQUEST['sort'] === 'real_name') && isset($_REQUEST['start']) && $_REQUEST['start'] > $cache_step_size; if ($use_cache) { // Maybe there's something cached already. if (!empty($modSettings['memberlist_cache'])) $memberlist_cache = @unserialize($modSettings['memberlist_cache']); // The chunk size for the cached index. $cache_step_size = 500; // Only update the cache if something changed or no cache existed yet. if (empty($memberlist_cache) || empty($modSettings['memberlist_updated']) || $memberlist_cache['last_update'] < $modSettings['memberlist_updated']) { $request = $smcFunc['db_query']('', ' SELECT real_name FROM {db_prefix}members WHERE is_activated = {int:is_activated} ORDER BY real_name', array( 'is_activated' => 1, ) ); $memberlist_cache = array( 'last_update' => time(), 'num_members' => $smcFunc['db_num_rows']($request), 'index' => array(), ); for ($i = 0, $n = $smcFunc['db_num_rows']($request); $i < $n; $i += $cache_step_size) { $smcFunc['db_data_seek']($request, $i); list($memberlist_cache['index'][$i]) = $smcFunc['db_fetch_row']($request); } $smcFunc['db_data_seek']($request, $memberlist_cache['num_members'] - 1); list ($memberlist_cache['index'][$i]) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); // Now we've got the cache...store it. updateSettings(array('memberlist_cache' => serialize($memberlist_cache))); } $context['num_members'] = $memberlist_cache['num_members']; } // Without cache we need an extra query to get the amount of members. else { $request = $smcFunc['db_query']('', ' SELECT COUNT(*) FROM {db_prefix}members WHERE is_activated = {int:is_activated}', array( 'is_activated' => 1, ) ); list ($context['num_members']) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); } // Set defaults for sort (real_name) and start. (0) if (!isset($_REQUEST['sort']) || !isset($context['columns'][$_REQUEST['sort']])) $_REQUEST['sort'] = 'real_name'; if (!is_numeric($_REQUEST['start'])) { if (preg_match('~^[^\'\\\\/]~' . ($context['utf8'] ? 'u' : ''), $smcFunc['strtolower']($_REQUEST['start']), $match) === 0) fatal_error('Hacker?', false); $_REQUEST['start'] = $match[0]; $request = $smcFunc['db_query']('substring', ' SELECT COUNT(*) FROM {db_prefix}members WHERE LOWER(SUBSTRING(real_name, 1, 1)) < {string:first_letter} AND is_activated = {int:is_activated}', array( 'is_activated' => 1, 'first_letter' => $_REQUEST['start'], ) ); list ($_REQUEST['start']) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); } $context['letter_links'] = ''; for ($i = 97; $i < 123; $i++) $context['letter_links'] .= '' . strtoupper(chr($i)) . ' '; // Sort out the column information. foreach ($context['columns'] as $col => $column_details) { $context['columns'][$col]['href'] = $scripturl . '?action=mlist;sort=' . $col . ';start=0'; if ((!isset($_REQUEST['desc']) && $col == $_REQUEST['sort']) || ($col != $_REQUEST['sort'] && !empty($column_details['default_sort_rev']))) $context['columns'][$col]['href'] .= ';desc'; $context['columns'][$col]['link'] = '' . $context['columns'][$col]['label'] . ''; $context['columns'][$col]['selected'] = $_REQUEST['sort'] == $col; } // Are we sorting the results $context['sort_by'] = $_REQUEST['sort']; $context['sort_direction'] = !isset($_REQUEST['desc']) ? 'up' : 'down'; // Construct the page index. $context['page_index'] = constructPageIndex($scripturl . '?action=mlist;sort=' . $_REQUEST['sort'] . (isset($_REQUEST['desc']) ? ';desc' : ''), $_REQUEST['start'], $context['num_members'], $modSettings['defaultMaxMembers']); // Send the data to the template. $context['start'] = $_REQUEST['start'] + 1; $context['end'] = min($_REQUEST['start'] + $modSettings['defaultMaxMembers'], $context['num_members']); $context['can_moderate_forum'] = allowedTo('moderate_forum'); $context['page_title'] = sprintf($txt['viewing_members'], $context['start'], $context['end']); $context['linktree'][] = array( 'url' => $scripturl . '?action=mlist;sort=' . $_REQUEST['sort'] . ';start=' . $_REQUEST['start'], 'name' => &$context['page_title'], 'extra_after' => ' (' . sprintf($txt['of_total_members'], $context['num_members']) . ')' ); $limit = $_REQUEST['start']; $query_parameters = array( 'regular_id_group' => 0, 'is_activated' => 1, 'sort' => $context['columns'][$_REQUEST['sort']]['sort'][$context['sort_direction']], ); // Using cache allows to narrow down the list to be retrieved. if ($use_cache && $_REQUEST['sort'] === 'real_name' && !isset($_REQUEST['desc'])) { $first_offset = $_REQUEST['start'] - ($_REQUEST['start'] % $cache_step_size); $second_offset = ceil(($_REQUEST['start'] + $modSettings['defaultMaxMembers']) / $cache_step_size) * $cache_step_size; $where = 'mem.real_name BETWEEN {string:real_name_low} AND {string:real_name_high}'; $query_parameters['real_name_low'] = $memberlist_cache['index'][$first_offset]; $query_parameters['real_name_high'] = $memberlist_cache['index'][$second_offset]; $limit -= $first_offset; } // Reverse sorting is a bit more complicated... elseif ($use_cache && $_REQUEST['sort'] === 'real_name') { $first_offset = floor(($memberlist_cache['num_members'] - $modSettings['defaultMaxMembers'] - $_REQUEST['start']) / $cache_step_size) * $cache_step_size; if ($first_offset < 0) $first_offset = 0; $second_offset = ceil(($memberlist_cache['num_members'] - $_REQUEST['start']) / $cache_step_size) * $cache_step_size; $where = 'mem.real_name BETWEEN {string:real_name_low} AND {string:real_name_high}'; $query_parameters['real_name_low'] = $memberlist_cache['index'][$first_offset]; $query_parameters['real_name_high'] = $memberlist_cache['index'][$second_offset]; $limit = $second_offset - ($memberlist_cache['num_members'] - $_REQUEST['start']) - ($second_offset > $memberlist_cache['num_members'] ? $cache_step_size - ($memberlist_cache['num_members'] % $cache_step_size) : 0); } // Select the members from the database. $request = $smcFunc['db_query']('', ' SELECT mem.id_member FROM {db_prefix}members AS mem' . ($_REQUEST['sort'] === 'is_online' ? ' LEFT JOIN {db_prefix}log_online AS lo ON (lo.id_member = mem.id_member)' : '') . ($_REQUEST['sort'] === 'id_group' ? ' LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = {int:regular_id_group} THEN mem.id_post_group ELSE mem.id_group END)' : '') . ' WHERE mem.is_activated = {int:is_activated}' . (empty($where) ? '' : ' AND ' . $where) . ' ORDER BY {raw:sort} LIMIT ' . $limit . ', ' . $modSettings['defaultMaxMembers'], $query_parameters ); printMemberListRows($request); $smcFunc['db_free_result']($request); // Add anchors at the start of each letter. if ($_REQUEST['sort'] == 'real_name') { $last_letter = ''; foreach ($context['members'] as $i => $dummy) { $this_letter = $smcFunc['strtolower']($smcFunc['substr']($context['members'][$i]['name'], 0, 1)); if ($this_letter != $last_letter && preg_match('~[a-z]~', $this_letter) === 1) { $context['members'][$i]['sort_letter'] = htmlspecialchars($this_letter); $last_letter = $this_letter; } } } } /** * Search for members, or display search results. * - Called by MemberList(). * - If variable 'search' is empty displays search dialog box, using the search sub template. * - Calls printMemberListRows to retrieve the results of the query. */ function MLSearch() { global $txt, $scripturl, $context, $user_info, $modSettings, $smcFunc; $context['page_title'] = $txt['mlist_search']; $context['can_moderate_forum'] = allowedTo('moderate_forum'); // Can they search custom fields? $request = $smcFunc['db_query']('', ' SELECT col_name, field_name, field_desc FROM {db_prefix}custom_fields WHERE active = {int:active} ' . (allowedTo('admin_forum') ? '' : ' AND private < {int:private_level}') . ' AND can_search = {int:can_search} AND (field_type = {string:field_type_text} OR field_type = {string:field_type_textarea})', array( 'active' => 1, 'can_search' => 1, 'private_level' => 2, 'field_type_text' => 'text', 'field_type_textarea' => 'textarea', ) ); $context['custom_search_fields'] = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $context['custom_search_fields'][$row['col_name']] = array( 'colname' => $row['col_name'], 'name' => $row['field_name'], 'desc' => $row['field_desc'], ); $smcFunc['db_free_result']($request); // They're searching.. if (isset($_REQUEST['search']) && isset($_REQUEST['fields'])) { $_POST['search'] = trim(isset($_GET['search']) ? $_GET['search'] : $_POST['search']); $_POST['fields'] = isset($_GET['fields']) ? explode(',', $_GET['fields']) : $_POST['fields']; $context['old_search'] = $_REQUEST['search']; $context['old_search_value'] = urlencode($_REQUEST['search']); // No fields? Use default... if (empty($_POST['fields'])) $_POST['fields'] = array('name'); // Set defaults for how the results are sorted if (!isset($_REQUEST['sort']) || !isset($context['columns'][$_REQUEST['sort']])) $_REQUEST['sort'] = 'real_name'; // Build the column link / sort information. foreach ($context['columns'] as $col => $column_details) { $context['columns'][$col]['href'] = $scripturl . '?action=mlist;sa=search;start=0;sort=' . $col; if ((!isset($_REQUEST['desc']) && $col == $_REQUEST['sort']) || ($col != $_REQUEST['sort'] && !empty($column_details['default_sort_rev']))) $context['columns'][$col]['href'] .= ';desc'; if (isset($_POST['search']) && isset($_POST['fields'])) $context['columns'][$col]['href'] .= ';search=' . $_POST['search'] . ';fields=' . implode(',', $_POST['fields']); $context['columns'][$col]['link'] = '' . $context['columns'][$col]['label'] . ''; $context['columns'][$col]['selected'] = $_REQUEST['sort'] == $col; } // set up some things for use in the template $context['sort_direction'] = !isset($_REQUEST['desc']) ? 'up' : 'down'; $context['sort_by'] = $_REQUEST['sort']; $query_parameters = array( 'regular_id_group' => 0, 'is_activated' => 1, 'blank_string' => '', 'search' => '%' . strtr($smcFunc['htmlspecialchars']($_POST['search'], ENT_QUOTES), array('_' => '\\_', '%' => '\\%', '*' => '%')) . '%', 'sort' => $context['columns'][$_REQUEST['sort']]['sort'][$context['sort_direction']], ); // Search for a name if (in_array('name', $_POST['fields'])) $fields = allowedTo('moderate_forum') ? array('member_name', 'real_name') : array('real_name'); else $fields = array(); // Search for messengers... if (in_array('messenger', $_POST['fields']) && (!$user_info['is_guest'] || empty($modSettings['guest_hideContacts']))) $fields += array(3 => 'msn', 'aim', 'icq', 'yim'); // Search for websites. if (in_array('website', $_POST['fields'])) $fields += array(7 => 'website_title', 'website_url'); // Search for groups. if (in_array('group', $_POST['fields'])) $fields += array(9 => 'IFNULL(group_name, {string:blank_string})'); // Search for an email address? if (in_array('email', $_POST['fields'])) { $fields += array(2 => allowedTo('moderate_forum') ? 'email_address' : '(hide_email = 0 AND email_address'); $condition = allowedTo('moderate_forum') ? '' : ')'; } else $condition = ''; if ($smcFunc['db_case_sensitive']) foreach ($fields as $key => $field) $fields[$key] = 'LOWER(' . $field . ')'; $customJoin = array(); $customCount = 10; // Any custom fields to search for - these being tricky? foreach ($_POST['fields'] as $field) { $curField = substr($field, 5); if (substr($field, 0, 5) == 'cust_' && isset($context['custom_search_fields'][$curField])) { $customJoin[] = 'LEFT JOIN {db_prefix}themes AS t' . $curField . ' ON (t' . $curField . '.variable = {string:t' . $curField . '} AND t' . $curField . '.id_theme = 1 AND t' . $curField . '.id_member = mem.id_member)'; $query_parameters['t' . $curField] = $curField; $fields += array($customCount++ => 'IFNULL(t' . $curField . '.value, {string:blank_string})'); } } $query = $_POST['search'] == '' ? '= {string:blank_string}' : ($smcFunc['db_case_sensitive'] ? 'LIKE LOWER({string:search})' : 'LIKE {string:search}'); $request = $smcFunc['db_query']('', ' SELECT COUNT(*) FROM {db_prefix}members AS mem LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = {int:regular_id_group} THEN mem.id_post_group ELSE mem.id_group END)' . (empty($customJoin) ? '' : implode(' ', $customJoin)) . ' WHERE (' . implode( ' ' . $query . ' OR ', $fields) . ' ' . $query . $condition . ') AND mem.is_activated = {int:is_activated}', $query_parameters ); list ($numResults) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); $context['page_index'] = constructPageIndex($scripturl . '?action=mlist;sa=search;search=' . $_POST['search'] . ';fields=' . implode(',', $_POST['fields']), $_REQUEST['start'], $numResults, $modSettings['defaultMaxMembers']); // Find the members from the database. $request = $smcFunc['db_query']('', ' SELECT mem.id_member FROM {db_prefix}members AS mem LEFT JOIN {db_prefix}log_online AS lo ON (lo.id_member = mem.id_member) LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = {int:regular_id_group} THEN mem.id_post_group ELSE mem.id_group END)' . (empty($customJoin) ? '' : implode(' ', $customJoin)) . ' WHERE (' . implode( ' ' . $query . ' OR ', $fields) . ' ' . $query . $condition . ') AND mem.is_activated = {int:is_activated} ORDER BY {raw:sort} LIMIT ' . $_REQUEST['start'] . ', ' . $modSettings['defaultMaxMembers'], $query_parameters ); printMemberListRows($request); $smcFunc['db_free_result']($request); } else { // These are all the possible fields. $context['search_fields'] = array( 'name' => $txt['mlist_search_name'], 'email' => $txt['mlist_search_email'], 'messenger' => $txt['mlist_search_messenger'], 'website' => $txt['mlist_search_website'], 'group' => $txt['mlist_search_group'], ); foreach ($context['custom_search_fields'] as $field) $context['search_fields']['cust_' . $field['colname']] = sprintf($txt['mlist_search_by'], $field['name']); // What do we search for by default? $context['search_defaults'] = array('name', 'email'); $context['sub_template'] = 'search'; $context['old_search'] = isset($_GET['search']) ? $_GET['search'] : (isset($_POST['search']) ? htmlspecialchars($_POST['search']) : ''); } $context['linktree'][] = array( 'url' => $scripturl . '?action=mlist;sa=search', 'name' => &$context['page_title'] ); // Highlight the correct button, too! unset($context['memberlist_buttons']['view_all_members']['active']); $context['memberlist_buttons']['mlist_search']['active'] = true; } /** * Retrieves results of the request passed to it * Puts results of request into the context for the sub template. * * @param resource $request */ function printMemberListRows($request) { global $scripturl, $txt, $user_info, $modSettings; global $context, $settings, $memberContext, $smcFunc; // Get the most posts. $result = $smcFunc['db_query']('', ' SELECT MAX(posts) FROM {db_prefix}members', array( ) ); list ($MOST_POSTS) = $smcFunc['db_fetch_row']($result); $smcFunc['db_free_result']($result); // Avoid division by zero... if ($MOST_POSTS == 0) $MOST_POSTS = 1; $members = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $members[] = $row['id_member']; // Load all the members for display. loadMemberData($members); $context['members'] = array(); foreach ($members as $member) { if (!loadMemberContext($member)) continue; $context['members'][$member] = $memberContext[$member]; $context['members'][$member]['post_percent'] = round(($context['members'][$member]['real_posts'] * 100) / $MOST_POSTS); $context['members'][$member]['registered_date'] = strftime('%Y-%m-%d', $context['members'][$member]['registered_timestamp']); } } ?>