', $context['user']['name'], '', allowedTo('pm_read') ? ', ' . $txt['msg_alert_you_have'] . ' ' . $context['user']['messages'] . ' ' . ($context['user']['messages'] == '1' ? $txt['message_lowercase'] : $txt['msg_alert_messages']) . '' . $txt['newmessages4'] . ' ' . $context['user']['unread_messages'] . ' ' . ($context['user']['unread_messages'] == '1' ? $txt['newmessages0'] : $txt['newmessages1']) : '', '.'; } // Don't echo... then do what?! else return $context['user']; } // Display a menu bar, like is displayed at the top of the forum. function ssi_menubar($output_method = 'echo') { global $context; if ($output_method == 'echo') template_menu(); // What else could this do? else return $context['menu_buttons']; } // Show a logout link. function ssi_logout($redirect_to = '', $output_method = 'echo') { global $context, $txt, $scripturl; if ($redirect_to != '') $_SESSION['logout_url'] = $redirect_to; // Guests can't log out. if ($context['user']['is_guest']) return false; $link = '' . $txt['logout'] . ''; if ($output_method == 'echo') echo $link; else return $link; } // Recent post list: [board] Subject by Poster Date function ssi_recentPosts($num_recent = 8, $exclude_boards = null, $include_boards = null, $output_method = 'echo', $limit_body = true) { global $context, $settings, $scripturl, $txt, $db_prefix, $user_info; global $modSettings, $smcFunc; // Excluding certain boards... if ($exclude_boards === null && !empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0) $exclude_boards = array($modSettings['recycle_board']); else $exclude_boards = empty($exclude_boards) ? array() : (is_array($exclude_boards) ? $exclude_boards : array($exclude_boards)); // What about including certain boards - note we do some protection here as pre-2.0 didn't have this parameter. if (is_array($include_boards) || (int) $include_boards === $include_boards) { $include_boards = is_array($include_boards) ? $include_boards : array($include_boards); } elseif ($include_boards != null) { $include_boards = array(); } // Let's restrict the query boys (and girls) $query_where = ' m.id_msg >= {int:min_message_id} ' . (empty($exclude_boards) ? '' : ' AND b.id_board NOT IN ({array_int:exclude_boards})') . ' ' . ($include_boards === null ? '' : ' AND b.id_board IN ({array_int:include_boards})') . ' AND {query_wanna_see_board}' . ($modSettings['postmod_active'] ? ' AND m.approved = {int:is_approved}' : ''); $query_where_params = array( 'is_approved' => 1, 'include_boards' => $include_boards === null ? '' : $include_boards, 'exclude_boards' => empty($exclude_boards) ? '' : $exclude_boards, 'min_message_id' => $modSettings['maxMsgID'] - 25 * min($num_recent, 5), ); // Past to this simpleton of a function... return ssi_queryPosts($query_where, $query_where_params, $num_recent, 'm.id_msg DESC', $output_method, $limit_body); } // Fetch a post with a particular ID. By default will only show if you have permission to the see the board in question - this can be overriden. function ssi_fetchPosts($post_ids = array(), $override_permissions = false, $output_method = 'echo') { global $user_info, $modSettings; if (empty($post_ids)) return; // Allow the user to request more than one - why not? $post_ids = is_array($post_ids) ? $post_ids : array($post_ids); // Restrict the posts required... $query_where = ' m.id_msg IN ({array_int:message_list})' . ($override_permissions ? '' : ' AND {query_wanna_see_board}') . ($modSettings['postmod_active'] ? ' AND m.approved = {int:is_approved}' : ''); $query_where_params = array( 'message_list' => $post_ids, 'is_approved' => 1, ); // Then make the query and dump the data. return ssi_queryPosts($query_where, $query_where_params, '', 'm.id_msg DESC', $output_method); } // This removes code duplication in other queries - don't call it direct unless you really know what you're up to. function ssi_queryPosts($query_where = '', $query_where_params = array(), $query_limit = 10, $query_order = 'm.id_msg DESC', $output_method = 'echo', $limit_body = false, $override_permissions = false) { global $context, $settings, $scripturl, $txt, $db_prefix, $user_info; global $modSettings, $smcFunc; // Find all the posts. Newer ones will have higher IDs. $request = $smcFunc['db_query']('substring', ' SELECT m.poster_time, m.subject, m.id_topic, m.id_member, m.id_msg, m.id_board, b.name AS board_name, IFNULL(mem.real_name, m.poster_name) AS poster_name, ' . ($user_info['is_guest'] ? '1 AS is_read, 0 AS new_from' : ' IFNULL(lt.id_msg, IFNULL(lmr.id_msg, 0)) >= m.id_msg_modified AS is_read, IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from') . ', ' . ($limit_body ? 'SUBSTRING(m.body, 1, 384) AS body' : 'm.body') . ', m.smileys_enabled FROM {db_prefix}messages AS m INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board) LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)' . (!$user_info['is_guest'] ? ' LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = m.id_topic AND lt.id_member = {int:current_member}) LEFT JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = m.id_board AND lmr.id_member = {int:current_member})' : '') . ' WHERE 1=1 ' . ($override_permissions ? '' : ' AND {query_wanna_see_board}') . ($modSettings['postmod_active'] ? ' AND m.approved = {int:is_approved}' : '') . ' ' . (empty($query_where) ? '' : 'AND ' . $query_where) . ' ORDER BY ' . $query_order . ' ' . ($query_limit == '' ? '' : 'LIMIT ' . $query_limit), array_merge($query_where_params, array( 'current_member' => $user_info['id'], 'is_approved' => 1, )) ); $posts = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) { $row['body'] = parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']); // Censor it! censorText($row['subject']); censorText($row['body']); $preview = strip_tags(strtr($row['body'], array('
' => ' '))); // Build the array. $posts[] = array( 'id' => $row['id_msg'], 'board' => array( 'id' => $row['id_board'], 'name' => $row['board_name'], 'href' => $scripturl . '?board=' . $row['id_board'] . '.0', 'link' => '' . $row['board_name'] . '' ), 'topic' => $row['id_topic'], 'poster' => array( 'id' => $row['id_member'], 'name' => $row['poster_name'], 'href' => empty($row['id_member']) ? '' : $scripturl . '?action=profile;u=' . $row['id_member'], 'link' => empty($row['id_member']) ? $row['poster_name'] : '' . $row['poster_name'] . '' ), 'subject' => $row['subject'], 'short_subject' => shorten_subject($row['subject'], 25), 'preview' => $smcFunc['strlen']($preview) > 128 ? $smcFunc['substr']($preview, 0, 128) . '...' : $preview, 'body' => $row['body'], 'time' => timeformat($row['poster_time']), 'timestamp' => forum_time(true, $row['poster_time']), 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . ';topicseen#new', 'link' => '' . $row['subject'] . '', 'new' => !empty($row['is_read']), 'is_new' => empty($row['is_read']), 'new_from' => $row['new_from'], ); } $smcFunc['db_free_result']($request); // Just return it. if ($output_method != 'echo' || empty($posts)) return $posts; echo ' '; foreach ($posts as $post) echo ' '; echo '
[', $post['board']['link'], '] ', $post['subject'], ' ', $txt['by'], ' ', $post['poster']['link'], ' ', $post['is_new'] ? '' . $txt['new'] . '' : '', ' ', $post['time'], '
'; } // Recent topic list: [board] Subject by Poster Date function ssi_recentTopics($num_recent = 8, $exclude_boards = null, $include_boards = null, $output_method = 'echo') { global $context, $settings, $scripturl, $txt, $db_prefix, $user_info; global $modSettings, $smcFunc; if ($exclude_boards === null && !empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0) $exclude_boards = array($modSettings['recycle_board']); else $exclude_boards = empty($exclude_boards) ? array() : (is_array($exclude_boards) ? $exclude_boards : array($exclude_boards)); // Only some boards?. if (is_array($include_boards) || (int) $include_boards === $include_boards) { $include_boards = is_array($include_boards) ? $include_boards : array($include_boards); } elseif ($include_boards != null) { $output_method = $include_boards; $include_boards = array(); } $stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless'); $icon_sources = array(); foreach ($stable_icons as $icon) $icon_sources[$icon] = 'images_url'; // Find all the posts in distinct topics. Newer ones will have higher IDs. $request = $smcFunc['db_query']('substring', ' SELECT m.poster_time, ms.subject, m.id_topic, m.id_member, m.id_msg, b.id_board, b.name AS board_name, t.num_replies, t.num_views, IFNULL(mem.real_name, m.poster_name) AS poster_name, ' . ($user_info['is_guest'] ? '1 AS is_read, 0 AS new_from' : ' IFNULL(lt.id_msg, IFNULL(lmr.id_msg, 0)) >= m.id_msg_modified AS is_read, IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from') . ', SUBSTRING(m.body, 1, 384) AS body, m.smileys_enabled, m.icon FROM {db_prefix}topics AS t INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_last_msg) INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board) INNER JOIN {db_prefix}messages AS ms ON (ms.id_msg = t.id_first_msg) LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)' . (!$user_info['is_guest'] ? ' LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = t.id_topic AND lt.id_member = {int:current_member}) LEFT JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = b.id_board AND lmr.id_member = {int:current_member})' : '') . ' WHERE t.id_last_msg >= {int:min_message_id} ' . (empty($exclude_boards) ? '' : ' AND b.id_board NOT IN ({array_int:exclude_boards})') . ' ' . (empty($include_boards) ? '' : ' AND b.id_board IN ({array_int:include_boards})') . ' AND {query_wanna_see_board}' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved} AND m.approved = {int:is_approved}' : '') . ' ORDER BY t.id_last_msg DESC LIMIT ' . $num_recent, array( 'current_member' => $user_info['id'], 'include_boards' => empty($include_boards) ? '' : $include_boards, 'exclude_boards' => empty($exclude_boards) ? '' : $exclude_boards, 'min_message_id' => $modSettings['maxMsgID'] - 35 * min($num_recent, 5), 'is_approved' => 1, ) ); $posts = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) { $row['body'] = strip_tags(strtr(parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']), array('
' => ' '))); if ($smcFunc['strlen']($row['body']) > 128) $row['body'] = $smcFunc['substr']($row['body'], 0, 128) . '...'; // Censor the subject. censorText($row['subject']); censorText($row['body']); if (empty($modSettings['messageIconChecks_disable']) && !isset($icon_sources[$row['icon']])) $icon_sources[$row['icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['icon'] . '.gif') ? 'images_url' : 'default_images_url'; // Build the array. $posts[] = array( 'board' => array( 'id' => $row['id_board'], 'name' => $row['board_name'], 'href' => $scripturl . '?board=' . $row['id_board'] . '.0', 'link' => '' . $row['board_name'] . '' ), 'topic' => $row['id_topic'], 'poster' => array( 'id' => $row['id_member'], 'name' => $row['poster_name'], 'href' => empty($row['id_member']) ? '' : $scripturl . '?action=profile;u=' . $row['id_member'], 'link' => empty($row['id_member']) ? $row['poster_name'] : '' . $row['poster_name'] . '' ), 'subject' => $row['subject'], 'replies' => $row['num_replies'], 'views' => $row['num_views'], 'short_subject' => shorten_subject($row['subject'], 25), 'preview' => $row['body'], 'time' => timeformat($row['poster_time']), 'timestamp' => forum_time(true, $row['poster_time']), 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . ';topicseen#new', 'link' => '' . $row['subject'] . '', // Retained for compatibility - is technically incorrect! 'new' => !empty($row['is_read']), 'is_new' => empty($row['is_read']), 'new_from' => $row['new_from'], 'icon' => '' . $row['icon'] . '', ); } $smcFunc['db_free_result']($request); // Just return it. if ($output_method != 'echo' || empty($posts)) return $posts; echo ' '; foreach ($posts as $post) echo ' '; echo '
[', $post['board']['link'], '] ', $post['subject'], ' ', $txt['by'], ' ', $post['poster']['link'], ' ', !$post['is_new'] ? '' : '' . $txt['new'] . '', ' ', $post['time'], '
'; } // Show the top poster's name and profile link. function ssi_topPoster($topNumber = 1, $output_method = 'echo') { global $db_prefix, $scripturl, $smcFunc; // Find the latest poster. $request = $smcFunc['db_query']('', ' SELECT id_member, real_name, posts FROM {db_prefix}members ORDER BY posts DESC LIMIT ' . $topNumber, array( ) ); $return = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $return[] = array( 'id' => $row['id_member'], 'name' => $row['real_name'], 'href' => $scripturl . '?action=profile;u=' . $row['id_member'], 'link' => '' . $row['real_name'] . '', 'posts' => $row['posts'] ); $smcFunc['db_free_result']($request); // Just return all the top posters. if ($output_method != 'echo') return $return; // Make a quick array to list the links in. $temp_array = array(); foreach ($return as $member) $temp_array[] = $member['link']; echo implode(', ', $temp_array); } // Show boards by activity. function ssi_topBoards($num_top = 10, $output_method = 'echo') { global $context, $settings, $db_prefix, $txt, $scripturl, $user_info, $modSettings, $smcFunc; // Find boards with lots of posts. $request = $smcFunc['db_query']('', ' SELECT b.name, b.num_topics, b.num_posts, b.id_board,' . (!$user_info['is_guest'] ? ' 1 AS is_read' : ' (IFNULL(lb.id_msg, 0) >= b.id_last_msg) AS is_read') . ' FROM {db_prefix}boards AS b LEFT JOIN {db_prefix}log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = {int:current_member}) WHERE {query_wanna_see_board}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' AND b.id_board != {int:recycle_board}' : '') . ' ORDER BY b.num_posts DESC LIMIT ' . $num_top, array( 'current_member' => $user_info['id'], 'recycle_board' => (int) $modSettings['recycle_board'], ) ); $boards = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $boards[] = array( 'id' => $row['id_board'], 'num_posts' => $row['num_posts'], 'num_topics' => $row['num_topics'], 'name' => $row['name'], 'new' => empty($row['is_read']), 'href' => $scripturl . '?board=' . $row['id_board'] . '.0', 'link' => '' . $row['name'] . '' ); $smcFunc['db_free_result']($request); // If we shouldn't output or have nothing to output, just jump out. if ($output_method != 'echo' || empty($boards)) return $boards; echo ' '; foreach ($boards as $board) echo ' '; echo '
', $txt['board'], ' ', $txt['board_topics'], ' ', $txt['posts'], '
', $board['link'], $board['new'] ? ' ' . $txt['new'] . '' : '', ' ', comma_format($board['num_topics']), ' ', comma_format($board['num_posts']), '
'; } // Shows the top topics. function ssi_topTopics($type = 'replies', $num_topics = 10, $output_method = 'echo') { global $db_prefix, $txt, $scripturl, $user_info, $modSettings, $smcFunc, $context; if ($modSettings['totalMessages'] > 100000) { // !!! Why don't we use {query(_wanna)_see_board}? $request = $smcFunc['db_query']('', ' SELECT id_topic FROM {db_prefix}topics WHERE num_' . ($type != 'replies' ? 'views' : 'replies') . ' != 0' . ($modSettings['postmod_active'] ? ' AND approved = {int:is_approved}' : '') . ' ORDER BY num_' . ($type != 'replies' ? 'views' : 'replies') . ' DESC LIMIT {int:limit}', array( 'is_approved' => 1, 'limit' => $num_topics > 100 ? ($num_topics + ($num_topics / 2)) : 100, ) ); $topic_ids = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $topic_ids[] = $row['id_topic']; $smcFunc['db_free_result']($request); } else $topic_ids = array(); $request = $smcFunc['db_query']('', ' SELECT m.subject, m.id_topic, t.num_views, t.num_replies FROM {db_prefix}topics AS t INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg) INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board) WHERE {query_wanna_see_board}' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . (!empty($topic_ids) ? ' AND t.id_topic IN ({array_int:topic_list})' : '') . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' AND b.id_board != {int:recycle_enable}' : '') . ' ORDER BY t.num_' . ($type != 'replies' ? 'views' : 'replies') . ' DESC LIMIT {int:limit}', array( 'topic_list' => $topic_ids, 'is_approved' => 1, 'recycle_enable' => $modSettings['recycle_board'], 'limit' => $num_topics, ) ); $topics = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) { censorText($row['subject']); $topics[] = array( 'id' => $row['id_topic'], 'subject' => $row['subject'], 'num_replies' => $row['num_replies'], 'num_views' => $row['num_views'], 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.0', 'link' => '' . $row['subject'] . '', ); } $smcFunc['db_free_result']($request); if ($output_method != 'echo' || empty($topics)) return $topics; echo ' '; foreach ($topics as $topic) echo ' '; echo '
', $txt['views'], ' ', $txt['replies'], '
', $topic['link'], ' ', comma_format($topic['num_views']), ' ', comma_format($topic['num_replies']), '
'; } // Shows the top topics, by replies. function ssi_topTopicsReplies($num_topics = 10, $output_method = 'echo') { return ssi_topTopics('replies', $num_topics, $output_method); } // Shows the top topics, by views. function ssi_topTopicsViews($num_topics = 10, $output_method = 'echo') { return ssi_topTopics('views', $num_topics, $output_method); } // Show a link to the latest member: Please welcome, Someone, out latest member. function ssi_latestMember($output_method = 'echo') { global $db_prefix, $txt, $scripturl, $context; if ($output_method == 'echo') echo ' ', $txt['welcome_member'], ' ', $context['common_stats']['latest_member']['link'], '', $txt['newest_member'], '
'; else return $context['common_stats']['latest_member']; } // Fetch a random member - if type set to 'day' will only change once a day! function ssi_randomMember($random_type = '', $output_method = 'echo') { global $modSettings; // If we're looking for something to stay the same each day then seed the generator. if ($random_type == 'day') { // Set the seed to change only once per day. mt_srand(floor(time() / 86400)); } // Get the lowest ID we're interested in. $member_id = mt_rand(1, $modSettings['latestMember']); $where_query = ' id_member >= {int:selected_member} AND is_activated = {int:is_activated}'; $query_where_params = array( 'selected_member' => $member_id, 'is_activated' => 1, ); $result = ssi_queryMembers($where_query, $query_where_params, 1, 'id_member ASC', $output_method); // If we got nothing do the reverse - in case of unactivated members. if (empty($result)) { $where_query = ' id_member <= {int:selected_member} AND is_activated = {int:is_activated}'; $query_where_params = array( 'selected_member' => $member_id, 'is_activated' => 1, ); $result = ssi_queryMembers($where_query, $query_where_params, 1, 'id_member DESC', $output_method); } // Just to be sure put the random generator back to something... random. if ($random_type != '') mt_srand(time()); return $result; } // Fetch a specific member. function ssi_fetchMember($member_ids = array(), $output_method = 'echo') { if (empty($member_ids)) return; // Can have more than one member if you really want... $member_ids = is_array($member_ids) ? $member_ids : array($member_ids); // Restrict it right! $query_where = ' id_member IN ({array_int:member_list})'; $query_where_params = array( 'member_list' => $member_ids, ); // Then make the query and dump the data. return ssi_queryMembers($query_where, $query_where_params, '', 'id_member', $output_method); } // Get all members of a group. function ssi_fetchGroupMembers($group_id = null, $output_method = 'echo') { if ($group_id === null) return; $query_where = ' id_group = {int:id_group} OR id_post_group = {int:id_group} OR FIND_IN_SET({int:id_group}, additional_groups) != 0'; $query_where_params = array( 'id_group' => $group_id, ); return ssi_queryMembers($query_where, $query_where_params, '', 'real_name', $output_method); } // Fetch some member data! function ssi_queryMembers($query_where = null, $query_where_params = array(), $query_limit = '', $query_order = 'id_member DESC', $output_method = 'echo') { global $context, $settings, $scripturl, $txt, $db_prefix, $user_info; global $modSettings, $smcFunc, $memberContext; if ($query_where === null) return; // Fetch the members in question. $request = $smcFunc['db_query']('', ' SELECT id_member FROM {db_prefix}members WHERE ' . $query_where . ' ORDER BY ' . $query_order . ' ' . ($query_limit == '' ? '' : 'LIMIT ' . $query_limit), array_merge($query_where_params, array( )) ); $members = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $members[] = $row['id_member']; $smcFunc['db_free_result']($request); if (empty($members)) return array(); // Load the members. loadMemberData($members); // Draw the table! if ($output_method == 'echo') echo ' '; $query_members = array(); foreach ($members as $member) { // Load their context data. if (!loadMemberContext($member)) continue; // Store this member's information. $query_members[$member] = $memberContext[$member]; // Only do something if we're echo'ing. if ($output_method == 'echo') echo ' '; } // End the table if appropriate. if ($output_method == 'echo') echo '
', $query_members[$member]['link'], '
', $query_members[$member]['blurb'], '
', $query_members[$member]['avatar']['image'], '
'; // Send back the data. return $query_members; } // Show some basic stats: Total This: XXXX, etc. function ssi_boardStats($output_method = 'echo') { global $db_prefix, $txt, $scripturl, $modSettings, $smcFunc; $totals = array( 'members' => $modSettings['totalMembers'], 'posts' => $modSettings['totalMessages'], 'topics' => $modSettings['totalTopics'] ); $result = $smcFunc['db_query']('', ' SELECT COUNT(*) FROM {db_prefix}boards', array( ) ); list ($totals['boards']) = $smcFunc['db_fetch_row']($result); $smcFunc['db_free_result']($result); $result = $smcFunc['db_query']('', ' SELECT COUNT(*) FROM {db_prefix}categories', array( ) ); list ($totals['categories']) = $smcFunc['db_fetch_row']($result); $smcFunc['db_free_result']($result); if ($output_method != 'echo') return $totals; echo ' ', $txt['total_members'], ': ', comma_format($totals['members']), '
', $txt['total_posts'], ': ', comma_format($totals['posts']), '
', $txt['total_topics'], ': ', comma_format($totals['topics']), '
', $txt['total_cats'], ': ', comma_format($totals['categories']), '
', $txt['total_boards'], ': ', comma_format($totals['boards']); } // Shows a list of online users: YY Guests, ZZ Users and then a list... function ssi_whosOnline($output_method = 'echo') { global $user_info, $txt, $sourcedir, $settings, $modSettings; require_once($sourcedir . '/Subs-MembersOnline.php'); $membersOnlineOptions = array( 'show_hidden' => allowedTo('moderate_forum'), 'sort' => 'log_time', 'reverse_sort' => true, ); $return = getMembersOnlineStats($membersOnlineOptions); // Add some redundancy for backwards compatibility reasons. if ($output_method != 'echo') return $return + array( 'users' => $return['users_online'], 'guests' => $return['num_guests'], 'hidden' => $return['num_users_hidden'], 'buddies' => $return['num_buddies'], 'num_users' => $return['num_users_online'], 'total_users' => $return['num_users_online'] + $return['num_guests'] + $return['num_spiders'], ); echo ' ', comma_format($return['num_guests']), ' ', $return['num_guests'] == 1 ? $txt['guest'] : $txt['guests'], ', ', comma_format($return['num_users_online']), ' ', $return['num_users_online'] == 1 ? $txt['user'] : $txt['users']; $bracketList = array(); if (!empty($user_info['buddies'])) $bracketList[] = comma_format($return['num_buddies']) . ' ' . ($return['num_buddies'] == 1 ? $txt['buddy'] : $txt['buddies']); if (!empty($return['num_spiders'])) $bracketList[] = comma_format($return['num_spiders']) . ' ' . ($return['num_spiders'] == 1 ? $txt['spider'] : $txt['spiders']); if (!empty($return['num_users_hidden'])) $bracketList[] = comma_format($return['num_users_hidden']) . ' ' . $txt['hidden']; if (!empty($bracketList)) echo ' (' . implode(', ', $bracketList) . ')'; echo '
', implode(', ', $return['list_users_online']); // Showing membergroups? if (!empty($settings['show_group_key']) && !empty($return['membergroups'])) echo '
[' . implode(']  [', $return['membergroups']) . ']'; } // Just like whosOnline except it also logs the online presence. function ssi_logOnline($output_method = 'echo') { writeLog(); if ($output_method != 'echo') return ssi_whosOnline($output_method); else ssi_whosOnline($output_method); } // Shows a login box. function ssi_login($redirect_to = '', $output_method = 'echo') { global $scripturl, $txt, $user_info, $context, $modSettings; if ($redirect_to != '') $_SESSION['login_url'] = $redirect_to; if ($output_method != 'echo' || !$user_info['is_guest']) return $user_info['is_guest']; echo '
'; // Open ID? if (!empty($modSettings['enableOpenID'])) echo ''; echo '
 
 
—', $txt['or'], '—
 
'; } // Show the most-voted-in poll. function ssi_topPoll($output_method = 'echo') { // Just use recentPoll, no need to duplicate code... return ssi_recentPoll(true, $output_method); } // Show the most recently posted poll. function ssi_recentPoll($topPollInstead = false, $output_method = 'echo') { global $db_prefix, $txt, $settings, $boardurl, $user_info, $context, $smcFunc, $modSettings; $boardsAllowed = array_intersect(boardsAllowedTo('poll_view'), boardsAllowedTo('poll_vote')); if (empty($boardsAllowed)) return array(); $request = $smcFunc['db_query']('', ' SELECT p.id_poll, p.question, t.id_topic, p.max_votes, p.guest_vote, p.hide_results, p.expire_time FROM {db_prefix}polls AS p INNER JOIN {db_prefix}topics AS t ON (t.id_poll = p.id_poll' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . ') INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)' . ($topPollInstead ? ' INNER JOIN {db_prefix}poll_choices AS pc ON (pc.id_poll = p.id_poll)' : '') . ' LEFT JOIN {db_prefix}log_polls AS lp ON (lp.id_poll = p.id_poll AND lp.id_member > {int:no_member} AND lp.id_member = {int:current_member}) WHERE p.voting_locked = {int:voting_opened} AND (p.expire_time = {int:no_expiration} OR {int:current_time} < p.expire_time) AND ' . ($user_info['is_guest'] ? 'p.guest_vote = {int:guest_vote_allowed}' : 'lp.id_choice IS NULL') . ' AND {query_wanna_see_board}' . (!in_array(0, $boardsAllowed) ? ' AND b.id_board IN ({array_int:boards_allowed_list})' : '') . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' AND b.id_board != {int:recycle_enable}' : '') . ' ORDER BY ' . ($topPollInstead ? 'pc.votes' : 'p.id_poll') . ' DESC LIMIT 1', array( 'current_member' => $user_info['id'], 'boards_allowed_list' => $boardsAllowed, 'is_approved' => 1, 'guest_vote_allowed' => 1, 'no_member' => 0, 'voting_opened' => 0, 'no_expiration' => 0, 'current_time' => time(), 'recycle_enable' => $modSettings['recycle_board'], ) ); $row = $smcFunc['db_fetch_assoc']($request); $smcFunc['db_free_result']($request); // This user has voted on all the polls. if ($row === false) return array(); // If this is a guest who's voted we'll through ourselves to show poll to show the results. if ($user_info['is_guest'] && (!$row['guest_vote'] || (isset($_COOKIE['guest_poll_vote']) && in_array($row['id_poll'], explode(',', $_COOKIE['guest_poll_vote']))))) return ssi_showPoll($row['id_topic'], $output_method); $request = $smcFunc['db_query']('', ' SELECT COUNT(DISTINCT id_member) FROM {db_prefix}log_polls WHERE id_poll = {int:current_poll}', array( 'current_poll' => $row['id_poll'], ) ); list ($total) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); $request = $smcFunc['db_query']('', ' SELECT id_choice, label, votes FROM {db_prefix}poll_choices WHERE id_poll = {int:current_poll}', array( 'current_poll' => $row['id_poll'], ) ); $options = array(); while ($rowChoice = $smcFunc['db_fetch_assoc']($request)) { censorText($rowChoice['label']); $options[$rowChoice['id_choice']] = array($rowChoice['label'], $rowChoice['votes']); } $smcFunc['db_free_result']($request); // Can they view it? $is_expired = !empty($row['expire_time']) && $row['expire_time'] < time(); $allow_view_results = allowedTo('moderate_board') || $row['hide_results'] == 0 || $is_expired; $return = array( 'id' => $row['id_poll'], 'image' => 'poll', 'question' => $row['question'], 'total_votes' => $total, 'is_locked' => false, 'topic' => $row['id_topic'], 'allow_view_results' => $allow_view_results, 'options' => array() ); // Calculate the percentages and bar lengths... $divisor = $return['total_votes'] == 0 ? 1 : $return['total_votes']; foreach ($options as $i => $option) { $bar = floor(($option[1] * 100) / $divisor); $barWide = $bar == 0 ? 1 : floor(($bar * 5) / 3); $return['options'][$i] = array( 'id' => 'options-' . ($topPollInstead ? 'top-' : 'recent-') . $i, 'percent' => $bar, 'votes' => $option[1], 'bar' => '-', 'option' => parse_bbc($option[0]), 'vote_button' => '' ); } $return['allowed_warning'] = $row['max_votes'] > 1 ? sprintf($txt['poll_options6'], min(count($options), $row['max_votes'])) : ''; if ($output_method != 'echo') return $return; if ($allow_view_results) { echo '
', $return['question'], '
', !empty($return['allowed_warning']) ? $return['allowed_warning'] . '
' : ''; foreach ($return['options'] as $option) echo '
'; echo '
'; } else echo $txt['poll_cannot_see']; } function ssi_showPoll($topic = null, $output_method = 'echo') { global $db_prefix, $txt, $settings, $boardurl, $user_info, $context, $smcFunc, $modSettings; $boardsAllowed = boardsAllowedTo('poll_view'); if (empty($boardsAllowed)) return array(); if ($topic === null && isset($_REQUEST['ssi_topic'])) $topic = (int) $_REQUEST['ssi_topic']; else $topic = (int) $topic; $request = $smcFunc['db_query']('', ' SELECT p.id_poll, p.question, p.voting_locked, p.hide_results, p.expire_time, p.max_votes, p.guest_vote, b.id_board FROM {db_prefix}topics AS t INNER JOIN {db_prefix}polls AS p ON (p.id_poll = t.id_poll) INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board) WHERE t.id_topic = {int:current_topic} AND {query_see_board}' . (!in_array(0, $boardsAllowed) ? ' AND b.id_board IN ({array_int:boards_allowed_see})' : '') . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . ' LIMIT 1', array( 'current_topic' => $topic, 'boards_allowed_see' => $boardsAllowed, 'is_approved' => 1, ) ); // Either this topic has no poll, or the user cannot view it. if ($smcFunc['db_num_rows']($request) == 0) return array(); $row = $smcFunc['db_fetch_assoc']($request); $smcFunc['db_free_result']($request); // Check if they can vote. $already_voted = false; if (!empty($row['expire_time']) && $row['expire_time'] < time()) $allow_vote = false; elseif ($user_info['is_guest']) { // There's a difference between "allowed to vote" and "already voted"... $allow_vote = $row['guest_vote']; // Did you already vote? if (isset($_COOKIE['guest_poll_vote']) && in_array($row['id_poll'], explode(',', $_COOKIE['guest_poll_vote']))) { $already_voted = true; } } elseif (!empty($row['voting_locked']) || !allowedTo('poll_vote', $row['id_board'])) $allow_vote = false; else { $request = $smcFunc['db_query']('', ' SELECT id_member FROM {db_prefix}log_polls WHERE id_poll = {int:current_poll} AND id_member = {int:current_member} LIMIT 1', array( 'current_member' => $user_info['id'], 'current_poll' => $row['id_poll'], ) ); $allow_vote = $smcFunc['db_num_rows']($request) == 0; $already_voted = $allow_vote; $smcFunc['db_free_result']($request); } // Can they view? $is_expired = !empty($row['expire_time']) && $row['expire_time'] < time(); $allow_view_results = allowedTo('moderate_board') || $row['hide_results'] == 0 || ($row['hide_results'] == 1 && $already_voted) || $is_expired; $request = $smcFunc['db_query']('', ' SELECT COUNT(DISTINCT id_member) FROM {db_prefix}log_polls WHERE id_poll = {int:current_poll}', array( 'current_poll' => $row['id_poll'], ) ); list ($total) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); $request = $smcFunc['db_query']('', ' SELECT id_choice, label, votes FROM {db_prefix}poll_choices WHERE id_poll = {int:current_poll}', array( 'current_poll' => $row['id_poll'], ) ); $options = array(); $total_votes = 0; while ($rowChoice = $smcFunc['db_fetch_assoc']($request)) { censorText($rowChoice['label']); $options[$rowChoice['id_choice']] = array($rowChoice['label'], $rowChoice['votes']); $total_votes += $rowChoice['votes']; } $smcFunc['db_free_result']($request); $return = array( 'id' => $row['id_poll'], 'image' => empty($pollinfo['voting_locked']) ? 'poll' : 'locked_poll', 'question' => $row['question'], 'total_votes' => $total, 'is_locked' => !empty($pollinfo['voting_locked']), 'allow_vote' => $allow_vote, 'allow_view_results' => $allow_view_results, 'topic' => $topic ); // Calculate the percentages and bar lengths... $divisor = $total_votes == 0 ? 1 : $total_votes; foreach ($options as $i => $option) { $bar = floor(($option[1] * 100) / $divisor); $barWide = $bar == 0 ? 1 : floor(($bar * 5) / 3); $return['options'][$i] = array( 'id' => 'options-' . $i, 'percent' => $bar, 'votes' => $option[1], 'bar' => '-', 'option' => parse_bbc($option[0]), 'vote_button' => '' ); } $return['allowed_warning'] = $row['max_votes'] > 1 ? sprintf($txt['poll_options6'], min(count($options), $row['max_votes'])) : ''; if ($output_method != 'echo') return $return; if ($return['allow_vote']) { echo '
', $return['question'], '
', !empty($return['allowed_warning']) ? $return['allowed_warning'] . '
' : ''; foreach ($return['options'] as $option) echo '
'; echo '
'; } else { echo '
', $return['question'], '
'; foreach ($return['options'] as $option) { echo '
', $option['option'], '
'; if ($return['allow_view_results']) { echo '
', $option['votes'], ' (', $option['percent'], '%)'; } echo '
'; } echo '
', ($return['allow_view_results'] ? ' '. $txt['poll_total_voters'] .': '. $return['total_votes'] .'' : ''), '
'; } } // Takes care of voting - don't worry, this is done automatically. function ssi_pollVote() { global $context, $db_prefix, $user_info, $sc, $smcFunc, $sourcedir, $modSettings; if (!isset($_POST[$context['session_var']]) || $_POST[$context['session_var']] != $sc || empty($_POST['options']) || !isset($_POST['poll'])) { echo ' « '; return; } // This can cause weird errors! (ie. copyright missing.) checkSession(); $_POST['poll'] = (int) $_POST['poll']; // Check if they have already voted, or voting is locked. $request = $smcFunc['db_query']('', ' SELECT p.id_poll, p.voting_locked, p.expire_time, p.max_votes, p.guest_vote, t.id_topic, IFNULL(lp.id_choice, -1) AS selected FROM {db_prefix}polls AS p INNER JOIN {db_prefix}topics AS t ON (t.id_poll = {int:current_poll}) INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board) LEFT JOIN {db_prefix}log_polls AS lp ON (lp.id_poll = p.id_poll AND lp.id_member = {int:current_member}) WHERE p.id_poll = {int:current_poll} AND {query_see_board}' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . ' LIMIT 1', array( 'current_member' => $user_info['id'], 'current_poll' => $_POST['poll'], 'is_approved' => 1, ) ); if ($smcFunc['db_num_rows']($request) == 0) die; $row = $smcFunc['db_fetch_assoc']($request); $smcFunc['db_free_result']($request); if (!empty($row['voting_locked']) || ($row['selected'] != -1 && !$user_info['is_guest']) || (!empty($row['expire_time']) && time() > $row['expire_time'])) redirectexit('topic=' . $row['id_topic'] . '.0'); // Too many options checked? if (count($_REQUEST['options']) > $row['max_votes']) redirectexit('topic=' . $row['id_topic'] . '.0'); // It's a guest who has already voted? if ($user_info['is_guest']) { // Guest voting disabled? if (!$row['guest_vote']) redirectexit('topic=' . $row['id_topic'] . '.0'); // Already voted? elseif (isset($_COOKIE['guest_poll_vote']) && in_array($row['id_poll'], explode(',', $_COOKIE['guest_poll_vote']))) redirectexit('topic=' . $row['id_topic'] . '.0'); } $options = array(); $inserts = array(); foreach ($_REQUEST['options'] as $id) { $id = (int) $id; $options[] = $id; $inserts[] = array($_POST['poll'], $user_info['id'], $id); } // Add their vote in to the tally. $smcFunc['db_insert']('insert', $db_prefix . 'log_polls', array('id_poll' => 'int', 'id_member' => 'int', 'id_choice' => 'int'), $inserts, array('id_poll', 'id_member', 'id_choice') ); $smcFunc['db_query']('', ' UPDATE {db_prefix}poll_choices SET votes = votes + 1 WHERE id_poll = {int:current_poll} AND id_choice IN ({array_int:option_list})', array( 'option_list' => $options, 'current_poll' => $_POST['poll'], ) ); // Track the vote if a guest. if ($user_info['is_guest']) { $_COOKIE['guest_poll_vote'] = !empty($_COOKIE['guest_poll_vote']) ? ($_COOKIE['guest_poll_vote'] . ',' . $row['id_poll']) : $row['id_poll']; require_once($sourcedir . '/Subs-Auth.php'); $cookie_url = url_parts(!empty($modSettings['localCookies']), !empty($modSettings['globalCookies'])); setcookie('guest_poll_vote', $_COOKIE['guest_poll_vote'], time() + 2500000, $cookie_url[1], $cookie_url[0], 0); } redirectexit('topic=' . $row['id_topic'] . '.0'); } // Show a search box. function ssi_quickSearch($output_method = 'echo') { global $scripturl, $txt, $context; if ($output_method != 'echo') return $scripturl . '?action=search'; echo '
'; } // Show what would be the forum news. function ssi_news($output_method = 'echo') { global $context; if ($output_method != 'echo') return $context['random_news_line']; echo $context['random_news_line']; } // Show today's birthdays. function ssi_todaysBirthdays($output_method = 'echo') { global $scripturl, $modSettings, $user_info; if (empty($modSettings['cal_enabled']) || !allowedTo('calendar_view') || !allowedTo('profile_view_any')) return; $eventOptions = array( 'include_birthdays' => true, 'num_days_shown' => empty($modSettings['cal_days_for_index']) || $modSettings['cal_days_for_index'] < 1 ? 1 : $modSettings['cal_days_for_index'], ); $return = cache_quick_get('calendar_index_offset_' . ($user_info['time_offset'] + $modSettings['time_offset']), 'Subs-Calendar.php', 'cache_getRecentEvents', array($eventOptions)); if ($output_method != 'echo') return $return['calendar_birthdays']; foreach ($return['calendar_birthdays'] as $member) echo ' ' . $member['name'] . (isset($member['age']) ? ' (' . $member['age'] . ')' : '') . '' . (!$member['is_last'] ? ', ' : ''); } // Show today's holidays. function ssi_todaysHolidays($output_method = 'echo') { global $modSettings, $user_info; if (empty($modSettings['cal_enabled']) || !allowedTo('calendar_view')) return; $eventOptions = array( 'include_holidays' => true, 'num_days_shown' => empty($modSettings['cal_days_for_index']) || $modSettings['cal_days_for_index'] < 1 ? 1 : $modSettings['cal_days_for_index'], ); $return = cache_quick_get('calendar_index_offset_' . ($user_info['time_offset'] + $modSettings['time_offset']), 'Subs-Calendar.php', 'cache_getRecentEvents', array($eventOptions)); if ($output_method != 'echo') return $return['calendar_holidays']; echo ' ', implode(', ', $return['calendar_holidays']); } // Show today's events. function ssi_todaysEvents($output_method = 'echo') { global $modSettings, $user_info; if (empty($modSettings['cal_enabled']) || !allowedTo('calendar_view')) return; $eventOptions = array( 'include_events' => true, 'num_days_shown' => empty($modSettings['cal_days_for_index']) || $modSettings['cal_days_for_index'] < 1 ? 1 : $modSettings['cal_days_for_index'], ); $return = cache_quick_get('calendar_index_offset_' . ($user_info['time_offset'] + $modSettings['time_offset']), 'Subs-Calendar.php', 'cache_getRecentEvents', array($eventOptions)); if ($output_method != 'echo') return $return['calendar_events']; foreach ($return['calendar_events'] as $event) { if ($event['can_edit']) echo ' * '; echo ' ' . $event['link'] . (!$event['is_last'] ? ', ' : ''); } } // Show all calendar entires for today. (birthdays, holodays, and events.) function ssi_todaysCalendar($output_method = 'echo') { global $modSettings, $txt, $scripturl, $user_info; $eventOptions = array( 'include_birthdays' => allowedTo('profile_view_any'), 'include_holidays' => true, 'include_events' => true, 'num_days_shown' => empty($modSettings['cal_days_for_index']) || $modSettings['cal_days_for_index'] < 1 ? 1 : $modSettings['cal_days_for_index'], ); $return = cache_quick_get('calendar_index_offset_' . ($user_info['time_offset'] + $modSettings['time_offset']), 'Subs-Calendar.php', 'cache_getRecentEvents', array($eventOptions)); if ($output_method != 'echo') return $return; if (!empty($return['calendar_holidays'])) echo ' ' . $txt['calendar_prompt'] . ' ' . implode(', ', $return['calendar_holidays']) . '
'; if (!empty($return['calendar_birthdays'])) { echo ' ' . $txt['birthdays_upcoming'] . ' '; foreach ($return['calendar_birthdays'] as $member) echo ' ', $member['name'], isset($member['age']) ? ' (' . $member['age'] . ')' : '', '', !$member['is_last'] ? ', ' : ''; echo '
'; } if (!empty($return['calendar_events'])) { echo ' ' . $txt['events_upcoming'] . ' '; foreach ($return['calendar_events'] as $event) { if ($event['can_edit']) echo ' * '; echo ' ' . $event['link'] . (!$event['is_last'] ? ', ' : ''); } } } // Show the latest news, with a template... by board. function ssi_boardNews($board = null, $limit = null, $start = null, $length = null, $output_method = 'echo') { global $scripturl, $db_prefix, $txt, $settings, $modSettings, $context; global $smcFunc; loadLanguage('Stats'); // Must be integers.... if ($limit === null) $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 5; else $limit = (int) $limit; if ($start === null) $start = isset($_GET['start']) ? (int) $_GET['start'] : 0; else $start = (int) $start; if ($board !== null) $board = (int) $board; elseif (isset($_GET['board'])) $board = (int) $_GET['board']; if ($length === null) $length = isset($_GET['length']) ? (int) $_GET['length'] : 0; else $length = (int) $length; $limit = max(0, $limit); $start = max(0, $start); // Make sure guests can see this board. $request = $smcFunc['db_query']('', ' SELECT id_board FROM {db_prefix}boards WHERE ' . ($board === null ? '' : 'id_board = {int:current_board} AND ') . 'FIND_IN_SET(-1, member_groups) != 0 LIMIT 1', array( 'current_board' => $board, ) ); if ($smcFunc['db_num_rows']($request) == 0) { if ($output_method == 'echo') die($txt['ssi_no_guests']); else return array(); } list ($board) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); // Load the message icons - the usual suspects. $stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless'); $icon_sources = array(); foreach ($stable_icons as $icon) $icon_sources[$icon] = 'images_url'; // Find the post ids. $request = $smcFunc['db_query']('', ' SELECT t.id_first_msg FROM {db_prefix}topics as t LEFT JOIN {db_prefix}boards as b ON (b.id_board = t.id_board) WHERE t.id_board = {int:current_board}' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . ' AND {query_see_board} ORDER BY t.id_first_msg DESC LIMIT ' . $start . ', ' . $limit, array( 'current_board' => $board, 'is_approved' => 1, ) ); $posts = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) $posts[] = $row['id_first_msg']; $smcFunc['db_free_result']($request); if (empty($posts)) return array(); // Find the posts. $request = $smcFunc['db_query']('', ' SELECT m.icon, m.subject, m.body, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.poster_time, t.num_replies, t.id_topic, m.id_member, m.smileys_enabled, m.id_msg, t.locked, t.id_last_msg FROM {db_prefix}topics AS t INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg) LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member) WHERE t.id_first_msg IN ({array_int:post_list}) ORDER BY t.id_first_msg DESC LIMIT ' . count($posts), array( 'post_list' => $posts, ) ); $return = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) { // If we want to limit the length of the post. if (!empty($length) && $smcFunc['strlen']($row['body']) > $length) { $row['body'] = $smcFunc['substr']($row['body'], 0, $length); // The first space or line break. (
, etc.) $cutoff = max(strrpos($row['body'], ' '), strrpos($row['body'], '<')); if ($cutoff !== false) $row['body'] = $smcFunc['substr']($row['body'], 0, $cutoff); $row['body'] .= '...'; } $row['body'] = parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']); // Check that this message icon is there... if (empty($modSettings['messageIconChecks_disable']) && !isset($icon_sources[$row['icon']])) $icon_sources[$row['icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['icon'] . '.gif') ? 'images_url' : 'default_images_url'; censorText($row['subject']); censorText($row['body']); $return[] = array( 'id' => $row['id_topic'], 'message_id' => $row['id_msg'], 'icon' => '' . $row['icon'] . '', 'subject' => $row['subject'], 'time' => timeformat($row['poster_time']), 'timestamp' => forum_time(true, $row['poster_time']), 'body' => $row['body'], 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.0', 'link' => '' . $row['num_replies'] . ' ' . ($row['num_replies'] == 1 ? $txt['ssi_comment'] : $txt['ssi_comments']) . '', 'replies' => $row['num_replies'], 'comment_href' => !empty($row['locked']) ? '' : $scripturl . '?action=post;topic=' . $row['id_topic'] . '.' . $row['num_replies'] . ';last_msg=' . $row['id_last_msg'], 'comment_link' => !empty($row['locked']) ? '' : '' . $txt['ssi_write_comment'] . '', 'new_comment' => !empty($row['locked']) ? '' : '' . $txt['ssi_write_comment'] . '', 'poster' => array( 'id' => $row['id_member'], 'name' => $row['poster_name'], 'href' => !empty($row['id_member']) ? $scripturl . '?action=profile;u=' . $row['id_member'] : '', 'link' => !empty($row['id_member']) ? '' . $row['poster_name'] . '' : $row['poster_name'] ), 'locked' => !empty($row['locked']), 'is_last' => false ); } $smcFunc['db_free_result']($request); if (empty($return)) return $return; $return[count($return) - 1]['is_last'] = true; if ($output_method != 'echo') return $return; foreach ($return as $news) { echo '

', $news['icon'], ' ', $news['subject'], '

', $news['time'], ' ', $txt['by'], ' ', $news['poster']['link'], '
', $news['body'], '
', $news['link'], $news['locked'] ? '' : ' | ' . $news['comment_link'], '
'; if (!$news['is_last']) echo '
'; } } // Show the most recent events. function ssi_recentEvents($max_events = 7, $output_method = 'echo') { global $db_prefix, $user_info, $scripturl, $modSettings, $txt, $context, $smcFunc; if (empty($modSettings['cal_enabled']) || !allowedTo('calendar_view')) return; // Find all events which are happening in the near future that the member can see. $request = $smcFunc['db_query']('', ' SELECT cal.id_event, cal.start_date, cal.end_date, cal.title, cal.id_member, cal.id_topic, cal.id_board, t.id_first_msg, t.approved FROM {db_prefix}calendar AS cal LEFT JOIN {db_prefix}boards AS b ON (b.id_board = cal.id_board) LEFT JOIN {db_prefix}topics AS t ON (t.id_topic = cal.id_topic) WHERE cal.start_date <= {date:current_date} AND cal.end_date >= {date:current_date} AND (cal.id_board = {int:no_board} OR {query_wanna_see_board}) ORDER BY cal.start_date DESC LIMIT ' . $max_events, array( 'current_date' => strftime('%Y-%m-%d', forum_time(false)), 'no_board' => 0, ) ); $return = array(); $duplicates = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) { // Check if we've already come by an event linked to this same topic with the same title... and don't display it if we have. if (!empty($duplicates[$row['title'] . $row['id_topic']])) continue; // Censor the title. censorText($row['title']); if ($row['start_date'] < strftime('%Y-%m-%d', forum_time(false))) $date = strftime('%Y-%m-%d', forum_time(false)); else $date = $row['start_date']; // If the topic it is attached to is not approved then don't link it. if (!empty($row['id_first_msg']) && !$row['approved']) $row['id_board'] = $row['id_topic'] = $row['id_first_msg'] = 0; $return[$date][] = array( 'id' => $row['id_event'], 'title' => $row['title'], 'can_edit' => allowedTo('calendar_edit_any') || ($row['id_member'] == $user_info['id'] && allowedTo('calendar_edit_own')), 'modify_href' => $scripturl . '?action=' . ($row['id_board'] == 0 ? 'calendar;sa=post;' : 'post;msg=' . $row['id_first_msg'] . ';topic=' . $row['id_topic'] . '.0;calendar;') . 'eventid=' . $row['id_event'] . ';' . $context['session_var'] . '=' . $context['session_id'], 'href' => $row['id_board'] == 0 ? '' : $scripturl . '?topic=' . $row['id_topic'] . '.0', 'link' => $row['id_board'] == 0 ? $row['title'] : '' . $row['title'] . '', 'start_date' => $row['start_date'], 'end_date' => $row['end_date'], 'is_last' => false ); // Let's not show this one again, huh? $duplicates[$row['title'] . $row['id_topic']] = true; } $smcFunc['db_free_result']($request); foreach ($return as $mday => $array) $return[$mday][count($array) - 1]['is_last'] = true; if ($output_method != 'echo' || empty($return)) return $return; // Well the output method is echo. echo ' ' . $txt['events'] . ' '; foreach ($return as $mday => $array) foreach ($array as $event) { if ($event['can_edit']) echo ' * '; echo ' ' . $event['link'] . (!$event['is_last'] ? ', ' : ''); } } // Check the passed id_member/password. If $is_username is true, treats $id as a username. function ssi_checkPassword($id = null, $password = null, $is_username = false) { global $db_prefix, $sourcedir, $smcFunc; // If $id is null, this was most likely called from a query string and should do nothing. if ($id === null) return; $request = $smcFunc['db_query']('', ' SELECT passwd, member_name, is_activated FROM {db_prefix}members WHERE ' . ($is_username ? 'member_name' : 'id_member') . ' = {string:id} LIMIT 1', array( 'id' => $id, ) ); list ($pass, $user, $active) = $smcFunc['db_fetch_row']($request); $smcFunc['db_free_result']($request); return sha1(strtolower($user) . $password) == $pass && $active == 1; } // We want to show the recent attachments outside of the forum. function ssi_recentAttachments($num_attachments = 10, $attachment_ext = array(), $output_method = 'echo') { global $smcFunc, $context, $modSettings, $scripturl, $txt, $settings; // We want to make sure that we only get attachments for boards that we can see *if* any. $attachments_boards = boardsAllowedTo('view_attachments'); // No boards? Adios amigo. if (empty($attachments_boards)) return array(); // Is it an array? if (!is_array($attachment_ext)) $attachment_ext = array($attachment_ext); // Lets build the query. $request = $smcFunc['db_query']('', ' SELECT att.id_attach, att.id_msg, att.filename, IFNULL(att.size, 0) AS filesize, att.downloads, mem.id_member, IFNULL(mem.real_name, m.poster_name) AS poster_name, m.id_topic, m.subject, t.id_board, m.poster_time, att.width, att.height' . (empty($modSettings['attachmentShowImages']) || empty($modSettings['attachmentThumbnails']) ? '' : ', IFNULL(thumb.id_attach, 0) AS id_thumb, thumb.width AS thumb_width, thumb.height AS thumb_height') . ' FROM {db_prefix}attachments AS att INNER JOIN {db_prefix}messages AS m ON (m.id_msg = att.id_msg) INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic) LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)' . (empty($modSettings['attachmentShowImages']) || empty($modSettings['attachmentThumbnails']) ? '' : ' LEFT JOIN {db_prefix}attachments AS thumb ON (thumb.id_attach = att.id_thumb)') . ' WHERE att.attachment_type = 0' . ($attachments_boards === array(0) ? '' : ' AND m.id_board IN ({array_int:boards_can_see})') . (!empty($attachment_ext) ? ' AND att.fileext IN ({array_string:attachment_ext})' : '') . (!$modSettings['postmod_active'] || allowedTo('approve_posts') ? '' : ' AND t.approved = {int:is_approved} AND m.approved = {int:is_approved} AND att.approved = {int:is_approved}') . ' ORDER BY att.id_attach DESC LIMIT {int:num_attachments}', array( 'boards_can_see' => $attachments_boards, 'attachment_ext' => $attachment_ext, 'num_attachments' => $num_attachments, 'is_approved' => 1, ) ); // We have something. $attachments = array(); while ($row = $smcFunc['db_fetch_assoc']($request)) { $filename = preg_replace('~&#(\\d{1,7}|x[0-9a-fA-F]{1,6});~', '&#\\1;', htmlspecialchars($row['filename'])); // Is it an image? $attachments[$row['id_attach']] = array( 'member' => array( 'id' => $row['id_member'], 'name' => $row['poster_name'], 'link' => empty($row['id_member']) ? $row['poster_name'] : '' . $row['poster_name'] . '', ), 'file' => array( 'filename' => $filename, 'filesize' => round($row['filesize'] /1024, 2) . $txt['kilobyte'], 'downloads' => $row['downloads'], 'href' => $scripturl . '?action=dlattach;topic=' . $row['id_topic'] . '.0;attach=' . $row['id_attach'], 'link' => ' ' . $filename . '', 'is_image' => !empty($row['width']) && !empty($row['height']) && !empty($modSettings['attachmentShowImages']), ), 'topic' => array( 'id' => $row['id_topic'], 'subject' => $row['subject'], 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'], 'link' => '' . $row['subject'] . '', 'time' => timeformat($row['poster_time']), ), ); // Images. if ($attachments[$row['id_attach']]['file']['is_image']) { $id_thumb = empty($row['id_thumb']) ? $row['id_attach'] : $row['id_thumb']; $attachments[$row['id_attach']]['file']['image'] = array( 'id' => $id_thumb, 'width' => $row['width'], 'height' => $row['height'], 'img' => '' . $filename . '', 'thumb' => '' . $filename . '', 'href' => $scripturl . '?action=dlattach;topic=' . $row['id_topic'] . '.0;attach=' . $id_thumb . ';image', 'link' => '' . $filename . '', ); } } $smcFunc['db_free_result']($request); // So you just want an array? Here you can have it. if ($output_method == 'array' || empty($attachments)) return $attachments; // Give them the default. echo ' '; foreach ($attachments as $attach) echo ' '; echo '
', $txt['file'], ' ', $txt['posted_by'], ' ', $txt['downloads'], ' ', $txt['filesize'], '
', $attach['file']['link'], ' ', $attach['member']['link'], ' ', $attach['file']['downloads'], ' ', $attach['file']['filesize'], '
'; } ?>