Mercurial > hg > vamp-website

annotate forum/Sources/Subs-Boards.php @ 85:6d7b61434be7 website

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add a copy of this here, just in case!
author Chris Cannam
date Mon, 20 Jan 2014 11:02:36 +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
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 mainly concerned with minor tasks relating to boards, such as
Chris@76 18 marking them read, collapsing categories, or quick moderation. It defines
Chris@76 19 the following list of functions:
Chris@76 20
Chris@76 21 void markBoardsRead(array boards)
Chris@76 22 // !!!
Chris@76 23
Chris@76 24 void MarkRead()
Chris@76 25 // !!!
Chris@76 26
Chris@76 27 int getMsgMemberID(int id_msg)
Chris@76 28 // !!!
Chris@76 29
Chris@76 30 void modifyBoard(int board_id, array boardOptions)
Chris@76 31 - general function to modify the settings and position of a board.
Chris@76 32 - used by ManageBoards.php to change the settings of a board.
Chris@76 33
Chris@76 34 int createBoard(array boardOptions)
Chris@76 35 - general function to create a new board and set its position.
Chris@76 36 - allows (almost) the same options as the modifyBoard() function.
Chris@76 37 - with the option inherit_permissions set, the parent board permissions
Chris@76 38 will be inherited.
Chris@76 39 - returns the ID of the newly created board.
Chris@76 40
Chris@76 41 void deleteBoards(array boards_to_remove, moveChildrenTo = null)
Chris@76 42 - general function to delete one or more boards.
Chris@76 43 - allows to move the children of the board before deleting it
Chris@76 44 - if moveChildrenTo is set to null, the child boards will be deleted.
Chris@76 45 - deletes all topics that are on the given boards.
Chris@76 46 - deletes all information that's associated with the given boards.
Chris@76 47 - updates the statistics to reflect the new situation.
Chris@76 48
Chris@76 49 void reorderBoards()
Chris@76 50 - updates the database to put all boards in the right order.
Chris@76 51 - sorts the records of the boards table.
Chris@76 52 - used by modifyBoard(), deleteBoards(), modifyCategory(), and
Chris@76 53 deleteCategories() functions.
Chris@76 54
Chris@76 55 void fixChildren(int parent, int newLevel, int newParent)
Chris@76 56 - recursively updates the children of parent's child_level and
Chris@76 57 id_parent to newLevel and newParent.
Chris@76 58 - used when a board is deleted or moved, to affect its children.
Chris@76 59
Chris@76 60 bool isChildOf(int child, int parent)
Chris@76 61 - determines if child is a child of parent.
Chris@76 62 - recurses down the tree until there are no more parents.
Chris@76 63 - returns true if child is a child of parent.
Chris@76 64
Chris@76 65 void getBoardTree()
Chris@76 66 - load information regarding the boards and categories.
Chris@76 67 - the information retrieved is stored in globals:
Chris@76 68 - $boards properties of each board.
Chris@76 69 - $boardList a list of boards grouped by category ID.
Chris@76 70 - $cat_tree properties of each category.
Chris@76 71
Chris@76 72 void recursiveBoards()
Chris@76 73 - function used by getBoardTree to recursively get a list of boards.
Chris@76 74
Chris@76 75 bool isChildOf(int child, int parent)
Chris@76 76 - determine if a certain board id is a child of another board.
Chris@76 77 - the parent might be several levels higher than the child.
Chris@76 78 */
Chris@76 79
Chris@76 80 // Mark a board or multiple boards read.
Chris@76 81 function markBoardsRead($boards, $unread = false)
Chris@76 82 {
Chris@76 83 global $user_info, $modSettings, $smcFunc;
Chris@76 84
Chris@76 85 // Force $boards to be an array.
Chris@76 86 if (!is_array($boards))
Chris@76 87 $boards = array($boards);
Chris@76 88 else
Chris@76 89 $boards = array_unique($boards);
Chris@76 90
Chris@76 91 // No boards, nothing to mark as read.
Chris@76 92 if (empty($boards))
Chris@76 93 return;
Chris@76 94
Chris@76 95 // Allow the user to mark a board as unread.
Chris@76 96 if ($unread)
Chris@76 97 {
Chris@76 98 // Clear out all the places where this lovely info is stored.
Chris@76 99 // !! Maybe not log_mark_read?
Chris@76 100 $smcFunc['db_query']('', '
Chris@76 101 DELETE FROM {db_prefix}log_mark_read
Chris@76 102 WHERE id_board IN ({array_int:board_list})
Chris@76 103 AND id_member = {int:current_member}',
Chris@76 104 array(
Chris@76 105 'current_member' => $user_info['id'],
Chris@76 106 'board_list' => $boards,
Chris@76 107 )
Chris@76 108 );
Chris@76 109 $smcFunc['db_query']('', '
Chris@76 110 DELETE FROM {db_prefix}log_boards
Chris@76 111 WHERE id_board IN ({array_int:board_list})
Chris@76 112 AND id_member = {int:current_member}',
Chris@76 113 array(
Chris@76 114 'current_member' => $user_info['id'],
Chris@76 115 'board_list' => $boards,
Chris@76 116 )
Chris@76 117 );
Chris@76 118 }
Chris@76 119 // Otherwise mark the board as read.
Chris@76 120 else
Chris@76 121 {
Chris@76 122 $markRead = array();
Chris@76 123 foreach ($boards as $board)
Chris@76 124 $markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $board);
Chris@76 125
Chris@76 126 // Update log_mark_read and log_boards.
Chris@76 127 $smcFunc['db_insert']('replace',
Chris@76 128 '{db_prefix}log_mark_read',
Chris@76 129 array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
Chris@76 130 $markRead,
Chris@76 131 array('id_board', 'id_member')
Chris@76 132 );
Chris@76 133
Chris@76 134 $smcFunc['db_insert']('replace',
Chris@76 135 '{db_prefix}log_boards',
Chris@76 136 array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
Chris@76 137 $markRead,
Chris@76 138 array('id_board', 'id_member')
Chris@76 139 );
Chris@76 140 }
Chris@76 141
Chris@76 142 // Get rid of useless log_topics data, because log_mark_read is better for it - even if marking unread - I think so...
Chris@76 143 $result = $smcFunc['db_query']('', '
Chris@76 144 SELECT MIN(id_topic)
Chris@76 145 FROM {db_prefix}log_topics
Chris@76 146 WHERE id_member = {int:current_member}',
Chris@76 147 array(
Chris@76 148 'current_member' => $user_info['id'],
Chris@76 149 )
Chris@76 150 );
Chris@76 151 list ($lowest_topic) = $smcFunc['db_fetch_row']($result);
Chris@76 152 $smcFunc['db_free_result']($result);
Chris@76 153
Chris@76 154 if (empty($lowest_topic))
Chris@76 155 return;
Chris@76 156
Chris@76 157 // !!!SLOW This query seems to eat it sometimes.
Chris@76 158 $result = $smcFunc['db_query']('', '
Chris@76 159 SELECT lt.id_topic
Chris@76 160 FROM {db_prefix}log_topics AS lt
Chris@76 161 INNER JOIN {db_prefix}topics AS t /*!40000 USE INDEX (PRIMARY) */ ON (t.id_topic = lt.id_topic
Chris@76 162 AND t.id_board IN ({array_int:board_list}))
Chris@76 163 WHERE lt.id_member = {int:current_member}
Chris@76 164 AND lt.id_topic >= {int:lowest_topic}',
Chris@76 165 array(
Chris@76 166 'current_member' => $user_info['id'],
Chris@76 167 'board_list' => $boards,
Chris@76 168 'lowest_topic' => $lowest_topic,
Chris@76 169 )
Chris@76 170 );
Chris@76 171 $topics = array();
Chris@76 172 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 173 $topics[] = $row['id_topic'];
Chris@76 174 $smcFunc['db_free_result']($result);
Chris@76 175
Chris@76 176 if (!empty($topics))
Chris@76 177 $smcFunc['db_query']('', '
Chris@76 178 DELETE FROM {db_prefix}log_topics
Chris@76 179 WHERE id_member = {int:current_member}
Chris@76 180 AND id_topic IN ({array_int:topic_list})',
Chris@76 181 array(
Chris@76 182 'current_member' => $user_info['id'],
Chris@76 183 'topic_list' => $topics,
Chris@76 184 )
Chris@76 185 );
Chris@76 186 }
Chris@76 187
Chris@76 188 // Mark one or more boards as read.
Chris@76 189 function MarkRead()
Chris@76 190 {
Chris@76 191 global $board, $topic, $user_info, $board_info, $modSettings, $smcFunc;
Chris@76 192
Chris@76 193 // No Guests allowed!
Chris@76 194 is_not_guest();
Chris@76 195
Chris@76 196 checkSession('get');
Chris@76 197
Chris@76 198 if (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'all')
Chris@76 199 {
Chris@76 200 // Find all the boards this user can see.
Chris@76 201 $result = $smcFunc['db_query']('', '
Chris@76 202 SELECT b.id_board
Chris@76 203 FROM {db_prefix}boards AS b
Chris@76 204 WHERE {query_see_board}',
Chris@76 205 array(
Chris@76 206 )
Chris@76 207 );
Chris@76 208 $boards = array();
Chris@76 209 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 210 $boards[] = $row['id_board'];
Chris@76 211 $smcFunc['db_free_result']($result);
Chris@76 212
Chris@76 213 if (!empty($boards))
Chris@76 214 markBoardsRead($boards, isset($_REQUEST['unread']));
Chris@76 215
Chris@76 216 $_SESSION['id_msg_last_visit'] = $modSettings['maxMsgID'];
Chris@76 217 if (!empty($_SESSION['old_url']) && strpos($_SESSION['old_url'], 'action=unread') !== false)
Chris@76 218 redirectexit('action=unread');
Chris@76 219
Chris@76 220 if (isset($_SESSION['topicseen_cache']))
Chris@76 221 $_SESSION['topicseen_cache'] = array();
Chris@76 222
Chris@76 223 redirectexit();
Chris@76 224 }
Chris@76 225 elseif (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'unreadreplies')
Chris@76 226 {
Chris@76 227 // Make sure all the boards are integers!
Chris@76 228 $topics = explode('-', $_REQUEST['topics']);
Chris@76 229
Chris@76 230 $markRead = array();
Chris@76 231 foreach ($topics as $id_topic)
Chris@76 232 $markRead[] = array($modSettings['maxMsgID'], $user_info['id'], (int) $id_topic);
Chris@76 233
Chris@76 234 $smcFunc['db_insert']('replace',
Chris@76 235 '{db_prefix}log_topics',
Chris@76 236 array('id_msg' => 'int', 'id_member' => 'int', 'id_topic' => 'int'),
Chris@76 237 $markRead,
Chris@76 238 array('id_member', 'id_topic')
Chris@76 239 );
Chris@76 240
Chris@76 241 if (isset($_SESSION['topicseen_cache']))
Chris@76 242 $_SESSION['topicseen_cache'] = array();
Chris@76 243
Chris@76 244 redirectexit('action=unreadreplies');
Chris@76 245 }
Chris@76 246
Chris@76 247 // Special case: mark a topic unread!
Chris@76 248 elseif (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'topic')
Chris@76 249 {
Chris@76 250 // First, let's figure out what the latest message is.
Chris@76 251 $result = $smcFunc['db_query']('', '
Chris@76 252 SELECT id_first_msg, id_last_msg
Chris@76 253 FROM {db_prefix}topics
Chris@76 254 WHERE id_topic = {int:current_topic}',
Chris@76 255 array(
Chris@76 256 'current_topic' => $topic,
Chris@76 257 )
Chris@76 258 );
Chris@76 259 $topicinfo = $smcFunc['db_fetch_assoc']($result);
Chris@76 260 $smcFunc['db_free_result']($result);
Chris@76 261
Chris@76 262 if (!empty($_GET['t']))
Chris@76 263 {
Chris@76 264 // If they read the whole topic, go back to the beginning.
Chris@76 265 if ($_GET['t'] >= $topicinfo['id_last_msg'])
Chris@76 266 $earlyMsg = 0;
Chris@76 267 // If they want to mark the whole thing read, same.
Chris@76 268 elseif ($_GET['t'] <= $topicinfo['id_first_msg'])
Chris@76 269 $earlyMsg = 0;
Chris@76 270 // Otherwise, get the latest message before the named one.
Chris@76 271 else
Chris@76 272 {
Chris@76 273 $result = $smcFunc['db_query']('', '
Chris@76 274 SELECT MAX(id_msg)
Chris@76 275 FROM {db_prefix}messages
Chris@76 276 WHERE id_topic = {int:current_topic}
Chris@76 277 AND id_msg >= {int:id_first_msg}
Chris@76 278 AND id_msg < {int:topic_msg_id}',
Chris@76 279 array(
Chris@76 280 'current_topic' => $topic,
Chris@76 281 'topic_msg_id' => (int) $_GET['t'],
Chris@76 282 'id_first_msg' => $topicinfo['id_first_msg'],
Chris@76 283 )
Chris@76 284 );
Chris@76 285 list ($earlyMsg) = $smcFunc['db_fetch_row']($result);
Chris@76 286 $smcFunc['db_free_result']($result);
Chris@76 287 }
Chris@76 288 }
Chris@76 289 // Marking read from first page? That's the whole topic.
Chris@76 290 elseif ($_REQUEST['start'] == 0)
Chris@76 291 $earlyMsg = 0;
Chris@76 292 else
Chris@76 293 {
Chris@76 294 $result = $smcFunc['db_query']('', '
Chris@76 295 SELECT id_msg
Chris@76 296 FROM {db_prefix}messages
Chris@76 297 WHERE id_topic = {int:current_topic}
Chris@76 298 ORDER BY id_msg
Chris@76 299 LIMIT ' . (int) $_REQUEST['start'] . ', 1',
Chris@76 300 array(
Chris@76 301 'current_topic' => $topic,
Chris@76 302 )
Chris@76 303 );
Chris@76 304 list ($earlyMsg) = $smcFunc['db_fetch_row']($result);
Chris@76 305 $smcFunc['db_free_result']($result);
Chris@76 306
Chris@76 307 $earlyMsg--;
Chris@76 308 }
Chris@76 309
Chris@76 310 // Blam, unread!
Chris@76 311 $smcFunc['db_insert']('replace',
Chris@76 312 '{db_prefix}log_topics',
Chris@76 313 array('id_msg' => 'int', 'id_member' => 'int', 'id_topic' => 'int'),
Chris@76 314 array($earlyMsg, $user_info['id'], $topic),
Chris@76 315 array('id_member', 'id_topic')
Chris@76 316 );
Chris@76 317
Chris@76 318 redirectexit('board=' . $board . '.0');
Chris@76 319 }
Chris@76 320 else
Chris@76 321 {
Chris@76 322 $categories = array();
Chris@76 323 $boards = array();
Chris@76 324
Chris@76 325 if (isset($_REQUEST['c']))
Chris@76 326 {
Chris@76 327 $_REQUEST['c'] = explode(',', $_REQUEST['c']);
Chris@76 328 foreach ($_REQUEST['c'] as $c)
Chris@76 329 $categories[] = (int) $c;
Chris@76 330 }
Chris@76 331 if (isset($_REQUEST['boards']))
Chris@76 332 {
Chris@76 333 $_REQUEST['boards'] = explode(',', $_REQUEST['boards']);
Chris@76 334 foreach ($_REQUEST['boards'] as $b)
Chris@76 335 $boards[] = (int) $b;
Chris@76 336 }
Chris@76 337 if (!empty($board))
Chris@76 338 $boards[] = (int) $board;
Chris@76 339
Chris@76 340 if (isset($_REQUEST['children']) && !empty($boards))
Chris@76 341 {
Chris@76 342 // They want to mark the entire tree starting with the boards specified
Chris@76 343 // The easist thing is to just get all the boards they can see, but since we've specified the top of tree we ignore some of them
Chris@76 344
Chris@76 345 $request = $smcFunc['db_query']('', '
Chris@76 346 SELECT b.id_board, b.id_parent
Chris@76 347 FROM {db_prefix}boards AS b
Chris@76 348 WHERE {query_see_board}
Chris@76 349 AND b.child_level > {int:no_parents}
Chris@76 350 AND b.id_board NOT IN ({array_int:board_list})
Chris@76 351 ORDER BY child_level ASC
Chris@76 352 ',
Chris@76 353 array(
Chris@76 354 'no_parents' => 0,
Chris@76 355 'board_list' => $boards,
Chris@76 356 )
Chris@76 357 );
Chris@76 358 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 359 if (in_array($row['id_parent'], $boards))
Chris@76 360 $boards[] = $row['id_board'];
Chris@76 361 $smcFunc['db_free_result']($request);
Chris@76 362 }
Chris@76 363
Chris@76 364 $clauses = array();
Chris@76 365 $clauseParameters = array();
Chris@76 366 if (!empty($categories))
Chris@76 367 {
Chris@76 368 $clauses[] = 'id_cat IN ({array_int:category_list})';
Chris@76 369 $clauseParameters['category_list'] = $categories;
Chris@76 370 }
Chris@76 371 if (!empty($boards))
Chris@76 372 {
Chris@76 373 $clauses[] = 'id_board IN ({array_int:board_list})';
Chris@76 374 $clauseParameters['board_list'] = $boards;
Chris@76 375 }
Chris@76 376
Chris@76 377 if (empty($clauses))
Chris@76 378 redirectexit();
Chris@76 379
Chris@76 380 $request = $smcFunc['db_query']('', '
Chris@76 381 SELECT b.id_board
Chris@76 382 FROM {db_prefix}boards AS b
Chris@76 383 WHERE {query_see_board}
Chris@76 384 AND b.' . implode(' OR b.', $clauses),
Chris@76 385 array_merge($clauseParameters, array(
Chris@76 386 ))
Chris@76 387 );
Chris@76 388 $boards = array();
Chris@76 389 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 390 $boards[] = $row['id_board'];
Chris@76 391 $smcFunc['db_free_result']($request);
Chris@76 392
Chris@76 393 if (empty($boards))
Chris@76 394 redirectexit();
Chris@76 395
Chris@76 396 markBoardsRead($boards, isset($_REQUEST['unread']));
Chris@76 397
Chris@76 398 foreach ($boards as $b)
Chris@76 399 {
Chris@76 400 if (isset($_SESSION['topicseen_cache'][$b]))
Chris@76 401 $_SESSION['topicseen_cache'][$b] = array();
Chris@76 402 }
Chris@76 403
Chris@76 404 if (!isset($_REQUEST['unread']))
Chris@76 405 {
Chris@76 406 // Find all the boards this user can see.
Chris@76 407 $result = $smcFunc['db_query']('', '
Chris@76 408 SELECT b.id_board
Chris@76 409 FROM {db_prefix}boards AS b
Chris@76 410 WHERE b.id_parent IN ({array_int:parent_list})
Chris@76 411 AND {query_see_board}',
Chris@76 412 array(
Chris@76 413 'parent_list' => $boards,
Chris@76 414 )
Chris@76 415 );
Chris@76 416 if ($smcFunc['db_num_rows']($result) > 0)
Chris@76 417 {
Chris@76 418 $logBoardInserts = '';
Chris@76 419 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 420 $logBoardInserts[] = array($modSettings['maxMsgID'], $user_info['id'], $row['id_board']);
Chris@76 421
Chris@76 422 $smcFunc['db_insert']('replace',
Chris@76 423 '{db_prefix}log_boards',
Chris@76 424 array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
Chris@76 425 $logBoardInserts,
Chris@76 426 array('id_member', 'id_board')
Chris@76 427 );
Chris@76 428 }
Chris@76 429 $smcFunc['db_free_result']($result);
Chris@76 430
Chris@76 431 if (empty($board))
Chris@76 432 redirectexit();
Chris@76 433 else
Chris@76 434 redirectexit('board=' . $board . '.0');
Chris@76 435 }
Chris@76 436 else
Chris@76 437 {
Chris@76 438 if (empty($board_info['parent']))
Chris@76 439 redirectexit();
Chris@76 440 else
Chris@76 441 redirectexit('board=' . $board_info['parent'] . '.0');
Chris@76 442 }
Chris@76 443 }
Chris@76 444 }
Chris@76 445
Chris@76 446 // Get the id_member associated with the specified message.
Chris@76 447 function getMsgMemberID($messageID)
Chris@76 448 {
Chris@76 449 global $smcFunc;
Chris@76 450
Chris@76 451 // Find the topic and make sure the member still exists.
Chris@76 452 $result = $smcFunc['db_query']('', '
Chris@76 453 SELECT IFNULL(mem.id_member, 0)
Chris@76 454 FROM {db_prefix}messages AS m
Chris@76 455 LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
Chris@76 456 WHERE m.id_msg = {int:selected_message}
Chris@76 457 LIMIT 1',
Chris@76 458 array(
Chris@76 459 'selected_message' => (int) $messageID,
Chris@76 460 )
Chris@76 461 );
Chris@76 462 if ($smcFunc['db_num_rows']($result) > 0)
Chris@76 463 list ($memberID) = $smcFunc['db_fetch_row']($result);
Chris@76 464 // The message doesn't even exist.
Chris@76 465 else
Chris@76 466 $memberID = 0;
Chris@76 467 $smcFunc['db_free_result']($result);
Chris@76 468
Chris@76 469 return (int) $memberID;
Chris@76 470 }
Chris@76 471
Chris@76 472 // Modify the settings and position of a board.
Chris@76 473 function modifyBoard($board_id, &$boardOptions)
Chris@76 474 {
Chris@76 475 global $sourcedir, $cat_tree, $boards, $boardList, $modSettings, $smcFunc;
Chris@76 476
Chris@76 477 // Get some basic information about all boards and categories.
Chris@76 478 getBoardTree();
Chris@76 479
Chris@76 480 // Make sure given boards and categories exist.
Chris@76 481 if (!isset($boards[$board_id]) || (isset($boardOptions['target_board']) && !isset($boards[$boardOptions['target_board']])) || (isset($boardOptions['target_category']) && !isset($cat_tree[$boardOptions['target_category']])))
Chris@76 482 fatal_lang_error('no_board');
Chris@76 483
Chris@76 484 // All things that will be updated in the database will be in $boardUpdates.
Chris@76 485 $boardUpdates = array();
Chris@76 486 $boardUpdateParameters = array();
Chris@76 487
Chris@76 488 // In case the board has to be moved
Chris@76 489 if (isset($boardOptions['move_to']))
Chris@76 490 {
Chris@76 491 // Move the board to the top of a given category.
Chris@76 492 if ($boardOptions['move_to'] == 'top')
Chris@76 493 {
Chris@76 494 $id_cat = $boardOptions['target_category'];
Chris@76 495 $child_level = 0;
Chris@76 496 $id_parent = 0;
Chris@76 497 $after = $cat_tree[$id_cat]['last_board_order'];
Chris@76 498 }
Chris@76 499
Chris@76 500 // Move the board to the bottom of a given category.
Chris@76 501 elseif ($boardOptions['move_to'] == 'bottom')
Chris@76 502 {
Chris@76 503 $id_cat = $boardOptions['target_category'];
Chris@76 504 $child_level = 0;
Chris@76 505 $id_parent = 0;
Chris@76 506 $after = 0;
Chris@76 507 foreach ($cat_tree[$id_cat]['children'] as $id_board => $dummy)
Chris@76 508 $after = max($after, $boards[$id_board]['order']);
Chris@76 509 }
Chris@76 510
Chris@76 511 // Make the board a child of a given board.
Chris@76 512 elseif ($boardOptions['move_to'] == 'child')
Chris@76 513 {
Chris@76 514 $id_cat = $boards[$boardOptions['target_board']]['category'];
Chris@76 515 $child_level = $boards[$boardOptions['target_board']]['level'] + 1;
Chris@76 516 $id_parent = $boardOptions['target_board'];
Chris@76 517
Chris@76 518 // People can be creative, in many ways...
Chris@76 519 if (isChildOf($id_parent, $board_id))
Chris@76 520 fatal_lang_error('mboards_parent_own_child_error', false);
Chris@76 521 elseif ($id_parent == $board_id)
Chris@76 522 fatal_lang_error('mboards_board_own_child_error', false);
Chris@76 523
Chris@76 524 $after = $boards[$boardOptions['target_board']]['order'];
Chris@76 525
Chris@76 526 // Check if there are already children and (if so) get the max board order.
Chris@76 527 if (!empty($boards[$id_parent]['tree']['children']) && empty($boardOptions['move_first_child']))
Chris@76 528 foreach ($boards[$id_parent]['tree']['children'] as $childBoard_id => $dummy)
Chris@76 529 $after = max($after, $boards[$childBoard_id]['order']);
Chris@76 530 }
Chris@76 531
Chris@76 532 // Place a board before or after another board, on the same child level.
Chris@76 533 elseif (in_array($boardOptions['move_to'], array('before', 'after')))
Chris@76 534 {
Chris@76 535 $id_cat = $boards[$boardOptions['target_board']]['category'];
Chris@76 536 $child_level = $boards[$boardOptions['target_board']]['level'];
Chris@76 537 $id_parent = $boards[$boardOptions['target_board']]['parent'];
Chris@76 538 $after = $boards[$boardOptions['target_board']]['order'] - ($boardOptions['move_to'] == 'before' ? 1 : 0);
Chris@76 539 }
Chris@76 540
Chris@76 541 // Oops...?
Chris@76 542 else
Chris@76 543 trigger_error('modifyBoard(): The move_to value \'' . $boardOptions['move_to'] . '\' is incorrect', E_USER_ERROR);
Chris@76 544
Chris@76 545 // Get a list of children of this board.
Chris@76 546 $childList = array();
Chris@76 547 recursiveBoards($childList, $boards[$board_id]['tree']);
Chris@76 548
Chris@76 549 // See if there are changes that affect children.
Chris@76 550 $childUpdates = array();
Chris@76 551 $levelDiff = $child_level - $boards[$board_id]['level'];
Chris@76 552 if ($levelDiff != 0)
Chris@76 553 $childUpdates[] = 'child_level = child_level ' . ($levelDiff > 0 ? '+ ' : '') . '{int:level_diff}';
Chris@76 554 if ($id_cat != $boards[$board_id]['category'])
Chris@76 555 $childUpdates[] = 'id_cat = {int:category}';
Chris@76 556
Chris@76 557 // Fix the children of this board.
Chris@76 558 if (!empty($childList) && !empty($childUpdates))
Chris@76 559 $smcFunc['db_query']('', '
Chris@76 560 UPDATE {db_prefix}boards
Chris@76 561 SET ' . implode(',
Chris@76 562 ', $childUpdates) . '
Chris@76 563 WHERE id_board IN ({array_int:board_list})',
Chris@76 564 array(
Chris@76 565 'board_list' => $childList,
Chris@76 566 'category' => $id_cat,
Chris@76 567 'level_diff' => $levelDiff,
Chris@76 568 )
Chris@76 569 );
Chris@76 570
Chris@76 571 // Make some room for this spot.
Chris@76 572 $smcFunc['db_query']('', '
Chris@76 573 UPDATE {db_prefix}boards
Chris@76 574 SET board_order = board_order + {int:new_order}
Chris@76 575 WHERE board_order > {int:insert_after}
Chris@76 576 AND id_board != {int:selected_board}',
Chris@76 577 array(
Chris@76 578 'insert_after' => $after,
Chris@76 579 'selected_board' => $board_id,
Chris@76 580 'new_order' => 1 + count($childList),
Chris@76 581 )
Chris@76 582 );
Chris@76 583
Chris@76 584 $boardUpdates[] = 'id_cat = {int:id_cat}';
Chris@76 585 $boardUpdates[] = 'id_parent = {int:id_parent}';
Chris@76 586 $boardUpdates[] = 'child_level = {int:child_level}';
Chris@76 587 $boardUpdates[] = 'board_order = {int:board_order}';
Chris@76 588 $boardUpdateParameters += array(
Chris@76 589 'id_cat' => $id_cat,
Chris@76 590 'id_parent' => $id_parent,
Chris@76 591 'child_level' => $child_level,
Chris@76 592 'board_order' => $after + 1,
Chris@76 593 );
Chris@76 594 }
Chris@76 595
Chris@76 596 // This setting is a little twisted in the database...
Chris@76 597 if (isset($boardOptions['posts_count']))
Chris@76 598 {
Chris@76 599 $boardUpdates[] = 'count_posts = {int:count_posts}';
Chris@76 600 $boardUpdateParameters['count_posts'] = $boardOptions['posts_count'] ? 0 : 1;
Chris@76 601 }
Chris@76 602
Chris@76 603 // Set the theme for this board.
Chris@76 604 if (isset($boardOptions['board_theme']))
Chris@76 605 {
Chris@76 606 $boardUpdates[] = 'id_theme = {int:id_theme}';
Chris@76 607 $boardUpdateParameters['id_theme'] = (int) $boardOptions['board_theme'];
Chris@76 608 }
Chris@76 609
Chris@76 610 // Should the board theme override the user preferred theme?
Chris@76 611 if (isset($boardOptions['override_theme']))
Chris@76 612 {
Chris@76 613 $boardUpdates[] = 'override_theme = {int:override_theme}';
Chris@76 614 $boardUpdateParameters['override_theme'] = $boardOptions['override_theme'] ? 1 : 0;
Chris@76 615 }
Chris@76 616
Chris@76 617 // Who's allowed to access this board.
Chris@76 618 if (isset($boardOptions['access_groups']))
Chris@76 619 {
Chris@76 620 $boardUpdates[] = 'member_groups = {string:member_groups}';
Chris@76 621 $boardUpdateParameters['member_groups'] = implode(',', $boardOptions['access_groups']);
Chris@76 622 }
Chris@76 623
Chris@76 624 if (isset($boardOptions['board_name']))
Chris@76 625 {
Chris@76 626 $boardUpdates[] = 'name = {string:board_name}';
Chris@76 627 $boardUpdateParameters['board_name'] = $boardOptions['board_name'];
Chris@76 628 }
Chris@76 629
Chris@76 630 if (isset($boardOptions['board_description']))
Chris@76 631 {
Chris@76 632 $boardUpdates[] = 'description = {string:board_description}';
Chris@76 633 $boardUpdateParameters['board_description'] = $boardOptions['board_description'];
Chris@76 634 }
Chris@76 635
Chris@76 636 if (isset($boardOptions['profile']))
Chris@76 637 {
Chris@76 638 $boardUpdates[] = 'id_profile = {int:profile}';
Chris@76 639 $boardUpdateParameters['profile'] = (int) $boardOptions['profile'];
Chris@76 640 }
Chris@76 641
Chris@76 642 if (isset($boardOptions['redirect']))
Chris@76 643 {
Chris@76 644 $boardUpdates[] = 'redirect = {string:redirect}';
Chris@76 645 $boardUpdateParameters['redirect'] = $boardOptions['redirect'];
Chris@76 646 }
Chris@76 647
Chris@76 648 if (isset($boardOptions['num_posts']))
Chris@76 649 {
Chris@76 650 $boardUpdates[] = 'num_posts = {int:num_posts}';
Chris@76 651 $boardUpdateParameters['num_posts'] = (int) $boardOptions['num_posts'];
Chris@76 652 }
Chris@76 653
Chris@76 654 // Do the updates (if any).
Chris@76 655 if (!empty($boardUpdates))
Chris@76 656 $request = $smcFunc['db_query']('', '
Chris@76 657 UPDATE {db_prefix}boards
Chris@76 658 SET
Chris@76 659 ' . implode(',
Chris@76 660 ', $boardUpdates) . '
Chris@76 661 WHERE id_board = {int:selected_board}',
Chris@76 662 array_merge($boardUpdateParameters, array(
Chris@76 663 'selected_board' => $board_id,
Chris@76 664 ))
Chris@76 665 );
Chris@76 666
Chris@76 667 // Set moderators of this board.
Chris@76 668 if (isset($boardOptions['moderators']) || isset($boardOptions['moderator_string']))
Chris@76 669 {
Chris@76 670 // Reset current moderators for this board - if there are any!
Chris@76 671 $smcFunc['db_query']('', '
Chris@76 672 DELETE FROM {db_prefix}moderators
Chris@76 673 WHERE id_board = {int:board_list}',
Chris@76 674 array(
Chris@76 675 'board_list' => $board_id,
Chris@76 676 )
Chris@76 677 );
Chris@76 678
Chris@76 679 // Validate and get the IDs of the new moderators.
Chris@76 680 if (isset($boardOptions['moderator_string']) && trim($boardOptions['moderator_string']) != '')
Chris@76 681 {
Chris@76 682 // Divvy out the usernames, remove extra space.
Chris@76 683 $moderator_string = strtr($smcFunc['htmlspecialchars']($boardOptions['moderator_string'], ENT_QUOTES), array('&quot;' => '"'));
Chris@76 684 preg_match_all('~"([^"]+)"~', $moderator_string, $matches);
Chris@76 685 $moderators = array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $moderator_string)));
Chris@76 686 for ($k = 0, $n = count($moderators); $k < $n; $k++)
Chris@76 687 {
Chris@76 688 $moderators[$k] = trim($moderators[$k]);
Chris@76 689
Chris@76 690 if (strlen($moderators[$k]) == 0)
Chris@76 691 unset($moderators[$k]);
Chris@76 692 }
Chris@76 693
Chris@76 694 // Find all the id_member's for the member_name's in the list.
Chris@76 695 if (empty($boardOptions['moderators']))
Chris@76 696 $boardOptions['moderators'] = array();
Chris@76 697 if (!empty($moderators))
Chris@76 698 {
Chris@76 699 $request = $smcFunc['db_query']('', '
Chris@76 700 SELECT id_member
Chris@76 701 FROM {db_prefix}members
Chris@76 702 WHERE member_name IN ({array_string:moderator_list}) OR real_name IN ({array_string:moderator_list})
Chris@76 703 LIMIT ' . count($moderators),
Chris@76 704 array(
Chris@76 705 'moderator_list' => $moderators,
Chris@76 706 )
Chris@76 707 );
Chris@76 708 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 709 $boardOptions['moderators'][] = $row['id_member'];
Chris@76 710 $smcFunc['db_free_result']($request);
Chris@76 711 }
Chris@76 712 }
Chris@76 713
Chris@76 714 // Add the moderators to the board.
Chris@76 715 if (!empty($boardOptions['moderators']))
Chris@76 716 {
Chris@76 717 $inserts = array();
Chris@76 718 foreach ($boardOptions['moderators'] as $moderator)
Chris@76 719 $inserts[] = array($board_id, $moderator);
Chris@76 720
Chris@76 721 $smcFunc['db_insert']('insert',
Chris@76 722 '{db_prefix}moderators',
Chris@76 723 array('id_board' => 'int', 'id_member' => 'int'),
Chris@76 724 $inserts,
Chris@76 725 array('id_board', 'id_member')
Chris@76 726 );
Chris@76 727 }
Chris@76 728
Chris@76 729 // Note that caches can now be wrong!
Chris@76 730 updateSettings(array('settings_updated' => time()));
Chris@76 731 }
Chris@76 732
Chris@76 733 if (isset($boardOptions['move_to']))
Chris@76 734 reorderBoards();
Chris@76 735
Chris@76 736 clean_cache('data');
Chris@76 737
Chris@76 738 if (empty($boardOptions['dont_log']))
Chris@76 739 logAction('edit_board', array('board' => $board_id), 'admin');
Chris@76 740 }
Chris@76 741
Chris@76 742 // Create a new board and set its properties and position.
Chris@76 743 function createBoard($boardOptions)
Chris@76 744 {
Chris@76 745 global $boards, $modSettings, $smcFunc;
Chris@76 746
Chris@76 747 // Trigger an error if one of the required values is not set.
Chris@76 748 if (!isset($boardOptions['board_name']) || trim($boardOptions['board_name']) == '' || !isset($boardOptions['move_to']) || !isset($boardOptions['target_category']))
Chris@76 749 trigger_error('createBoard(): One or more of the required options is not set', E_USER_ERROR);
Chris@76 750
Chris@76 751 if (in_array($boardOptions['move_to'], array('child', 'before', 'after')) && !isset($boardOptions['target_board']))
Chris@76 752 trigger_error('createBoard(): Target board is not set', E_USER_ERROR);
Chris@76 753
Chris@76 754 // Set every optional value to its default value.
Chris@76 755 $boardOptions += array(
Chris@76 756 'posts_count' => true,
Chris@76 757 'override_theme' => false,
Chris@76 758 'board_theme' => 0,
Chris@76 759 'access_groups' => array(),
Chris@76 760 'board_description' => '',
Chris@76 761 'profile' => 1,
Chris@76 762 'moderators' => '',
Chris@76 763 'inherit_permissions' => true,
Chris@76 764 'dont_log' => true,
Chris@76 765 );
Chris@76 766
Chris@76 767 // Insert a board, the settings are dealt with later.
Chris@76 768 $smcFunc['db_insert']('',
Chris@76 769 '{db_prefix}boards',
Chris@76 770 array(
Chris@76 771 'id_cat' => 'int', 'name' => 'string-255', 'description' => 'string', 'board_order' => 'int',
Chris@76 772 'member_groups' => 'string', 'redirect' => 'string',
Chris@76 773 ),
Chris@76 774 array(
Chris@76 775 $boardOptions['target_category'], $boardOptions['board_name'] , '', 0,
Chris@76 776 '-1,0', '',
Chris@76 777 ),
Chris@76 778 array('id_board')
Chris@76 779 );
Chris@76 780 $board_id = $smcFunc['db_insert_id']('{db_prefix}boards', 'id_board');
Chris@76 781
Chris@76 782 if (empty($board_id))
Chris@76 783 return 0;
Chris@76 784
Chris@76 785 // Change the board according to the given specifications.
Chris@76 786 modifyBoard($board_id, $boardOptions);
Chris@76 787
Chris@76 788 // Do we want the parent permissions to be inherited?
Chris@76 789 if ($boardOptions['inherit_permissions'])
Chris@76 790 {
Chris@76 791 getBoardTree();
Chris@76 792
Chris@76 793 if (!empty($boards[$board_id]['parent']))
Chris@76 794 {
Chris@76 795 $request = $smcFunc['db_query']('', '
Chris@76 796 SELECT id_profile
Chris@76 797 FROM {db_prefix}boards
Chris@76 798 WHERE id_board = {int:board_parent}
Chris@76 799 LIMIT 1',
Chris@76 800 array(
Chris@76 801 'board_parent' => (int) $boards[$board_id]['parent'],
Chris@76 802 )
Chris@76 803 );
Chris@76 804 list ($boardOptions['profile']) = $smcFunc['db_fetch_row']($request);
Chris@76 805 $smcFunc['db_free_result']($request);
Chris@76 806
Chris@76 807 $smcFunc['db_query']('', '
Chris@76 808 UPDATE {db_prefix}boards
Chris@76 809 SET id_profile = {int:new_profile}
Chris@76 810 WHERE id_board = {int:current_board}',
Chris@76 811 array(
Chris@76 812 'new_profile' => $boardOptions['profile'],
Chris@76 813 'current_board' => $board_id,
Chris@76 814 )
Chris@76 815 );
Chris@76 816 }
Chris@76 817 }
Chris@76 818
Chris@76 819 // Clean the data cache.
Chris@76 820 clean_cache('data');
Chris@76 821
Chris@76 822 // Created it.
Chris@76 823 logAction('add_board', array('board' => $board_id), 'admin');
Chris@76 824
Chris@76 825 // Here you are, a new board, ready to be spammed.
Chris@76 826 return $board_id;
Chris@76 827 }
Chris@76 828
Chris@76 829 // Remove one or more boards.
Chris@76 830 function deleteBoards($boards_to_remove, $moveChildrenTo = null)
Chris@76 831 {
Chris@76 832 global $sourcedir, $boards, $smcFunc;
Chris@76 833
Chris@76 834 // No boards to delete? Return!
Chris@76 835 if (empty($boards_to_remove))
Chris@76 836 return;
Chris@76 837
Chris@76 838 getBoardTree();
Chris@76 839
Chris@76 840 // If $moveChildrenTo is set to null, include the children in the removal.
Chris@76 841 if ($moveChildrenTo === null)
Chris@76 842 {
Chris@76 843 // Get a list of the child boards that will also be removed.
Chris@76 844 $child_boards_to_remove = array();
Chris@76 845 foreach ($boards_to_remove as $board_to_remove)
Chris@76 846 recursiveBoards($child_boards_to_remove, $boards[$board_to_remove]['tree']);
Chris@76 847
Chris@76 848 // Merge the children with their parents.
Chris@76 849 if (!empty($child_boards_to_remove))
Chris@76 850 $boards_to_remove = array_unique(array_merge($boards_to_remove, $child_boards_to_remove));
Chris@76 851 }
Chris@76 852 // Move the children to a safe home.
Chris@76 853 else
Chris@76 854 {
Chris@76 855 foreach ($boards_to_remove as $id_board)
Chris@76 856 {
Chris@76 857 // !!! Separate category?
Chris@76 858 if ($moveChildrenTo === 0)
Chris@76 859 fixChildren($id_board, 0, 0);
Chris@76 860 else
Chris@76 861 fixChildren($id_board, $boards[$moveChildrenTo]['level'] + 1, $moveChildrenTo);
Chris@76 862 }
Chris@76 863 }
Chris@76 864
Chris@76 865 // Delete ALL topics in the selected boards (done first so topics can't be marooned.)
Chris@76 866 $request = $smcFunc['db_query']('', '
Chris@76 867 SELECT id_topic
Chris@76 868 FROM {db_prefix}topics
Chris@76 869 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 870 array(
Chris@76 871 'boards_to_remove' => $boards_to_remove,
Chris@76 872 )
Chris@76 873 );
Chris@76 874 $topics = array();
Chris@76 875 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 876 $topics[] = $row['id_topic'];
Chris@76 877 $smcFunc['db_free_result']($request);
Chris@76 878
Chris@76 879 require_once($sourcedir . '/RemoveTopic.php');
Chris@76 880 removeTopics($topics, false);
Chris@76 881
Chris@76 882 // Delete the board's logs.
Chris@76 883 $smcFunc['db_query']('', '
Chris@76 884 DELETE FROM {db_prefix}log_mark_read
Chris@76 885 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 886 array(
Chris@76 887 'boards_to_remove' => $boards_to_remove,
Chris@76 888 )
Chris@76 889 );
Chris@76 890 $smcFunc['db_query']('', '
Chris@76 891 DELETE FROM {db_prefix}log_boards
Chris@76 892 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 893 array(
Chris@76 894 'boards_to_remove' => $boards_to_remove,
Chris@76 895 )
Chris@76 896 );
Chris@76 897 $smcFunc['db_query']('', '
Chris@76 898 DELETE FROM {db_prefix}log_notify
Chris@76 899 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 900 array(
Chris@76 901 'boards_to_remove' => $boards_to_remove,
Chris@76 902 )
Chris@76 903 );
Chris@76 904
Chris@76 905 // Delete this board's moderators.
Chris@76 906 $smcFunc['db_query']('', '
Chris@76 907 DELETE FROM {db_prefix}moderators
Chris@76 908 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 909 array(
Chris@76 910 'boards_to_remove' => $boards_to_remove,
Chris@76 911 )
Chris@76 912 );
Chris@76 913
Chris@76 914 // Delete any extra events in the calendar.
Chris@76 915 $smcFunc['db_query']('', '
Chris@76 916 DELETE FROM {db_prefix}calendar
Chris@76 917 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 918 array(
Chris@76 919 'boards_to_remove' => $boards_to_remove,
Chris@76 920 )
Chris@76 921 );
Chris@76 922
Chris@76 923 // Delete any message icons that only appear on these boards.
Chris@76 924 $smcFunc['db_query']('', '
Chris@76 925 DELETE FROM {db_prefix}message_icons
Chris@76 926 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 927 array(
Chris@76 928 'boards_to_remove' => $boards_to_remove,
Chris@76 929 )
Chris@76 930 );
Chris@76 931
Chris@76 932 // Delete the boards.
Chris@76 933 $smcFunc['db_query']('', '
Chris@76 934 DELETE FROM {db_prefix}boards
Chris@76 935 WHERE id_board IN ({array_int:boards_to_remove})',
Chris@76 936 array(
Chris@76 937 'boards_to_remove' => $boards_to_remove,
Chris@76 938 )
Chris@76 939 );
Chris@76 940
Chris@76 941 // Latest message/topic might not be there anymore.
Chris@76 942 updateStats('message');
Chris@76 943 updateStats('topic');
Chris@76 944 updateSettings(array(
Chris@76 945 'calendar_updated' => time(),
Chris@76 946 ));
Chris@76 947
Chris@76 948 // Plus reset the cache to stop people getting odd results.
Chris@76 949 updateSettings(array('settings_updated' => time()));
Chris@76 950
Chris@76 951 // Clean the cache as well.
Chris@76 952 clean_cache('data');
Chris@76 953
Chris@76 954 // Let's do some serious logging.
Chris@76 955 foreach ($boards_to_remove as $id_board)
Chris@76 956 logAction('delete_board', array('boardname' => $boards[$id_board]['name']), 'admin');
Chris@76 957
Chris@76 958 reorderBoards();
Chris@76 959 }
Chris@76 960
Chris@76 961 // Put all boards in the right order.
Chris@76 962 function reorderBoards()
Chris@76 963 {
Chris@76 964 global $cat_tree, $boardList, $boards, $smcFunc;
Chris@76 965
Chris@76 966 getBoardTree();
Chris@76 967
Chris@76 968 // Set the board order for each category.
Chris@76 969 $board_order = 0;
Chris@76 970 foreach ($cat_tree as $catID => $dummy)
Chris@76 971 {
Chris@76 972 foreach ($boardList[$catID] as $boardID)
Chris@76 973 if ($boards[$boardID]['order'] != ++$board_order)
Chris@76 974 $smcFunc['db_query']('', '
Chris@76 975 UPDATE {db_prefix}boards
Chris@76 976 SET board_order = {int:new_order}
Chris@76 977 WHERE id_board = {int:selected_board}',
Chris@76 978 array(
Chris@76 979 'new_order' => $board_order,
Chris@76 980 'selected_board' => $boardID,
Chris@76 981 )
Chris@76 982 );
Chris@76 983 }
Chris@76 984
Chris@76 985 // Sort the records of the boards table on the board_order value.
Chris@76 986 $smcFunc['db_query']('alter_table_boards', '
Chris@76 987 ALTER TABLE {db_prefix}boards
Chris@76 988 ORDER BY board_order',
Chris@76 989 array(
Chris@76 990 'db_error_skip' => true,
Chris@76 991 )
Chris@76 992 );
Chris@76 993 }
Chris@76 994
Chris@76 995 // Fixes the children of a board by setting their child_levels to new values.
Chris@76 996 function fixChildren($parent, $newLevel, $newParent)
Chris@76 997 {
Chris@76 998 global $smcFunc;
Chris@76 999
Chris@76 1000 // Grab all children of $parent...
Chris@76 1001 $result = $smcFunc['db_query']('', '
Chris@76 1002 SELECT id_board
Chris@76 1003 FROM {db_prefix}boards
Chris@76 1004 WHERE id_parent = {int:parent_board}',
Chris@76 1005 array(
Chris@76 1006 'parent_board' => $parent,
Chris@76 1007 )
Chris@76 1008 );
Chris@76 1009 $children = array();
Chris@76 1010 while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76 1011 $children[] = $row['id_board'];
Chris@76 1012 $smcFunc['db_free_result']($result);
Chris@76 1013
Chris@76 1014 // ...and set it to a new parent and child_level.
Chris@76 1015 $smcFunc['db_query']('', '
Chris@76 1016 UPDATE {db_prefix}boards
Chris@76 1017 SET id_parent = {int:new_parent}, child_level = {int:new_child_level}
Chris@76 1018 WHERE id_parent = {int:parent_board}',
Chris@76 1019 array(
Chris@76 1020 'new_parent' => $newParent,
Chris@76 1021 'new_child_level' => $newLevel,
Chris@76 1022 'parent_board' => $parent,
Chris@76 1023 )
Chris@76 1024 );
Chris@76 1025
Chris@76 1026 // Recursively fix the children of the children.
Chris@76 1027 foreach ($children as $child)
Chris@76 1028 fixChildren($child, $newLevel + 1, $child);
Chris@76 1029 }
Chris@76 1030
Chris@76 1031 // Load a lot of useful information regarding the boards and categories.
Chris@76 1032 function getBoardTree()
Chris@76 1033 {
Chris@76 1034 global $cat_tree, $boards, $boardList, $txt, $modSettings, $smcFunc;
Chris@76 1035
Chris@76 1036 // Getting all the board and category information you'd ever wanted.
Chris@76 1037 $request = $smcFunc['db_query']('', '
Chris@76 1038 SELECT
Chris@76 1039 IFNULL(b.id_board, 0) AS id_board, b.id_parent, b.name AS board_name, b.description, b.child_level,
Chris@76 1040 b.board_order, b.count_posts, b.member_groups, b.id_theme, b.override_theme, b.id_profile, b.redirect,
Chris@76 1041 b.num_posts, b.num_topics, c.id_cat, c.name AS cat_name, c.cat_order, c.can_collapse
Chris@76 1042 FROM {db_prefix}categories AS c
Chris@76 1043 LEFT JOIN {db_prefix}boards AS b ON (b.id_cat = c.id_cat)
Chris@76 1044 ORDER BY c.cat_order, b.child_level, b.board_order',
Chris@76 1045 array(
Chris@76 1046 )
Chris@76 1047 );
Chris@76 1048 $cat_tree = array();
Chris@76 1049 $boards = array();
Chris@76 1050 $last_board_order = 0;
Chris@76 1051 while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76 1052 {
Chris@76 1053 if (!isset($cat_tree[$row['id_cat']]))
Chris@76 1054 {
Chris@76 1055 $cat_tree[$row['id_cat']] = array(
Chris@76 1056 'node' => array(
Chris@76 1057 'id' => $row['id_cat'],
Chris@76 1058 'name' => $row['cat_name'],
Chris@76 1059 'order' => $row['cat_order'],
Chris@76 1060 'can_collapse' => $row['can_collapse']
Chris@76 1061 ),
Chris@76 1062 'is_first' => empty($cat_tree),
Chris@76 1063 'last_board_order' => $last_board_order,
Chris@76 1064 'children' => array()
Chris@76 1065 );
Chris@76 1066 $prevBoard = 0;
Chris@76 1067 $curLevel = 0;
Chris@76 1068 }
Chris@76 1069
Chris@76 1070 if (!empty($row['id_board']))
Chris@76 1071 {
Chris@76 1072 if ($row['child_level'] != $curLevel)
Chris@76 1073 $prevBoard = 0;
Chris@76 1074
Chris@76 1075 $boards[$row['id_board']] = array(
Chris@76 1076 'id' => $row['id_board'],
Chris@76 1077 'category' => $row['id_cat'],
Chris@76 1078 'parent' => $row['id_parent'],
Chris@76 1079 'level' => $row['child_level'],
Chris@76 1080 'order' => $row['board_order'],
Chris@76 1081 'name' => $row['board_name'],
Chris@76 1082 'member_groups' => explode(',', $row['member_groups']),
Chris@76 1083 'description' => $row['description'],
Chris@76 1084 'count_posts' => empty($row['count_posts']),
Chris@76 1085 'posts' => $row['num_posts'],
Chris@76 1086 'topics' => $row['num_topics'],
Chris@76 1087 'theme' => $row['id_theme'],
Chris@76 1088 'override_theme' => $row['override_theme'],
Chris@76 1089 'profile' => $row['id_profile'],
Chris@76 1090 'redirect' => $row['redirect'],
Chris@76 1091 'prev_board' => $prevBoard
Chris@76 1092 );
Chris@76 1093 $prevBoard = $row['id_board'];
Chris@76 1094 $last_board_order = $row['board_order'];
Chris@76 1095
Chris@76 1096 if (empty($row['child_level']))
Chris@76 1097 {
Chris@76 1098 $cat_tree[$row['id_cat']]['children'][$row['id_board']] = array(
Chris@76 1099 'node' => &$boards[$row['id_board']],
Chris@76 1100 'is_first' => empty($cat_tree[$row['id_cat']]['children']),
Chris@76 1101 'children' => array()
Chris@76 1102 );
Chris@76 1103 $boards[$row['id_board']]['tree'] = &$cat_tree[$row['id_cat']]['children'][$row['id_board']];
Chris@76 1104 }
Chris@76 1105 else
Chris@76 1106 {
Chris@76 1107 // Parent doesn't exist!
Chris@76 1108 if (!isset($boards[$row['id_parent']]['tree']))
Chris@76 1109 fatal_lang_error('no_valid_parent', false, array($row['board_name']));
Chris@76 1110
Chris@76 1111 // Wrong childlevel...we can silently fix this...
Chris@76 1112 if ($boards[$row['id_parent']]['tree']['node']['level'] != $row['child_level'] - 1)
Chris@76 1113 $smcFunc['db_query']('', '
Chris@76 1114 UPDATE {db_prefix}boards
Chris@76 1115 SET child_level = {int:new_child_level}
Chris@76 1116 WHERE id_board = {int:selected_board}',
Chris@76 1117 array(
Chris@76 1118 'new_child_level' => $boards[$row['id_parent']]['tree']['node']['level'] + 1,
Chris@76 1119 'selected_board' => $row['id_board'],
Chris@76 1120 )
Chris@76 1121 );
Chris@76 1122
Chris@76 1123 $boards[$row['id_parent']]['tree']['children'][$row['id_board']] = array(
Chris@76 1124 'node' => &$boards[$row['id_board']],
Chris@76 1125 'is_first' => empty($boards[$row['id_parent']]['tree']['children']),
Chris@76 1126 'children' => array()
Chris@76 1127 );
Chris@76 1128 $boards[$row['id_board']]['tree'] = &$boards[$row['id_parent']]['tree']['children'][$row['id_board']];
Chris@76 1129 }
Chris@76 1130 }
Chris@76 1131 }
Chris@76 1132 $smcFunc['db_free_result']($request);
Chris@76 1133
Chris@76 1134 // Get a list of all the boards in each category (using recursion).
Chris@76 1135 $boardList = array();
Chris@76 1136 foreach ($cat_tree as $catID => $node)
Chris@76 1137 {
Chris@76 1138 $boardList[$catID] = array();
Chris@76 1139 recursiveBoards($boardList[$catID], $node);
Chris@76 1140 }
Chris@76 1141 }
Chris@76 1142
Chris@76 1143 // Recursively get a list of boards.
Chris@76 1144 function recursiveBoards(&$_boardList, &$_tree)
Chris@76 1145 {
Chris@76 1146 if (empty($_tree['children']))
Chris@76 1147 return;
Chris@76 1148
Chris@76 1149 foreach ($_tree['children'] as $id => $node)
Chris@76 1150 {
Chris@76 1151 $_boardList[] = $id;
Chris@76 1152 recursiveBoards($_boardList, $node);
Chris@76 1153 }
Chris@76 1154 }
Chris@76 1155
Chris@76 1156 // Returns whether the child board id is actually a child of the parent (recursive).
Chris@76 1157 function isChildOf($child, $parent)
Chris@76 1158 {
Chris@76 1159 global $boards;
Chris@76 1160
Chris@76 1161 if (empty($boards[$child]['parent']))
Chris@76 1162 return false;
Chris@76 1163
Chris@76 1164 if ($boards[$child]['parent'] == $parent)
Chris@76 1165 return true;
Chris@76 1166
Chris@76 1167 return isChildOf($boards[$child]['parent'], $parent);
Chris@76 1168 }
Chris@76 1169
Chris@76 1170 ?>