Просмотр архива PHPBB 3.0.14.RU


<?php
/**
*
* @package mcp
* @version $Id$
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
    exit;
}

/**
* MCP Front Panel
*/
function mcp_front_view($id, $mode, $action)
{
    global $phpEx, $phpbb_root_path, $config;
    global $template, $db, $user, $auth, $module;

    // Latest 5 unapproved
    if ($module->loaded('queue'))
    {
        $forum_list = array_values(array_intersect(get_forum_list('f_read'), get_forum_list('m_approve')));
        $post_list = array();
        $forum_names = array();

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

        $template->assign_var('S_SHOW_UNAPPROVED', (!empty($forum_list)) ? true : false);

        if (!empty($forum_list))
        {
            $sql = 'SELECT COUNT(post_id) AS total
                FROM ' . POSTS_TABLE . '
                WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
                    AND post_approved = 0';
            $result = $db->sql_query($sql);
            $total = (int) $db->sql_fetchfield('total');
            $db->sql_freeresult($result);

            if ($total)
            {
                $global_id = $forum_list[0];

                $sql = 'SELECT forum_id, forum_name
                    FROM ' . FORUMS_TABLE . '
                    WHERE ' . $db->sql_in_set('forum_id', $forum_list);
                $result = $db->sql_query($sql);

                while ($row = $db->sql_fetchrow($result))
                {
                    $forum_names[$row['forum_id']] = $row['forum_name'];
                }
                $db->sql_freeresult($result);

                $sql = 'SELECT post_id
                    FROM ' . POSTS_TABLE . '
                    WHERE forum_id IN (0, ' . implode(', ', $forum_list) . ')
                        AND post_approved = 0
                    ORDER BY post_time DESC';
                $result = $db->sql_query_limit($sql, 5);

                while ($row = $db->sql_fetchrow($result))
                {
                    $post_list[] = $row['post_id'];
                }
                $db->sql_freeresult($result);

                if (empty($post_list))
                {
                    $total = 0;
                }
            }

            if ($total)
            {
                $sql = 'SELECT p.post_id, p.post_subject, p.post_time, p.poster_id, p.post_username, u.username, u.username_clean, u.user_colour, t.topic_id, t.topic_title, t.topic_first_post_id, p.forum_id
                    FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t, ' . USERS_TABLE . ' u
                    WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '
                        AND t.topic_id = p.topic_id
                        AND p.poster_id = u.user_id
                    ORDER BY p.post_time DESC';
                $result = $db->sql_query($sql);

                while ($row = $db->sql_fetchrow($result))
                {
                    $global_topic = ($row['forum_id']) ? false : true;
                    if ($global_topic)
                    {
                        $row['forum_id'] = $global_id;
                    }

                    $template->assign_block_vars('unapproved', array(
                        'U_POST_DETAILS'    => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=approve_details&amp;f=' . $row['forum_id'] . '&amp;p=' . $row['post_id']),
                        'U_MCP_FORUM'        => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view&amp;f=' . $row['forum_id']) : '',
                        'U_MCP_TOPIC'        => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=topic_view&amp;f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),
                        'U_FORUM'            => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
                        'U_TOPIC'            => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

                        'AUTHOR_FULL'        => get_username_string('full', $row['poster_id'], $row['username'], $row['user_colour']),
                        'AUTHOR'            => get_username_string('username', $row['poster_id'], $row['username'], $row['user_colour']),
                        'AUTHOR_COLOUR'        => get_username_string('colour', $row['poster_id'], $row['username'], $row['user_colour']),
                        'U_AUTHOR'            => get_username_string('profile', $row['poster_id'], $row['username'], $row['user_colour']),

                        'FORUM_NAME'    => (!$global_topic) ? $forum_names[$row['forum_id']] : $user->lang['GLOBAL_ANNOUNCEMENT'],
                        'POST_ID'        => $row['post_id'],
                        'TOPIC_TITLE'    => $row['topic_title'],
                        'SUBJECT'        => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
                        'POST_TIME'        => $user->format_date($row['post_time']))
                    );
                }
                $db->sql_freeresult($result);
            }

            $s_hidden_fields = build_hidden_fields(array(
                'redirect'        => append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main' . (($forum_id) ? '&amp;f=' . $forum_id : ''))
            ));

            $template->assign_vars(array(
                'S_HIDDEN_FIELDS'        => $s_hidden_fields,
                'S_MCP_QUEUE_ACTION'    => append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue"),
            ));

            if ($total == 0)
            {
                $template->assign_vars(array(
                    'L_UNAPPROVED_TOTAL'        => $user->lang['UNAPPROVED_POSTS_ZERO_TOTAL'],
                    'S_HAS_UNAPPROVED_POSTS'    => false)
                );
            }
            else
            {
                $template->assign_vars(array(
                    'L_UNAPPROVED_TOTAL'        => ($total == 1) ? $user->lang['UNAPPROVED_POST_TOTAL'] : sprintf($user->lang['UNAPPROVED_POSTS_TOTAL'], $total),
                    'S_HAS_UNAPPROVED_POSTS'    => true)
                );
            }
        }
    }

    // Latest 5 reported
    if ($module->loaded('reports'))
    {
        $forum_list = array_values(array_intersect(get_forum_list('f_read'), get_forum_list('m_report')));

        $template->assign_var('S_SHOW_REPORTS', (!empty($forum_list)) ? true : false);

        if (!empty($forum_list))
        {
            $sql = 'SELECT COUNT(r.report_id) AS total
                FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p
                WHERE r.post_id = p.post_id
                    AND r.pm_id = 0
                    AND r.report_closed = 0
                    AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')';
            $result = $db->sql_query($sql);
            $total = (int) $db->sql_fetchfield('total');
            $db->sql_freeresult($result);

            if ($total)
            {
                $global_id = $forum_list[0];

                $sql = $db->sql_build_query('SELECT', array(
                    'SELECT'    => 'r.report_time, p.post_id, p.post_subject, p.post_time, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id, t.topic_id, t.topic_title, f.forum_id, f.forum_name',

                    'FROM'        => array(
                        REPORTS_TABLE            => 'r',
                        REPORTS_REASONS_TABLE    => 'rr',
                        TOPICS_TABLE            => 't',
                        USERS_TABLE                => array('u', 'u2'),
                        POSTS_TABLE                => 'p'
                    ),

                    'LEFT_JOIN'    => array(
                        array(
                            'FROM'    => array(FORUMS_TABLE => 'f'),
                            'ON'    => 'f.forum_id = p.forum_id'
                        )
                    ),

                    'WHERE'        => 'r.post_id = p.post_id
                        AND r.pm_id = 0
                        AND r.report_closed = 0
                        AND r.reason_id = rr.reason_id
                        AND p.topic_id = t.topic_id
                        AND r.user_id = u.user_id
                        AND p.poster_id = u2.user_id
                        AND p.forum_id IN (0, ' . implode(', ', $forum_list) . ')',

                    'ORDER_BY'    => 'p.post_time DESC'
                ));
                $result = $db->sql_query_limit($sql, 5);

                while ($row = $db->sql_fetchrow($result))
                {
                    $global_topic = ($row['forum_id']) ? false : true;
                    if ($global_topic)
                    {
                        $row['forum_id'] = $global_id;
                    }

                    $template->assign_block_vars('report', array(
                        'U_POST_DETAILS'    => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;p=' . $row['post_id'] . "&amp;i=reports&amp;mode=report_details"),
                        'U_MCP_FORUM'        => (!$global_topic) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . "&amp;i=$id&amp;mode=forum_view") : '',
                        'U_MCP_TOPIC'        => append_sid("{$phpbb_root_path}mcp.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id'] . "&amp;i=$id&amp;mode=topic_view"),
                        'U_FORUM'            => (!$global_topic) ? append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id']) : '',
                        'U_TOPIC'            => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&amp;t=' . $row['topic_id']),

                        'REPORTER_FULL'        => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
                        'REPORTER'            => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
                        'REPORTER_COLOUR'    => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
                        'U_REPORTER'        => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),

                        'AUTHOR_FULL'        => get_username_string('full', $row['author_id'], $row['author_name'], $row['author_colour']),
                        'AUTHOR'            => get_username_string('username', $row['author_id'], $row['author_name'], $row['author_colour']),
                        'AUTHOR_COLOUR'        => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),
                        'U_AUTHOR'            => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),

                        'FORUM_NAME'    => (!$global_topic) ? $row['forum_name'] : $user->lang['GLOBAL_ANNOUNCEMENT'],
                        'TOPIC_TITLE'    => $row['topic_title'],
                        'SUBJECT'        => ($row['post_subject']) ? $row['post_subject'] : $user->lang['NO_SUBJECT'],
                        'REPORT_TIME'    => $user->format_date($row['report_time']),
                        'POST_TIME'        => $user->format_date($row['post_time']),
                    ));
                }
            }

            if ($total == 0)
            {
                $template->assign_vars(array(
                    'L_REPORTS_TOTAL'    =>    $user->lang['REPORTS_ZERO_TOTAL'],
                    'S_HAS_REPORTS'        =>    false)
                );
            }
            else
            {
                $template->assign_vars(array(
                    'L_REPORTS_TOTAL'    => ($total == 1) ? $user->lang['REPORT_TOTAL'] : sprintf($user->lang['REPORTS_TOTAL'], $total),
                    'S_HAS_REPORTS'        => true)
                );
            }
        }
    }

    // Latest 5 reported PMs
    if ($module->loaded('pm_reports') && $auth->acl_getf_global('m_report'))
    {
        $template->assign_var('S_SHOW_PM_REPORTS', true);
        $user->add_lang(array('ucp'));

        $sql = 'SELECT COUNT(r.report_id) AS total
            FROM ' . REPORTS_TABLE . ' r, ' . PRIVMSGS_TABLE . ' p
            WHERE r.post_id = 0
                AND r.pm_id = p.msg_id
                AND r.report_closed = 0';
        $result = $db->sql_query($sql);
        $total = (int) $db->sql_fetchfield('total');
        $db->sql_freeresult($result);

        if ($total)
        {
            include($phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx);

            $sql = $db->sql_build_query('SELECT', array(
                'SELECT'    => 'r.report_id, r.report_time, p.msg_id, p.message_subject, p.message_time, p.to_address, p.bcc_address, u.username, u.username_clean, u.user_colour, u.user_id, u2.username as author_name, u2.username_clean as author_name_clean, u2.user_colour as author_colour, u2.user_id as author_id',

                'FROM'        => array(
                    REPORTS_TABLE            => 'r',
                    REPORTS_REASONS_TABLE    => 'rr',
                    USERS_TABLE                => array('u', 'u2'),
                    PRIVMSGS_TABLE                => 'p'
                ),

                'WHERE'        => 'r.pm_id = p.msg_id
                    AND r.post_id = 0
                    AND r.report_closed = 0
                    AND r.reason_id = rr.reason_id
                    AND r.user_id = u.user_id
                    AND p.author_id = u2.user_id',

                'ORDER_BY'    => 'p.message_time DESC'
            ));
            $result = $db->sql_query_limit($sql, 5);

            $pm_by_id = $pm_list = array();
            while ($row = $db->sql_fetchrow($result))
            {
                $pm_by_id[(int) $row['msg_id']] = $row;
                $pm_list[] = (int) $row['msg_id'];
            }

            $address_list = get_recipient_strings($pm_by_id);

            foreach ($pm_list as $message_id)
            {
                $row = $pm_by_id[$message_id];

                $template->assign_block_vars('pm_report', array(
                    'U_PM_DETAILS'    => append_sid("{$phpbb_root_path}mcp.$phpEx", 'r=' . $row['report_id'] . "&amp;i=pm_reports&amp;mode=pm_report_details"),

                    'REPORTER_FULL'        => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']),
                    'REPORTER'            => get_username_string('username', $row['user_id'], $row['username'], $row['user_colour']),
                    'REPORTER_COLOUR'    => get_username_string('colour', $row['user_id'], $row['username'], $row['user_colour']),
                    'U_REPORTER'        => get_username_string('profile', $row['user_id'], $row['username'], $row['user_colour']),

                    'PM_AUTHOR_FULL'        => get_username_string('full', $row['author_id'], $row['author_name'], $row['author_colour']),
                    'PM_AUTHOR'            => get_username_string('username', $row['author_id'], $row['author_name'], $row['author_colour']),
                    'PM_AUTHOR_COLOUR'        => get_username_string('colour', $row['author_id'], $row['author_name'], $row['author_colour']),
                    'U_PM_AUTHOR'            => get_username_string('profile', $row['author_id'], $row['author_name'], $row['author_colour']),

                    'PM_SUBJECT'        => $row['message_subject'],
                    'REPORT_TIME'        => $user->format_date($row['report_time']),
                    'PM_TIME'            => $user->format_date($row['message_time']),
                    'RECIPIENTS'        => implode(', ', $address_list[$row['msg_id']]),
                ));
            }
        }

        if ($total == 0)
        {
            $template->assign_vars(array(
                'L_PM_REPORTS_TOTAL'    =>    $user->lang['PM_REPORTS_ZERO_TOTAL'],
                'S_HAS_PM_REPORTS'        =>    false)
            );
        }
        else
        {
            $template->assign_vars(array(
                'L_PM_REPORTS_TOTAL'    => ($total == 1) ? $user->lang['PM_REPORT_TOTAL'] : sprintf($user->lang['PM_REPORTS_TOTAL'], $total),
                'S_HAS_PM_REPORTS'        => true)
            );
        }
    }

    // Latest 5 logs
    if ($module->loaded('logs'))
    {
        $forum_list = array_values(array_intersect(get_forum_list('f_read'), get_forum_list('m_')));

        if (!empty($forum_list))
        {
            // Add forum_id 0 for global announcements
            $forum_list[] = 0;

            $log_count = false;
            $log = array();
            view_log('mod', $log, $log_count, 5, 0, $forum_list);

            foreach ($log as $row)
            {
                $template->assign_block_vars('log', array(
                    'USERNAME'        => $row['username_full'],
                    'IP'            => $row['ip'],
                    'TIME'            => $user->format_date($row['time']),
                    'ACTION'        => $row['action'],
                    'U_VIEW_TOPIC'    => (!empty($row['viewtopic'])) ? $row['viewtopic'] : '',
                    'U_VIEWLOGS'    => (!empty($row['viewlogs'])) ? $row['viewlogs'] : '')
                );
            }
        }

        $template->assign_vars(array(
            'S_SHOW_LOGS'    => (!empty($forum_list)) ? true : false,
            'S_HAS_LOGS'    => (!empty($log)) ? true : false)
        );
    }

    $template->assign_var('S_MCP_ACTION', append_sid("{$phpbb_root_path}mcp.$phpEx"));
    make_jumpbox(append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&amp;mode=forum_view'), 0, false, 'm_', true);
}

?>