Subforum question

[parry60]

Alright, since I'm too lazy to get the latest CVS to see how this is done, could someone tell me how the jumpbox lists all forums?
I mean, is this recursion, or is there a database field that tells how many levels in a forum is?

thanks

[jeroen234]

Code: Select all

parent forum 1,0
       child forum 1,1
       child forum 1,1
       childforum  1,2
                  sub child forum 2,1
                  sub child forum 2,1
parent forum 3,0
parent forum 4,0
       child forum 4,1
       child forum 4,5
                  sub child forum 5,1
                  sub child forum 5,1
       childforum  4,1
parent forum 6,0

i think

[haravikk]

Just look at the jumpbox here (bottom of page on the right)

[sj26]

I believe ur talking about the php code behind it

it uses a handy little function called get_forum_parents():

Code: Select all

// Returns forum parents as an array. Get them from forum_data if available, or update the database otherwise
function get_forum_parents($forum_data)
{
	global $db;

	$forum_parents = array();
	if ($forum_data['parent_id'] > 0)
	{
		if ($forum_data['forum_parents'] == '')
		{
			$sql = 'SELECT forum_id, forum_name
				FROM ' . FORUMS_TABLE . '
				WHERE left_id < ' . $forum_data['left_id'] . '
					AND right_id > ' . $forum_data['right_id'] . '
				ORDER BY left_id ASC';
			$result = $db->sql_query($sql);

			while ($row = $db->sql_fetchrow($result))
			{
				$forum_parents[$row['forum_id']] = $row['forum_name'];
			}
			$db->sql_freeresult($result);

			$sql = 'UPDATE ' . FORUMS_TABLE . "
				SET forum_parents = '" . $db->sql_escape(serialize($forum_parents)) . "'
				WHERE parent_id = " . $forum_data['parent_id'];
			$db->sql_query($sql);
		}
		else
		{
			$forum_parents = unserialize($forum_data['forum_parents']);
		}
	}

	return $forum_parents;
}

I haven't figured out the left and right id stuff yet :S

[sj26]

OK, well, it doesn't, but that's the main forum-parent getting function... the actual make_jumpbox() function is:

Code: Select all

function make_jumpbox($action, $forum_id = false, $select_all = false)
{
	global $auth, $template, $user, $db, $phpEx, $SID;

	$boxstring = '';
	$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id
		FROM ' . FORUMS_TABLE . '
		ORDER BY left_id ASC';
	$result = $db->sql_query($sql, 600);

	$right = $cat_right = $padding_inc = 0;
	$padding = $forum_list = $holding = '';
	$padding_store = array('0' => '');
	while ($row = $db->sql_fetchrow($result))
	{
		if ($row['forum_type'] == FORUM_CAT && ($row['left_id'] + 1 == $row['right_id']))
		{
			// Non-postable forum with no subforums, don't display
			continue;
		}

		if (!$auth->acl_get('f_list', $row['forum_id']))
		{
			// if the user does not have permissions to list this forum skip
			continue;
		}

		if ($row['left_id'] < $right)
		{
			$padding .= '     ';
			$padding_store[$row['parent_id']] = $padding;
		}
		else if ($row['left_id'] > $right + 1)
		{
			$padding = $padding_store[$row['parent_id']];
		}

		$right = $row['right_id'];

		$selected = ($row['forum_id'] == $forum_id) ? ' selected="selected"' : '';

		if ($row['left_id'] > $cat_right)
		{
			$holding = '';
		}

		if ($row['right_id'] - $row['left_id'] > 1)
		{
			$cat_right = max($cat_right, $row['right_id']);

			$holding .= '<option value="' . $row['forum_id'] . '"' . $selected . '>' . $padding . $row['forum_name'] . '</option>';
		}
		else
		{
			$boxstring .= $holding . '<option value="' . $row['forum_id'] . '"' . $selected . '>' . $padding . $row['forum_name'] . '</option>';
			$holding = '';
		}
	}
	$db->sql_freeresult($result);
	unset($padding_store);

	if ($boxstring != '')
	{
		$boxstring = (($select_all) ? '<option value="0">' . $user->lang['ALL_FORUMS'] : '<option value="-1">' . $user->lang['SELECT_FORUM']) . '</option><option value="-1">-----------------</option>' . $boxstring;
	}

	$template->assign_vars(array(
		'S_JUMPBOX_OPTIONS' => $boxstring,
		'S_JUMPBOX_ACTION' => $action)
	);

	return;
}

[hasten]

In which file would I find this code?

OK, well, it doesn't, but that's the main forum-parent getting function... the actual make_jumpbox() function is:

Code: Select all

function make_jumpbox($action, $forum_id = false, $select_all = false)
{
	// Shortened to aviod long and needless post.
	return;
}

[Gogeta]

./viewforum.php

[DoD]

In which file would I find this code?

includes/functions.php

[hasten]

Thsnks, DoD.

[SHS`]

Thsnks, DoD.

It's unsupported, as has been said many many many times before... if you can't work it out by yourself... don't mess with CVS code.

Anyone asking for support or providing support for 2.1/2.2 CVS are likely to make developers rather miffed, which further delays this forcoming version version.