Last active
January 1, 2016 18:19
-
-
Save emanuele45/8182929 to your computer and use it in GitHub Desktop.
Performance testing for BoardIndex query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| global $user_info, $cache_enable; | |
| require_once('../big_elk/SSI.php'); | |
| require_once(SUBSDIR . '/Categories.subs.php'); | |
| $cache_enable = 1; | |
| $db = database(); | |
| $iterations = 100; | |
| $users = array( | |
| 'admin' => array( | |
| 'id' => 1, | |
| 'query' => '1=1', | |
| ), | |
| 'guest' => array( | |
| 'id' => 0, | |
| 'query' => ' ((FIND_IN_SET(-1, b.member_groups) != 0))', | |
| ), | |
| 'normal' => array( | |
| 'id' => 50001, | |
| 'query' => ' ((FIND_IN_SET(0, b.member_groups) != 0 OR FIND_IN_SET(4, b.member_groups) != 0))', | |
| ), | |
| ); | |
| $boardoptions = array( | |
| 'bi_nocount' => array( | |
| 'include_categories' => true, | |
| 'base_level' => 0, | |
| 'parent_id' => 0, | |
| 'set_latest_post' => true, | |
| 'countChildPosts' => 0, | |
| ), | |
| 'bi_count' => array( | |
| 'include_categories' => true, | |
| 'base_level' => 0, | |
| 'parent_id' => 0, | |
| 'set_latest_post' => true, | |
| 'countChildPosts' => 1, | |
| ), | |
| 'sub_nocount' => array( | |
| 'include_categories' => false, | |
| 'base_level' => 1, | |
| 'parent_id' => 6, | |
| 'set_latest_post' => false, | |
| 'countChildPosts' => 0, | |
| ), | |
| 'sub_count' => array( | |
| 'include_categories' => false, | |
| 'base_level' => 1, | |
| 'parent_id' => 6, | |
| 'set_latest_post' => false, | |
| 'countChildPosts' => 1, | |
| ), | |
| ); | |
| collapseCategories(range(1, 5), 'collapse', range(2, 50000)); | |
| collapseCategories(range(1, 5), 'expand', array(1, 50001)); | |
| for ($a = 0; $a < 2; $a++) | |
| { | |
| if ($a == 1) | |
| { | |
| $fill = array(); | |
| while (count($fill) < 5) | |
| for ($b = count($fill); $b < 5; $b++) | |
| $fill[$b] = rand(1, 10); | |
| collapseCategories($fill, 'collapse', array(1, 50001)); | |
| } | |
| $usrs = $users; | |
| while (!empty($usrs)) | |
| { | |
| $bopt = $boardoptions; | |
| $rank = array_rand($usrs); | |
| $user = $usrs[$rank]; | |
| unset($usrs[$rank]); | |
| $user_info['id'] = $user['id']; | |
| $user_info['query_see_board'] = $user['query']; | |
| $user_info['is_guest'] = empty($user['id']); | |
| $user_info['is_admin'] = $user['id'] == 1; | |
| while (!empty($bopt)) | |
| { | |
| @set_time_limit(600); | |
| if (function_exists('apache_reset_timeout')) | |
| @apache_reset_timeout(); | |
| $type = array_rand($bopt); | |
| $boardIndexOptions = $bopt[$type]; | |
| unset($bopt[$type]); | |
| for ($i = 0; $i < 8; $i++) | |
| { | |
| $opt = str_pad(decbin($i), 3, '0', STR_PAD_LEFT); | |
| $start[$a][$rank][$type][$i] = microtime(true); | |
| for ($l = 0; $l < $iterations; $l++) | |
| getBoardIndex($boardIndexOptions, $opt[0], $opt[1], $opt[2]); | |
| $end[$a][$rank][$type][$i] = microtime(true); | |
| } | |
| } | |
| } | |
| if ($a == 1) | |
| collapseCategories($fill, 'expand', array(1, 50001)); | |
| } | |
| foreach ($start as $a => $ranks) | |
| { | |
| echo '<div style="width: 49%;display: inline-block;"> | |
| <pre>'; | |
| echo $a == 0 ? '~=~=~ Uncollapsed ~=~=~<br />' : '~=~=~ Collapsed ~=~=~<br />'; | |
| ksort($ranks); | |
| foreach ($ranks as $rank => $types) | |
| { | |
| echo $rank . '<br />'; | |
| ksort($types); | |
| foreach ($types as $type => $is) | |
| { | |
| echo $type . '<br />'; | |
| foreach ($is as $i => $val) | |
| { | |
| $opt = str_pad(decbin($i), 3, '0', STR_PAD_LEFT); | |
| echo $i . ': ', $opt[0], $opt[1], $opt[2], ' - ', floor(($end[$a][$rank][$type][$i] - $val) * 100) / 100, '<br />'; | |
| } | |
| } | |
| echo $rank . '<hr />'; | |
| } | |
| echo '</pre> | |
| </div>'; | |
| } | |
| function getBoardIndex($boardIndexOptions, $mods, $order, $collapse) | |
| { | |
| global $scripturl, $user_info, $modSettings, $txt; | |
| $db = database(); | |
| global $settings, $context; | |
| // For performance, track the latest post while going through the boards. | |
| if (!empty($boardIndexOptions['set_latest_post'])) | |
| $latest_post = array( | |
| 'timestamp' => 0, | |
| 'ref' => 0, | |
| ); | |
| // Find all boards and categories, as well as related information. This will be sorted by the natural order of boards and categories, which we control. | |
| $result_boards = $db->query('boardindex_fetch_boards', ' | |
| SELECT' . ($boardIndexOptions['include_categories'] ? ' | |
| c.id_cat, c.name AS cat_name,' : '') . ' | |
| b.id_board, b.name AS board_name, b.description, | |
| CASE WHEN b.redirect != {string:blank_string} THEN 1 ELSE 0 END AS is_redirect, | |
| b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent, | |
| IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name, | |
| m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name, | |
| ' . ($user_info['is_guest'] ? ' 1 AS is_read, 0 AS new_from,' : ' | |
| (IFNULL(lb.id_msg, 0) >= b.id_msg_updated) AS is_read, IFNULL(lb.id_msg, -1) + 1 AS new_from,' . ($collapse && $boardIndexOptions['include_categories'] ? ' | |
| c.can_collapse, IFNULL(cc.id_member, 0) AS is_collapsed,' : '')) . ' | |
| IFNULL(mem.id_member, 0) AS id_member, mem.avatar, m.id_msg' . ($mods ? ', | |
| IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name' : '') . (!empty($settings['avatars_on_indexes']) ? ', | |
| IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type' : '') . ' | |
| FROM {db_prefix}boards AS b' . ($boardIndexOptions['include_categories'] ? ' | |
| LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)' : '') . ' | |
| LEFT JOIN {db_prefix}messages AS m ON (m.id_msg = b.id_last_msg) | |
| LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)' . ($user_info['is_guest'] ? '' : ' | |
| LEFT JOIN {db_prefix}log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = {int:current_member})' . ($collapse && $boardIndexOptions['include_categories'] ? ' | |
| LEFT JOIN {db_prefix}collapsed_categories AS cc ON (cc.id_cat = c.id_cat AND cc.id_member = {int:current_member})' : '')) . ($mods ? ' | |
| LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board) | |
| LEFT JOIN {db_prefix}members AS mods_mem ON (mods_mem.id_member = mods.id_member)' : '') . (!empty($settings['avatars_on_indexes']) ? ' | |
| LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = m.id_member)' : '') . ' | |
| WHERE {query_see_board}' . (empty($boardIndexOptions['countChildPosts']) ? (empty($boardIndexOptions['base_level']) ? '' : ' | |
| AND b.child_level >= {int:child_level}') : ' | |
| AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)). (!$order ? ' | |
| ORDER BY board_order' : ''), | |
| array( | |
| 'current_member' => $user_info['id'], | |
| 'child_level' => $boardIndexOptions['base_level'], | |
| 'blank_string' => '', | |
| ) | |
| ); | |
| // Start with an empty array. | |
| if ($boardIndexOptions['include_categories']) | |
| $categories = array(); | |
| else | |
| $this_category = array(); | |
| $grab_mods = array(); | |
| // Run through the categories and boards (or only boards).... | |
| while ($row_board = $db->fetch_assoc($result_boards)) | |
| { | |
| // Perhaps we are ignoring this board? | |
| $ignoreThisBoard = in_array($row_board['id_board'], $user_info['ignoreboards']); | |
| $row_board['is_read'] = !empty($row_board['is_read']) || $ignoreThisBoard ? '1' : '0'; | |
| if ($boardIndexOptions['include_categories']) | |
| { | |
| // Haven't set this category yet. | |
| if (empty($categories[$row_board['id_cat']])) | |
| { | |
| $categories[$row_board['id_cat']] = array( | |
| 'id' => $row_board['id_cat'], | |
| 'name' => $row_board['cat_name'], | |
| 'is_collapsed' => isset($row_board['can_collapse']) && $row_board['can_collapse'] == 1 && $row_board['is_collapsed'] > 0, | |
| 'can_collapse' => isset($row_board['can_collapse']) && $row_board['can_collapse'] == 1, | |
| 'collapse_href' => isset($row_board['can_collapse']) ? $scripturl . '?action=collapse;c=' . $row_board['id_cat'] . ';sa=' . ($row_board['is_collapsed'] > 0 ? 'expand;' : 'collapse;') . $context['session_var'] . '=' . $context['session_id'] . '#c' . $row_board['id_cat'] : '', | |
| 'collapse_image' => isset($row_board['can_collapse']) ? '<img src="' . $settings['images_url'] . '/' . $context['theme_variant_url'] . ($row_board['is_collapsed'] > 0 ? 'expand.png" alt="+"' : 'collapse.png" alt="-"') . ' />' : '', | |
| 'href' => $scripturl . '#c' . $row_board['id_cat'], | |
| 'boards' => array(), | |
| 'new' => false | |
| ); | |
| $categories[$row_board['id_cat']]['link'] = '<a id="c' . $row_board['id_cat'] . '"></a>' . (!$context['user']['is_guest'] ? '<a href="' . $scripturl . '?action=unread;c='. $row_board['id_cat'] . '" title="' . sprintf($txt['new_posts_in_category'], strip_tags($row_board['cat_name'])) . '">' . $row_board['cat_name'] . '</a>' : $row_board['cat_name']); | |
| } | |
| // If this board has new posts in it (and isn't the recycle bin!) then the category is new. | |
| if (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $row_board['id_board']) | |
| $categories[$row_board['id_cat']]['new'] |= empty($row_board['is_read']) && $row_board['poster_name'] != ''; | |
| // Avoid showing category unread link where it only has redirection boards. | |
| $categories[$row_board['id_cat']]['show_unread'] = !empty($categories[$row_board['id_cat']]['show_unread']) ? 1 : !$row_board['is_redirect']; | |
| // Collapsed category - don't do any of this. | |
| if ($categories[$row_board['id_cat']]['is_collapsed']) | |
| continue; | |
| // Let's save some typing. Climbing the array might be slower, anyhow. | |
| $this_category = &$categories[$row_board['id_cat']]['boards']; | |
| } | |
| // This is a parent board. | |
| if ($row_board['id_parent'] == $boardIndexOptions['parent_id']) | |
| { | |
| // Is this a new board, or just another moderator? | |
| if (!isset($this_category[$row_board['id_board']])) | |
| { | |
| // Not a child. | |
| $isChild = false; | |
| $this_category[$row_board['id_board']] = array( | |
| 'new' => empty($row_board['is_read']), | |
| 'id' => $row_board['id_board'], | |
| 'name' => $row_board['board_name'], | |
| 'description' => $row_board['description'], | |
| 'moderators' => array(), | |
| 'link_moderators' => array(), | |
| 'children' => array(), | |
| 'link_children' => array(), | |
| 'children_new' => false, | |
| 'topics' => $row_board['num_topics'], | |
| 'posts' => $row_board['num_posts'], | |
| 'is_redirect' => $row_board['is_redirect'], | |
| 'unapproved_topics' => $row_board['unapproved_topics'], | |
| 'unapproved_posts' => $row_board['unapproved_posts'] - $row_board['unapproved_topics'], | |
| 'can_approve_posts' => !empty($user_info['mod_cache']['ap']) && ($user_info['mod_cache']['ap'] == array(0) || in_array($row_board['id_board'], $user_info['mod_cache']['ap'])), | |
| 'href' => $scripturl . '?board=' . $row_board['id_board'] . '.0', | |
| 'link' => '<a href="' . $scripturl . '?board=' . $row_board['id_board'] . '.0">' . $row_board['board_name'] . '</a>' | |
| ); | |
| } | |
| if ($mods) | |
| { | |
| if (!empty($row_board['id_moderator'])) | |
| { | |
| $this_category[$row_board['id_board']]['moderators'][$row_board['id_moderator']] = array( | |
| 'id' => $row_board['id_moderator'], | |
| 'name' => $row_board['mod_real_name'], | |
| 'href' => $scripturl . '?action=profile;u=' . $row_board['id_moderator'], | |
| 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_board['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_board['mod_real_name'] . '</a>' | |
| ); | |
| $this_category[$row_board['id_board']]['link_moderators'][] = '<a href="' . $scripturl . '?action=profile;u=' . $row_board['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_board['mod_real_name'] . '</a>'; | |
| } | |
| } | |
| else | |
| $grab_mods[$row_board['id_board']] = array($boardIndexOptions['include_categories'] ? $row_board['id_cat'] : -1, $row_board['id_board']); | |
| } | |
| // Found a child board.... make sure we've found its parent and the child hasn't been set already. | |
| elseif (isset($this_category[$row_board['id_parent']]['children']) && !isset($this_category[$row_board['id_parent']]['children'][$row_board['id_board']])) | |
| { | |
| // A valid child! | |
| $isChild = true; | |
| $this_category[$row_board['id_parent']]['children'][$row_board['id_board']] = array( | |
| 'id' => $row_board['id_board'], | |
| 'name' => $row_board['board_name'], | |
| 'description' => $row_board['description'], | |
| 'new' => empty($row_board['is_read']) && $row_board['poster_name'] != '', | |
| 'topics' => $row_board['num_topics'], | |
| 'posts' => $row_board['num_posts'], | |
| 'is_redirect' => $row_board['is_redirect'], | |
| 'unapproved_topics' => $row_board['unapproved_topics'], | |
| 'unapproved_posts' => $row_board['unapproved_posts'] - $row_board['unapproved_topics'], | |
| 'can_approve_posts' => !empty($user_info['mod_cache']['ap']) && ($user_info['mod_cache']['ap'] == array(0) || in_array($row_board['id_board'], $user_info['mod_cache']['ap'])), | |
| 'href' => $scripturl . '?board=' . $row_board['id_board'] . '.0', | |
| 'link' => '<a href="' . $scripturl . '?board=' . $row_board['id_board'] . '.0">' . $row_board['board_name'] . '</a>' | |
| ); | |
| // Counting child board posts is... slow :/. | |
| if (!empty($boardIndexOptions['countChildPosts']) && !$row_board['is_redirect']) | |
| { | |
| $this_category[$row_board['id_parent']]['posts'] += $row_board['num_posts']; | |
| $this_category[$row_board['id_parent']]['topics'] += $row_board['num_topics']; | |
| } | |
| // Does this board contain new boards? | |
| $this_category[$row_board['id_parent']]['children_new'] |= empty($row_board['is_read']); | |
| // This is easier to use in many cases for the theme.... | |
| $this_category[$row_board['id_parent']]['link_children'][] = &$this_category[$row_board['id_parent']]['children'][$row_board['id_board']]['link']; | |
| } | |
| // Child of a child... just add it on... | |
| elseif (!empty($boardIndexOptions['countChildPosts'])) | |
| { | |
| // @todo why this is not initialized outside the loop? | |
| if (!isset($parent_map)) | |
| $parent_map = array(); | |
| if (!isset($parent_map[$row_board['id_parent']])) | |
| foreach ($this_category as $id => $board) | |
| { | |
| if (!isset($board['children'][$row_board['id_parent']])) | |
| continue; | |
| $parent_map[$row_board['id_parent']] = array(&$this_category[$id], &$this_category[$id]['children'][$row_board['id_parent']]); | |
| $parent_map[$row_board['id_board']] = array(&$this_category[$id], &$this_category[$id]['children'][$row_board['id_parent']]); | |
| break; | |
| } | |
| if (isset($parent_map[$row_board['id_parent']]) && !$row_board['is_redirect']) | |
| { | |
| $parent_map[$row_board['id_parent']][0]['posts'] += $row_board['num_posts']; | |
| $parent_map[$row_board['id_parent']][0]['topics'] += $row_board['num_topics']; | |
| $parent_map[$row_board['id_parent']][1]['posts'] += $row_board['num_posts']; | |
| $parent_map[$row_board['id_parent']][1]['topics'] += $row_board['num_topics']; | |
| continue; | |
| } | |
| continue; | |
| } | |
| // Found a child of a child - skip. | |
| else | |
| continue; | |
| if (!empty($settings['avatars_on_indexes'])) | |
| { | |
| // Allow themers to show the latest poster's avatar along with the board | |
| if (!empty($row_board['avatar'])) | |
| { | |
| if ($modSettings['avatar_action_too_large'] == 'option_html_resize' || $modSettings['avatar_action_too_large'] == 'option_js_resize') | |
| { | |
| $avatar_width = !empty($modSettings['avatar_max_width_external']) ? ' width:' . $modSettings['avatar_max_width_external'] . 'px;' : ''; | |
| $avatar_height = !empty($modSettings['avatar_max_height_external']) ? ' height:' . $modSettings['avatar_max_height_external'] . 'px;' : ''; | |
| } | |
| else | |
| { | |
| $avatar_width = ''; | |
| $avatar_height = ''; | |
| } | |
| } | |
| } | |
| // Prepare the subject, and make sure it's not too long. | |
| censorText($row_board['subject']); | |
| $row_board['short_subject'] = shorten_text($row_board['subject'], !empty($modSettings['subject_length']) ? $modSettings['subject_length'] : 24); | |
| $this_last_post = array( | |
| 'id' => $row_board['id_msg'], | |
| 'time' => $row_board['poster_time'] > 0 ? ('<time datetime="' . htmlTime($row_board['poster_time']) . '" title="' . standardTime($row_board['poster_time']) . '">' . standardTime($row_board['poster_time']) . '</time>') : $txt['not_applicable'], | |
| 'timestamp' => forum_time(true, $row_board['poster_time']), | |
| 'subject' => $row_board['short_subject'], | |
| 'member' => array( | |
| 'id' => $row_board['id_member'], | |
| 'username' => $row_board['poster_name'] != '' ? $row_board['poster_name'] : $txt['not_applicable'], | |
| 'name' => $row_board['real_name'], | |
| 'href' => $row_board['poster_name'] != '' && !empty($row_board['id_member']) ? $scripturl . '?action=profile;u=' . $row_board['id_member'] : '', | |
| 'link' => $row_board['poster_name'] != '' ? (!empty($row_board['id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row_board['id_member'] . '">' . $row_board['real_name'] . '</a>' : $row_board['real_name']) : $txt['not_applicable'], | |
| ), | |
| 'start' => 'msg' . $row_board['new_from'], | |
| 'topic' => $row_board['id_topic'] | |
| ); | |
| if (!empty($settings['avatars_on_indexes'])) | |
| $this_last_post['member']['avatar'] = array( | |
| 'name' => $row_board['avatar'], | |
| 'image' => $row_board['avatar'] == '' ? ($row_board['id_attach'] > 0 ? '<img class="avatar" src="' . (empty($row_board['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $row_board['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row_board['filename']) . '" alt="" />' : '') : (stristr($row_board['avatar'], 'http://') ? '<img class="avatar" src="' . $row_board['avatar'] . '" style="' . $avatar_width . $avatar_height . '" alt="" />' : '<img class="avatar" src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($row_board['avatar'], ENT_COMPAT, 'UTF-8') . '" alt="" />'), | |
| 'href' => $row_board['avatar'] == '' ? ($row_board['id_attach'] > 0 ? (empty($row_board['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $row_board['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row_board['filename']) : '') : (stristr($row_board['avatar'], 'http://') ? $row_board['avatar'] : $modSettings['avatar_url'] . '/' . $row_board['avatar']), | |
| 'url' => $row_board['avatar'] == '' ? '' : (stristr($row_board['avatar'], 'http://') ? $row_board['avatar'] : $modSettings['avatar_url'] . '/' . $row_board['avatar']) | |
| ); | |
| // Provide the href and link. | |
| if ($row_board['subject'] != '') | |
| { | |
| $this_last_post['href'] = $scripturl . '?topic=' . $row_board['id_topic'] . '.msg' . ($user_info['is_guest'] ? $row_board['id_msg'] : $row_board['new_from']) . (empty($row_board['is_read']) ? ';boardseen' : '') . '#new'; | |
| $this_last_post['link'] = '<a href="' . $this_last_post['href'] . '" title="' . $row_board['subject'] . '">' . $row_board['short_subject'] . '</a>'; | |
| /* The board's and children's 'last_post's have: | |
| time, timestamp (a number that represents the time.), id (of the post), topic (topic id.), | |
| link, href, subject, start (where they should go for the first unread post.), | |
| and member. (which has id, name, link, href, username in it.) */ | |
| $this_last_post['last_post_message'] = sprintf($txt['last_post_message'], $this_last_post['member']['link'], $this_last_post['link'], $this_last_post['time']); | |
| } | |
| else | |
| { | |
| $this_last_post['href'] = ''; | |
| $this_last_post['link'] = $txt['not_applicable']; | |
| $this_last_post['last_post_message'] = ''; | |
| } | |
| // Set the last post in the parent board. | |
| if ($row_board['id_parent'] == $boardIndexOptions['parent_id'] || ($isChild && !empty($row_board['poster_time']) && $this_category[$row_board['id_parent']]['last_post']['timestamp'] < forum_time(true, $row_board['poster_time']))) | |
| $this_category[$isChild ? $row_board['id_parent'] : $row_board['id_board']]['last_post'] = $this_last_post; | |
| // Just in the child...? | |
| if ($isChild) | |
| { | |
| $this_category[$row_board['id_parent']]['children'][$row_board['id_board']]['last_post'] = $this_last_post; | |
| // If there are no posts in this board, it really can't be new... | |
| $this_category[$row_board['id_parent']]['children'][$row_board['id_board']]['new'] &= $row_board['poster_name'] != ''; | |
| } | |
| // No last post for this board? It's not new then, is it..? | |
| elseif ($row_board['poster_name'] == '') | |
| $this_category[$row_board['id_board']]['new'] = false; | |
| // Determine a global most recent topic. | |
| if (!empty($boardIndexOptions['set_latest_post']) && !empty($row_board['poster_time']) && $row_board['poster_time'] > $latest_post['timestamp'] && !$ignoreThisBoard) | |
| $latest_post = array( | |
| 'timestamp' => $row_board['poster_time'], | |
| 'ref' => &$this_category[$isChild ? $row_board['id_parent'] : $row_board['id_board']]['last_post'], | |
| ); | |
| } | |
| $db->free_result($result_boards); | |
| if (!$mods) | |
| { | |
| if (($mod_cached = cache_get_data('localmods_' . md5(implode(',', array_keys($grab_mods))), 3600)) === null) | |
| { | |
| $mod_req = $db->query('', ' | |
| SELECT mods.id_board, IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name | |
| FROM {db_prefix}moderators AS mods | |
| LEFT JOIN {db_prefix}members AS mods_mem ON (mods_mem.id_member = mods.id_member) | |
| WHERE mods.id_board IN ({array_int:id_boards})', | |
| array( | |
| 'id_boards' => array_keys($grab_mods), | |
| ) | |
| ); | |
| $mod_cached = array(); | |
| while($row_mods = $db->fetch_assoc($mod_req)) | |
| $mod_cached[] = $row_mods; | |
| $db->free_result($mod_req); | |
| cache_put_data('localmods_' . md5(implode(',', array_keys($grab_mods))), $mod_cached, 3600); | |
| } | |
| foreach ($mod_cached as $row_mods) | |
| { | |
| if ($boardIndexOptions['include_categories']) | |
| $this_category = &$categories[$grab_mods[$row_mods['id_board']][0]]['boards']; | |
| $this_category[$row_mods['id_board']]['moderators'][$row_mods['id_moderator']] = array( | |
| 'id' => $row_mods['id_moderator'], | |
| 'name' => $row_mods['mod_real_name'], | |
| 'href' => $scripturl . '?action=profile;u=' . $row_mods['id_moderator'], | |
| 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_mods['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_mods['mod_real_name'] . '</a>' | |
| ); | |
| $this_category[$row_mods['id_board']]['link_moderators'][] = '<a href="' . $scripturl . '?action=profile;u=' . $row_mods['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_mods['mod_real_name'] . '</a>'; | |
| } | |
| } | |
| // By now we should know the most recent post...if we wanna know it that is. | |
| if (!empty($boardIndexOptions['set_latest_post']) && !empty($latest_post['ref'])) | |
| $context['latest_post'] = $latest_post['ref']; | |
| return $boardIndexOptions['include_categories'] ? $categories : $this_category; | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| global $user_info, $cache_enable; | |
| require_once('../big_elk/SSI.php'); | |
| require_once(SUBSDIR . '/Categories.subs.php'); | |
| $cache_enable = 1; | |
| $db = database(); | |
| $iterations = 100; | |
| $users = array( | |
| 'admin' => array( | |
| 'id' => 1, | |
| 'query' => '1=1', | |
| ), | |
| 'guest' => array( | |
| 'id' => 0, | |
| 'query' => ' ((FIND_IN_SET(-1, b.member_groups) != 0))', | |
| ), | |
| 'normal' => array( | |
| 'id' => 50001, | |
| 'query' => ' ((FIND_IN_SET(0, b.member_groups) != 0 OR FIND_IN_SET(4, b.member_groups) != 0))', | |
| ), | |
| ); | |
| $boardoptions = array( | |
| 'bi_nocount' => array( | |
| 'include_categories' => true, | |
| 'base_level' => 0, | |
| 'parent_id' => 0, | |
| 'set_latest_post' => true, | |
| 'countChildPosts' => 0, | |
| ), | |
| 'bi_count' => array( | |
| 'include_categories' => true, | |
| 'base_level' => 0, | |
| 'parent_id' => 0, | |
| 'set_latest_post' => true, | |
| 'countChildPosts' => 1, | |
| ), | |
| 'sub_nocount' => array( | |
| 'include_categories' => false, | |
| 'base_level' => 1, | |
| 'parent_id' => 6, | |
| 'set_latest_post' => false, | |
| 'countChildPosts' => 0, | |
| ), | |
| 'sub_count' => array( | |
| 'include_categories' => false, | |
| 'base_level' => 1, | |
| 'parent_id' => 6, | |
| 'set_latest_post' => false, | |
| 'countChildPosts' => 1, | |
| ), | |
| ); | |
| collapseCategories(range(1, 5), 'collapse', range(2, 50000)); | |
| collapseCategories(range(1, 5), 'expand', array(1, 50001)); | |
| for ($a = 0; $a < 2; $a++) | |
| { | |
| if ($a == 1) | |
| { | |
| $fill = array(); | |
| while (count($fill) < 5) | |
| for ($b = count($fill); $b < 5; $b++) | |
| $fill[$b] = rand(1, 10); | |
| collapseCategories($fill, 'collapse', array(1, 50001)); | |
| } | |
| $usrs = $users; | |
| while (!empty($usrs)) | |
| { | |
| $bopt = $boardoptions; | |
| $rank = array_rand($usrs); | |
| $user = $usrs[$rank]; | |
| unset($usrs[$rank]); | |
| $user_info['id'] = $user['id']; | |
| $user_info['query_see_board'] = $user['query']; | |
| $user_info['is_guest'] = empty($user['id']); | |
| $user_info['is_admin'] = $user['id'] == 1; | |
| while (!empty($bopt)) | |
| { | |
| @set_time_limit(600); | |
| if (function_exists('apache_reset_timeout')) | |
| @apache_reset_timeout(); | |
| $type = array_rand($bopt); | |
| $boardIndexOptions = $bopt[$type]; | |
| unset($bopt[$type]); | |
| for ($i = 0; $i < 8; $i++) | |
| { | |
| $opt = str_pad(decbin($i), 3, '0', STR_PAD_LEFT); | |
| $start[$a][$rank][$type][$i] = microtime(true); | |
| for ($l = 0; $l < $iterations; $l++) | |
| getBoardIndex($boardIndexOptions, $opt[0], $opt[1], $opt[2]); | |
| $end[$a][$rank][$type][$i] = microtime(true); | |
| } | |
| } | |
| } | |
| if ($a == 1) | |
| collapseCategories($fill, 'expand', array(1, 50001)); | |
| } | |
| foreach ($start as $a => $ranks) | |
| { | |
| echo '<div style="width: 49%;display: inline-block;"> | |
| <pre>'; | |
| echo $a == 0 ? '~=~=~ Uncollapsed ~=~=~<br />' : '~=~=~ Collapsed ~=~=~<br />'; | |
| ksort($ranks); | |
| foreach ($ranks as $rank => $types) | |
| { | |
| echo $rank . '<br />'; | |
| ksort($types); | |
| foreach ($types as $type => $is) | |
| { | |
| echo $type . '<br />'; | |
| foreach ($is as $i => $val) | |
| { | |
| $opt = str_pad(decbin($i), 3, '0', STR_PAD_LEFT); | |
| echo $i . ': ', $opt[0], $opt[1], $opt[2], ' - ', floor(($end[$a][$rank][$type][$i] - $val) * 100) / 100, '<br />'; | |
| } | |
| } | |
| echo $rank . '<hr />'; | |
| } | |
| echo '</pre> | |
| </div>'; | |
| } | |
| function getBoardIndex($boardIndexOptions, $mods, $order, $collapse) | |
| { | |
| global $scripturl, $user_info, $modSettings, $txt; | |
| $db = database(); | |
| global $settings, $context; | |
| // For performance, track the latest post while going through the boards. | |
| if (!empty($boardIndexOptions['set_latest_post'])) | |
| $latest_post = array( | |
| 'timestamp' => 0, | |
| 'ref' => 0, | |
| ); | |
| // Find all boards and categories, as well as related information. This will be sorted by the natural order of boards and categories, which we control. | |
| $result_boards = $db->query('boardindex_fetch_boards', ' | |
| SELECT' . ($boardIndexOptions['include_categories'] ? ' | |
| c.id_cat, c.name AS cat_name,' : '') . ' | |
| b.id_board, b.name AS board_name, b.description, | |
| CASE WHEN b.redirect != {string:blank_string} THEN 1 ELSE 0 END AS is_redirect, | |
| b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent, | |
| IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name, | |
| m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name, | |
| ' . ($user_info['is_guest'] ? ' 1 AS is_read, 0 AS new_from,' : ' | |
| (IFNULL(lb.id_msg, 0) >= b.id_msg_updated) AS is_read, IFNULL(lb.id_msg, -1) + 1 AS new_from,' . ($collapse && $boardIndexOptions['include_categories'] ? ' | |
| c.can_collapse, IFNULL(cc.id_member, 0) AS is_collapsed,' : '')) . ' | |
| IFNULL(mem.id_member, 0) AS id_member, mem.avatar, m.id_msg' . ($mods ? ', | |
| IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name' : '') . (!empty($settings['avatars_on_indexes']) ? ', | |
| IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type' : '') . ' | |
| FROM {db_prefix}boards AS b' . ($boardIndexOptions['include_categories'] ? ' | |
| LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)' : '') . ' | |
| LEFT JOIN {db_prefix}messages AS m ON (m.id_msg = b.id_last_msg) | |
| LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)' . ($user_info['is_guest'] ? '' : ' | |
| LEFT JOIN {db_prefix}log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = {int:current_member})' . ($collapse && $boardIndexOptions['include_categories'] ? ' | |
| LEFT JOIN {db_prefix}collapsed_categories AS cc ON (cc.id_cat = c.id_cat AND cc.id_member = {int:current_member})' : '')) . ($mods ? ' | |
| LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board) | |
| LEFT JOIN {db_prefix}members AS mods_mem ON (mods_mem.id_member = mods.id_member)' : '') . (!empty($settings['avatars_on_indexes']) ? ' | |
| LEFT JOIN {db_prefix}attachments AS a ON (a.id_member = m.id_member)' : '') . ' | |
| WHERE {query_see_board}' . (empty($boardIndexOptions['countChildPosts']) ? (empty($boardIndexOptions['base_level']) ? '' : ' | |
| AND b.child_level >= {int:child_level}') : ' | |
| AND b.child_level BETWEEN ' . $boardIndexOptions['base_level'] . ' AND ' . ($boardIndexOptions['base_level'] + 1)). (!$order ? ' | |
| ORDER BY board_order' : ''), | |
| array( | |
| 'current_member' => $user_info['id'], | |
| 'child_level' => $boardIndexOptions['base_level'], | |
| 'blank_string' => '', | |
| ) | |
| ); | |
| // Start with an empty array. | |
| if ($boardIndexOptions['include_categories']) | |
| $categories = array(); | |
| else | |
| $this_category = array(); | |
| $grab_mods = array(); | |
| // Run through the categories and boards (or only boards).... | |
| while ($row_board = $db->fetch_assoc($result_boards)) | |
| { | |
| // Perhaps we are ignoring this board? | |
| $ignoreThisBoard = in_array($row_board['id_board'], $user_info['ignoreboards']); | |
| $row_board['is_read'] = !empty($row_board['is_read']) || $ignoreThisBoard ? '1' : '0'; | |
| if ($boardIndexOptions['include_categories']) | |
| { | |
| // Haven't set this category yet. | |
| if (empty($categories[$row_board['id_cat']])) | |
| { | |
| $categories[$row_board['id_cat']] = array( | |
| 'id' => $row_board['id_cat'], | |
| 'name' => $row_board['cat_name'], | |
| 'is_collapsed' => isset($row_board['can_collapse']) && $row_board['can_collapse'] == 1 && $row_board['is_collapsed'] > 0, | |
| 'can_collapse' => isset($row_board['can_collapse']) && $row_board['can_collapse'] == 1, | |
| 'collapse_href' => isset($row_board['can_collapse']) ? $scripturl . '?action=collapse;c=' . $row_board['id_cat'] . ';sa=' . ($row_board['is_collapsed'] > 0 ? 'expand;' : 'collapse;') . $context['session_var'] . '=' . $context['session_id'] . '#c' . $row_board['id_cat'] : '', | |
| 'collapse_image' => isset($row_board['can_collapse']) ? '<img src="' . $settings['images_url'] . '/' . $context['theme_variant_url'] . ($row_board['is_collapsed'] > 0 ? 'expand.png" alt="+"' : 'collapse.png" alt="-"') . ' />' : '', | |
| 'href' => $scripturl . '#c' . $row_board['id_cat'], | |
| 'boards' => array(), | |
| 'new' => false | |
| ); | |
| $categories[$row_board['id_cat']]['link'] = '<a id="c' . $row_board['id_cat'] . '"></a>' . (!$context['user']['is_guest'] ? '<a href="' . $scripturl . '?action=unread;c='. $row_board['id_cat'] . '" title="' . sprintf($txt['new_posts_in_category'], strip_tags($row_board['cat_name'])) . '">' . $row_board['cat_name'] . '</a>' : $row_board['cat_name']); | |
| } | |
| // If this board has new posts in it (and isn't the recycle bin!) then the category is new. | |
| if (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $row_board['id_board']) | |
| $categories[$row_board['id_cat']]['new'] |= empty($row_board['is_read']) && $row_board['poster_name'] != ''; | |
| // Avoid showing category unread link where it only has redirection boards. | |
| $categories[$row_board['id_cat']]['show_unread'] = !empty($categories[$row_board['id_cat']]['show_unread']) ? 1 : !$row_board['is_redirect']; | |
| // Collapsed category - don't do any of this. | |
| if ($categories[$row_board['id_cat']]['is_collapsed']) | |
| continue; | |
| // Let's save some typing. Climbing the array might be slower, anyhow. | |
| $this_category = &$categories[$row_board['id_cat']]['boards']; | |
| } | |
| // This is a parent board. | |
| if ($row_board['id_parent'] == $boardIndexOptions['parent_id']) | |
| { | |
| // Is this a new board, or just another moderator? | |
| if (!isset($this_category[$row_board['id_board']])) | |
| { | |
| // Not a child. | |
| $isChild = false; | |
| $this_category[$row_board['id_board']] = array( | |
| 'new' => empty($row_board['is_read']), | |
| 'id' => $row_board['id_board'], | |
| 'name' => $row_board['board_name'], | |
| 'description' => $row_board['description'], | |
| 'moderators' => array(), | |
| 'link_moderators' => array(), | |
| 'children' => array(), | |
| 'link_children' => array(), | |
| 'children_new' => false, | |
| 'topics' => $row_board['num_topics'], | |
| 'posts' => $row_board['num_posts'], | |
| 'is_redirect' => $row_board['is_redirect'], | |
| 'unapproved_topics' => $row_board['unapproved_topics'], | |
| 'unapproved_posts' => $row_board['unapproved_posts'] - $row_board['unapproved_topics'], | |
| 'can_approve_posts' => !empty($user_info['mod_cache']['ap']) && ($user_info['mod_cache']['ap'] == array(0) || in_array($row_board['id_board'], $user_info['mod_cache']['ap'])), | |
| 'href' => $scripturl . '?board=' . $row_board['id_board'] . '.0', | |
| 'link' => '<a href="' . $scripturl . '?board=' . $row_board['id_board'] . '.0">' . $row_board['board_name'] . '</a>' | |
| ); | |
| } | |
| if ($mods) | |
| { | |
| if (!empty($row_board['id_moderator'])) | |
| { | |
| $this_category[$row_board['id_board']]['moderators'][$row_board['id_moderator']] = array( | |
| 'id' => $row_board['id_moderator'], | |
| 'name' => $row_board['mod_real_name'], | |
| 'href' => $scripturl . '?action=profile;u=' . $row_board['id_moderator'], | |
| 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_board['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_board['mod_real_name'] . '</a>' | |
| ); | |
| $this_category[$row_board['id_board']]['link_moderators'][] = '<a href="' . $scripturl . '?action=profile;u=' . $row_board['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_board['mod_real_name'] . '</a>'; | |
| } | |
| } | |
| else | |
| $grab_mods[$row_board['id_board']] = array($boardIndexOptions['include_categories'] ? $row_board['id_cat'] : -1, $row_board['id_board']); | |
| } | |
| // Found a child board.... make sure we've found its parent and the child hasn't been set already. | |
| elseif (isset($this_category[$row_board['id_parent']]['children']) && !isset($this_category[$row_board['id_parent']]['children'][$row_board['id_board']])) | |
| { | |
| // A valid child! | |
| $isChild = true; | |
| $this_category[$row_board['id_parent']]['children'][$row_board['id_board']] = array( | |
| 'id' => $row_board['id_board'], | |
| 'name' => $row_board['board_name'], | |
| 'description' => $row_board['description'], | |
| 'new' => empty($row_board['is_read']) && $row_board['poster_name'] != '', | |
| 'topics' => $row_board['num_topics'], | |
| 'posts' => $row_board['num_posts'], | |
| 'is_redirect' => $row_board['is_redirect'], | |
| 'unapproved_topics' => $row_board['unapproved_topics'], | |
| 'unapproved_posts' => $row_board['unapproved_posts'] - $row_board['unapproved_topics'], | |
| 'can_approve_posts' => !empty($user_info['mod_cache']['ap']) && ($user_info['mod_cache']['ap'] == array(0) || in_array($row_board['id_board'], $user_info['mod_cache']['ap'])), | |
| 'href' => $scripturl . '?board=' . $row_board['id_board'] . '.0', | |
| 'link' => '<a href="' . $scripturl . '?board=' . $row_board['id_board'] . '.0">' . $row_board['board_name'] . '</a>' | |
| ); | |
| // Counting child board posts is... slow :/. | |
| if (!empty($boardIndexOptions['countChildPosts']) && !$row_board['is_redirect']) | |
| { | |
| $this_category[$row_board['id_parent']]['posts'] += $row_board['num_posts']; | |
| $this_category[$row_board['id_parent']]['topics'] += $row_board['num_topics']; | |
| } | |
| // Does this board contain new boards? | |
| $this_category[$row_board['id_parent']]['children_new'] |= empty($row_board['is_read']); | |
| // This is easier to use in many cases for the theme.... | |
| $this_category[$row_board['id_parent']]['link_children'][] = &$this_category[$row_board['id_parent']]['children'][$row_board['id_board']]['link']; | |
| } | |
| // Child of a child... just add it on... | |
| elseif (!empty($boardIndexOptions['countChildPosts'])) | |
| { | |
| // @todo why this is not initialized outside the loop? | |
| if (!isset($parent_map)) | |
| $parent_map = array(); | |
| if (!isset($parent_map[$row_board['id_parent']])) | |
| foreach ($this_category as $id => $board) | |
| { | |
| if (!isset($board['children'][$row_board['id_parent']])) | |
| continue; | |
| $parent_map[$row_board['id_parent']] = array(&$this_category[$id], &$this_category[$id]['children'][$row_board['id_parent']]); | |
| $parent_map[$row_board['id_board']] = array(&$this_category[$id], &$this_category[$id]['children'][$row_board['id_parent']]); | |
| break; | |
| } | |
| if (isset($parent_map[$row_board['id_parent']]) && !$row_board['is_redirect']) | |
| { | |
| $parent_map[$row_board['id_parent']][0]['posts'] += $row_board['num_posts']; | |
| $parent_map[$row_board['id_parent']][0]['topics'] += $row_board['num_topics']; | |
| $parent_map[$row_board['id_parent']][1]['posts'] += $row_board['num_posts']; | |
| $parent_map[$row_board['id_parent']][1]['topics'] += $row_board['num_topics']; | |
| continue; | |
| } | |
| continue; | |
| } | |
| // Found a child of a child - skip. | |
| else | |
| continue; | |
| if (!empty($settings['avatars_on_indexes'])) | |
| { | |
| // Allow themers to show the latest poster's avatar along with the board | |
| if (!empty($row_board['avatar'])) | |
| { | |
| if ($modSettings['avatar_action_too_large'] == 'option_html_resize' || $modSettings['avatar_action_too_large'] == 'option_js_resize') | |
| { | |
| $avatar_width = !empty($modSettings['avatar_max_width_external']) ? ' width:' . $modSettings['avatar_max_width_external'] . 'px;' : ''; | |
| $avatar_height = !empty($modSettings['avatar_max_height_external']) ? ' height:' . $modSettings['avatar_max_height_external'] . 'px;' : ''; | |
| } | |
| else | |
| { | |
| $avatar_width = ''; | |
| $avatar_height = ''; | |
| } | |
| } | |
| } | |
| // Prepare the subject, and make sure it's not too long. | |
| censorText($row_board['subject']); | |
| $row_board['short_subject'] = shorten_text($row_board['subject'], !empty($modSettings['subject_length']) ? $modSettings['subject_length'] : 24); | |
| $this_last_post = array( | |
| 'id' => $row_board['id_msg'], | |
| 'time' => $row_board['poster_time'] > 0 ? ('<time datetime="' . htmlTime($row_board['poster_time']) . '" title="' . standardTime($row_board['poster_time']) . '">' . standardTime($row_board['poster_time']) . '</time>') : $txt['not_applicable'], | |
| 'timestamp' => forum_time(true, $row_board['poster_time']), | |
| 'subject' => $row_board['short_subject'], | |
| 'member' => array( | |
| 'id' => $row_board['id_member'], | |
| 'username' => $row_board['poster_name'] != '' ? $row_board['poster_name'] : $txt['not_applicable'], | |
| 'name' => $row_board['real_name'], | |
| 'href' => $row_board['poster_name'] != '' && !empty($row_board['id_member']) ? $scripturl . '?action=profile;u=' . $row_board['id_member'] : '', | |
| 'link' => $row_board['poster_name'] != '' ? (!empty($row_board['id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row_board['id_member'] . '">' . $row_board['real_name'] . '</a>' : $row_board['real_name']) : $txt['not_applicable'], | |
| ), | |
| 'start' => 'msg' . $row_board['new_from'], | |
| 'topic' => $row_board['id_topic'] | |
| ); | |
| if (!empty($settings['avatars_on_indexes'])) | |
| $this_last_post['member']['avatar'] = array( | |
| 'name' => $row_board['avatar'], | |
| 'image' => $row_board['avatar'] == '' ? ($row_board['id_attach'] > 0 ? '<img class="avatar" src="' . (empty($row_board['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $row_board['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row_board['filename']) . '" alt="" />' : '') : (stristr($row_board['avatar'], 'http://') ? '<img class="avatar" src="' . $row_board['avatar'] . '" style="' . $avatar_width . $avatar_height . '" alt="" />' : '<img class="avatar" src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($row_board['avatar'], ENT_COMPAT, 'UTF-8') . '" alt="" />'), | |
| 'href' => $row_board['avatar'] == '' ? ($row_board['id_attach'] > 0 ? (empty($row_board['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $row_board['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $row_board['filename']) : '') : (stristr($row_board['avatar'], 'http://') ? $row_board['avatar'] : $modSettings['avatar_url'] . '/' . $row_board['avatar']), | |
| 'url' => $row_board['avatar'] == '' ? '' : (stristr($row_board['avatar'], 'http://') ? $row_board['avatar'] : $modSettings['avatar_url'] . '/' . $row_board['avatar']) | |
| ); | |
| // Provide the href and link. | |
| if ($row_board['subject'] != '') | |
| { | |
| $this_last_post['href'] = $scripturl . '?topic=' . $row_board['id_topic'] . '.msg' . ($user_info['is_guest'] ? $row_board['id_msg'] : $row_board['new_from']) . (empty($row_board['is_read']) ? ';boardseen' : '') . '#new'; | |
| $this_last_post['link'] = '<a href="' . $this_last_post['href'] . '" title="' . $row_board['subject'] . '">' . $row_board['short_subject'] . '</a>'; | |
| /* The board's and children's 'last_post's have: | |
| time, timestamp (a number that represents the time.), id (of the post), topic (topic id.), | |
| link, href, subject, start (where they should go for the first unread post.), | |
| and member. (which has id, name, link, href, username in it.) */ | |
| $this_last_post['last_post_message'] = sprintf($txt['last_post_message'], $this_last_post['member']['link'], $this_last_post['link'], $this_last_post['time']); | |
| } | |
| else | |
| { | |
| $this_last_post['href'] = ''; | |
| $this_last_post['link'] = $txt['not_applicable']; | |
| $this_last_post['last_post_message'] = ''; | |
| } | |
| // Set the last post in the parent board. | |
| if ($row_board['id_parent'] == $boardIndexOptions['parent_id'] || ($isChild && !empty($row_board['poster_time']) && $this_category[$row_board['id_parent']]['last_post']['timestamp'] < forum_time(true, $row_board['poster_time']))) | |
| $this_category[$isChild ? $row_board['id_parent'] : $row_board['id_board']]['last_post'] = $this_last_post; | |
| // Just in the child...? | |
| if ($isChild) | |
| { | |
| $this_category[$row_board['id_parent']]['children'][$row_board['id_board']]['last_post'] = $this_last_post; | |
| // If there are no posts in this board, it really can't be new... | |
| $this_category[$row_board['id_parent']]['children'][$row_board['id_board']]['new'] &= $row_board['poster_name'] != ''; | |
| } | |
| // No last post for this board? It's not new then, is it..? | |
| elseif ($row_board['poster_name'] == '') | |
| $this_category[$row_board['id_board']]['new'] = false; | |
| // Determine a global most recent topic. | |
| if (!empty($boardIndexOptions['set_latest_post']) && !empty($row_board['poster_time']) && $row_board['poster_time'] > $latest_post['timestamp'] && !$ignoreThisBoard) | |
| $latest_post = array( | |
| 'timestamp' => $row_board['poster_time'], | |
| 'ref' => &$this_category[$isChild ? $row_board['id_parent'] : $row_board['id_board']]['last_post'], | |
| ); | |
| } | |
| $db->free_result($result_boards); | |
| if (!$mods) | |
| { | |
| { | |
| $mod_req = $db->query('', ' | |
| SELECT mods.id_board, IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name | |
| FROM {db_prefix}moderators AS mods | |
| LEFT JOIN {db_prefix}members AS mods_mem ON (mods_mem.id_member = mods.id_member) | |
| WHERE mods.id_board IN ({array_int:id_boards})', | |
| array( | |
| 'id_boards' => array_keys($grab_mods), | |
| ) | |
| ); | |
| $mod_cached = array(); | |
| while($row_mods = $db->fetch_assoc($mod_req)) | |
| { | |
| if ($boardIndexOptions['include_categories']) | |
| $this_category = &$categories[$grab_mods[$row_mods['id_board']][0]]['boards']; | |
| $this_category[$row_mods['id_board']]['moderators'][$row_mods['id_moderator']] = array( | |
| 'id' => $row_mods['id_moderator'], | |
| 'name' => $row_mods['mod_real_name'], | |
| 'href' => $scripturl . '?action=profile;u=' . $row_mods['id_moderator'], | |
| 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_mods['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_mods['mod_real_name'] . '</a>' | |
| ); | |
| $this_category[$row_mods['id_board']]['link_moderators'][] = '<a href="' . $scripturl . '?action=profile;u=' . $row_mods['id_moderator'] . '" title="' . $txt['board_moderator'] . '">' . $row_mods['mod_real_name'] . '</a>'; | |
| } | |
| $db->free_result($mod_req); | |
| } | |
| } | |
| // By now we should know the most recent post...if we wanna know it that is. | |
| if (!empty($boardIndexOptions['set_latest_post']) && !empty($latest_post['ref'])) | |
| $context['latest_post'] = $latest_post['ref']; | |
| return $boardIndexOptions['include_categories'] ? $categories : $this_category; | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment