Code Forge

<?php

/**

*

* @package phpBB3

* @version $Id$

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*

*/

/**

*/

define('IN_PHPBB', true);

$phpbb_root_path = './';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'common.'.$phpEx);

include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Start session management

$user->session_begin();

$auth->acl($user->data);

// Initial var setup

$forum_id        = request_var('f', 0);

$topic_id        = request_var('t', 0);

$post_id        = request_var('p', 0);

$voted_id        = request_var('vote_id', 0);;

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

$view                = request_var('view', '');

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

$sort_days        = request_var('st', ((!empty($user->data['user_post_show_days'])) ? $user->data['user_post_show_days'] : 0));

$sort_key        = request_var('sk', ((!empty($user->data['user_post_sortby_type'])) ? $user->data['user_post_sortby_type'] : 't'));

$sort_dir        = request_var('sd', ((!empty($user->data['user_post_sortby_dir'])) ? $user->data['user_post_sortby_dir'] : 'a'));

$update                = request_var('update', false);

$hilit_words                = request_var('hilit', '');

// Do we have a topic or post id?

if (!$topic_id && !$post_id)

{

        trigger_error('NO_TOPIC');

}

// Find topic id if user requested a newer or older topic

$unread_post_id = 0;

if ($view && !$post_id)

{

        if (!$forum_id)

        {

                $sql = 'SELECT forum_id FROM ' . TOPICS_TABLE . "

                        WHERE topic_id = $topic_id";

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

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

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

                {

                        $forum_id = $row['forum_id'];

                }

                else

                {

                        trigger_error('NO_TOPIC');

                }

                $db->sql_freeresult($result);

        }

        if ($view == 'unread')

        {

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

                {

                        $topic_last_read = get_topic_last_read($topic_id, $forum_id);

                }

                else

                {

                        $topic_last_read = 0;

                }

                $sql = 'SELECT p.post_id, p.topic_id, p.forum_id

                        FROM (' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t)

                        WHERE t.topic_id = $topic_id

                                AND p.topic_id = t.topic_id

                                " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND p.post_approved = 1') . "

                                AND (p.post_time > $topic_last_read

                                        OR p.post_id = t.topic_last_post_id)

                        ORDER BY p.post_time ASC";

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

                if (!($row = $db->sql_fetchrow($result)))

                {

                        // Setup user environment so we can process lang string

                        $user->setup('viewtopic');

                        meta_refresh(3, "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id");

                        $message = $user->lang['NO_UNREAD_POSTS'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id\">", '</a>');

                        trigger_error($message);

                }

                $db->sql_freeresult($result);

                $unread_post_id = $post_id = $row['post_id'];

                $topic_id = $row['topic_id'];

        }

        else if ($view == 'next' || $view == 'previous')

        {

                $sql_condition = ($view == 'next') ? '>' : '<';

                $sql_ordering = ($view == 'next') ? 'ASC' : 'DESC';

                $sql = 'SELECT t.topic_id, t.forum_id

                        FROM ' . TOPICS_TABLE . ' t, ' . TOPICS_TABLE . " t2

                        WHERE t2.topic_id = $topic_id

                                AND t.forum_id = t2.forum_id

                                " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND t.topic_approved = 1') . "

                                AND t.topic_last_post_time $sql_condition t2.topic_last_post_time

                        ORDER BY t.topic_last_post_time $sql_ordering";

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

                if (!($row = $db->sql_fetchrow($result)))

                {

                        $message = ($view == 'next') ? 'NO_NEWER_TOPICS' : 'NO_OLDER_TOPICS';

                        trigger_error($message);

                }

                else

                {

                        $topic_id = $row['topic_id'];

                        // Check for global announcement correctness?

                        if (!$row['forum_id'] && !$forum_id)

                        {

                                trigger_error('NO_TOPIC');

                        }

                        else if ($row['forum_id'])

                        {

                                $forum_id = $row['forum_id'];

                        }

                }

        }

        // Check for global announcement correctness?

        if ((!$row || !$row['forum_id']) && !$forum_id)

        {

                trigger_error('NO_TOPIC');

        }

        else if ($row['forum_id'])

        {

                $forum_id = $row['forum_id'];

        }

}

// This rather complex gaggle of code handles querying for topics but

// also allows for direct linking to a post (and the calculation of which

// page the post is on and the correct display of viewtopic)

$join_sql_table = (!$post_id) ? '' : ', ' . POSTS_TABLE . ' p, ' . POSTS_TABLE . ' p2 ';

if (!$post_id)

{

        $join_sql = "t.topic_id = $topic_id";

}

else

{

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

        {

                $join_sql = (!$post_id) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= $post_id";

        }

        else

        {

                $join_sql = (!$post_id) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND p.post_approved = 1 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_approved = 1 AND p2.post_id <= $post_id";

        }

}

$extra_fields = (!$post_id)  ? '' : ', COUNT(p2.post_id) AS prev_posts';

$order_sql = (!$post_id) ? '' : 'GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.poll_max_options, t.poll_start, t.poll_length, t.poll_title, f.forum_name, f.forum_desc, f.forum_parents, f.parent_id, f.left_id, f.right_id, f.forum_status, f.forum_id, f.forum_style, f.forum_password ORDER BY p.post_id ASC';

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

{

        $extra_fields .= ', tw.notify_status' . (($config['allow_bookmarks']) ? ', bm.order_id as bookmarked' : '');

        $join_sql_table .= ' LEFT JOIN ' . TOPICS_WATCH_TABLE . ' tw ON (tw.user_id = ' . $user->data['user_id'] . '

                AND t.topic_id = tw.topic_id)';

        $join_sql_table .= ($config['allow_bookmarks']) ? ' LEFT JOIN ' . BOOKMARKS_TABLE . ' bm ON (bm.user_id = ' . $user->data['user_id'] . '

                AND t.topic_id = bm.topic_id)' : '';

}

// Join to forum table on topic forum_id unless topic forum_id is zero

// whereupon we join on the forum_id passed as a parameter ... this

// is done so navigation, forum name, etc. remain consistent with where

// user clicked to view a global topic

$sql = 'SELECT t.topic_id, t.forum_id, t.topic_title, t.topic_attachment, t.topic_status, t.topic_approved, t.topic_replies_real, t.topic_replies, t.topic_first_post_id, t.topic_last_post_id, t.topic_last_poster_id, t.topic_last_post_time, t.topic_poster, t.topic_time, t.topic_time_limit, t.topic_type, t.topic_bumped, t.topic_bumper, t.poll_max_options, t.poll_start, t.poll_length, t.poll_title, t.poll_vote_change, f.forum_name, f.forum_desc, f.forum_parents, f.parent_id, f.left_id, f.right_id, f.forum_status, f.forum_type, f.forum_id, f.forum_style, f.forum_password, f.forum_rules, f.forum_rules_link, f.forum_rules_flags, f.forum_rules_bbcode_uid, f.forum_rules_bbcode_bitfield' . $extra_fields . '

        FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . ' f' . $join_sql_table . "

        WHERE $join_sql

                AND (f.forum_id = t.forum_id

                        " . ((!$forum_id) ? '' : 'OR (t.topic_type = ' . POST_GLOBAL . " AND f.forum_id = $forum_id)") . "

                        )

                $order_sql";

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

if (!($topic_data = $db->sql_fetchrow($result)))

{

        // If post_id was submitted, we try at least to display the topic as a last resort...

        if ($post_id && $forum_id && $topic_id)

        {

                redirect("viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id");

        }

        trigger_error('NO_TOPIC');

}

// Extract the data

extract($topic_data);

//

$topic_replies = ($auth->acl_get('m_approve', $forum_id)) ? $topic_replies_real : $topic_replies;

unset($topic_replies_real);

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

{

        $topic_last_read = get_topic_last_read($topic_id, $forum_id);

}

else

{

        $topic_last_read = 0;

}

// Check sticky/announcement time limit

if (($topic_type == POST_STICKY || $topic_type == POST_ANNOUNCE) && $topic_time_limit && ($topic_time + $topic_time_limit) < time())

{

        $sql = 'UPDATE ' . TOPICS_TABLE . '

                SET topic_type = ' . POST_NORMAL . ', topic_time_limit = 0

                WHERE topic_id = ' . $topic_id;

        $db->sql_query($sql);

        $topic_type = POST_NORMAL;

        $topic_time_limit = 0;

}

// Setup look and feel

$user->setup('viewtopic', $forum_style);

if (!$topic_approved && !$auth->acl_get('m_approve', $forum_id))

{

        trigger_error('NO_TOPIC');

}

// Start auth check

if (!$auth->acl_get('f_read', $forum_id))

{

        if ($user->data['user_id'] != ANONYMOUS)

        {

                trigger_error($user->lang['SORRY_AUTH_READ']);

        }

        login_box('', $user->lang['LOGIN_VIEWFORUM']);

}

// Forum is passworded ... check whether access has been granted to this

// user this session, if not show login box

if ($forum_password)

{

        login_forum_box($topic_data);

}

// Redirect to login or to the correct post upon emailed notification links

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

{

        $jump_to = request_var('e', 0);

        $redirect_url = "{$phpbb_root_path}viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id";

        if ($user->data['user_id'] == ANONYMOUS)

        {

                login_box($redirect_url . "&p=$post_id&e=$jump_to", $user->lang['LOGIN_NOTIFY_TOPIC']);

        }

        if ($jump_to > 0)

        {

                // We direct the already logged in user to the correct post...

                redirect($redirect_url . ((!$post_id) ? "&p=$jump_to" : "&p=$post_id") . "#$jump_to");

        }

}

// What is start equal to?

if (!empty($post_id))

{

        $start = floor(($prev_posts - 1) / $config['posts_per_page']) * $config['posts_per_page'];

}

// Post ordering options

$limit_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 364 => $user->lang['1_YEAR']);

$sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);

$sort_by_sql = array('a' => 'u.username', 't' => 'p.post_id', 's' => 'p.post_subject');

$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

// Obtain correct post count and ordering SQL if user has

// requested anything different

if ($sort_days)

{

        $min_post_time = time() - ($sort_days * 86400);

        $sql = 'SELECT COUNT(post_id) AS num_posts

                FROM ' . POSTS_TABLE . "

                WHERE topic_id = $topic_id

                        AND post_time >= $min_post_time

                " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1');

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

        if (isset($_POST['sort']))

        {

                $start = 0;

        }

        $total_posts = ($row = $db->sql_fetchrow($result)) ? $row['num_posts'] : 0;

        $limit_posts_time = "AND p.post_time >= $min_post_time ";

}

else

{

        $total_posts = $topic_replies + 1;

        $limit_posts_time = '';

}

// Was a highlight request part of the URI?

$highlight_match = $highlight = '';

if ($hilit_words)

{

        foreach (explode(' ', trim($hilit_words)) as $word)

        {

                if (trim($word))

                {

                        $highlight_match .= (($highlight_match != '') ? '|' : '') . str_replace('\*', '\w*?', preg_quote(urlencode($word), '#'));

                }

        }

        $highlight = urlencode($hilit_words);

}

// General Viewtopic URL for return links

$viewtopic_url = "{$phpbb_root_path}viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id&start=$start&$u_sort_param" . (($highlight_match) ? "&hilit=$highlight" : '');

// Are we watching this topic?

$s_watching_topic = $s_watching_topic_img = array();

$s_watching_topic['link'] = $s_watching_topic['title'] = '';

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

{

        watch_topic_forum('topic', $s_watching_topic, $s_watching_topic_img, $user->data['user_id'], $topic_id, $notify_status, $start);

}

// Bookmarks

if ($config['allow_bookmarks'] && $user->data['is_registered'] && request_var('bookmark', 0))

{

        if (!$bookmarked)

        {

                $sql = 'INSERT INTO ' . BOOKMARKS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

                        'user_id'        => $user->data['user_id'],

                        'topic_id'        => $topic_id,

                        'order_id'        => 0)

                );

                $db->sql_query($sql);

                $where_sql = '';

                $sign = '+';

        }

        else

        {

                $sql = 'DELETE FROM ' . BOOKMARKS_TABLE . "

                        WHERE user_id = {$user->data['user_id']}

                                AND topic_id = $topic_id";

                $db->sql_query($sql);

                // Works because of current order_id selected as bookmark value (please do not change because of simplicity)

                $where_sql = " AND order_id > $bookmarked";

                $sign = '-';

        }

        // Re-Sort Bookmarks

        $sql = 'UPDATE ' . BOOKMARKS_TABLE . "

                SET order_id = order_id $sign 1

                        WHERE user_id = {$user->data['user_id']}

                        $where_sql";

        $db->sql_query($sql);

        meta_refresh(3, $viewtopic_url);

        $message = (($bookmarked) ? $user->lang['BOOKMARK_REMOVED'] : $user->lang['BOOKMARK_ADDED']) . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $viewtopic_url . '">', '</a>');

        trigger_error($message);

}

// Grab ranks

$ranks = array();

$cache->obtain_ranks($ranks);

// Grab icons

$icons = array();

$cache->obtain_icons($icons);

// Grab extensions

$extensions = array();

if ($topic_attachment)

{

        $cache->obtain_attach_extensions($extensions);

}

// Forum rules listing

$s_forum_rules = '';

gen_forum_auth_level('topic', $forum_id);

// Quick mod tools

$topic_mod = '';

$topic_mod .= ($auth->acl_get('m_lock', $forum_id) || ($auth->acl_get('f_user_lock', $forum_id) && $user->data['is_registered'] && $user->data['user_id'] == $topic_poster)) ? (($topic_status == ITEM_UNLOCKED) ? '<option value="lock">' . $user->lang['LOCK_TOPIC'] . '</option>' : '<option value="unlock">' . $user->lang['UNLOCK_TOPIC'] . '</option>') : '';

$topic_mod .= ($auth->acl_get('m_delete', $forum_id)) ? '<option value="delete_topic">' . $user->lang['DELETE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_move', $forum_id)) ? '<option value="move">' . $user->lang['MOVE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_split', $forum_id)) ? '<option value="split">' . $user->lang['SPLIT_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_merge', $forum_id)) ? '<option value="merge">' . $user->lang['MERGE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_', $forum_id)) ? '<option value="fork">' . $user->lang['FORK_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_', $forum_id) && $topic_type != POST_NORMAL) ? '<option value="make_normal">' . $user->lang['MAKE_NORMAL'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('f_sticky', $forum_id) && $topic_type != POST_STICKY) ? '<option value="make_sticky">' . $user->lang['MAKE_STICKY'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('f_announce', $forum_id) && $topic_type != POST_ANNOUNCE) ? '<option value="make_announce">' . $user->lang['MAKE_ANNOUNCE'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('f_announce', $forum_id) && $topic_type != POST_GLOBAL) ? '<option value="make_global">' . $user->lang['MAKE_GLOBAL'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_', $forum_id)) ? '<option value="viewlogs">' . $user->lang['VIEW_TOPIC_LOGS'] . '</option>' : '';

// If we've got a hightlight set pass it on to pagination.

$pagination = generate_pagination("{$phpbb_root_path}viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id&$u_sort_param" . (($highlight_match) ? "&hilit=$highlight" : ''), $total_posts, $config['posts_per_page'], $start);

// Navigation links

generate_forum_nav($topic_data);

// Forum Rules

generate_forum_rules($topic_data);

// Moderators

$forum_moderators = array();

get_moderators($forum_moderators, $forum_id);

// This is only used for print view so ...

$server_path = (!$view) ? '' : generate_board_url() . '/';

// Replace naughty words in title

$topic_title = censor_text($topic_title);

// Send vars to template

$template->assign_vars(array(

        'FORUM_ID'                 => $forum_id,

        'FORUM_NAME'         => $forum_name,

        'FORUM_DESC'        => $forum_desc,

        'TOPIC_ID'                 => $topic_id,

        'TOPIC_TITLE'         => $topic_title,

        'PAGINATION'         => $pagination,

        'PAGE_NUMBER'         => on_page($total_posts, $config['posts_per_page'], $start),

        'TOTAL_POSTS'        => ($total_posts == 1) ? $user->lang['VIEW_TOPIC_POST'] : sprintf($user->lang['VIEW_TOPIC_POSTS'], $total_posts),

        'U_MCP'                 => ($auth->acl_get('m_', $forum_id)) ? "mcp.$phpEx?sid=" . $user->session_id . "&mode=topic_view&f=$forum_id&t=$topic_id&start=$start&$u_sort_param" : '',

        'MODERATORS'        => (isset($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id])) ? implode(', ', $forum_moderators[$forum_id]) : '',

        'POST_IMG'                         => ($forum_status == ITEM_LOCKED) ? $user->img('btn_locked', 'FORUM_LOCKED') : $user->img('btn_post', 'POST_NEW_TOPIC'),

        'QUOTE_IMG'                 => $user->img('btn_quote', 'REPLY_WITH_QUOTE'),

        'REPLY_IMG'                        => ($forum_status == ITEM_LOCKED || $topic_status == ITEM_LOCKED) ? $user->img('btn_locked', 'TOPIC_LOCKED') : $user->img('btn_reply', 'REPLY_TO_TOPIC'),

        'EDIT_IMG'                         => $user->img('btn_edit', 'EDIT_POST'),

        'DELETE_IMG'                 => $user->img('btn_delete', 'DELETE_POST'),

        'INFO_IMG'                         => $user->img('btn_info', 'VIEW_INFO'),

        'PROFILE_IMG'                => $user->img('btn_profile', 'READ_PROFILE'),

        'SEARCH_IMG'                 => $user->img('btn_search', 'SEARCH_USER_POSTS'),

        'PM_IMG'                         => $user->img('btn_pm', 'SEND_PRIVATE_MESSAGE'),

        'EMAIL_IMG'                 => $user->img('btn_email', 'SEND_EMAIL'),

        'WWW_IMG'                         => $user->img('btn_www', 'VISIT_WEBSITE'),

        'ICQ_IMG'                         => $user->img('btn_icq', 'ICQ'),

        'AIM_IMG'                         => $user->img('btn_aim', 'AIM'),

        'MSN_IMG'                         => $user->img('btn_msnm', 'MSNM'),

        'YIM_IMG'                         => $user->img('btn_yim', 'YIM'),

        'JABBER_IMG'                => $user->img('btn_jabber', 'JABBER') ,

        'REPORT_IMG'                => $user->img('btn_report', 'REPORT_POST'),

        'REPORTED_IMG'                => $user->img('icon_reported', 'POST_REPORTED'),

        'UNAPPROVED_IMG'        => $user->img('icon_unapproved', 'POST_UNAPPROVED'),

        'S_SELECT_SORT_DIR'         => $s_sort_dir,

        'S_SELECT_SORT_KEY'         => $s_sort_key,

        'S_SELECT_SORT_DAYS'         => $s_limit_days,

        'S_TOPIC_ACTION'                 => "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id&start=$start",

        'S_TOPIC_MOD'                         => ($topic_mod != '') ? '<select name="mode">' . $topic_mod . '</select>' : '',

        'S_MOD_ACTION'                         => "mcp.$phpEx?sid=" . $user->session_id . "&t=$topic_id&f=$forum_id&quickmod=1",

        'S_DISPLAY_SEARCHBOX'        => ($auth->acl_get('f_search', $forum_id)) ? true : false,

        'S_SEARCHBOX_ACTION'        => "search.$phpEx$SID&search_forum[]=$forum_id",

        'U_TOPIC'                                => "{$server_path}viewtopic.$phpEx?f=$forum_id&t=$topic_id",

        'U_FORUM'                                => $server_path,

        'U_VIEW_UNREAD_POST'        => "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id&view=unread#unread",

        'U_VIEW_TOPIC'                         => $viewtopic_url,

        'U_VIEW_FORUM'                         => "viewforum.$phpEx$SID&f=$forum_id",

        'U_VIEW_OLDER_TOPIC'        => "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id&view=previous",

        'U_VIEW_NEWER_TOPIC'        => "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id&view=next",

        'U_PRINT_TOPIC'                        => ($auth->acl_get('f_print', $forum_id)) ? $viewtopic_url . '&view=print' : '',

        'U_EMAIL_TOPIC'                        => ($auth->acl_get('f_email', $forum_id) && $config['email_enable']) ? "memberlist.$phpEx$SID&mode=email&t=$topic_id" : '',

        'U_WATCH_TOPIC'                 => $s_watching_topic['link'],

        'L_WATCH_TOPIC'                 => $s_watching_topic['title'],

        'U_BOOKMARK_TOPIC'                => ($user->data['is_registered'] && $config['allow_bookmarks']) ? $viewtopic_url . '&bookmark=1' : '',

        'L_BOOKMARK_TOPIC'                => ($user->data['is_registered'] && $config['allow_bookmarks'] && $bookmarked) ? $user->lang['BOOKMARK_TOPIC_REMOVE'] : $user->lang['BOOKMARK_TOPIC'],

        'U_POST_NEW_TOPIC'                 => "posting.$phpEx$SID&mode=post&f=$forum_id",

        'U_POST_REPLY_TOPIC'         => "posting.$phpEx$SID&mode=reply&f=$forum_id&t=$topic_id",

        'U_BUMP_TOPIC'                        => (bump_topic_allowed($forum_id, $topic_bumped, $topic_last_post_time, $topic_poster, $topic_last_poster_id)) ? "posting.$phpEx$SID&mode=bump&f=$forum_id&t=$topic_id" : '')

);

// Does this topic contain a poll?

if (!empty($poll_start))

{

        $sql = 'SELECT o.*, p.bbcode_bitfield, p.bbcode_uid

                FROM ' . POLL_OPTIONS_TABLE . ' o, ' . POSTS_TABLE . " p

                WHERE o.topic_id = $topic_id

                        AND p.post_id = $topic_first_post_id

                        AND p.topic_id = o.topic_id

                ORDER BY o.poll_option_id";

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

        $poll_info = array();

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

        {

                $poll_info[] = $row;

        }

        $db->sql_freeresult($result);

        $cur_voted_id = array();

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

        {

                $sql = 'SELECT poll_option_id

                        FROM ' . POLL_VOTES_TABLE . '

                        WHERE topic_id = ' . $topic_id . '

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

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

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

                {

                        $cur_voted_id[] = $row['poll_option_id'];

                }

                $db->sql_freeresult($result);

        }

        else

        {

                // Cookie based guest tracking ... I don't like this but hum ho

                // it's oft requested. This relies on "nice" users who don't feel

                // the need to delete cookies to mess with results.

                if (isset($_COOKIE[$config['cookie_name'] . '_poll_' . $topic_id]))

                {

                        $cur_voted_id = explode(',', $_COOKIE[$config['cookie_name'] . '_poll_' . $topic_id]);

                }

        }

        $s_can_vote = (((!sizeof($cur_voted_id) && $auth->acl_get('f_vote', $forum_id)) ||

                ($auth->acl_get('f_votechg', $forum_id) && $poll_vote_change)) &&

                (($poll_length != 0 && $poll_start + $poll_length > time()) || $poll_length == 0) &&

                $topic_status != ITEM_LOCKED &&

                $forum_status != ITEM_LOCKED) ? true : false;

        $s_display_results = (!$s_can_vote || ($s_can_vote && sizeof($cur_voted_id)) || $view == 'viewpoll') ? true : false;

        if ($update && $s_can_vote)

        {

                if (!sizeof($voted_id) || sizeof($voted_id) > $poll_max_options)

                {

                        meta_refresh(5, "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id");

                        $message = (!sizeof($voted_id)) ? 'NO_VOTE_OPTION' : 'TOO_MANY_VOTE_OPTIONS';

                        $message = $user->lang[$message] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id\">", '</a>');

                        trigger_error($message);

                }

                foreach ($voted_id as $option)

                {

                        if (in_array($option, $cur_voted_id))

                        {

                                continue;

                        }

                        $sql = 'UPDATE ' . POLL_OPTIONS_TABLE . "

                                SET poll_option_total = poll_option_total + 1

                                WHERE poll_option_id = $option

                                        AND topic_id = $topic_id";

                        $db->sql_query($sql);

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

                        {

                                $sql = 'INSERT INTO  ' . POLL_VOTES_TABLE . " (topic_id, poll_option_id, vote_user_id, vote_user_ip)

                                        VALUES ($topic_id, $option, " . $user->data['user_id'] . ", '$user->ip')";

                                $db->sql_query($sql);

                        }

                }

                foreach ($cur_voted_id as $option)

                {

                        if (!in_array($option, $voted_id))

                        {

                                $sql = 'UPDATE ' . POLL_OPTIONS_TABLE . "

                                        SET poll_option_total = poll_option_total - 1

                                        WHERE poll_option_id = $option

                                                AND topic_id = $topic_id";

                                $db->sql_query($sql);

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

                                {

                                        $sql = 'DELETE FROM ' . POLL_VOTES_TABLE . "

                                                WHERE topic_id = $topic_id

                                                        AND poll_option_id = $option

                                                        AND vote_user_id = " . $user->data['user_id'];

                                        $db->sql_query($sql);

                                }

                        }

                }

                if ($user->data['user_id'] == ANONYMOUS && !$user->data['is_bot'])

                {

                        $user->set_cookie('poll_' . $topic_id, implode(',', $voted_id), time() + 31536000);

                }

                $sql = 'UPDATE ' . TOPICS_TABLE . '

                        SET poll_last_vote = ' . time() . "

                        WHERE topic_id = $topic_id";

                //, topic_last_post_time = ' . time() . " -- for bumping topics with new votes, ignore for now

                $db->sql_query($sql);

                meta_refresh(5, "viewtopic.$phpEx$SID&f=$forum_id&t=$topic_id");

                $message = $user->lang['VOTE_SUBMITTED'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id\">", '</a>');

                trigger_error($message);

        }

        $poll_total = 0;

        foreach ($poll_info as $poll_option)

        {