Chris@76: <?php
Chris@76: 
Chris@76: /**
Chris@76:  * Simple Machines Forum (SMF)
Chris@76:  *
Chris@76:  * @package SMF
Chris@76:  * @author Simple Machines http://www.simplemachines.org
Chris@76:  * @copyright 2011 Simple Machines
Chris@76:  * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76:  *
Chris@76:  * @version 2.0
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: function getBoardList($boardListOptions = array())
Chris@76: {
Chris@76: 	global $smcFunc, $user_info;
Chris@76: 
Chris@76: 	if (isset($boardListOptions['excluded_boards']) && isset($boardListOptions['included_boards']))
Chris@76: 		trigger_error('getBoardList(): Setting both excluded_boards and included_boards is not allowed.', E_USER_ERROR);
Chris@76: 
Chris@76: 	$where = array();
Chris@76: 	$where_parameters = array();
Chris@76: 	if (isset($boardListOptions['excluded_boards']))
Chris@76: 	{
Chris@76: 		$where[] = 'b.id_board NOT IN ({array_int:excluded_boards})';
Chris@76: 		$where_parameters['excluded_boards'] = $boardListOptions['excluded_boards'];
Chris@76: 	}
Chris@76: 
Chris@76: 	if (isset($boardListOptions['included_boards']))
Chris@76: 	{
Chris@76: 		$where[] = 'b.id_board IN ({array_int:included_boards})';
Chris@76: 		$where_parameters['included_boards'] = $boardListOptions['included_boards'];
Chris@76: 	}
Chris@76: 
Chris@76: 	if (!empty($boardListOptions['ignore_boards']))
Chris@76: 		$where[] = '{query_wanna_see_board}';
Chris@76: 
Chris@76: 	elseif (!empty($boardListOptions['use_permissions']))
Chris@76: 		$where[] = '{query_see_board}';
Chris@76: 
Chris@76: 	if (!empty($boardListOptions['not_redirection']))
Chris@76: 	{
Chris@76: 		$where[] = 'b.redirect = {string:blank_redirect}';
Chris@76: 		$where_parameters['blank_redirect'] = '';
Chris@76: 	}
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('messageindex_fetch_boards', '
Chris@76: 		SELECT c.name AS cat_name, c.id_cat, b.id_board, b.name AS board_name, b.child_level
Chris@76: 		FROM {db_prefix}boards AS b
Chris@76: 			LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)' . (empty($where) ? '' : '
Chris@76: 		WHERE ' . implode('
Chris@76: 			AND ', $where)),
Chris@76: 		$where_parameters
Chris@76: 	);
Chris@76: 
Chris@76: 	$return_value = array();
Chris@76: 	if ($smcFunc['db_num_rows']($request) !== 0)
Chris@76: 	{
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		{
Chris@76: 			if (!isset($return_value[$row['id_cat']]))
Chris@76: 				$return_value[$row['id_cat']] = array(
Chris@76: 					'id' => $row['id_cat'],
Chris@76: 					'name' => $row['cat_name'],
Chris@76: 					'boards' => array(),
Chris@76: 				);
Chris@76: 
Chris@76: 			$return_value[$row['id_cat']]['boards'][] = array(
Chris@76: 				'id' => $row['id_board'],
Chris@76: 				'name' => $row['board_name'],
Chris@76: 				'child_level' => $row['child_level'],
Chris@76: 				'selected' => isset($boardListOptions['selected_board']) && $boardListOptions['selected_board'] == $row['id_board'],
Chris@76: 			);
Chris@76: 		}
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $return_value;
Chris@76: }
Chris@76: 
Chris@76: ?>