/**

*

* @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;

$sql_where = 'left_id > ' . $root_data['left_id'] . ' AND left_id < ' . $root_data['right_id'];

}

// Display list of active topics for this category?

$show_active = (isset($root_data['forum_flags']) && ($root_data['forum_flags'] & FORUM_FLAG_ACTIVE_TOPICS)) ? true : false;

$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();

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

{

$forum_id = $row['forum_id'];

// Mark forums read?

{

if ($auth->acl_get('f_list', $forum_id))

{

$forum_ids[] = $forum_id;

}

}

// Category with no members

continue;

}

if ($config['load_db_lastread'] && $user->data['is_registered'])

{

$forum_tracking_info[$forum_id] = (!empty($row['mark_time'])) ? $row['mark_time'] : $user->data['user_lastmark'];

$forum_rows[$parent_id]['forum_id_last_post'] = $forum_id;

}

}

}

$db->sql_freeresult($result);

// Handle marking posts

{

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

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

{

meta_refresh(3, $redirect);

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

}

else

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

if ($display_moderators && !empty($forum_moderators[$forum_id]))

{

$l_moderator = (sizeof($forum_moderators[$forum_id]) == 1) ? $user->lang['MODERATOR'] : $user->lang['MODERATORS'];

}

$l_post_click_count = ($row['forum_type'] == FORUM_LINK) ? 'CLICKS' : 'POSTS';

{

$s_subforums_list[] = '<a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['UNREAD_POSTS'] : $user->lang['NO_UNREAD_POSTS']) . '">' . $subforum['name'] . '</a>';

}

$catless = ($row['parent_id'] == $root_data['forum_id']) ? true : false;

if ($row['forum_type'] != FORUM_LINK)

}

}

'S_IS_CAT' => false,

'S_NO_CAT' => $catless && !$last_catless,

'S_IS_LINK' => ($row['forum_type'] == FORUM_LINK) ? true : false,

'S_UNREAD_FORUM' => $forum_unread,

'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'],

$l_post_click_count => $post_click_count,

'FORUM_IMG_STYLE' => $folder_image,

'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']),

'SUBFORUMS' => $s_subforums_list,

'L_SUBFORUM_STR' => $l_subforums,

'L_MODERATOR_STR' => $l_moderator,

'U_UNAPPROVED_TOPICS' => ($row['forum_id_unapproved_topics']) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=unapproved_topics&amp;f=' . $row['forum_id_unapproved_topics']) : '',

'U_VIEWFORUM' => $u_viewforum,

'U_LAST_POSTER' => get_username_string('profile', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),

);

// Assign subforums loop for style authors

foreach ($subforums_list as $subforum)

{

}

$template->assign_vars(array(

'S_HAS_SUBFORUM' => ($visible_forums) ? true : false,

'L_SUBFORUM' => ($visible_forums == 1) ? $user->lang['SUBFORUM'] : $user->lang['SUBFORUMS'],

'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

}

/**

* Obtain list of moderators of each forum

*/

function get_moderators(&$forum_moderators, $forum_id = false)

*/

function display_custom_bbcodes()

{

// Start counting from 22 for the bbcode ids (every bbcode takes two ids - opening/closing)

$num_predefined_bbcodes = 22;

$row['bbcode_helpline'] = $user->lang[strtoupper($row['bbcode_helpline'])];

}

'BBCODE_NAME' => "'[{$row['bbcode_tag']}]', '[/" . str_replace('=', '', $row['bbcode_tag']) . "]'",

'BBCODE_ID' => $num_predefined_bbcodes + ($i * 2),

'BBCODE_TAG' => $row['bbcode_tag'],

'BBCODE_HELPLINE' => $row['bbcode_helpline'],

'A_BBCODE_HELPLINE' => str_replace(array('&amp;', '&quot;', "'", '&lt;', '&gt;'), array('&', '"', "\'", '<', '>'), $row['bbcode_helpline']),

$i++;

}

$db->sql_freeresult($result);

}

/**

}

// Obtain active topic

$sql = 'SELECT topic_id, COUNT(post_id) AS num_posts

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $userdata['user_id'] . "

AND post_postcount = 1

AND (post_approved = 1

$sql_m_approve)

GROUP BY topic_id

ORDER BY num_posts DESC";

$result = $db->sql_query_limit($sql, 1);

$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),

/**

* Topic and forum watching common code

*/

{

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

global $request;

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

$u_url = "uid={$user->data['user_id']}";

$u_url .= ($mode == 'forum') ? '&amp;f' : '&amp;f=' . $forum_id . '&amp;t';

// Is user watching this thread?

if ($user_id != ANONYMOUS)

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

{

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

{

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

{

$sql = 'DELETE FROM ' . $table_sql . "

WHERE $where_sql = $match_id

AND user_id = $user_id";

$db->sql_query($sql);

}

else

{

{

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

{

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

{

$is_watching = true;

$sql = 'INSERT INTO ' . $table_sql . " (user_id, $where_sql, notify_status)

VALUES ($user_id, $match_id, " . NOTIFY_YES . ')';

$db->sql_query($sql);

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

}

else

{

}

else

{

}

else

{

{

login_box();

}

if ($can_watch)

{

$s_watching['link'] = append_sid("{$phpbb_root_path}view$mode.$phpEx", "$u_url=$match_id&amp;" . (($is_watching) ? 'unwatch' : 'watch') . "=$mode&amp;start=$start&amp;hash=" . generate_link_hash("{$mode}_$match_id"));

$s_watching['title'] = $user->lang[(($is_watching) ? 'STOP' : 'START') . '_WATCHING_' . strtoupper($mode)];

$s_watching['is_watching'] = $is_watching;

}

function get_user_avatar($avatar, $avatar_type, $avatar_width, $avatar_height, $alt = 'USER_AVATAR', $ignore_config = false)

{

global $user, $config, $phpbb_root_path, $phpEx;

if (empty($avatar) || !$avatar_type || (!$config['allow_avatar'] && !$ignore_config))

{

$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) . '" />';

}