1. /data/phpBB
  2. includes
  3. ucp
  4. ucp_main.php
 
Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 3
 CRAP
0.00% covered (danger)
0.00%
0 / 732
ucp_main
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 3
 19182
0.00% covered (danger)
0.00%
0 / 728
 __construct
0.00% covered (danger)
0.00%
0 / 1
 2
0.00% covered (danger)
0.00%
0 / 3
 main
0.00% covered (danger)
0.00%
0 / 1
 12210
0.00% covered (danger)
0.00%
0 / 543
 assign_topiclist
0.00% covered (danger)
0.00%
0 / 1
 756
0.00% covered (danger)
0.00%
0 / 182
<?php
/**
*
* This file is part of the phpBB Forum Software package.
*
* @copyright (c) phpBB Limited <https://www.phpbb.com>
* @license GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
    exit;
}
/**
* ucp_main
* UCP Front Panel
*/
class ucp_main
{
    var $p_master;
    var $u_action;
    function __construct($p_master)
    {
        $this->p_master = $p_master;
    }
    function main($id, $mode)
    {
        global $config, $db, $user, $auth, $template, $phpbb_root_path, $phpEx, $phpbb_dispatcher;
        global $request;
        switch ($mode)
        {
            case 'front':
                $user->add_lang('memberlist');
                $sql_from = TOPICS_TABLE . ' t ';
                $sql_select = '';
                if ($config['load_db_track'])
                {
                    $sql_from .= ' LEFT JOIN ' . TOPICS_POSTED_TABLE . ' tp ON (tp.topic_id = t.topic_id
                        AND tp.user_id = ' . $user->data['user_id'] . ')';
                    $sql_select .= ', tp.topic_posted';
                }
                if ($config['load_db_lastread'])
                {
                    $sql_from .= ' LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.topic_id = t.topic_id
                        AND tt.user_id = ' . $user->data['user_id'] . ')';
                    $sql_select .= ', tt.mark_time';
                    $sql_from .= ' LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.forum_id = t.forum_id
                        AND ft.user_id = ' . $user->data['user_id'] . ')';
                    $sql_select .= ', ft.mark_time AS forum_mark_time';
                }
                $topic_type = $user->lang['VIEW_TOPIC_GLOBAL'];
                $folder = 'global_read';
                $folder_new = 'global_unread';
                // Get cleaned up list... return only those forums having the f_read permission
                $forum_ary = $auth->acl_getf('f_read', true);
                $forum_ary = array_unique(array_keys($forum_ary));
                $topic_list = $rowset = array();
                // If the user can't see any forums, he can't read any posts because fid of 0 is invalid
                if (!empty($forum_ary))
                {
                    /**
                     * Modify sql variables before query is processed
                     *
                     * @event core.ucp_main_front_modify_sql
                     * @var string    sql_select    SQL select
                     * @var string  sql_from    SQL from
                     * @var array   forum_ary    Forum array
                     * @since 3.2.4-RC1
                     */
                    $vars = array(
                        'sql_select',
                        'sql_from',
                        'forum_ary',
                    );
                    extract($phpbb_dispatcher->trigger_event('core.ucp_main_front_modify_sql', compact($vars)));
                    $sql = "SELECT t.* $sql_select
                        FROM $sql_from
                        WHERE t.topic_type = " . POST_GLOBAL . '
                            AND ' . $db->sql_in_set('t.forum_id', $forum_ary) . '
                        ORDER BY t.topic_last_post_time DESC, t.topic_last_post_id DESC';
                    $result = $db->sql_query($sql);
                    while ($row = $db->sql_fetchrow($result))
                    {
                        $topic_list[] = $row['topic_id'];
                        $rowset[$row['topic_id']] = $row;
                    }
                    $db->sql_freeresult($result);
                }
                $topic_forum_list = array();
                foreach ($rowset as $t_id => $row)
                {
                    if (isset($forum_tracking_info[$row['forum_id']]))
                    {
                        $row['forum_mark_time'] = $forum_tracking_info[$row['forum_id']];
                    }
                    $topic_forum_list[$row['forum_id']]['forum_mark_time'] = ($config['load_db_lastread'] && $user->data['is_registered'] && isset($row['forum_mark_time'])) ? $row['forum_mark_time'] : 0;
                    $topic_forum_list[$row['forum_id']]['topics'][] = (int) $t_id;
                }
                $topic_tracking_info = $tracking_topics = array();
                if ($config['load_db_lastread'])
                {
                    foreach ($topic_forum_list as $f_id => $topic_row)
                    {
                        $topic_tracking_info += get_topic_tracking($f_id, $topic_row['topics'], $rowset, array($f_id => $topic_row['forum_mark_time']));
                    }
                }
                else
                {
                    foreach ($topic_forum_list as $f_id => $topic_row)
                    {
                        $topic_tracking_info += get_complete_topic_tracking($f_id, $topic_row['topics']);
                    }
                }
                unset($topic_forum_list);
                foreach ($topic_list as $topic_id)
                {
                    $row = &$rowset[$topic_id];
                    $forum_id = $row['forum_id'];
                    $topic_id = $row['topic_id'];
                    $unread_topic = (isset($topic_tracking_info[$topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$topic_id]) ? true : false;
                    $folder_img = ($unread_topic) ? $folder_new : $folder;
                    $folder_alt = ($unread_topic) ? 'UNREAD_POSTS' : (($row['topic_status'] == ITEM_LOCKED) ? 'TOPIC_LOCKED' : 'NO_UNREAD_POSTS');
                    if ($row['topic_status'] == ITEM_LOCKED)
                    {
                        $folder_img .= '_locked';
                    }
                    // Posted image?
                    if (!empty($row['topic_posted']) && $row['topic_posted'])
                    {
                        $folder_img .= '_mine';
                    }
                    $topicrow = array(
                        'FORUM_ID'                    => $forum_id,
                        'TOPIC_ID'                    => $topic_id,
                        'TOPIC_AUTHOR'                => get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                        'TOPIC_AUTHOR_COLOUR'        => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                        'TOPIC_AUTHOR_FULL'            => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                        'FIRST_POST_TIME'            => $user->format_date($row['topic_time']),
                        'LAST_POST_SUBJECT'            => censor_text($row['topic_last_post_subject']),
                        'LAST_POST_TIME'            => $user->format_date($row['topic_last_post_time']),
                        'LAST_VIEW_TIME'            => $user->format_date($row['topic_last_view_time']),
                        'LAST_POST_AUTHOR'            => get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                        'LAST_POST_AUTHOR_COLOUR'    => get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                        'LAST_POST_AUTHOR_FULL'        => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                        'TOPIC_TITLE'                => censor_text($row['topic_title']),
                        'TOPIC_TYPE'                => $topic_type,
                        'TOPIC_IMG_STYLE'        => $folder_img,
                        'TOPIC_FOLDER_IMG'        => $user->img($folder_img, $folder_alt),
                        'ATTACH_ICON_IMG'        => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment']) ? $user->img('icon_topic_attach', '') : '',
                        'S_USER_POSTED'        => (!empty($row['topic_posted']) && $row['topic_posted']) ? true : false,
                        'S_UNREAD'            => $unread_topic,
                        'U_TOPIC_AUTHOR'        => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                        'U_LAST_POST'            => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id&amp;p=" . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'],
                        'U_LAST_POST_AUTHOR'    => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                        'U_NEWEST_POST'            => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id&amp;view=unread") . '#unread',
                        'U_VIEW_TOPIC'            => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=$topic_id"),
                    );
                    /**
                     * Add template variables to a front topics row.
                     *
                     * @event core.ucp_main_front_modify_template_vars
                     * @var array    topicrow        Array containing the template variables for the row
                     * @var array   row                Array containing the subscribed forum row data
                     * @var int     forum_id        Forum ID
                     * @var string  folder_img        Folder image
                     * @var string  folder_alt      Alt text for the folder image
                     * @since 3.2.4-RC1
                     */
                    $vars = array(
                        'topicrow',
                        'row',
                        'forum_id',
                        'folder_img',
                        'folder_alt',
                    );
                    extract($phpbb_dispatcher->trigger_event('core.ucp_main_front_modify_template_vars', compact($vars)));
                    $template->assign_block_vars('topicrow', $topicrow);
                }
                if ($config['load_user_activity'])
                {
                    if (!function_exists('display_user_activity'))
                    {
                        include_once($phpbb_root_path . 'includes/functions_display.' . $phpEx);
                    }
                    display_user_activity($user->data);
                }
                // Do the relevant calculations
                $memberdays = max(1, round((time() - $user->data['user_regdate']) / 86400));
                $posts_per_day = $user->data['user_posts'] / $memberdays;
                $percentage = ($config['num_posts']) ? min(100, ($user->data['user_posts'] / $config['num_posts']) * 100) : 0;
                $template->assign_vars(array(
                    'USER_COLOR'        => (!empty($user->data['user_colour'])) ? $user->data['user_colour'] : '',
                    'JOINED'            => $user->format_date($user->data['user_regdate']),
                    'LAST_ACTIVE'            => (empty($last_active)) ? ' - ' : $user->format_date($last_active),
                    'WARNINGS'            => ($user->data['user_warnings']) ? $user->data['user_warnings'] : 0,
                    'POSTS'                => ($user->data['user_posts']) ? $user->data['user_posts'] : 0,
                    'POSTS_DAY'            => $user->lang('POST_DAY', $posts_per_day),
                    'POSTS_PCT'            => $user->lang('POST_PCT', $percentage),
//                    'S_GROUP_OPTIONS'    => $group_options,
                    'U_SEARCH_USER'        => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'author_id=' . $user->data['user_id'] . '&amp;sr=posts') : '',
                ));
            break;
            case 'subscribed':
                if (!function_exists('topic_status'))
                {
                    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
                }
                $user->add_lang('viewforum');
                add_form_key('ucp_front_subscribed');
                $unwatch = (isset($_POST['unwatch'])) ? true : false;
                /**
                 * Read and potentially modify the post data used to remove subscriptions to forums/topics
                 *
                 * @event core.ucp_main_subscribed_post_data
                 * @since 3.1.10-RC1
                 */
                $phpbb_dispatcher->dispatch('core.ucp_main_subscribed_post_data');
                if ($unwatch)
                {
                    if (check_form_key('ucp_front_subscribed'))
                    {
                        $forums = array_keys($request->variable('f', array(0 => 0)));
                        $topics = array_keys($request->variable('t', array(0 => 0)));
                        if (count($forums) || count($topics))
                        {
                            $l_unwatch = '';
                            if (count($forums))
                            {
                                $sql = 'DELETE FROM ' . FORUMS_WATCH_TABLE . '
                                    WHERE ' . $db->sql_in_set('forum_id', $forums) . '
                                        AND user_id = ' . $user->data['user_id'];
                                $db->sql_query($sql);
                                $l_unwatch .= '_FORUMS';
                            }
                            if (count($topics))
                            {
                                $sql = 'DELETE FROM ' . TOPICS_WATCH_TABLE . '
                                    WHERE ' . $db->sql_in_set('topic_id', $topics) . '
                                        AND user_id = ' . $user->data['user_id'];
                                $db->sql_query($sql);
                                $l_unwatch .= '_TOPICS';
                            }
                            $msg = $user->lang['UNWATCHED' . $l_unwatch];
                        }
                        else
                        {
                            $msg = $user->lang['NO_WATCHED_SELECTED'];
                        }
                    }
                    else
                    {
                        $msg = $user->lang['FORM_INVALID'];
                    }
                    $message = $msg . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&amp;mode=subscribed") . '">', '</a>');
                    meta_refresh(3, append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&amp;mode=subscribed"));
                    trigger_error($message);
                }
                $forbidden_forums = array();
                if ($config['allow_forum_notify'])
                {
                    $forbidden_forums = $auth->acl_getf('!f_read', true);
                    $forbidden_forums = array_unique(array_keys($forbidden_forums));
                    $sql_array = array(
                        'SELECT'    => 'f.*',
                        'FROM'        => array(
                            FORUMS_WATCH_TABLE    => 'fw',
                            FORUMS_TABLE        => 'f'
                        ),
                        'WHERE'        => 'fw.user_id = ' . $user->data['user_id'] . '
                            AND f.forum_id = fw.forum_id
                            AND ' . $db->sql_in_set('f.forum_id', $forbidden_forums, true, true),
                        'ORDER_BY'    => 'left_id'
                    );
                    if ($config['load_db_lastread'])
                    {
                        $sql_array['LEFT_JOIN'] = array(
                            array(
                                'FROM'    => array(FORUMS_TRACK_TABLE => 'ft'),
                                'ON'    => 'ft.user_id = ' . $user->data['user_id'] . ' AND ft.forum_id = f.forum_id'
                            )
                        );
                        $sql_array['SELECT'] .= ', ft.mark_time ';
                    }
                    else
                    {
                        $tracking_topics = $request->variable($config['cookie_name'] . '_track', '', true, \phpbb\request\request_interface::COOKIE);
                        $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();
                    }
                    /**
                     * Modify the query used to retrieve a list of subscribed forums
                     *
                     * @event core.ucp_main_subscribed_forums_modify_query
                     * @var array    sql_array           The subscribed forums query
                     * @var array   forbidden_forums   The list of forbidden forums
                     * @since 3.1.10-RC1
                     */
                    $vars = array(
                        'sql_array',
                        'forbidden_forums',
                    );
                    extract($phpbb_dispatcher->trigger_event('core.ucp_main_subscribed_forums_modify_query', compact($vars)));
                    $sql = $db->sql_build_query('SELECT', $sql_array);
                    $result = $db->sql_query($sql);
                    while ($row = $db->sql_fetchrow($result))
                    {
                        $forum_id = $row['forum_id'];
                        if ($config['load_db_lastread'])
                        {
                            $forum_check = (!empty($row['mark_time'])) ? $row['mark_time'] : $user->data['user_lastmark'];
                        }
                        else
                        {
                            $forum_check = (isset($tracking_topics['f'][$forum_id])) ? (int) (base_convert($tracking_topics['f'][$forum_id], 36, 10) + $config['board_startdate']) : $user->data['user_lastmark'];
                        }
                        $unread_forum = ($row['forum_last_post_time'] > $forum_check) ? true : false;
                        // Which folder should we display?
                        if ($row['forum_status'] == ITEM_LOCKED)
                        {
                            $folder_image = ($unread_forum) ? 'forum_unread_locked' : 'forum_read_locked';
                            $folder_alt = 'FORUM_LOCKED';
                        }
                        else
                        {
                            $folder_image = ($unread_forum) ? 'forum_unread' : 'forum_read';
                            $folder_alt = ($unread_forum) ? 'UNREAD_POSTS' : 'NO_UNREAD_POSTS';
                        }
                        // Create last post link information, if appropriate
                        if ($row['forum_last_post_id'])
                        {
                            $last_post_time = $user->format_date($row['forum_last_post_time']);
                            $last_post_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;p=" . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];
                        }
                        else
                        {
                            $last_post_time = $last_post_url = '';
                        }
                        $template_vars = array(
                            'FORUM_ID'                => $forum_id,
                            'FORUM_IMG_STYLE'        => $folder_image,
                            'FORUM_FOLDER_IMG'        => $user->img($folder_image, $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'] : '',
                            'FORUM_NAME'            => $row['forum_name'],
                            'FORUM_DESC'            => generate_text_for_display($row['forum_desc'], $row['forum_desc_uid'], $row['forum_desc_bitfield'], $row['forum_desc_options']),
                            'LAST_POST_SUBJECT'        => $row['forum_last_post_subject'],
                            'LAST_POST_TIME'        => $last_post_time,
                            'LAST_POST_AUTHOR'            => get_username_string('username', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
                            'LAST_POST_AUTHOR_COLOUR'    => get_username_string('colour', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
                            'LAST_POST_AUTHOR_FULL'        => get_username_string('full', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
                            'U_LAST_POST_AUTHOR'        => get_username_string('profile', $row['forum_last_poster_id'], $row['forum_last_poster_name'], $row['forum_last_poster_colour']),
                            'S_UNREAD_FORUM'        => $unread_forum,
                            'U_LAST_POST'            => $last_post_url,
                            'U_VIEWFORUM'            => append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id'])
                        );
                        /**
                         * Add template variables to a subscribed forum row.
                         *
                         * @event core.ucp_main_subscribed_forum_modify_template_vars
                         * @var array    template_vars    Array containing the template variables for the row
                         * @var array   row                Array containing the subscribed forum row data
                         * @var int     forum_id        Forum ID
                         * @var string  folder_image    Folder image
                         * @var string  folder_alt      Alt text for the folder image
                         * @var bool    unread_forum    Whether the forum has unread content or not
                         * @var string  last_post_time  The time of the most recent post, expressed as a formatted date string
                         * @var string  last_post_url   The URL of the most recent post in the forum
                         * @since 3.1.10-RC1
                         */
                        $vars = array(
                            'template_vars',
                            'row',
                            'forum_id',
                            'folder_image',
                            'folder_alt',
                            'unread_forum',
                            'last_post_time',
                            'last_post_url',
                        );
                        extract($phpbb_dispatcher->trigger_event('core.ucp_main_subscribed_forum_modify_template_vars', compact($vars)));
                        $template->assign_block_vars('forumrow', $template_vars);
                    }
                    $db->sql_freeresult($result);
                }
                // Subscribed Topics
                if ($config['allow_topic_notify'])
                {
                    if (empty($forbidden_forums))
                    {
                        $forbidden_forums = $auth->acl_getf('!f_read', true);
                        $forbidden_forums = array_unique(array_keys($forbidden_forums));
                    }
                    $this->assign_topiclist('subscribed', $forbidden_forums);
                }
                $template->assign_vars(array(
                    'S_TOPIC_NOTIFY'        => $config['allow_topic_notify'],
                    'S_FORUM_NOTIFY'        => $config['allow_forum_notify'],
                ));
            break;
            case 'bookmarks':
                if (!$config['allow_bookmarks'])
                {
                    $template->assign_vars(array(
                        'S_NO_DISPLAY_BOOKMARKS'    => true)
                    );
                    break;
                }
                if (!function_exists('topic_status'))
                {
                    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
                }
                $user->add_lang('viewforum');
                if (isset($_POST['unbookmark']))
                {
                    $s_hidden_fields = array('unbookmark' => 1);
                    $topics = (isset($_POST['t'])) ? array_keys($request->variable('t', array(0 => 0))) : array();
                    $url = $this->u_action;
                    if (!count($topics))
                    {
                        trigger_error('NO_BOOKMARKS_SELECTED');
                    }
                    foreach ($topics as $topic_id)
                    {
                        $s_hidden_fields['t'][$topic_id] = 1;
                    }
                    if (confirm_box(true))
                    {
                        $sql = 'DELETE FROM ' . BOOKMARKS_TABLE . '
                            WHERE user_id = ' . $user->data['user_id'] . '
                                AND ' . $db->sql_in_set('topic_id', $topics);
                        $db->sql_query($sql);
                        meta_refresh(3, $url);
                        $message = $user->lang['BOOKMARKS_REMOVED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $url . '">', '</a>');
                        trigger_error($message);
                    }
                    else
                    {
                        confirm_box(false, 'REMOVE_SELECTED_BOOKMARKS', build_hidden_fields($s_hidden_fields));
                    }
                }
                $forbidden_forums = $auth->acl_getf('!f_read', true);
                $forbidden_forums = array_unique(array_keys($forbidden_forums));
                $this->assign_topiclist('bookmarks', $forbidden_forums);
            break;
            case 'drafts':
                $pm_drafts = ($this->p_master->p_name == 'pm') ? true : false;
                $template->assign_var('S_SHOW_DRAFTS', true);
                $user->add_lang('posting');
                $edit        = (isset($_REQUEST['edit'])) ? true : false;
                $submit        = (isset($_POST['submit'])) ? true : false;
                $draft_id    = $request->variable('edit', 0);
                $delete        = (isset($_POST['delete'])) ? true : false;
                $s_hidden_fields = ($edit) ? '<input type="hidden" name="edit" value="' . $draft_id . '" />' : '';
                $draft_subject = $draft_message = '';
                add_form_key('ucp_draft');
                include_once($phpbb_root_path . 'includes/message_parser.' . $phpEx);
                $message_parser = new parse_message();
                if ($delete)
                {
                    if (check_form_key('ucp_draft'))
                    {
                        $drafts = array_keys($request->variable('d', array(0 => 0)));
                        if (count($drafts))
                        {
                            $sql = 'DELETE FROM ' . DRAFTS_TABLE . '
                                WHERE ' . $db->sql_in_set('draft_id', $drafts) . '
                                    AND user_id = ' . $user->data['user_id'];
                            $db->sql_query($sql);
                        }
                        $msg = $user->lang['DRAFTS_DELETED'];
                        unset($drafts);
                    }
                    else
                    {
                        $msg = $user->lang['FORM_INVALID'];
                    }
                    $message = $msg . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');
                    meta_refresh(3, $this->u_action);
                    trigger_error($message);
                }
                if ($submit && $edit)
                {
                    $draft_subject = $request->variable('subject', '', true);
                    $draft_message = $request->variable('message', '', true);
                    if (check_form_key('ucp_draft'))
                    {
                        if ($draft_message && $draft_subject)
                        {
                            // $auth->acl_gets can't be used here because it will check for global forum permissions in this case
                            // In general we don't need too harsh checking here for permissions, as this will be handled later when submitting
                            $bbcode_status = $auth->acl_get('u_pm_bbcode') || $auth->acl_getf_global('f_bbcode');
                            $smilies_status = $auth->acl_get('u_pm_smilies') || $auth->acl_getf_global('f_smilies');
                            $img_status = $auth->acl_get('u_pm_img') || $auth->acl_getf_global('f_img');
                            $flash_status = $auth->acl_get('u_pm_flash') || $auth->acl_getf_global('f_flash');
                            $message_parser->message = $draft_message;
                            $message_parser->parse($bbcode_status, $config['allow_post_links'], $smilies_status, $img_status, $flash_status, true, $config['allow_post_links']);
                            $draft_row = array(
                                'draft_subject' => $draft_subject,
                                'draft_message' => $message_parser->message,
                            );
                            $sql = 'UPDATE ' . DRAFTS_TABLE . '
                                SET ' . $db->sql_build_array('UPDATE', $draft_row) . "
                                WHERE draft_id = $draft_id
                                    AND user_id = " . $user->data['user_id'];
                            $db->sql_query($sql);
                            $message = $user->lang['DRAFT_UPDATED'] . '<br /><br />' . sprintf($user->lang['RETURN_UCP'], '<a href="' . $this->u_action . '">', '</a>');
                            meta_refresh(3, $this->u_action);
                            trigger_error($message);
                        }
                        else
                        {
                            $template->assign_var('ERROR', ($draft_message == '') ? $user->lang['EMPTY_DRAFT'] : (($draft_subject == '') ? $user->lang['EMPTY_DRAFT_TITLE'] : ''));
                        }
                    }
                    else
                    {
                        $template->assign_var('ERROR', $user->lang['FORM_INVALID']);
                    }
                }
                if (!$pm_drafts)
                {
                    $sql = 'SELECT d.*, f.forum_name
                        FROM ' . DRAFTS_TABLE . ' d, ' . FORUMS_TABLE . ' f
                        WHERE d.user_id = ' . $user->data['user_id'] . ' ' .
                            (($edit) ? "AND d.draft_id = $draft_id" : '') . '
                            AND f.forum_id = d.forum_id
                        ORDER BY d.save_time DESC';
                }
                else
                {
                    $sql = 'SELECT * FROM ' . DRAFTS_TABLE . '
                        WHERE user_id = ' . $user->data['user_id'] . ' ' .
                            (($edit) ? "AND draft_id = $draft_id" : '') . '
                            AND forum_id = 0
                            AND topic_id = 0
                        ORDER BY save_time DESC';
                }
                $result = $db->sql_query($sql);
                $draftrows = $topic_ids = array();
                while ($row = $db->sql_fetchrow($result))
                {
                    if ($row['topic_id'])
                    {
                        $topic_ids[] = (int) $row['topic_id'];
                    }
                    $draftrows[] = $row;
                }
                $db->sql_freeresult($result);
                if (count($topic_ids))
                {
                    $sql = 'SELECT topic_id, forum_id, topic_title
                        FROM ' . TOPICS_TABLE . '
                        WHERE ' . $db->sql_in_set('topic_id', array_unique($topic_ids));
                    $result = $db->sql_query($sql);
                    while ($row = $db->sql_fetchrow($result))
                    {
                        $topic_rows[$row['topic_id']] = $row;
                    }
                    $db->sql_freeresult($result);
                }
                unset($topic_ids);
                $template->assign_var('S_EDIT_DRAFT', $edit);
                $row_count = 0;
                foreach ($draftrows as $draft)
                {
                    $link_topic = $link_forum = $link_pm = false;
                    $insert_url = $view_url = $title = '';
                    if (isset($topic_rows[$draft['topic_id']]) && $auth->acl_get('f_read', $topic_rows[$draft['topic_id']]['forum_id']))
                    {
                        $link_topic = true;
                        $view_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topic_rows[$draft['topic_id']]['forum_id'] . '&amp;t=' . $draft['topic_id']);
                        $title = $topic_rows[$draft['topic_id']]['topic_title'];
                        $insert_url = append_sid("{$phpbb_root_path}posting.$phpEx", 'f=' . $topic_rows[$draft['topic_id']]['forum_id'] . '&amp;t=' . $draft['topic_id'] . '&amp;mode=reply&amp;d=' . $draft['draft_id']);
                    }
                    else if ($auth->acl_get('f_read', $draft['forum_id']))
                    {
                        $link_forum = true;
                        $view_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $draft['forum_id']);
                        $title = $draft['forum_name'];
                        $insert_url = append_sid("{$phpbb_root_path}posting.$phpEx", 'f=' . $draft['forum_id'] . '&amp;mode=post&amp;d=' . $draft['draft_id']);
                    }
                    else if ($pm_drafts)
                    {
                        $link_pm = true;
                        $insert_url = append_sid("{$phpbb_root_path}ucp.$phpEx", "i=$id&amp;mode=compose&amp;d=" . $draft['draft_id']);
                    }
                    if (!$submit)
                    {
                        $message_parser->message = $draft['draft_message'];
                        $message_parser->decode_message();
                        $draft_message = $message_parser->message;
                    }
                    $template_row = array(
                        'DATE'            => $user->format_date($draft['save_time']),
                        'DRAFT_MESSAGE'    => $draft_message,
                        'DRAFT_SUBJECT'    => ($submit) ? $draft_subject : $draft['draft_subject'],
                        'TITLE'            => $title,
                        'DRAFT_ID'    => $draft['draft_id'],
                        'FORUM_ID'    => $draft['forum_id'],
                        'TOPIC_ID'    => $draft['topic_id'],
                        'U_VIEW'        => $view_url,
                        'U_VIEW_EDIT'    => $this->u_action . '&amp;edit=' . $draft['draft_id'],
                        'U_INSERT'        => $insert_url,
                        'S_LINK_TOPIC'        => $link_topic,
                        'S_LINK_FORUM'        => $link_forum,
                        'S_LINK_PM'            => $link_pm,
                        'S_HIDDEN_FIELDS'    => $s_hidden_fields
                    );
                    $row_count++;
                    ($edit) ? $template->assign_vars($template_row) : $template->assign_block_vars('draftrow', $template_row);
                }
                if (!$edit)
                {
                    $template->assign_var('S_DRAFT_ROWS', $row_count);
                }
            break;
        }
        $template->assign_vars(array(
            'L_TITLE'            => $user->lang['UCP_MAIN_' . strtoupper($mode)],
            'S_DISPLAY_MARK_ALL'    => ($mode == 'watched' || ($mode == 'drafts' && !isset($_GET['edit']))) ? true : false,
            'S_HIDDEN_FIELDS'        => (isset($s_hidden_fields)) ? $s_hidden_fields : '',
            'S_UCP_ACTION'            => $this->u_action,
            'LAST_POST_IMG'            => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),
            'NEWEST_POST_IMG'        => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),
        ));
        // Set desired template
        $this->tpl_name = 'ucp_main_' . $mode;
        $this->page_title = 'UCP_MAIN_' . strtoupper($mode);
    }
    /**
    * Build and assign topiclist for bookmarks/subscribed topics
    */
    function assign_topiclist($mode = 'subscribed', $forbidden_forum_ary = array())
    {
        global $user, $db, $template, $config, $cache, $auth, $phpbb_root_path, $phpEx, $phpbb_container, $request, $phpbb_dispatcher;
        /* @var $pagination \phpbb\pagination */
        $pagination = $phpbb_container->get('pagination');
        $table = ($mode == 'subscribed') ? TOPICS_WATCH_TABLE : BOOKMARKS_TABLE;
        $start = $request->variable('start', 0);
        // Grab icons
        $icons = $cache->obtain_icons();
        $sql_array = array(
            'SELECT'    => 'COUNT(t.topic_id) as topics_count',
            'FROM'        => array(
                $table            => 'i',
                TOPICS_TABLE    => 't'
            ),
            'WHERE'        =>    'i.topic_id = t.topic_id
                AND i.user_id = ' . $user->data['user_id'] . '
                AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),
        );
        /**
         * Modify the query used to retrieve the count of subscribed/bookmarked topics
         *
         * @event core.ucp_main_topiclist_count_modify_query
         * @var array    sql_array              The subscribed/bookmarked topics query
         * @var array   forbidden_forum_ary   The list of forbidden forums
         * @var string  mode                  The type of topic list ('subscribed' or 'bookmarks')
         * @since 3.1.10-RC1
         */
        $vars = array(
            'sql_array',
            'forbidden_forum_ary',
            'mode',
        );
        extract($phpbb_dispatcher->trigger_event('core.ucp_main_topiclist_count_modify_query', compact($vars)));
        $sql = $db->sql_build_query('SELECT', $sql_array);
        $result = $db->sql_query($sql);
        $topics_count = (int) $db->sql_fetchfield('topics_count');
        $db->sql_freeresult($result);
        if ($topics_count)
        {
            $start = $pagination->validate_start($start, $config['topics_per_page'], $topics_count);
            $pagination->generate_template_pagination($this->u_action, 'pagination', 'start', $topics_count, $config['topics_per_page'], $start);
            $template->assign_vars(array(
                'TOTAL_TOPICS'    => $user->lang('VIEW_FORUM_TOPICS', (int) $topics_count),
            ));
        }
        if ($mode == 'subscribed')
        {
            $sql_array = array(
                'SELECT'    => 't.*, f.forum_name',
                'FROM'        => array(
                    TOPICS_WATCH_TABLE    => 'tw',
                    TOPICS_TABLE        => 't'
                ),
                'WHERE'        => 'tw.user_id = ' . $user->data['user_id'] . '
                    AND t.topic_id = tw.topic_id
                    AND ' . $db->sql_in_set('t.forum_id', $forbidden_forum_ary, true, true),
                'ORDER_BY'    => 't.topic_last_post_time DESC, t.topic_last_post_id DESC'
            );
            $sql_array['LEFT_JOIN'] = array();
        }
        else
        {
            $sql_array = array(
                'SELECT'    => 't.*, f.forum_name, b.topic_id as b_topic_id',
                'FROM'        => array(
                    BOOKMARKS_TABLE        => 'b',
                ),
                'WHERE'        => 'b.user_id = ' . $user->data['user_id'] . '
                    AND ' . $db->sql_in_set('f.forum_id', $forbidden_forum_ary, true, true),
                'ORDER_BY'    => 't.topic_last_post_time DESC, t.topic_last_post_id DESC'
            );
            $sql_array['LEFT_JOIN'] = array();
            $sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_TABLE => 't'), 'ON' => 'b.topic_id = t.topic_id');
        }
        $sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TABLE => 'f'), 'ON' => 't.forum_id = f.forum_id');
        if ($config['load_db_lastread'])
        {
            $sql_array['LEFT_JOIN'][] = array('FROM' => array(FORUMS_TRACK_TABLE => 'ft'), 'ON' => 'ft.forum_id = t.forum_id AND ft.user_id = ' . $user->data['user_id']);
            $sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_TRACK_TABLE => 'tt'), 'ON' => 'tt.topic_id = t.topic_id AND tt.user_id = ' . $user->data['user_id']);
            $sql_array['SELECT'] .= ', tt.mark_time, ft.mark_time AS forum_mark_time';
        }
        if ($config['load_db_track'])
        {
            $sql_array['LEFT_JOIN'][] = array('FROM' => array(TOPICS_POSTED_TABLE => 'tp'), 'ON' => 'tp.topic_id = t.topic_id AND tp.user_id = ' . $user->data['user_id']);
            $sql_array['SELECT'] .= ', tp.topic_posted';
        }
        /**
         * Modify the query used to retrieve the list of subscribed/bookmarked topics
         *
         * @event core.ucp_main_topiclist_modify_query
         * @var array    sql_array              The subscribed/bookmarked topics query
         * @var array   forbidden_forum_ary   The list of forbidden forums
         * @var string  mode                  The type of topic list ('subscribed' or 'bookmarks')
         * @since 3.1.10-RC1
         */
        $vars = array(
            'sql_array',
            'forbidden_forum_ary',
            'mode',
        );
        extract($phpbb_dispatcher->trigger_event('core.ucp_main_topiclist_modify_query', compact($vars)));
        $sql = $db->sql_build_query('SELECT', $sql_array);
        $result = $db->sql_query_limit($sql, $config['topics_per_page'], $start);
        $topic_list = $topic_forum_list = $global_announce_list = $rowset = array();
        while ($row = $db->sql_fetchrow($result))
        {
            $topic_id = (isset($row['b_topic_id'])) ? $row['b_topic_id'] : $row['topic_id'];
            $topic_list[] = $topic_id;
            $rowset[$topic_id] = $row;
            $topic_forum_list[$row['forum_id']]['forum_mark_time'] = ($config['load_db_lastread']) ? $row['forum_mark_time'] : 0;
            $topic_forum_list[$row['forum_id']]['topics'][] = $topic_id;
            if ($row['topic_type'] == POST_GLOBAL)
            {
                $global_announce_list[] = $topic_id;
            }
        }
        $db->sql_freeresult($result);
        $topic_tracking_info = array();
        if ($config['load_db_lastread'])
        {
            foreach ($topic_forum_list as $f_id => $topic_row)
            {
                $topic_tracking_info += get_topic_tracking($f_id, $topic_row['topics'], $rowset, array($f_id => $topic_row['forum_mark_time']));
            }
        }
        else
        {
            foreach ($topic_forum_list as $f_id => $topic_row)
            {
                $topic_tracking_info += get_complete_topic_tracking($f_id, $topic_row['topics']);
            }
        }
        /* @var $phpbb_content_visibility \phpbb\content_visibility */
        $phpbb_content_visibility = $phpbb_container->get('content.visibility');
        foreach ($topic_list as $topic_id)
        {
            $row = &$rowset[$topic_id];
            $forum_id = $row['forum_id'];
            $topic_id = (isset($row['b_topic_id'])) ? $row['b_topic_id'] : $row['topic_id'];
            $unread_topic = (isset($topic_tracking_info[$topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$topic_id]) ? true : false;
            // Replies
            $replies = $phpbb_content_visibility->get_count('topic_posts', $row, $forum_id) - 1;
            if ($row['topic_status'] == ITEM_MOVED && !empty($row['topic_moved_id']))
            {
                $topic_id = $row['topic_moved_id'];
            }
            // Get folder img, topic status/type related information
            $folder_img = $folder_alt = $topic_type = '';
            topic_status($row, $replies, $unread_topic, $folder_img, $folder_alt, $topic_type);
            $view_topic_url_params = "f=$forum_id&amp;t=$topic_id";
            $view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params);
            // Send vars to template
            $template_vars = array(
                'FORUM_ID'                    => $forum_id,
                'TOPIC_ID'                    => $topic_id,
                'FIRST_POST_TIME'            => $user->format_date($row['topic_time']),
                'LAST_POST_SUBJECT'            => $row['topic_last_post_subject'],
                'LAST_POST_TIME'            => $user->format_date($row['topic_last_post_time']),
                'LAST_VIEW_TIME'            => $user->format_date($row['topic_last_view_time']),
                'TOPIC_AUTHOR'                => get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                'TOPIC_AUTHOR_COLOUR'        => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                'TOPIC_AUTHOR_FULL'            => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                'U_TOPIC_AUTHOR'            => get_username_string('profile', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
                'LAST_POST_AUTHOR'            => get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                'LAST_POST_AUTHOR_COLOUR'    => get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                'LAST_POST_AUTHOR_FULL'        => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                'U_LAST_POST_AUTHOR'        => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
                'S_DELETED_TOPIC'    => (!$row['topic_id']) ? true : false,
                'REPLIES'            => $replies,
                'VIEWS'                => $row['topic_views'],
                'TOPIC_TITLE'        => censor_text($row['topic_title']),
                'TOPIC_TYPE'        => $topic_type,
                'FORUM_NAME'        => $row['forum_name'],
                'TOPIC_IMG_STYLE'        => $folder_img,
                'TOPIC_FOLDER_IMG'        => $user->img($folder_img, $folder_alt),
                'TOPIC_FOLDER_IMG_ALT'    => $user->lang[$folder_alt],
                'TOPIC_ICON_IMG'        => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['img'] : '',
                'TOPIC_ICON_IMG_WIDTH'    => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['width'] : '',
                'TOPIC_ICON_IMG_HEIGHT'    => (!empty($icons[$row['icon_id']])) ? $icons[$row['icon_id']]['height'] : '',
                'ATTACH_ICON_IMG'        => ($auth->acl_get('u_download') && $auth->acl_get('f_download', $forum_id) && $row['topic_attachment']) ? $user->img('icon_topic_attach', $user->lang['TOTAL_ATTACHMENTS']) : '',
                'S_TOPIC_TYPE'            => $row['topic_type'],
                'S_USER_POSTED'            => (!empty($row['topic_posted'])) ? true : false,
                'S_UNREAD_TOPIC'        => $unread_topic,
                'U_NEWEST_POST'            => append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params . '&amp;view=unread') . '#unread',
                '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),
            );
            /**
             * Add template variables to a subscribed/bookmarked topic row.
             *
             * @event core.ucp_main_topiclist_topic_modify_template_vars
             * @var array    template_vars    Array containing the template variables for the row
             * @var array   row                Array containing the subscribed/bookmarked topic row data
             * @var int     forum_id        ID of the forum containing the topic
             * @var int     topic_id        Topic ID
             * @var int     replies         Number of replies in the topic
             * @var string  topic_type      Topic type
             * @var string  folder_img      Folder image
             * @var string  folder_alt      Alt text for the folder image
             * @var array   icons           Array containing topic icons
             * @var bool    unread_topic    Whether the topic has unread content or not
             * @var string  view_topic_url  The URL of the topic
             * @since 3.1.10-RC1
             */
            $vars = array(
                'template_vars',
                'row',
                'forum_id',
                'topic_id',
                'replies',
                'topic_type',
                'folder_img',
                'folder_alt',
                'icons',
                'unread_topic',
                'view_topic_url',
            );
            extract($phpbb_dispatcher->trigger_event('core.ucp_main_topiclist_topic_modify_template_vars', compact($vars)));
            $template->assign_block_vars('topicrow', $template_vars);
            $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);
        }
    }
}