ORDER BY left_id";

$result = $db->sql_query($sql);

{

{

$forum_type = $row['forum_type'];

'U_SYNC' => $url . '&action=sync')

);

}

}

else if ($this->parent_id)

{

'U_SYNC' => $url . '&action=sync')

);

}

$template->assign_vars(array(

'ERROR_MSG' => (sizeof($errors)) ? implode('<br />', $errors) : '',

*/

function make_forum_select($select_id = false, $ignore_id = false, $ignore_acl = false, $ignore_nonpost = false, $ignore_emptycat = true, $only_acl_post = false, $return_array = false)

{

// This query is identical to the jumpbox one

$sql = 'SELECT forum_id, forum_name, parent_id, forum_type, forum_flags, forum_options, left_id, right_id

ORDER BY left_id ASC';

$result = $db->sql_query($sql, 600);

$right = 0;

$padding_store = array('0' => '');

$padding = '';

$forum_list = ($return_array) ? array() : '';

// Sometimes it could happen that forums will be displayed here not be displayed within the index page

// This is the result of forums not displayed at index, having list permissions and a parent of a forum with no permissions.

// If this happens, the padding could be "broken"

{

if ($row['left_id'] < $right)

{

$forum_list .= '<option value="' . $row['forum_id'] . '"' . (($disabled) ? ' disabled="disabled" class="disabled-option"' : $selected) . '>' . $padding . $row['forum_name'] . '</option>';

}

}

return $forum_list;

}

ORDER BY left_id ASC';

$result = $db->sql_query($sql, 600);

$right = $padding = 0;

$padding_store = array('0' => 0);

$display_jumpbox = false;

$iteration = 0;

// Sometimes it could happen that forums will be displayed here not be displayed within the index page

// This is the result of forums not displayed at index, having list permissions and a parent of a forum with no permissions.

// If this happens, the padding could be "broken"

{

if ($row['left_id'] < $right)

{

}

$iteration++;

}

$url_parts = $phpbb_path_helper->get_url_parts($action);

function main($id, $mode)

{

global $request;

switch ($mode)

$unwatch = (isset($_POST['unwatch'])) ? true : false;

if ($unwatch)

{

if (check_form_key('ucp_front_subscribed'))

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

$sql = $db->sql_build_query('SELECT', $sql_array);

$result = $db->sql_query($sql);

$last_post_time = $last_post_url = '';

}

'FORUM_ID' => $forum_id,

'FORUM_IMG_STYLE' => $folder_image,

'FORUM_FOLDER_IMG' => $user->img($folder_image, $folder_alt),

'S_UNREAD_FORUM' => $unread_forum,

'U_LAST_POST' => $last_post_url,

);

}

$db->sql_freeresult($result);

}

*/

function assign_topiclist($mode = 'subscribed', $forbidden_forum_ary = array())

{

$table = ($mode == 'subscribed') ? TOPICS_WATCH_TABLE : BOOKMARKS_TABLE;

$start = request_var('start', 0);

AND i.user_id = ' . $user->data['user_id'] . '

AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),

);

$sql = $db->sql_build_query('SELECT', $sql_array);

$result = $db->sql_query($sql);

$topics_count = (int) $db->sql_fetchfield('topics_count');

$sql_array['SELECT'] .= ', tp.topic_posted';

}

$sql = $db->sql_build_query('SELECT', $sql_array);

$result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);

$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params);

// Send vars to template

'FORUM_ID' => $forum_id,

'TOPIC_ID' => $topic_id,

'FIRST_POST_TIME' => $user->format_date($row['topic_time']),

'U_LAST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params . '&amp;p=' . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'],

'U_VIEW_TOPIC' => $view_topic_url,

'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id),

$pagination->generate_template_pagination(append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . "&amp;t=$topic_id"), 'topicrow.pagination', 'start', $replies + 1, $config['posts_per_page'], 1, true, true);

}