/**

*

* @package phpBB3

* @copyright (c) 2005 phpBB Group

*

*/

{

global $db, $auth, $user, $template;

global $phpbb_root_path, $phpEx, $config;

$forum_rows = $subforums = $forum_ids = $forum_ids_moderator = $forum_moderators = $active_forum_ary = array();

$parent_id = $visible_forums = 0;

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

{

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

if (!$user->data['is_registered'])

$sql_array['SELECT'] .= ', fa.user_id';

}

'SELECT' => $sql_array['SELECT'],

'FROM' => $sql_array['FROM'],

'LEFT_JOIN' => $sql_array['LEFT_JOIN'],

'WHERE' => $sql_where,

'ORDER_BY' => 'f.left_id',

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

$forum_tracking_info = array();

$branch_root_id = $root_data['forum_id'];

while ($row = $db->sql_fetchrow($result))

{

$forum_id = $row['forum_id'];

$token = request_var('hash', '');

if (check_link_hash($token, 'global'))

{

markread('topics', $forum_ids);

$message = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect . '">', '</a>');

meta_refresh(3, $redirect);

trigger_error($user->lang['FORUMS_MARKED'] . '<br /><br />' . $message);

}

else

$forum_unread = (isset($forum_tracking_info[$forum_id]) && $row['orig_forum_last_post_time'] > $forum_tracking_info[$forum_id]) ? true : false;

$folder_image = $folder_alt = $l_subforums = '';

$subforums_list = array();

if ($row['forum_last_post_id'])

{

$last_post_subject = $row['forum_last_post_subject'];

$last_post_time = $user->format_date($row['forum_last_post_time']);

$last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&amp;p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];

}

else

{

}

// Output moderator listing ... if applicable

'S_LOCKED_FORUM' => ($row['forum_status'] == ITEM_LOCKED) ? true : false,

'S_LIST_SUBFORUMS' => ($row['display_subforum_list']) ? true : false,

'S_SUBFORUMS' => (sizeof($subforums_list)) ? true : false,

'S_FEED_ENABLED' => ($config['feed_forum'] && !phpbb_optionget(FORUM_OPTION_FEED_EXCLUDE, $row['forum_options']) && $row['forum_type'] == FORUM_POST) ? true : false,

'FORUM_ID' => $row['forum_id'],

'FORUM_DESC' => generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield'], $row['forum_desc_options']),

'TOPICS' => $row['forum_topics'],

$l_post_click_count => $post_click_count,

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

'FORUM_FOLDER_IMG_ALT' => isset($user->lang[$folder_alt]) ? $user->lang[$folder_alt] : '',

'FORUM_IMAGE' => ($row['forum_image']) ? '<img src="' . $phpbb_root_path . $row['forum_image'] . '" alt="' . $user->lang[$folder_alt] . '" />' : '',

'FORUM_IMAGE_SRC' => ($row['forum_image']) ? $phpbb_root_path . $row['forum_image'] : '',

'LAST_POST_TIME' => $last_post_time,

'LAST_POSTER' => get_username_string('username', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

'LAST_POSTER_COLOUR' => get_username_string('colour', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

$template->assign_vars(array(

'ACTIVE_FORUM' => $active_f_name,

'ACTIVE_FORUM_PCT' => sprintf($l_active_pct, $active_f_pct),

'ACTIVE_TOPIC' => censor_text($active_t_name),

'ACTIVE_TOPIC_PCT' => sprintf($l_active_pct, $active_t_pct),

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

'U_ACTIVE_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $active_t_id),

function watch_topic_forum($mode, &$s_watching, $user_id, $forum_id, $topic_id, $notify_status = 'unset', $start = 0, $item_title = '')

{

global $template, $db, $user, $phpEx, $start, $phpbb_root_path;

$table_sql = ($mode == 'forum') ? FORUMS_WATCH_TABLE : TOPICS_WATCH_TABLE;

$where_sql = ($mode == 'forum') ? 'forum_id' : 'topic_id';

if (!is_null($notify_status) && $notify_status !== '')

{

if (isset($_GET['unwatch']))

{

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

if ($token && check_link_hash($token, "{$mode}_$match_id") || confirm_box(true))

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_UNWATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

if ($token && check_link_hash($token, "{$mode}_$match_id") || confirm_box(true))

{

{

$redirect_url = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;start=$start");

$message = $user->lang['ERR_WATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

}

else

{

{

login_box();

}

$avatar_img .= $avatar;

return '<img src="' . (str_replace(' ', '%20', $avatar_img)) . '" width="' . $avatar_width . '" height="' . $avatar_height . '" alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';

}