ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / sudairsocs / www / forum / Sources

<?php

/**
 * Simple Machines Forum (SMF)
 *
 * @package SMF
 * @author Simple Machines https://www.simplemachines.org
 * @copyright 2022 Simple Machines and individual contributors
 * @license https://www.simplemachines.org/about/smf/license.php BSD
 *
 * @version 2.1.2
 */

if (!defined('SMF'))
	die('No direct access...');

/**
 * Generates the query to determine the list of available boards for a user
 * Executes the query and returns the list
 *
 * @param array $boardListOptions An array of options for the board list
 * @return array An array of board info
 */
function getBoardList($boardListOptions = array())
{
	global $smcFunc, $sourcedir, $txt;

if (isset($boardListOptions['excluded_boards']) && isset($boardListOptions['included_boards']))
	{
		loadLanguage('Errors');
		trigger_error($txt['get_board_list_cannot_include_and_exclude'], E_USER_ERROR);
	}

$where = array();
	$where_parameters = array();
	if (isset($boardListOptions['excluded_boards']))
	{
		$where[] = 'b.id_board NOT IN ({array_int:excluded_boards})';
		$where_parameters['excluded_boards'] = $boardListOptions['excluded_boards'];
	}

if (isset($boardListOptions['included_boards']))
	{
		$where[] = 'b.id_board IN ({array_int:included_boards})';
		$where_parameters['included_boards'] = $boardListOptions['included_boards'];
	}

if (!empty($boardListOptions['ignore_boards']))
		$where[] = '{query_wanna_see_board}';

elseif (!empty($boardListOptions['use_permissions']))
		$where[] = '{query_see_board}';

if (!empty($boardListOptions['not_redirection']))
	{
		$where[] = 'b.redirect = {string:blank_redirect}';
		$where_parameters['blank_redirect'] = '';
	}

$request = $smcFunc['db_query']('order_by_board_order', '
		SELECT c.name AS cat_name, c.id_cat, b.id_board, b.name AS board_name, b.child_level, b.redirect
		FROM {db_prefix}boards AS b
			LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)' . (empty($where) ? '' : '
		WHERE ' . implode('
			AND ', $where)),
		$where_parameters
	);

$return_value = array();
	if ($smcFunc['db_num_rows']($request) !== 0)
	{
		while ($row = $smcFunc['db_fetch_assoc']($request))
		{
			if (!isset($return_value[$row['id_cat']]))
				$return_value[$row['id_cat']] = array(
					'id' => $row['id_cat'],
					'name' => $row['cat_name'],
					'boards' => array(),
				);

$return_value[$row['id_cat']]['boards'][$row['id_board']] = array(
				'id' => $row['id_board'],
				'name' => $row['board_name'],
				'child_level' => $row['child_level'],
				'redirect' => $row['redirect'],
				'selected' => isset($boardListOptions['selected_board']) && $boardListOptions['selected_board'] == $row['id_board'],
			);
		}
	}
	$smcFunc['db_free_result']($request);

require_once($sourcedir . '/Subs-Boards.php');
	sortCategories($return_value);

return $return_value;
}

[+] ..
[-] Errors.php~ [edit]
[-] ReportedContent.php [edit]
[-] Profile.php~ [edit]
[-] Notify.php [edit]
[-] Security.php~ [edit]
[-] ScheduledTasks.php [edit]
[-] ModerationCenter.php [edit]
[-] Mentions.php [edit]
[-] DbExtra-mysql.php~ [edit]
[-] Subs-MessageIndex.php [edit]
[-] Display.php~ [edit]
[-] DbPackages-sqlite.php [edit]
[-] ManageSettings.php~ [edit]
[-] Subs-Compat.php [edit]
[-] ManageScheduledTasks.php [edit]
[-] Security.php [edit]
[-] Profile-View.php~ [edit]
[-] BoardIndex.php [edit]
[-] Class-Punycode.php [edit]
[-] Subs-Db-postgresql.php~ [edit]
[-] MessageIndex.php [edit]
[-] ManageMail.php~ [edit]
[-] Modlog.php [edit]
[-] Calendar.php [edit]
[-] Subs-Members.php~ [edit]
[-] Profile-Modify.php~ [edit]
[-] .reference [edit]
[-] RemoveTopic.php~ [edit]
[-] ManageSmileys.php [edit]
[-] MoveTopic.php [edit]
[-] RemoveTopic.php [edit]
[-] Subs-Post.php~ [edit]
[-] Profile.php [edit]
[+] Unicode
[-] Groups.php [edit]
[-] Subs-Sound.php~ [edit]
[-] Groups.php~ [edit]
[-] Recent.php~ [edit]
[-] Who.php~ [edit]
[-] Class-TOTP.php [edit]
[-] ManageRegistration.php~ [edit]
[-] Agreement.php [edit]
[-] ReportToMod.php [edit]
[-] Profile-Actions.php [edit]
[-] Subs-Db-sqlite.php~ [edit]
[-] Display.php [edit]
[-] ManageCalendar.php~ [edit]
[-] PersonalMessage.php [edit]
[-] ManageAttachments.php~ [edit]
[-] Subs-Attachments.php [edit]
[-] Help.php [edit]
[-] Subs-Notify.php [edit]
[-] index.php [edit]
[-] Subs-Admin.php~ [edit]
[-] Subs-Db-mysql.php~ [edit]
[-] Subs-Package.php [edit]
[-] Printpage.php [edit]
[-] Subs-Post.php [edit]
[-] Class-SearchAPI.php [edit]
[-] Subs-Admin.php [edit]
[-] DbExtra-postgresql.php [edit]
[-] ManageSmileys.php~ [edit]
[-] Class-Graphics.php~ [edit]
[-] Subs-Categories.php [edit]
[-] ManageSearch.php~ [edit]
[-] Subs-Editor.php~ [edit]
[-] Likes.php [edit]
[-] Subs.php~ [edit]
[-] SendTopic.php [edit]
[-] DbPackages-postgresql.php [edit]
[-] DbSearch-mysql.php [edit]
[-] Xml.php [edit]
[-] Reports.php [edit]
[-] Subs-Membergroups.php [edit]
[-] ManagePosts.php [edit]
[-] ManageAttachments.php [edit]
[-] ManagePaid.php~ [edit]
[-] SearchAPI-Standard.php [edit]
[-] DbExtra-mysql.php [edit]
[-] ManageLanguages.php [edit]
[+] Cache
[-] Session.php [edit]
[-] Load.php~ [edit]
[-] Packages.php~ [edit]
[-] ManageScheduledTasks.php~ [edit]
[-] Karma.php [edit]
[-] Poll.php~ [edit]
[-] ManageMembers.php~ [edit]
[-] News.php [edit]
[-] Subs-Compat.php~ [edit]
[-] DbSearch-sqlite.php [edit]
[-] Subs-Charset.php [edit]
[-] Subs.php [edit]
[-] Reminder.php [edit]
[-] Modlog.php~ [edit]
[-] ManagePaid.php [edit]
[-] LogInOut.php [edit]
[-] DbSearch-postgresql.php [edit]
[-] hcaptcha.php [edit]
[-] Subs-BoardIndex.php [edit]
[-] ManageMembergroups.php~ [edit]
[+] minify
[-] Class-Graphics.php [edit]
[-] Subs-Graphics.php~ [edit]
[-] Subs-Menu.php [edit]
[-] Admin.php~ [edit]
[-] ManageMail.php [edit]
[-] SearchAPI-Custom.php [edit]
[-] ScheduledTasks.php~ [edit]
[-] Logging.php [edit]
[-] DbPackages-mysql.php [edit]
[-] Subs-Recent.php [edit]
[-] Class-CurlFetchWeb.php~ [edit]
[-] ModerationCenter.php~ [edit]
[+] random_compat
[-] Admin.php [edit]
[-] Class-Package.php [edit]
[-] ManageMaintenance.php [edit]
[-] Packages.php [edit]
[-] Subs-BoardIndex.php~ [edit]
[-] ManageBans.php~ [edit]
[-] ManageMembers.php [edit]
[-] ManageServer.php [edit]
[-] Subs-Db-mysql.php [edit]
[-] ManageErrors.php [edit]
[-] Subs-Calendar.php [edit]
[-] Subs-Editor.php [edit]
[-] Load.php [edit]
[-] Subs-Graphics.php [edit]
[-] Subs-Boards.php [edit]
[-] News.php~ [edit]
[-] Stats.php [edit]
[-] ManageNews.php [edit]
[-] Subs-Db-sqlite.php [edit]
[-] Attachments.php [edit]
[-] Subs-ReportedContent.php [edit]
[-] Register.php~ [edit]
[-] Subs-Sound.php [edit]
[-] Who.php [edit]
[-] Subs-Members.php [edit]
[-] Search.php~ [edit]
[-] ManageRegistration.php [edit]
[-] Help.php~ [edit]
[-] PostModeration.php [edit]
[-] ShowAttachments.php [edit]
[-] Subs-Db-postgresql.php [edit]
[-] Recent.php [edit]
[-] Memberlist.php [edit]
[-] ManageBoards.php [edit]
[-] Themes.php~ [edit]
[-] Errors.php [edit]
[-] ManagePermissions.php [edit]
[-] SplitTopics.php [edit]
[-] Profile-Modify.php [edit]
[-] Themes.php [edit]
[-] Register.php [edit]
[-] Profile-Export.php [edit]
[-] ManageServer.php~ [edit]
[-] Subs-Auth.php [edit]
[-] PersonalMessage.php~ [edit]
[-] ManageSearchEngines.php [edit]
[-] Drafts.php [edit]
[-] Subs-Package.php~ [edit]
[-] Subs-MembersOnline.php [edit]
[-] ManageCalendar.php [edit]
[-] Memberlist.php~ [edit]
[-] QueryString.php [edit]
[-] Poll.php [edit]
[-] ManageMembergroups.php [edit]
[+] tasks
[-] ManageSearch.php [edit]
[-] Subs-Auth.php~ [edit]
[-] Agreement.php~ [edit]
[-] Topic.php [edit]
[-] QueryString.php~ [edit]
[-] ViewQuery.php [edit]
[-] ManageMaintenance.php~ [edit]
[-] PackageGet.php [edit]
[-] Post.php [edit]
[-] Subs-Timezones.php [edit]
[-] ManageErrors.php~ [edit]
[-] Post.php~ [edit]
[-] SearchAPI-Fulltext.php~ [edit]
[-] Profile-View.php [edit]
[-] Subs-OpenID.php [edit]
[-] ManageBans.php [edit]
[-] Class-CurlFetchWeb.php [edit]
[-] DbExtra-sqlite.php [edit]
[-] ManageNews.php~ [edit]
[-] Subscriptions-PayPal.php [edit]
[-] ManageSearchEngines.php~ [edit]
[-] RepairBoards.php [edit]
[-] Class-BrowserDetect.php [edit]
[+] ReCaptcha
[-] Subs-List.php [edit]
[-] Notify.php~ [edit]
[-] ManageSettings.php [edit]
[-] RepairBoards.php~ [edit]
[-] Subs-Themes.php [edit]
[-] Search.php [edit]
[-] SearchAPI-Fulltext.php [edit]