Mercurial > hg > vamp-website

annotate forum/Sources/MessageIndex.php @ 87:df86d318892b website

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Link to SampleType doc
author Chris Cannam
date Mon, 10 Feb 2014 18:11:48 +0000
parents e3e11437ecea
children
rev   line source
Chris@76 1 <?php
Chris@76 2
Chris@76 3 /**
Chris@76 4 * Simple Machines Forum (SMF)
Chris@76 5 *
Chris@76 6 * @package SMF
Chris@76 7 * @author Simple Machines http://www.simplemachines.org
Chris@76 8 * @copyright 2011 Simple Machines
Chris@76 9 * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76 10 *
Chris@76 11 * @version 2.0.2
Chris@76 12 */
Chris@76 13
Chris@76 14 if (!defined('SMF'))
Chris@76 15 die('Hacking attempt...');
Chris@76 16
Chris@76 17 /* This file is what shows the listing of topics in a board. It's just one
Chris@76 18 function, but don't under estimate it ;).
Chris@76 19
Chris@76 20 void MessageIndex()
Chris@76 21 // !!!
Chris@76 22
Chris@76 23 void QuickModeration()
Chris@76 24 // !!!
Chris@76 25
Chris@76 26 */
Chris@76 27
Chris@76 28 // Show the list of topics in this board, along with any child boards.
Chris@76 29 function MessageIndex()
Chris@76 30 {
Chris@76 31 global $txt, $scripturl, $board, $modSettings, $context;
Chris@76 32 global $options, $settings, $board_info, $user_info, $smcFunc, $sourcedir;
Chris@76 33
Chris@76 34 // If this is a redirection board head off.
Chris@76 35 if ($board_info['redirect'])
Chris@76 36 {
Chris@76 37 $smcFunc['db_query']('', '
Chris@76 38 UPDATE {db_prefix}boards
Chris@76 39 SET num_posts = num_posts + 1
Chris@76 40 WHERE id_board = {int:current_board}',
Chris@76 41 array(
Chris@76 42 'current_board' => $board,
Chris@76 43 )
Chris@76 44 );
Chris@76 45
Chris@76 46 redirectexit($board_info['redirect']);
Chris@76 47 }
Chris@76 48
Chris@76 49 if (WIRELESS)
Chris@76 50 $context['sub_template'] = WIRELESS_PROTOCOL . '_messageindex';
Chris@76 51 else
Chris@76 52 loadTemplate('MessageIndex');
Chris@76 53
Chris@76 54 $context['name'] = $board_info['name'];
Chris@76 55 $context['description'] = $board_info['description'];
Chris@76 56 // How many topics do we have in total?
Chris@76 57 $board_info['total_topics'] = allowedTo('approve_posts') ? $board_info['num_topics'] + $board_info['unapproved_topics'] : $board_info['num_topics'] + $board_info['unapproved_user_topics'];
Chris@76 58
Chris@76 59 // View all the topics, or just a few?
Chris@76 60 $context['topics_per_page'] = empty($modSettings['disableCustomPerPage']) && !empty($options['topics_per_page']) && !WIRELESS ? $options['topics_per_page'] : $modSettings['defaultMaxTopics'];
Chris@76 61 $context['messages_per_page'] = empty($modSettings['disableCustomPerPage']) && !empty($options['messages_per_page']) && !WIRELESS ? $options['messages_per_page'] : $modSettings['defaultMaxMessages'];
Chris@76 62 $maxindex = isset($_REQUEST['all']) && !empty($modSettings['enableAllMessages']) ? $board_info['total_topics'] : $context['topics_per_page'];
Chris@76 63
Chris@76 64 // Right, let's only index normal stuff!
Chris@76 65 if (count($_GET) > 1)
Chris@76 66 {
Chris@76 67 $session_name = session_name();
Chris@76 68 foreach ($_GET as $k => $v)
Chris@76 69 {
Chris@76 70 if (!in_array($k, array('board', 'start', $session_name)))
Chris@76 71 $context['robot_no_index'] = true;
Chris@76 72 }
Chris@76 73 }
Chris@76 74 if (!empty($_REQUEST['start']) && (!is_numeric($_REQUEST['start']) || $_REQUEST['start'] % $context['messages_per_page'] != 0))
Chris@76 75 $context['robot_no_index'] = true;
Chris@76 76
Chris@76 77 // If we can view unapproved messages and there are some build up a list.
Chris@76 78 if (allowedTo('approve_posts') && ($board_info['unapproved_topics'] || $board_info['unapproved_posts']))
Chris@76 79 {
Chris@76 80 $untopics = $board_info['unapproved_topics'] ? '<a href="' . $scripturl . '?action=moderate;area=postmod;sa=topics;brd=' . $board . '">' . $board_info['unapproved_topics'] . '</a>' : 0;
Chris@76 81 $unposts = $board_info['unapproved_posts'] ? '<a href="' . $scripturl . '?action=moderate;area=postmod;sa=posts;brd=' . $board . '">' . ($board_info['unapproved_posts'] - $board_info['unapproved_topics']) . '</a>' : 0;
Chris@76 82 $context['unapproved_posts_message'] = sprintf($txt['there_are_unapproved_topics'], $untopics, $unposts, $scripturl . '?action=moderate;area=postmod;sa=' . ($board_info['unapproved_topics'] ? 'topics' : 'posts') . ';brd=' . $board);
Chris@76 83 }
Chris@76 84
Chris@76 85 // We only know these.
Chris@76 86 if (isset($_REQUEST['sort']) && !in_array($_REQUEST['sort'], array('subject', 'starter', 'last_poster', 'replies', 'views', 'first_post', 'last_post')))
Chris@76 87 $_REQUEST['sort'] = 'last_post';
Chris@76 88
Chris@76 89 // Make sure the starting place makes sense and construct the page index.
Chris@76 90 if (isset($_REQUEST['sort']))
Chris@76 91 $context['page_index'] = constructPageIndex($scripturl . '?board=' . $board . '.%1$d;sort=' . $_REQUEST['sort'] . (isset($_REQUEST['desc']) ? ';desc' : ''), $_REQUEST['start'], $board_info['total_topics'], $maxindex, true);
Chris@76 92 else
Chris@76 93 $context['page_index'] = constructPageIndex($scripturl . '?board=' . $board . '.%1$d', $_REQUEST['start'], $board_info['total_topics'], $maxindex, true);
Chris@76 94 $context['start'] = &$_REQUEST['start'];
Chris@76 95
Chris@76 96 // Set a canonical URL for this page.
Chris@76 97 $context['canonical_url'] = $scripturl . '?board=' . $board . '.' . $context['start'];
Chris@76 98
Chris@76 99 $context['links'] = array(
Chris@76 100 'first' => $_REQUEST['start'] >= $context['topics_per_page'] ? $scripturl . '?board=' . $board . '.0' : '',
Chris@76 101 'prev' => $_REQUEST['start'] >= $context['topics_per_page'] ? $scripturl . '?board=' . $board . '.' . ($_REQUEST['start'] - $context['topics_per_page']) : '',
Chris@76 102 'next' => $_REQUEST['start'] + $context['topics_per_page'] < $board_info['total_topics'] ? $scripturl . '?board=' . $board . '.' . ($_REQUEST['start'] + $context['topics_per_page']) : '',
Chris@76 103 'last' => $_REQUEST['start'] + $context['topics_per_page'] < $board_info['total_topics'] ? $scripturl . '?board=' . $board . '.' . (floor(($board_info['total_topics'] - 1) / $context['topics_per_page']) * $context['topics_per_page']) : '',
Chris@76 104 'up' => $board_info['parent'] == 0 ? $scripturl . '?' : $scripturl . '?board=' . $board_info['parent'] . '.0'
Chris@76 105 );
Chris@76 106
Chris@76 107 $context['page_info'] = array(
Chris@76 108 'current_page' => $_REQUEST['start'] / $context['topics_per_page'] + 1,
Chris@76 109 'num_pages' => floor(($board_info['total_topics'] - 1) / $context['topics_per_page']) + 1
Chris@76 110 );
Chris@76 111
Chris@76 112 if (isset($_REQUEST['all']) && !empty($modSettings['enableAllMessages']) && $maxindex > $modSettings['enableAllMessages'])
Chris@76 113 {
Chris@76 114 $maxindex = $modSettings['enableAllMessages'];
Chris@76 115 $_REQUEST['start'] = 0;
Chris@76 116 }
Chris@76 117
Chris@76 118 // Build a list of the board's moderators.
Chris@76 119 $context['moderators'] = &$board_info['moderators'];
Chris@76 120 $context['link_moderators'] = array();
Chris@76 121 if (!empty($board_info['moderators']))
Chris@76 122 {
Chris@76 123 foreach ($board_info['moderators'] as $mod)
Chris@76 124 $context['link_moderators'][] ='<a href="' . $scripturl . '?action=profile;u=' . $mod['id'] . '" title="' . $txt['board_moderator'] . '">' . $mod['name'] . '</a>';
Chris@76 125
Chris@76 126 $context['linktree'][count($context['linktree']) - 1]['extra_after'] = ' (' . (count($context['link_moderators']) == 1 ? $txt['moderator'] : $txt['moderators']) . ': ' . implode(', ', $context['link_moderators']) . ')';
Chris@76 127 }
Chris@76 128
Chris@76 129 // Mark current and parent boards as seen.
Chris@76 130 if (!$user_info['is_guest'])
Chris@76 131 {
Chris@76 132 // We can't know they read it if we allow prefetches.
Chris@76 133 if (isset($_SERVER['HTTP_X_MOZ']) && $_SERVER['HTTP_X_MOZ'] == 'prefetch')
Chris@76 134 {
Chris@76 135 ob_end_clean();
Chris@76 136 header('HTTP/1.1 403 Prefetch Forbidden');
Chris@76 137 die;
Chris@76 138 }
Chris@76 139
Chris@76 140 $smcFunc['db_insert']('replace',
Chris@76 141 '{db_prefix}log_boards',
Chris@76 142 array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
Chris@76 143 array($modSettings['maxMsgID'], $user_info['id'], $board),
Chris@76 144 array('id_member', 'id_board')
Chris@76 145 );
Chris@76 146
Chris@76 147 if (!empty($board_info['parent_boards']))
Chris@76 148 {
Chris@76 149 $smcFunc['db_query']('', '
Chris@76 150 UPDATE {db_prefix}log_boards
Chris@76 151 SET id_msg = {int:id_msg}
Chris@76 152 WHERE id_member = {int:current_member}
Chris@76 153 AND id_board IN ({array_int:board_list})',
Chris@76 154 array(
Chris@76 155 'current_member' => $user_info['id'],
Chris@76 156 'board_list' => array_keys($board_info['parent_boards']),
Chris@76 157 'id_msg' => $modSettings['maxMsgID'],
Chris@76 158 )
Chris@76 159 );
Chris@76 160
Chris@76 161 // We've seen all these boards now!
Chris@76 162 foreach ($board_info['parent_boards'] as $k => $dummy)
Chris@76 163 if (isset($_SESSION['topicseen_cache'][$k]))
Chris@76 164 unset($_SESSION['topicseen_cache'][$k]);
Chris@76 165 }
Chris@76 166
Chris@76 167 if (isset($_SESSION['topicseen_cache'][$board]))
Chris@76 168 unset($_SESSION['topicseen_cache'][$board]);
Chris@76 169
Chris@76 170 $request = $smcFunc['db_query']('', '
Chris@76 171 SELECT sent
Chris@76 172 FROM {db_prefix}log_notify
Chris@76 173 WHERE id_board = {int:current_board}
Chris@76 174 AND id_member = {int:current_member}
Chris@76 175 LIMIT 1',
Chris@76 176 array(
Chris@76 177 'current_board' => $board,
Chris@76 178 'current_member' => $user_info['id'],
Chris@76 179 )
Chris@76 180 );
Chris@76 181 $context['is_marked_notify'] = $smcFunc['db_num_rows']($request) != 0;
Chris@76 182 if ($context['is_marked_notify'])
Chris@76 183 {
Chris@76 184 list ($sent) = $smcFunc['db_fetch_row']($request);
Chris@76 185 if (!empty($sent))
Chris@76 186 {
Chris@76 187 $smcFunc['db_query']('', '
Chris@76 188 UPDATE {db_prefix}log_notify
Chris@76 189 SET sent = {int:is_sent}
Chris@76 190 WHERE id_board = {int:current_board}
Chris@76 191 AND id_member = {int:current_member}',
Chris@76 192 array(
Chris@76 193 'current_board' => $board,
Chris@76 194 'current_member' => $user_info['id'],
Chris@76 195 'is_sent' => 0,
Chris@76 196 )
Chris@76 197 );
Chris@76 198 }
Chris@76 199 }
Chris@76 200 $smcFunc['db_free_result']($request);
Chris@76 201 }
Chris@76 202 else
Chris@76 203 $context['is_marked_notify'] = false;
Chris@76 204
Chris@76 205 // 'Print' the header and board info.
Chris@76 206 $context['page_title'] = strip_tags($board_info['name']);
Chris@76 207
Chris@76 208 // Set the variables up for the template.
Chris@76 209 $context['can_mark_notify'] = allowedTo('mark_notify') && !$user_info['is_guest'];
Chris@76 210 $context['can_post_new'] = allowedTo('post_new') || ($modSettings['postmod_active'] && allowedTo('post_unapproved_topics'));
Chris@76 211 $context['can_post_poll'] = $modSettings['pollMode'] == '1' && allowedTo('poll_post') && $context['can_post_new'];
Chris@76 212 $context['can_moderate_forum'] = allowedTo('moderate_forum');
Chris@76 213 $context['can_approve_posts'] = allowedTo('approve_posts');
Chris@76 214
Chris@76 215 require_once($sourcedir . '/Subs-BoardIndex.php');
Chris@76 216 $boardIndexOptions = array(
Chris@76 217 'include_categories' => false,
Chris@76 218 'base_level' => $board_info['child_level'] + 1,
Chris@76 219 'parent_id' => $board_info['id'],
Chris@76 220 'set_latest_post' => false,
Chris@76 221 'countChildPosts' => !empty($modSettings['countChildPosts']),
Chris@76 222 );
Chris@76 223 $context['boards'] = getBoardIndex($boardIndexOptions);
Chris@76 224
Chris@76 225 // Nosey, nosey - who's viewing this topic?
Chris@76 226 if (!empty($settings['display_who_viewing']))
Chris@76 227 {
Chris@76 228 $context['view_members'] = array();
Chris@76 229 $context['view_members_list'] = array();
Chris@76 230 $context['view_num_hidden'] = 0;
Chris@76 231
Chris@76 232 $request = $smcFunc['db_query']('', '
Chris@76 233 SELECT
Chris@76 234 lo.id_member, lo.log_time, mem.real_name, mem.member_name, mem.show_online,
Chris@76 235 mg.online_color, mg.id_group, mg.group_name
Chris@76 236 FROM {db_prefix}log_online AS lo
Chris@76 237 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = lo.id_member)
Chris@76 238 LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = {int:reg_member_group} THEN mem.id_post_group ELSE mem.id_group END)
Chris@76 239 WHERE INSTR(lo.url, {string:in_url_string}) > 0 OR lo.session = {string:session}',
Chris@76 240 array(
Chris@76 241 'reg_member_group' => 0,
Chris@76 242 'in_url_string' => 's:5:"board";i:' . $board . ';',
Chris@76 243 'session' => $user_info['is_guest'] ? 'ip' . $user_info['ip'] : session_id(),
Chris@76 244 )
Chris@76 245 );
Chris@76 246 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 247 {
Chris@76 248 if (empty($row['id_member']))
Chris@76 249 continue;
Chris@76 250
Chris@76 251 if (!empty($row['online_color']))
Chris@76 252 $link = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '" style="color: ' . $row['online_color'] . ';">' . $row['real_name'] . '</a>';
Chris@76 253 else
Chris@76 254 $link = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
Chris@76 255
Chris@76 256 $is_buddy = in_array($row['id_member'], $user_info['buddies']);
Chris@76 257 if ($is_buddy)
Chris@76 258 $link = '<strong>' . $link . '</strong>';
Chris@76 259
Chris@76 260 if (!empty($row['show_online']) || allowedTo('moderate_forum'))
Chris@76 261 $context['view_members_list'][$row['log_time'] . $row['member_name']] = empty($row['show_online']) ? '<em>' . $link . '</em>' : $link;
Chris@76 262 $context['view_members'][$row['log_time'] . $row['member_name']] = array(
Chris@76 263 'id' => $row['id_member'],
Chris@76 264 'username' => $row['member_name'],
Chris@76 265 'name' => $row['real_name'],
Chris@76 266 'group' => $row['id_group'],
Chris@76 267 'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
Chris@76 268 'link' => $link,
Chris@76 269 'is_buddy' => $is_buddy,
Chris@76 270 'hidden' => empty($row['show_online']),
Chris@76 271 );
Chris@76 272
Chris@76 273 if (empty($row['show_online']))
Chris@76 274 $context['view_num_hidden']++;
Chris@76 275 }
Chris@76 276 $context['view_num_guests'] = $smcFunc['db_num_rows']($request) - count($context['view_members']);
Chris@76 277 $smcFunc['db_free_result']($request);
Chris@76 278
Chris@76 279 // Put them in "last clicked" order.
Chris@76 280 krsort($context['view_members_list']);
Chris@76 281 krsort($context['view_members']);
Chris@76 282 }
Chris@76 283
Chris@76 284 // Default sort methods.
Chris@76 285 $sort_methods = array(
Chris@76 286 'subject' => 'mf.subject',
Chris@76 287 'starter' => 'IFNULL(memf.real_name, mf.poster_name)',
Chris@76 288 'last_poster' => 'IFNULL(meml.real_name, ml.poster_name)',
Chris@76 289 'replies' => 't.num_replies',
Chris@76 290 'views' => 't.num_views',
Chris@76 291 'first_post' => 't.id_topic',
Chris@76 292 'last_post' => 't.id_last_msg'
Chris@76 293 );
Chris@76 294
Chris@76 295 // They didn't pick one, default to by last post descending.
Chris@76 296 if (!isset($_REQUEST['sort']) || !isset($sort_methods[$_REQUEST['sort']]))
Chris@76 297 {
Chris@76 298 $context['sort_by'] = 'last_post';
Chris@76 299 $_REQUEST['sort'] = 'id_last_msg';
Chris@76 300 $ascending = isset($_REQUEST['asc']);
Chris@76 301 }
Chris@76 302 // Otherwise default to ascending.
Chris@76 303 else
Chris@76 304 {
Chris@76 305 $context['sort_by'] = $_REQUEST['sort'];
Chris@76 306 $_REQUEST['sort'] = $sort_methods[$_REQUEST['sort']];
Chris@76 307 $ascending = !isset($_REQUEST['desc']);
Chris@76 308 }
Chris@76 309
Chris@76 310 $context['sort_direction'] = $ascending ? 'up' : 'down';
Chris@76 311
Chris@76 312 // Calculate the fastest way to get the topics.
Chris@76 313 $start = (int) $_REQUEST['start'];
Chris@76 314 if ($start > ($board_info['total_topics'] - 1) / 2)
Chris@76 315 {
Chris@76 316 $ascending = !$ascending;
Chris@76 317 $fake_ascending = true;
Chris@76 318 $maxindex = $board_info['total_topics'] < $start + $maxindex + 1 ? $board_info['total_topics'] - $start : $maxindex;
Chris@76 319 $start = $board_info['total_topics'] < $start + $maxindex + 1 ? 0 : $board_info['total_topics'] - $start - $maxindex;
Chris@76 320 }
Chris@76 321 else
Chris@76 322 $fake_ascending = false;
Chris@76 323
Chris@76 324 // Setup the default topic icons...
Chris@76 325 $stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless', 'clip');
Chris@76 326 $context['icon_sources'] = array();
Chris@76 327 foreach ($stable_icons as $icon)
Chris@76 328 $context['icon_sources'][$icon] = 'images_url';
Chris@76 329
Chris@76 330 $topic_ids = array();
Chris@76 331 $context['topics'] = array();
Chris@76 332
Chris@76 333 // Sequential pages are often not optimized, so we add an additional query.
Chris@76 334 $pre_query = $start > 0;
Chris@76 335 if ($pre_query && $maxindex > 0)
Chris@76 336 {
Chris@76 337 $request = $smcFunc['db_query']('', '
Chris@76 338 SELECT t.id_topic
Chris@76 339 FROM {db_prefix}topics AS t' . ($context['sort_by'] === 'last_poster' ? '
Chris@76 340 INNER JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)' : (in_array($context['sort_by'], array('starter', 'subject')) ? '
Chris@76 341 INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)' : '')) . ($context['sort_by'] === 'starter' ? '
Chris@76 342 LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)' : '') . ($context['sort_by'] === 'last_poster' ? '
Chris@76 343 LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)' : '') . '
Chris@76 344 WHERE t.id_board = {int:current_board}' . (!$modSettings['postmod_active'] || $context['can_approve_posts'] ? '' : '
Chris@76 345 AND (t.approved = {int:is_approved}' . ($user_info['is_guest'] ? '' : ' OR t.id_member_started = {int:current_member}') . ')') . '
Chris@76 346 ORDER BY ' . (!empty($modSettings['enableStickyTopics']) ? 'is_sticky' . ($fake_ascending ? '' : ' DESC') . ', ' : '') . $_REQUEST['sort'] . ($ascending ? '' : ' DESC') . '
Chris@76 347 LIMIT {int:start}, {int:maxindex}',
Chris@76 348 array(
Chris@76 349 'current_board' => $board,
Chris@76 350 'current_member' => $user_info['id'],
Chris@76 351 'is_approved' => 1,
Chris@76 352 'id_member_guest' => 0,
Chris@76 353 'start' => $start,
Chris@76 354 'maxindex' => $maxindex,
Chris@76 355 )
Chris@76 356 );
Chris@76 357 $topic_ids = array();
Chris@76 358 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 359 $topic_ids[] = $row['id_topic'];
Chris@76 360 }
Chris@76 361
Chris@76 362 // Grab the appropriate topic information...
Chris@76 363 if (!$pre_query || !empty($topic_ids))
Chris@76 364 {
Chris@76 365 // For search engine effectiveness we'll link guests differently.
Chris@76 366 $context['pageindex_multiplier'] = empty($modSettings['disableCustomPerPage']) && !empty($options['messages_per_page']) && !WIRELESS ? $options['messages_per_page'] : $modSettings['defaultMaxMessages'];
Chris@76 367
Chris@76 368 $result = $smcFunc['db_query']('substring', '
Chris@76 369 SELECT
Chris@76 370 t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_board,
Chris@76 371 ' . ($user_info['is_guest'] ? '0' : 'IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1') . ' AS new_from,
Chris@76 372 t.id_last_msg, t.approved, t.unapproved_posts, ml.poster_time AS last_poster_time,
Chris@76 373 ml.id_msg_modified, ml.subject AS last_subject, ml.icon AS last_icon,
Chris@76 374 ml.poster_name AS last_member_name, ml.id_member AS last_id_member,
Chris@76 375 IFNULL(meml.real_name, ml.poster_name) AS last_display_name, t.id_first_msg,
Chris@76 376 mf.poster_time AS first_poster_time, mf.subject AS first_subject, mf.icon AS first_icon,
Chris@76 377 mf.poster_name AS first_member_name, mf.id_member AS first_id_member,
Chris@76 378 IFNULL(memf.real_name, mf.poster_name) AS first_display_name, SUBSTRING(ml.body, 1, 385) AS last_body,
Chris@76 379 SUBSTRING(mf.body, 1, 385) AS first_body, ml.smileys_enabled AS last_smileys, mf.smileys_enabled AS first_smileys
Chris@76 380 FROM {db_prefix}topics AS t
Chris@76 381 INNER JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)
Chris@76 382 INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)
Chris@76 383 LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)
Chris@76 384 LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)' . ($user_info['is_guest'] ? '' : '
Chris@76 385 LEFT JOIN {db_prefix}log_topics AS lt ON (lt.id_topic = t.id_topic AND lt.id_member = {int:current_member})
Chris@76 386 LEFT JOIN {db_prefix}log_mark_read AS lmr ON (lmr.id_board = {int:current_board} AND lmr.id_member = {int:current_member})'). '
Chris@76 387 WHERE ' . ($pre_query ? 't.id_topic IN ({array_int:topic_list})' : 't.id_board = {int:current_board}') . (!$modSettings['postmod_active'] || $context['can_approve_posts'] ? '' : '
Chris@76 388 AND (t.approved = {int:is_approved}' . ($user_info['is_guest'] ? '' : ' OR t.id_member_started = {int:current_member}') . ')') . '
Chris@76 389 ORDER BY ' . ($pre_query ? 'FIND_IN_SET(t.id_topic, {string:find_set_topics})' : (!empty($modSettings['enableStickyTopics']) ? 'is_sticky' . ($fake_ascending ? '' : ' DESC') . ', ' : '') . $_REQUEST['sort'] . ($ascending ? '' : ' DESC')) . '
Chris@76 390 LIMIT ' . ($pre_query ? '' : '{int:start}, ') . '{int:maxindex}',
Chris@76 391 array(
Chris@76 392 'current_board' => $board,
Chris@76 393 'current_member' => $user_info['id'],
Chris@76 394 'topic_list' => $topic_ids,
Chris@76 395 'is_approved' => 1,
Chris@76 396 'find_set_topics' => implode(',', $topic_ids),
Chris@76 397 'start' => $start,
Chris@76 398 'maxindex' => $maxindex,
Chris@76 399 )
Chris@76 400 );
Chris@76 401
Chris@76 402 // Begin 'printing' the message index for current board.
Chris@76 403 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 404 {
Chris@76 405 if ($row['id_poll'] > 0 && $modSettings['pollMode'] == '0')
Chris@76 406 continue;
Chris@76 407
Chris@76 408 if (!$pre_query)
Chris@76 409 $topic_ids[] = $row['id_topic'];
Chris@76 410
Chris@76 411 if (!empty($settings['message_index_preview']))
Chris@76 412 {
Chris@76 413 // Limit them to 128 characters - do this FIRST because it's a lot of wasted censoring otherwise.
Chris@76 414 $row['first_body'] = strip_tags(strtr(parse_bbc($row['first_body'], $row['first_smileys'], $row['id_first_msg']), array('<br />' => '&#10;')));
Chris@76 415 if ($smcFunc['strlen']($row['first_body']) > 128)
Chris@76 416 $row['first_body'] = $smcFunc['substr']($row['first_body'], 0, 128) . '...';
Chris@76 417 $row['last_body'] = strip_tags(strtr(parse_bbc($row['last_body'], $row['last_smileys'], $row['id_last_msg']), array('<br />' => '&#10;')));
Chris@76 418 if ($smcFunc['strlen']($row['last_body']) > 128)
Chris@76 419 $row['last_body'] = $smcFunc['substr']($row['last_body'], 0, 128) . '...';
Chris@76 420
Chris@76 421 // Censor the subject and message preview.
Chris@76 422 censorText($row['first_subject']);
Chris@76 423 censorText($row['first_body']);
Chris@76 424
Chris@76 425 // Don't censor them twice!
Chris@76 426 if ($row['id_first_msg'] == $row['id_last_msg'])
Chris@76 427 {
Chris@76 428 $row['last_subject'] = $row['first_subject'];
Chris@76 429 $row['last_body'] = $row['first_body'];
Chris@76 430 }
Chris@76 431 else
Chris@76 432 {
Chris@76 433 censorText($row['last_subject']);
Chris@76 434 censorText($row['last_body']);
Chris@76 435 }
Chris@76 436 }
Chris@76 437 else
Chris@76 438 {
Chris@76 439 $row['first_body'] = '';
Chris@76 440 $row['last_body'] = '';
Chris@76 441 censorText($row['first_subject']);
Chris@76 442
Chris@76 443 if ($row['id_first_msg'] == $row['id_last_msg'])
Chris@76 444 $row['last_subject'] = $row['first_subject'];
Chris@76 445 else
Chris@76 446 censorText($row['last_subject']);
Chris@76 447 }
Chris@76 448
Chris@76 449 // Decide how many pages the topic should have.
Chris@76 450 if ($row['num_replies'] + 1 > $context['messages_per_page'])
Chris@76 451 {
Chris@76 452 $pages = '&#171; ';
Chris@76 453
Chris@76 454 // We can't pass start by reference.
Chris@76 455 $start = -1;
Chris@76 456 $pages .= constructPageIndex($scripturl . '?topic=' . $row['id_topic'] . '.%1$d', $start, $row['num_replies'] + 1, $context['messages_per_page'], true);
Chris@76 457
Chris@76 458 // If we can use all, show all.
Chris@76 459 if (!empty($modSettings['enableAllMessages']) && $row['num_replies'] + 1 < $modSettings['enableAllMessages'])
Chris@76 460 $pages .= ' &nbsp;<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.0;all">' . $txt['all'] . '</a>';
Chris@76 461 $pages .= ' &#187;';
Chris@76 462 }
Chris@76 463 else
Chris@76 464 $pages = '';
Chris@76 465
Chris@76 466 // We need to check the topic icons exist...
Chris@76 467 if (empty($modSettings['messageIconChecks_disable']))
Chris@76 468 {
Chris@76 469 if (!isset($context['icon_sources'][$row['first_icon']]))
Chris@76 470 $context['icon_sources'][$row['first_icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['first_icon'] . '.gif') ? 'images_url' : 'default_images_url';
Chris@76 471 if (!isset($context['icon_sources'][$row['last_icon']]))
Chris@76 472 $context['icon_sources'][$row['last_icon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['last_icon'] . '.gif') ? 'images_url' : 'default_images_url';
Chris@76 473 }
Chris@76 474 else
Chris@76 475 {
Chris@76 476 if (!isset($context['icon_sources'][$row['first_icon']]))
Chris@76 477 $context['icon_sources'][$row['first_icon']] = 'images_url';
Chris@76 478 if (!isset($context['icon_sources'][$row['last_icon']]))
Chris@76 479 $context['icon_sources'][$row['last_icon']] = 'images_url';
Chris@76 480 }
Chris@76 481
Chris@76 482 // 'Print' the topic info.
Chris@76 483 $context['topics'][$row['id_topic']] = array(
Chris@76 484 'id' => $row['id_topic'],
Chris@76 485 'first_post' => array(
Chris@76 486 'id' => $row['id_first_msg'],
Chris@76 487 'member' => array(
Chris@76 488 'username' => $row['first_member_name'],
Chris@76 489 'name' => $row['first_display_name'],
Chris@76 490 'id' => $row['first_id_member'],
Chris@76 491 'href' => !empty($row['first_id_member']) ? $scripturl . '?action=profile;u=' . $row['first_id_member'] : '',
Chris@76 492 'link' => !empty($row['first_id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['first_id_member'] . '" title="' . $txt['profile_of'] . ' ' . $row['first_display_name'] . '">' . $row['first_display_name'] . '</a>' : $row['first_display_name']
Chris@76 493 ),
Chris@76 494 'time' => timeformat($row['first_poster_time']),
Chris@76 495 'timestamp' => forum_time(true, $row['first_poster_time']),
Chris@76 496 'subject' => $row['first_subject'],
Chris@76 497 'preview' => $row['first_body'],
Chris@76 498 'icon' => $row['first_icon'],
Chris@76 499 'icon_url' => $settings[$context['icon_sources'][$row['first_icon']]] . '/post/' . $row['first_icon'] . '.gif',
Chris@76 500 'href' => $scripturl . '?topic=' . $row['id_topic'] . '.0',
Chris@76 501 'link' => '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.0">' . $row['first_subject'] . '</a>'
Chris@76 502 ),
Chris@76 503 'last_post' => array(
Chris@76 504 'id' => $row['id_last_msg'],
Chris@76 505 'member' => array(
Chris@76 506 'username' => $row['last_member_name'],
Chris@76 507 'name' => $row['last_display_name'],
Chris@76 508 'id' => $row['last_id_member'],
Chris@76 509 'href' => !empty($row['last_id_member']) ? $scripturl . '?action=profile;u=' . $row['last_id_member'] : '',
Chris@76 510 'link' => !empty($row['last_id_member']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['last_id_member'] . '">' . $row['last_display_name'] . '</a>' : $row['last_display_name']
Chris@76 511 ),
Chris@76 512 'time' => timeformat($row['last_poster_time']),
Chris@76 513 'timestamp' => forum_time(true, $row['last_poster_time']),
Chris@76 514 'subject' => $row['last_subject'],
Chris@76 515 'preview' => $row['last_body'],
Chris@76 516 'icon' => $row['last_icon'],
Chris@76 517 'icon_url' => $settings[$context['icon_sources'][$row['last_icon']]] . '/post/' . $row['last_icon'] . '.gif',
Chris@76 518 'href' => $scripturl . '?topic=' . $row['id_topic'] . ($user_info['is_guest'] ? ('.' . (!empty($options['view_newest_first']) ? 0 : ((int) (($row['num_replies']) / $context['pageindex_multiplier'])) * $context['pageindex_multiplier']) . '#msg' . $row['id_last_msg']) : (($row['num_replies'] == 0 ? '.0' : '.msg' . $row['id_last_msg']) . '#new')),
Chris@76 519 'link' => '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . ($user_info['is_guest'] ? ('.' . (!empty($options['view_newest_first']) ? 0 : ((int) (($row['num_replies']) / $context['pageindex_multiplier'])) * $context['pageindex_multiplier']) . '#msg' . $row['id_last_msg']) : (($row['num_replies'] == 0 ? '.0' : '.msg' . $row['id_last_msg']) . '#new')) . '" ' . ($row['num_replies'] == 0 ? '' : 'rel="nofollow"') . '>' . $row['last_subject'] . '</a>'
Chris@76 520 ),
Chris@76 521 'is_sticky' => !empty($modSettings['enableStickyTopics']) && !empty($row['is_sticky']),
Chris@76 522 'is_locked' => !empty($row['locked']),
Chris@76 523 'is_poll' => $modSettings['pollMode'] == '1' && $row['id_poll'] > 0,
Chris@76 524 'is_hot' => $row['num_replies'] >= $modSettings['hotTopicPosts'],
Chris@76 525 'is_very_hot' => $row['num_replies'] >= $modSettings['hotTopicVeryPosts'],
Chris@76 526 'is_posted_in' => false,
Chris@76 527 'icon' => $row['first_icon'],
Chris@76 528 'icon_url' => $settings[$context['icon_sources'][$row['first_icon']]] . '/post/' . $row['first_icon'] . '.gif',
Chris@76 529 'subject' => $row['first_subject'],
Chris@76 530 'new' => $row['new_from'] <= $row['id_msg_modified'],
Chris@76 531 'new_from' => $row['new_from'],
Chris@76 532 'newtime' => $row['new_from'],
Chris@76 533 'new_href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['new_from'] . '#new',
Chris@76 534 'pages' => $pages,
Chris@76 535 'replies' => comma_format($row['num_replies']),
Chris@76 536 'views' => comma_format($row['num_views']),
Chris@76 537 'approved' => $row['approved'],
Chris@76 538 'unapproved_posts' => $row['unapproved_posts'],
Chris@76 539 );
Chris@76 540
Chris@76 541 determineTopicClass($context['topics'][$row['id_topic']]);
Chris@76 542 }
Chris@76 543 $smcFunc['db_free_result']($result);
Chris@76 544
Chris@76 545 // Fix the sequence of topics if they were retrieved in the wrong order. (for speed reasons...)
Chris@76 546 if ($fake_ascending)
Chris@76 547 $context['topics'] = array_reverse($context['topics'], true);
Chris@76 548
Chris@76 549 if (!empty($modSettings['enableParticipation']) && !$user_info['is_guest'] && !empty($topic_ids))
Chris@76 550 {
Chris@76 551 $result = $smcFunc['db_query']('', '
Chris@76 552 SELECT id_topic
Chris@76 553 FROM {db_prefix}messages
Chris@76 554 WHERE id_topic IN ({array_int:topic_list})
Chris@76 555 AND id_member = {int:current_member}
Chris@76 556 GROUP BY id_topic
Chris@76 557 LIMIT ' . count($topic_ids),
Chris@76 558 array(
Chris@76 559 'current_member' => $user_info['id'],
Chris@76 560 'topic_list' => $topic_ids,
Chris@76 561 )
Chris@76 562 );
Chris@76 563 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 564 {
Chris@76 565 $context['topics'][$row['id_topic']]['is_posted_in'] = true;
Chris@76 566 $context['topics'][$row['id_topic']]['class'] = 'my_' . $context['topics'][$row['id_topic']]['class'];
Chris@76 567 }
Chris@76 568 $smcFunc['db_free_result']($result);
Chris@76 569 }
Chris@76 570 }
Chris@76 571
Chris@76 572 $context['jump_to'] = array(
Chris@76 573 'label' => addslashes(un_htmlspecialchars($txt['jump_to'])),
Chris@76 574 'board_name' => htmlspecialchars(strtr(strip_tags($board_info['name']), array('&amp;' => '&'))),
Chris@76 575 'child_level' => $board_info['child_level'],
Chris@76 576 );
Chris@76 577
Chris@76 578 // Is Quick Moderation active/needed?
Chris@76 579 if (!empty($options['display_quick_mod']) && !empty($context['topics']))
Chris@76 580 {
Chris@76 581 $context['can_lock'] = allowedTo('lock_any');
Chris@76 582 $context['can_sticky'] = allowedTo('make_sticky') && !empty($modSettings['enableStickyTopics']);
Chris@76 583 $context['can_move'] = allowedTo('move_any');
Chris@76 584 $context['can_remove'] = allowedTo('remove_any');
Chris@76 585 $context['can_merge'] = allowedTo('merge_any');
Chris@76 586 // Ignore approving own topics as it's unlikely to come up...
Chris@76 587 $context['can_approve'] = $modSettings['postmod_active'] && allowedTo('approve_posts') && !empty($board_info['unapproved_topics']);
Chris@76 588 // Can we restore topics?
Chris@76 589 $context['can_restore'] = allowedTo('move_any') && !empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] == $board;
Chris@76 590
Chris@76 591 // Set permissions for all the topics.
Chris@76 592 foreach ($context['topics'] as $t => $topic)
Chris@76 593 {
Chris@76 594 $started = $topic['first_post']['member']['id'] == $user_info['id'];
Chris@76 595 $context['topics'][$t]['quick_mod'] = array(
Chris@76 596 'lock' => allowedTo('lock_any') || ($started && allowedTo('lock_own')),
Chris@76 597 'sticky' => allowedTo('make_sticky') && !empty($modSettings['enableStickyTopics']),
Chris@76 598 'move' => allowedTo('move_any') || ($started && allowedTo('move_own')),
Chris@76 599 'modify' => allowedTo('modify_any') || ($started && allowedTo('modify_own')),
Chris@76 600 'remove' => allowedTo('remove_any') || ($started && allowedTo('remove_own')),
Chris@76 601 'approve' => $context['can_approve'] && $topic['unapproved_posts']
Chris@76 602 );
Chris@76 603 $context['can_lock'] |= ($started && allowedTo('lock_own'));
Chris@76 604 $context['can_move'] |= ($started && allowedTo('move_own'));
Chris@76 605 $context['can_remove'] |= ($started && allowedTo('remove_own'));
Chris@76 606 }
Chris@76 607
Chris@76 608 // Find the boards/cateogories they can move their topic to.
Chris@76 609 if ($options['display_quick_mod'] == 1 && $context['can_move'] && !empty($context['topics']))
Chris@76 610 {
Chris@76 611 require_once($sourcedir . '/Subs-MessageIndex.php');
Chris@76 612 $boardListOptions = array(
Chris@76 613 'excluded_boards' => array($board),
Chris@76 614 'not_redirection' => true,
Chris@76 615 'use_permissions' => true,
Chris@76 616 'selected_board' => empty($_SESSION['move_to_topic']) ? null : $_SESSION['move_to_topic'],
Chris@76 617 );
Chris@76 618 $context['move_to_boards'] = getBoardList($boardListOptions);
Chris@76 619
Chris@76 620 // Make the boards safe for display.
Chris@76 621 foreach ($context['move_to_boards'] as $id_cat => $cat)
Chris@76 622 {
Chris@76 623 $context['move_to_boards'][$id_cat]['name'] = strip_tags($cat['name']);
Chris@76 624 foreach ($cat['boards'] as $id_board => $board)
Chris@76 625 $context['move_to_boards'][$id_cat]['boards'][$id_board]['name'] = strip_tags($board['name']);
Chris@76 626 }
Chris@76 627
Chris@76 628 // With no other boards to see, it's useless to move.
Chris@76 629 if (empty($context['move_to_boards']))
Chris@76 630 $context['can_move'] = false;
Chris@76 631 }
Chris@76 632 // Can we use quick moderation checkboxes?
Chris@76 633 if ($options['display_quick_mod'] == 1)
Chris@76 634 $context['can_quick_mod'] = $context['user']['is_logged'] || $context['can_approve'] || $context['can_remove'] || $context['can_lock'] || $context['can_sticky'] || $context['can_move'] || $context['can_merge'] || $context['can_restore'];
Chris@76 635 // Or the icons?
Chris@76 636 else
Chris@76 637 $context['can_quick_mod'] = $context['can_remove'] || $context['can_lock'] || $context['can_sticky'] || $context['can_move'];
Chris@76 638 }
Chris@76 639
Chris@76 640 // If there are children, but no topics and no ability to post topics...
Chris@76 641 $context['no_topic_listing'] = !empty($context['boards']) && empty($context['topics']) && !$context['can_post_new'];
Chris@76 642 }
Chris@76 643
Chris@76 644 // Allows for moderation from the message index.
Chris@76 645 function QuickModeration()
Chris@76 646 {
Chris@76 647 global $sourcedir, $board, $user_info, $modSettings, $sourcedir, $smcFunc, $context;
Chris@76 648
Chris@76 649 // Check the session = get or post.
Chris@76 650 checkSession('request');
Chris@76 651
Chris@76 652 // Lets go straight to the restore area.
Chris@76 653 if (isset($_REQUEST['qaction']) && $_REQUEST['qaction'] == 'restore' && !empty($_REQUEST['topics']))
Chris@76 654 redirectexit('action=restoretopic;topics=' . implode(',', $_REQUEST['topics']) . ';' . $context['session_var'] . '=' . $context['session_id']);
Chris@76 655
Chris@76 656 if (isset($_SESSION['topicseen_cache']))
Chris@76 657 $_SESSION['topicseen_cache'] = array();
Chris@76 658
Chris@76 659 // This is going to be needed to send off the notifications and for updateLastMessages().
Chris@76 660 require_once($sourcedir . '/Subs-Post.php');
Chris@76 661
Chris@76 662 // Remember the last board they moved things to.
Chris@76 663 if (isset($_REQUEST['move_to']))
Chris@76 664 $_SESSION['move_to_topic'] = $_REQUEST['move_to'];
Chris@76 665
Chris@76 666 // Only a few possible actions.
Chris@76 667 $possibleActions = array();
Chris@76 668
Chris@76 669 if (!empty($board))
Chris@76 670 {
Chris@76 671 $boards_can = array(
Chris@76 672 'make_sticky' => allowedTo('make_sticky') ? array($board) : array(),
Chris@76 673 'move_any' => allowedTo('move_any') ? array($board) : array(),
Chris@76 674 'move_own' => allowedTo('move_own') ? array($board) : array(),
Chris@76 675 'remove_any' => allowedTo('remove_any') ? array($board) : array(),
Chris@76 676 'remove_own' => allowedTo('remove_own') ? array($board) : array(),
Chris@76 677 'lock_any' => allowedTo('lock_any') ? array($board) : array(),
Chris@76 678 'lock_own' => allowedTo('lock_own') ? array($board) : array(),
Chris@76 679 'merge_any' => allowedTo('merge_any') ? array($board) : array(),
Chris@76 680 'approve_posts' => allowedTo('approve_posts') ? array($board) : array(),
Chris@76 681 );
Chris@76 682
Chris@76 683 $redirect_url = 'board=' . $board . '.' . $_REQUEST['start'];
Chris@76 684 }
Chris@76 685 else
Chris@76 686 {
Chris@76 687 // !!! Ugly. There's no getting around this, is there?
Chris@76 688 // !!! Maybe just do this on the actions people want to use?
Chris@76 689 $boards_can = array(
Chris@76 690 'make_sticky' => boardsAllowedTo('make_sticky'),
Chris@76 691 'move_any' => boardsAllowedTo('move_any'),
Chris@76 692 'move_own' => boardsAllowedTo('move_own'),
Chris@76 693 'remove_any' => boardsAllowedTo('remove_any'),
Chris@76 694 'remove_own' => boardsAllowedTo('remove_own'),
Chris@76 695 'lock_any' => boardsAllowedTo('lock_any'),
Chris@76 696 'lock_own' => boardsAllowedTo('lock_own'),
Chris@76 697 'merge_any' => boardsAllowedTo('merge_any'),
Chris@76 698 'approve_posts' => boardsAllowedTo('approve_posts'),
Chris@76 699 );
Chris@76 700
Chris@76 701 $redirect_url = isset($_POST['redirect_url']) ? $_POST['redirect_url'] : (isset($_SESSION['old_url']) ? $_SESSION['old_url'] : '');
Chris@76 702 }
Chris@76 703
Chris@76 704 if (!$user_info['is_guest'])
Chris@76 705 $possibleActions[] = 'markread';
Chris@76 706 if (!empty($boards_can['make_sticky']) && !empty($modSettings['enableStickyTopics']))
Chris@76 707 $possibleActions[] = 'sticky';
Chris@76 708 if (!empty($boards_can['move_any']) || !empty($boards_can['move_own']))
Chris@76 709 $possibleActions[] = 'move';
Chris@76 710 if (!empty($boards_can['remove_any']) || !empty($boards_can['remove_own']))
Chris@76 711 $possibleActions[] = 'remove';
Chris@76 712 if (!empty($boards_can['lock_any']) || !empty($boards_can['lock_own']))
Chris@76 713 $possibleActions[] = 'lock';
Chris@76 714 if (!empty($boards_can['merge_any']))
Chris@76 715 $possibleActions[] = 'merge';
Chris@76 716 if (!empty($boards_can['approve_posts']))
Chris@76 717 $possibleActions[] = 'approve';
Chris@76 718
Chris@76 719 // Two methods: $_REQUEST['actions'] (id_topic => action), and $_REQUEST['topics'] and $_REQUEST['qaction'].
Chris@76 720 // (if action is 'move', $_REQUEST['move_to'] or $_REQUEST['move_tos'][$topic] is used.)
Chris@76 721 if (!empty($_REQUEST['topics']))
Chris@76 722 {
Chris@76 723 // If the action isn't valid, just quit now.
Chris@76 724 if (empty($_REQUEST['qaction']) || !in_array($_REQUEST['qaction'], $possibleActions))
Chris@76 725 redirectexit($redirect_url);
Chris@76 726
Chris@76 727 // Merge requires all topics as one parameter and can be done at once.
Chris@76 728 if ($_REQUEST['qaction'] == 'merge')
Chris@76 729 {
Chris@76 730 // Merge requires at least two topics.
Chris@76 731 if (empty($_REQUEST['topics']) || count($_REQUEST['topics']) < 2)
Chris@76 732 redirectexit($redirect_url);
Chris@76 733
Chris@76 734 require_once($sourcedir . '/SplitTopics.php');
Chris@76 735 return MergeExecute($_REQUEST['topics']);
Chris@76 736 }
Chris@76 737
Chris@76 738 // Just convert to the other method, to make it easier.
Chris@76 739 foreach ($_REQUEST['topics'] as $topic)
Chris@76 740 $_REQUEST['actions'][(int) $topic] = $_REQUEST['qaction'];
Chris@76 741 }
Chris@76 742
Chris@76 743 // Weird... how'd you get here?
Chris@76 744 if (empty($_REQUEST['actions']))
Chris@76 745 redirectexit($redirect_url);
Chris@76 746
Chris@76 747 // Validate each action.
Chris@76 748 $temp = array();
Chris@76 749 foreach ($_REQUEST['actions'] as $topic => $action)
Chris@76 750 {
Chris@76 751 if (in_array($action, $possibleActions))
Chris@76 752 $temp[(int) $topic] = $action;
Chris@76 753 }
Chris@76 754 $_REQUEST['actions'] = $temp;
Chris@76 755
Chris@76 756 if (!empty($_REQUEST['actions']))
Chris@76 757 {
Chris@76 758 // Find all topics...
Chris@76 759 $request = $smcFunc['db_query']('', '
Chris@76 760 SELECT id_topic, id_member_started, id_board, locked, approved, unapproved_posts
Chris@76 761 FROM {db_prefix}topics
Chris@76 762 WHERE id_topic IN ({array_int:action_topic_ids})
Chris@76 763 LIMIT ' . count($_REQUEST['actions']),
Chris@76 764 array(
Chris@76 765 'action_topic_ids' => array_keys($_REQUEST['actions']),
Chris@76 766 )
Chris@76 767 );
Chris@76 768 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 769 {
Chris@76 770 if (!empty($board))
Chris@76 771 {
Chris@76 772 if ($row['id_board'] != $board || ($modSettings['postmod_active'] && !$row['approved'] && !allowedTo('approve_posts')))
Chris@76 773 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 774 }
Chris@76 775 else
Chris@76 776 {
Chris@76 777 // Don't allow them to act on unapproved posts they can't see...
Chris@76 778 if ($modSettings['postmod_active'] && !$row['approved'] && !in_array(0, $boards_can['approve_posts']) && !in_array($row['id_board'], $boards_can['approve_posts']))
Chris@76 779 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 780 // Goodness, this is fun. We need to validate the action.
Chris@76 781 elseif ($_REQUEST['actions'][$row['id_topic']] == 'sticky' && !in_array(0, $boards_can['make_sticky']) && !in_array($row['id_board'], $boards_can['make_sticky']))
Chris@76 782 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 783 elseif ($_REQUEST['actions'][$row['id_topic']] == 'move' && !in_array(0, $boards_can['move_any']) && !in_array($row['id_board'], $boards_can['move_any']) && ($row['id_member_started'] != $user_info['id'] || (!in_array(0, $boards_can['move_own']) && !in_array($row['id_board'], $boards_can['move_own']))))
Chris@76 784 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 785 elseif ($_REQUEST['actions'][$row['id_topic']] == 'remove' && !in_array(0, $boards_can['remove_any']) && !in_array($row['id_board'], $boards_can['remove_any']) && ($row['id_member_started'] != $user_info['id'] || (!in_array(0, $boards_can['remove_own']) && !in_array($row['id_board'], $boards_can['remove_own']))))
Chris@76 786 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 787 elseif ($_REQUEST['actions'][$row['id_topic']] == 'lock' && !in_array(0, $boards_can['lock_any']) && !in_array($row['id_board'], $boards_can['lock_any']) && ($row['id_member_started'] != $user_info['id'] || $locked == 1 || (!in_array(0, $boards_can['lock_own']) && !in_array($row['id_board'], $boards_can['lock_own']))))
Chris@76 788 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 789 // If the topic is approved then you need permission to approve the posts within.
Chris@76 790 elseif ($_REQUEST['actions'][$row['id_topic']] == 'approve' && (!$row['unapproved_posts'] || (!in_array(0, $boards_can['approve_posts']) && !in_array($row['id_board'], $boards_can['approve_posts']))))
Chris@76 791 unset($_REQUEST['actions'][$row['id_topic']]);
Chris@76 792 }
Chris@76 793 }
Chris@76 794 $smcFunc['db_free_result']($request);
Chris@76 795 }
Chris@76 796
Chris@76 797 $stickyCache = array();
Chris@76 798 $moveCache = array(0 => array(), 1 => array());
Chris@76 799 $removeCache = array();
Chris@76 800 $lockCache = array();
Chris@76 801 $markCache = array();
Chris@76 802 $approveCache = array();
Chris@76 803
Chris@76 804 // Separate the actions.
Chris@76 805 foreach ($_REQUEST['actions'] as $topic => $action)
Chris@76 806 {
Chris@76 807 $topic = (int) $topic;
Chris@76 808
Chris@76 809 if ($action == 'markread')
Chris@76 810 $markCache[] = $topic;
Chris@76 811 elseif ($action == 'sticky')
Chris@76 812 $stickyCache[] = $topic;
Chris@76 813 elseif ($action == 'move')
Chris@76 814 {
Chris@76 815 // $moveCache[0] is the topic, $moveCache[1] is the board to move to.
Chris@76 816 $moveCache[1][$topic] = (int) (isset($_REQUEST['move_tos'][$topic]) ? $_REQUEST['move_tos'][$topic] : $_REQUEST['move_to']);
Chris@76 817
Chris@76 818 if (empty($moveCache[1][$topic]))
Chris@76 819 continue;
Chris@76 820
Chris@76 821 $moveCache[0][] = $topic;
Chris@76 822 }
Chris@76 823 elseif ($action == 'remove')
Chris@76 824 $removeCache[] = $topic;
Chris@76 825 elseif ($action == 'lock')
Chris@76 826 $lockCache[] = $topic;
Chris@76 827 elseif ($action == 'approve')
Chris@76 828 $approveCache[] = $topic;
Chris@76 829 }
Chris@76 830
Chris@76 831 if (empty($board))
Chris@76 832 $affectedBoards = array();
Chris@76 833 else
Chris@76 834 $affectedBoards = array($board => array(0, 0));
Chris@76 835
Chris@76 836 // Do all the stickies...
Chris@76 837 if (!empty($stickyCache))
Chris@76 838 {
Chris@76 839 $smcFunc['db_query']('', '
Chris@76 840 UPDATE {db_prefix}topics
Chris@76 841 SET is_sticky = CASE WHEN is_sticky = {int:is_sticky} THEN 0 ELSE 1 END
Chris@76 842 WHERE id_topic IN ({array_int:sticky_topic_ids})',
Chris@76 843 array(
Chris@76 844 'sticky_topic_ids' => $stickyCache,
Chris@76 845 'is_sticky' => 1,
Chris@76 846 )
Chris@76 847 );
Chris@76 848
Chris@76 849 // Get the board IDs and Sticky status
Chris@76 850 $request = $smcFunc['db_query']('', '
Chris@76 851 SELECT id_topic, id_board, is_sticky
Chris@76 852 FROM {db_prefix}topics
Chris@76 853 WHERE id_topic IN ({array_int:sticky_topic_ids})
Chris@76 854 LIMIT ' . count($stickyCache),
Chris@76 855 array(
Chris@76 856 'sticky_topic_ids' => $stickyCache,
Chris@76 857 )
Chris@76 858 );
Chris@76 859 $stickyCacheBoards = array();
Chris@76 860 $stickyCacheStatus = array();
Chris@76 861 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 862 {
Chris@76 863 $stickyCacheBoards[$row['id_topic']] = $row['id_board'];
Chris@76 864 $stickyCacheStatus[$row['id_topic']] = empty($row['is_sticky']);
Chris@76 865 }
Chris@76 866 $smcFunc['db_free_result']($request);
Chris@76 867 }
Chris@76 868
Chris@76 869 // Move sucka! (this is, by the by, probably the most complicated part....)
Chris@76 870 if (!empty($moveCache[0]))
Chris@76 871 {
Chris@76 872 // I know - I just KNOW you're trying to beat the system. Too bad for you... we CHECK :P.
Chris@76 873 $request = $smcFunc['db_query']('', '
Chris@76 874 SELECT t.id_topic, t.id_board, b.count_posts
Chris@76 875 FROM {db_prefix}topics AS t
Chris@76 876 LEFT JOIN {db_prefix}boards AS b ON (t.id_board = b.id_board)
Chris@76 877 WHERE t.id_topic IN ({array_int:move_topic_ids})' . (!empty($board) && !allowedTo('move_any') ? '
Chris@76 878 AND t.id_member_started = {int:current_member}' : '') . '
Chris@76 879 LIMIT ' . count($moveCache[0]),
Chris@76 880 array(
Chris@76 881 'current_member' => $user_info['id'],
Chris@76 882 'move_topic_ids' => $moveCache[0],
Chris@76 883 )
Chris@76 884 );
Chris@76 885 $moveTos = array();
Chris@76 886 $moveCache2 = array();
Chris@76 887 $countPosts = array();
Chris@76 888 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 889 {
Chris@76 890 $to = $moveCache[1][$row['id_topic']];
Chris@76 891
Chris@76 892 if (empty($to))
Chris@76 893 continue;
Chris@76 894
Chris@76 895 // Does this topic's board count the posts or not?
Chris@76 896 $countPosts[$row['id_topic']] = empty($row['count_posts']);
Chris@76 897
Chris@76 898 if (!isset($moveTos[$to]))
Chris@76 899 $moveTos[$to] = array();
Chris@76 900
Chris@76 901 $moveTos[$to][] = $row['id_topic'];
Chris@76 902
Chris@76 903 // For reporting...
Chris@76 904 $moveCache2[] = array($row['id_topic'], $row['id_board'], $to);
Chris@76 905 }
Chris@76 906 $smcFunc['db_free_result']($request);
Chris@76 907
Chris@76 908 $moveCache = $moveCache2;
Chris@76 909
Chris@76 910 require_once($sourcedir . '/MoveTopic.php');
Chris@76 911
Chris@76 912 // Do the actual moves...
Chris@76 913 foreach ($moveTos as $to => $topics)
Chris@76 914 moveTopics($topics, $to);
Chris@76 915
Chris@76 916 // Does the post counts need to be updated?
Chris@76 917 if (!empty($moveTos))
Chris@76 918 {
Chris@76 919 $topicRecounts = array();
Chris@76 920 $request = $smcFunc['db_query']('', '
Chris@76 921 SELECT id_board, count_posts
Chris@76 922 FROM {db_prefix}boards
Chris@76 923 WHERE id_board IN ({array_int:move_boards})',
Chris@76 924 array(
Chris@76 925 'move_boards' => array_keys($moveTos),
Chris@76 926 )
Chris@76 927 );
Chris@76 928
Chris@76 929 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 930 {
Chris@76 931 $cp = empty($row['count_posts']);
Chris@76 932
Chris@76 933 // Go through all the topics that are being moved to this board.
Chris@76 934 foreach ($moveTos[$row['id_board']] as $topic)
Chris@76 935 {
Chris@76 936 // If both boards have the same value for post counting then no adjustment needs to be made.
Chris@76 937 if ($countPosts[$topic] != $cp)
Chris@76 938 {
Chris@76 939 // If the board being moved to does count the posts then the other one doesn't so add to their post count.
Chris@76 940 $topicRecounts[$topic] = $cp ? '+' : '-';
Chris@76 941 }
Chris@76 942 }
Chris@76 943 }
Chris@76 944
Chris@76 945 $smcFunc['db_free_result']($request);
Chris@76 946
Chris@76 947 if (!empty($topicRecounts))
Chris@76 948 {
Chris@76 949 $members = array();
Chris@76 950
Chris@76 951 // Get all the members who have posted in the moved topics.
Chris@76 952 $request = $smcFunc['db_query']('', '
Chris@76 953 SELECT id_member, id_topic
Chris@76 954 FROM {db_prefix}messages
Chris@76 955 WHERE id_topic IN ({array_int:moved_topic_ids})',
Chris@76 956 array(
Chris@76 957 'moved_topic_ids' => array_keys($topicRecounts),
Chris@76 958 )
Chris@76 959 );
Chris@76 960
Chris@76 961 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 962 {
Chris@76 963 if (!isset($members[$row['id_member']]))
Chris@76 964 $members[$row['id_member']] = 0;
Chris@76 965
Chris@76 966 if ($topicRecounts[$row['id_topic']] === '+')
Chris@76 967 $members[$row['id_member']] += 1;
Chris@76 968 else
Chris@76 969 $members[$row['id_member']] -= 1;
Chris@76 970 }
Chris@76 971
Chris@76 972 $smcFunc['db_free_result']($request);
Chris@76 973
Chris@76 974 // And now update them member's post counts
Chris@76 975 foreach ($members as $id_member => $post_adj)
Chris@76 976 updateMemberData($id_member, array('posts' => 'posts + ' . $post_adj));
Chris@76 977
Chris@76 978 }
Chris@76 979 }
Chris@76 980 }
Chris@76 981
Chris@76 982 // Now delete the topics...
Chris@76 983 if (!empty($removeCache))
Chris@76 984 {
Chris@76 985 // They can only delete their own topics. (we wouldn't be here if they couldn't do that..)
Chris@76 986 $result = $smcFunc['db_query']('', '
Chris@76 987 SELECT id_topic, id_board
Chris@76 988 FROM {db_prefix}topics
Chris@76 989 WHERE id_topic IN ({array_int:removed_topic_ids})' . (!empty($board) && !allowedTo('remove_any') ? '
Chris@76 990 AND id_member_started = {int:current_member}' : '') . '
Chris@76 991 LIMIT ' . count($removeCache),
Chris@76 992 array(
Chris@76 993 'current_member' => $user_info['id'],
Chris@76 994 'removed_topic_ids' => $removeCache,
Chris@76 995 )
Chris@76 996 );
Chris@76 997
Chris@76 998 $removeCache = array();
Chris@76 999 $removeCacheBoards = array();
Chris@76 1000 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 1001 {
Chris@76 1002 $removeCache[] = $row['id_topic'];
Chris@76 1003 $removeCacheBoards[$row['id_topic']] = $row['id_board'];
Chris@76 1004 }
Chris@76 1005 $smcFunc['db_free_result']($result);
Chris@76 1006
Chris@76 1007 // Maybe *none* were their own topics.
Chris@76 1008 if (!empty($removeCache))
Chris@76 1009 {
Chris@76 1010 // Gotta send the notifications *first*!
Chris@76 1011 foreach ($removeCache as $topic)
Chris@76 1012 {
Chris@76 1013 // Only log the topic ID if it's not in the recycle board.
Chris@76 1014 logAction('remove', array((empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $removeCacheBoards[$topic] ? 'topic' : 'old_topic_id') => $topic, 'board' => $removeCacheBoards[$topic]));
Chris@76 1015 sendNotifications($topic, 'remove');
Chris@76 1016 }
Chris@76 1017
Chris@76 1018 require_once($sourcedir . '/RemoveTopic.php');
Chris@76 1019 removeTopics($removeCache);
Chris@76 1020 }
Chris@76 1021 }
Chris@76 1022
Chris@76 1023 // Approve the topics...
Chris@76 1024 if (!empty($approveCache))
Chris@76 1025 {
Chris@76 1026 // We need unapproved topic ids and their authors!
Chris@76 1027 $request = $smcFunc['db_query']('', '
Chris@76 1028 SELECT id_topic, id_member_started
Chris@76 1029 FROM {db_prefix}topics
Chris@76 1030 WHERE id_topic IN ({array_int:approve_topic_ids})
Chris@76 1031 AND approved = {int:not_approved}
Chris@76 1032 LIMIT ' . count($approveCache),
Chris@76 1033 array(
Chris@76 1034 'approve_topic_ids' => $approveCache,
Chris@76 1035 'not_approved' => 0,
Chris@76 1036 )
Chris@76 1037 );
Chris@76 1038 $approveCache = array();
Chris@76 1039 $approveCacheMembers = array();
Chris@76 1040 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 1041 {
Chris@76 1042 $approveCache[] = $row['id_topic'];
Chris@76 1043 $approveCacheMembers[$row['id_topic']] = $row['id_member_started'];
Chris@76 1044 }
Chris@76 1045 $smcFunc['db_free_result']($request);
Chris@76 1046
Chris@76 1047 // Any topics to approve?
Chris@76 1048 if (!empty($approveCache))
Chris@76 1049 {
Chris@76 1050 // Handle the approval part...
Chris@76 1051 approveTopics($approveCache);
Chris@76 1052
Chris@76 1053 // Time for some logging!
Chris@76 1054 foreach ($approveCache as $topic)
Chris@76 1055 logAction('approve_topic', array('topic' => $topic, 'member' => $approveCacheMembers[$topic]));
Chris@76 1056 }
Chris@76 1057 }
Chris@76 1058
Chris@76 1059 // And (almost) lastly, lock the topics...
Chris@76 1060 if (!empty($lockCache))
Chris@76 1061 {
Chris@76 1062 $lockStatus = array();
Chris@76 1063
Chris@76 1064 // Gotta make sure they CAN lock/unlock these topics...
Chris@76 1065 if (!empty($board) && !allowedTo('lock_any'))
Chris@76 1066 {
Chris@76 1067 // Make sure they started the topic AND it isn't already locked by someone with higher priv's.
Chris@76 1068 $result = $smcFunc['db_query']('', '
Chris@76 1069 SELECT id_topic, locked, id_board
Chris@76 1070 FROM {db_prefix}topics
Chris@76 1071 WHERE id_topic IN ({array_int:locked_topic_ids})
Chris@76 1072 AND id_member_started = {int:current_member}
Chris@76 1073 AND locked IN (2, 0)
Chris@76 1074 LIMIT ' . count($lockCache),
Chris@76 1075 array(
Chris@76 1076 'current_member' => $user_info['id'],
Chris@76 1077 'locked_topic_ids' => $lockCache,
Chris@76 1078 )
Chris@76 1079 );
Chris@76 1080 $lockCache = array();
Chris@76 1081 $lockCacheBoards = array();
Chris@76 1082 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 1083 {
Chris@76 1084 $lockCache[] = $row['id_topic'];
Chris@76 1085 $lockCacheBoards[$row['id_topic']] = $row['id_board'];
Chris@76 1086 $lockStatus[$row['id_topic']] = empty($row['locked']);
Chris@76 1087 }
Chris@76 1088 $smcFunc['db_free_result']($result);
Chris@76 1089 }
Chris@76 1090 else
Chris@76 1091 {
Chris@76 1092 $result = $smcFunc['db_query']('', '
Chris@76 1093 SELECT id_topic, locked, id_board
Chris@76 1094 FROM {db_prefix}topics
Chris@76 1095 WHERE id_topic IN ({array_int:locked_topic_ids})
Chris@76 1096 LIMIT ' . count($lockCache),
Chris@76 1097 array(
Chris@76 1098 'locked_topic_ids' => $lockCache,
Chris@76 1099 )
Chris@76 1100 );
Chris@76 1101 $lockCacheBoards = array();
Chris@76 1102 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 1103 {
Chris@76 1104 $lockStatus[$row['id_topic']] = empty($row['locked']);
Chris@76 1105 $lockCacheBoards[$row['id_topic']] = $row['id_board'];
Chris@76 1106 }
Chris@76 1107 $smcFunc['db_free_result']($result);
Chris@76 1108 }
Chris@76 1109
Chris@76 1110 // It could just be that *none* were their own topics...
Chris@76 1111 if (!empty($lockCache))
Chris@76 1112 {
Chris@76 1113 // Alternate the locked value.
Chris@76 1114 $smcFunc['db_query']('', '
Chris@76 1115 UPDATE {db_prefix}topics
Chris@76 1116 SET locked = CASE WHEN locked = {int:is_locked} THEN ' . (allowedTo('lock_any') ? '1' : '2') . ' ELSE 0 END
Chris@76 1117 WHERE id_topic IN ({array_int:locked_topic_ids})',
Chris@76 1118 array(
Chris@76 1119 'locked_topic_ids' => $lockCache,
Chris@76 1120 'is_locked' => 0,
Chris@76 1121 )
Chris@76 1122 );
Chris@76 1123 }
Chris@76 1124 }
Chris@76 1125
Chris@76 1126 if (!empty($markCache))
Chris@76 1127 {
Chris@76 1128 $markArray = array();
Chris@76 1129 foreach ($markCache as $topic)
Chris@76 1130 $markArray[] = array($modSettings['maxMsgID'], $user_info['id'], $topic);
Chris@76 1131
Chris@76 1132 $smcFunc['db_insert']('replace',
Chris@76 1133 '{db_prefix}log_topics',
Chris@76 1134 array('id_msg' => 'int', 'id_member' => 'int', 'id_topic' => 'int'),
Chris@76 1135 $markArray,
Chris@76 1136 array('id_member', 'id_topic')
Chris@76 1137 );
Chris@76 1138 }
Chris@76 1139
Chris@76 1140 foreach ($moveCache as $topic)
Chris@76 1141 {
Chris@76 1142 // Didn't actually move anything!
Chris@76 1143 if (!isset($topic[0]))
Chris@76 1144 break;
Chris@76 1145
Chris@76 1146 logAction('move', array('topic' => $topic[0], 'board_from' => $topic[1], 'board_to' => $topic[2]));
Chris@76 1147 sendNotifications($topic[0], 'move');
Chris@76 1148 }
Chris@76 1149 foreach ($lockCache as $topic)
Chris@76 1150 {
Chris@76 1151 logAction($lockStatus[$topic] ? 'lock' : 'unlock', array('topic' => $topic, 'board' => $lockCacheBoards[$topic]));
Chris@76 1152 sendNotifications($topic, $lockStatus[$topic] ? 'lock' : 'unlock');
Chris@76 1153 }
Chris@76 1154 foreach ($stickyCache as $topic)
Chris@76 1155 {
Chris@76 1156 logAction($stickyCacheStatus[$topic] ? 'unsticky' : 'sticky', array('topic' => $topic, 'board' => $stickyCacheBoards[$topic]));
Chris@76 1157 sendNotifications($topic, 'sticky');
Chris@76 1158 }
Chris@76 1159
Chris@76 1160 updateStats('topic');
Chris@76 1161 updateStats('message');
Chris@76 1162 updateSettings(array(
Chris@76 1163 'calendar_updated' => time(),
Chris@76 1164 ));
Chris@76 1165
Chris@76 1166 if (!empty($affectedBoards))
Chris@76 1167 updateLastMessages(array_keys($affectedBoards));
Chris@76 1168
Chris@76 1169 redirectexit($redirect_url);
Chris@76 1170 }
Chris@76 1171
Chris@76 1172 ?>