diff options
Diffstat (limited to 'phpBB/modules/mcp/mcp_post.php')
| -rw-r--r-- | phpBB/modules/mcp/mcp_post.php | 497 |
1 files changed, 0 insertions, 497 deletions
diff --git a/phpBB/modules/mcp/mcp_post.php b/phpBB/modules/mcp/mcp_post.php deleted file mode 100644 index 2f3320dd07..0000000000 --- a/phpBB/modules/mcp/mcp_post.php +++ /dev/null @@ -1,497 +0,0 @@ -<?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; -} - -/** -* Handling actions in post details screen -*/ -function mcp_post_details($id, $mode, $action) -{ - phpbb::$user->add_lang('posting'); - - $post_id = request_var('p', 0); - $start = request_var('start', 0); - - // Get post data - $post_info = get_post_data(array($post_id), false, true); - - add_form_key('mcp_post_details'); - - if (!sizeof($post_info)) - { - trigger_error('POST_NOT_EXIST'); - } - - $post_info = $post_info[$post_id]; - $extra_url = extra_url(); - $url = ($extra_url) ? append_sid('mcp', extra_url()) : append_sid('mcp') . '?'; - - switch ($action) - { - case 'whois': - - if (phpbb::$acl->acl_get('m_info', $post_info['forum_id'])) - { - $ip = request_var('ip', ''); - include(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT); - - phpbb::$template->assign_vars(array( - 'RETURN_POST' => sprintf(phpbb::$user->lang['RETURN_POST'], '<a href="' . append_sid('mcp', "i=$id&mode=$mode&p=$post_id") . '">', '</a>'), - 'U_RETURN_POST' => append_sid('mcp', "i=$id&mode=$mode&p=$post_id"), - 'L_RETURN_POST' => sprintf(phpbb::$user->lang['RETURN_POST'], '', ''), - 'WHOIS' => user_ipwhois($ip), - )); - } - - // We're done with the whois page so return - return; - - break; - - case 'chgposter': - case 'chgposter_ip': - - if ($action == 'chgposter') - { - $username = request_var('username', '', true); - $sql_where = "username_clean = '" . phpbb::$db->sql_escape(utf8_clean_string($username)) . "'"; - } - else - { - $new_user_id = request_var('u', 0); - $sql_where = 'user_id = ' . $new_user_id; - } - - $sql = 'SELECT * - FROM ' . USERS_TABLE . ' - WHERE ' . $sql_where; - $result = phpbb::$db->sql_query($sql); - $row = phpbb::$db->sql_fetchrow($result); - phpbb::$db->sql_freeresult($result); - - if (!$row) - { - trigger_error('NO_USER'); - } - - if (phpbb::$acl->acl_get('m_chgposter', $post_info['forum_id'])) - { - if (check_form_key('mcp_post_details')) - { - change_poster($post_info, $row); - } - else - { - trigger_error('FORM_INVALID'); - } - } - - break; - } - - // Set some vars - $users_ary = $usernames_ary = array(); - $attachments = $extensions = array(); - $post_id = $post_info['post_id']; - $topic_tracking_info = array(); - - // Get topic tracking info - if (phpbb::$config['load_db_lastread']) - { - $tmp_topic_data = array($post_info['topic_id'] => $post_info); - $topic_tracking_info = get_topic_tracking($post_info['forum_id'], $post_info['topic_id'], $tmp_topic_data, array($post_info['forum_id'] => $post_info['forum_mark_time'])); - unset($tmp_topic_data); - } - else - { - $topic_tracking_info = get_complete_topic_tracking($post_info['forum_id'], $post_info['topic_id']); - } - - $post_unread = (isset($topic_tracking_info[$post_info['topic_id']]) && $post_info['post_time'] > $topic_tracking_info[$post_info['topic_id']]) ? true : false; - - // Process message, leave it uncensored - $message = $post_info['post_text']; - - if ($post_info['bbcode_bitfield']) - { - include_once(PHPBB_ROOT_PATH . 'includes/bbcode.' . PHP_EXT); - $bbcode = new bbcode($post_info['bbcode_bitfield']); - $bbcode->bbcode_second_pass($message, $post_info['bbcode_uid'], $post_info['bbcode_bitfield']); - } - - $message = bbcode_nl2br($message); - $message = smiley_text($message); - - if ($post_info['post_attachment'] && phpbb::$acl->acl_get('u_download') && phpbb::$acl->acl_get('f_download', $post_info['forum_id'])) - { - $extensions = phpbb_cache::obtain_extensions_forum($post_info['forum_id']); - - $sql = 'SELECT * - FROM ' . ATTACHMENTS_TABLE . ' - WHERE post_msg_id = ' . $post_id . ' - AND in_message = 0 - ORDER BY filetime DESC, post_msg_id ASC'; - $result = phpbb::$db->sql_query($sql); - - while ($row = phpbb::$db->sql_fetchrow($result)) - { - $attachments[] = $row; - } - phpbb::$db->sql_freeresult($result); - - if (sizeof($attachments)) - { - $update_count = array(); - parse_attachments($post_info['forum_id'], $message, $attachments, $update_count); - } - - // Display not already displayed Attachments for this post, we already parsed them. ;) - if (!empty($attachments)) - { - phpbb::$template->assign_var('S_HAS_ATTACHMENTS', true); - - foreach ($attachments as $attachment) - { - phpbb::$template->assign_block_vars('attachment', array( - 'DISPLAY_ATTACHMENT' => $attachment, - )); - } - } - } - - phpbb::$template->assign_vars(array( - 'U_MCP_ACTION' => "$url&i=main&quickmod=1", // Use this for mode paramaters - 'U_POST_ACTION' => "$url&i=$id&mode=post_details", // Use this for action parameters - 'U_APPROVE_ACTION' => append_sid('mcp', "i=queue&p=$post_id&f={$post_info['forum_id']}"), - - 'S_CAN_VIEWIP' => phpbb::$acl->acl_get('m_info', $post_info['forum_id']), - 'S_CAN_CHGPOSTER' => phpbb::$acl->acl_get('m_chgposter', $post_info['forum_id']), - 'S_CAN_LOCK_POST' => phpbb::$acl->acl_get('m_lock', $post_info['forum_id']), - 'S_CAN_DELETE_POST' => phpbb::$acl->acl_get('m_delete', $post_info['forum_id']), - - 'S_POST_REPORTED' => ($post_info['post_reported']) ? true : false, - 'S_POST_UNAPPROVED' => (!$post_info['post_approved']) ? true : false, - 'S_POST_LOCKED' => ($post_info['post_edit_locked']) ? true : false, - 'S_USER_NOTES' => true, - 'S_CLEAR_ALLOWED' => (phpbb::$acl->acl_get('a_clearlogs')) ? true : false, - - 'U_EDIT' => (phpbb::$acl->acl_get('m_edit', $post_info['forum_id'])) ? append_sid('posting', "mode=edit&f={$post_info['forum_id']}&p={$post_info['post_id']}") : '', - 'U_FIND_USERNAME' => append_sid('memberlist', 'mode=searchuser&form=mcp_chgposter&field=username&select_single=true'), - 'U_MCP_APPROVE' => append_sid('mcp', 'i=queue&mode=approve_details&f=' . $post_info['forum_id'] . '&p=' . $post_id), - 'U_MCP_REPORT' => append_sid('mcp', 'i=reports&mode=report_details&f=' . $post_info['forum_id'] . '&p=' . $post_id), - 'U_MCP_USER_NOTES' => append_sid('mcp', 'i=notes&mode=user_notes&u=' . $post_info['user_id']), - 'U_MCP_WARN_USER' => (phpbb::$acl->acl_get('m_warn')) ? append_sid('mcp', 'i=warn&mode=warn_user&u=' . $post_info['user_id']) : '', - 'U_VIEW_POST' => append_sid('viewtopic', 'f=' . $post_info['forum_id'] . '&p=' . $post_info['post_id'] . '#p' . $post_info['post_id']), - 'U_VIEW_TOPIC' => append_sid('viewtopic', 'f=' . $post_info['forum_id'] . '&t=' . $post_info['topic_id']), - - 'MINI_POST_IMG' => ($post_unread) ? phpbb::$user->img('icon_post_target_unread', 'NEW_POST') : phpbb::$user->img('icon_post_target', 'POST'), - - 'RETURN_TOPIC' => sprintf(phpbb::$user->lang['RETURN_TOPIC'], '<a href="' . append_sid('viewtopic', "f={$post_info['forum_id']}&p=$post_id") . "#p$post_id\">", '</a>'), - 'RETURN_FORUM' => sprintf(phpbb::$user->lang['RETURN_FORUM'], '<a href="' . append_sid('viewforum', "f={$post_info['forum_id']}&start={$start}") . '">', '</a>'), - 'REPORTED_IMG' => phpbb::$user->img('icon_topic_reported', 'POST_REPORTED'), - 'UNAPPROVED_IMG' => phpbb::$user->img('icon_topic_unapproved', 'POST_UNAPPROVED'), - 'EDIT_IMG' => phpbb::$user->img('icon_post_edit', 'EDIT_POST'), - 'SEARCH_IMG' => phpbb::$user->img('icon_user_search', 'SEARCH'), - - 'POST_AUTHOR_FULL' => get_username_string('full', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), - 'POST_AUTHOR_COLOUR' => get_username_string('colour', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), - 'POST_AUTHOR' => get_username_string('username', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), - 'U_POST_AUTHOR' => get_username_string('profile', $post_info['user_id'], $post_info['username'], $post_info['user_colour'], $post_info['post_username']), - - 'POST_PREVIEW' => $message, - 'POST_SUBJECT' => $post_info['post_subject'], - 'POST_DATE' => phpbb::$user->format_date($post_info['post_time']), - 'POST_IP' => $post_info['poster_ip'], - 'POST_IPADDR' => (phpbb::$acl->acl_get('m_info', $post_info['forum_id']) && request_var('lookup', '')) ? @gethostbyaddr($post_info['poster_ip']) : '', - 'POST_ID' => $post_info['post_id'], - - 'U_LOOKUP_IP' => (phpbb::$acl->acl_get('m_info', $post_info['forum_id'])) ? "$url&i=$id&mode=$mode&lookup={$post_info['poster_ip']}#ip" : '', - 'U_WHOIS' => (phpbb::$acl->acl_get('m_info', $post_info['forum_id'])) ? append_sid('mcp', "i=$id&mode=$mode&action=whois&p=$post_id&ip={$post_info['poster_ip']}") : '', - )); - - // Get User Notes - $log_data = array(); - $log_count = 0; - view_log('user', $log_data, $log_count, phpbb::$config['posts_per_page'], 0, 0, 0, $post_info['user_id']); - - if ($log_count) - { - phpbb::$template->assign_var('S_USER_NOTES', true); - - foreach ($log_data as $row) - { - phpbb::$template->assign_block_vars('usernotes', array( - 'REPORT_BY' => $row['username_full'], - 'REPORT_AT' => phpbb::$user->format_date($row['time']), - 'ACTION' => $row['action'], - 'ID' => $row['id'], - )); - } - } - - // Get Reports - if (phpbb::$acl->acl_get('m_', $post_info['forum_id'])) - { - $sql = 'SELECT r.*, re.*, u.user_id, u.username - FROM ' . REPORTS_TABLE . ' r, ' . USERS_TABLE . ' u, ' . REPORTS_REASONS_TABLE . " re - WHERE r.post_id = $post_id - AND r.reason_id = re.reason_id - AND u.user_id = r.user_id - ORDER BY r.report_time DESC"; - $result = phpbb::$db->sql_query($sql); - - if ($row = phpbb::$db->sql_fetchrow($result)) - { - phpbb::$template->assign_var('S_SHOW_REPORTS', true); - - do - { - // If the reason is defined within the language file, we will use the localized version, else just use the database entry... - if (isset(phpbb::$user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]) && isset(phpbb::$user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])])) - { - $row['reson_description'] = phpbb::$user->lang['report_reasons']['DESCRIPTION'][strtoupper($row['reason_title'])]; - $row['reason_title'] = phpbb::$user->lang['report_reasons']['TITLE'][strtoupper($row['reason_title'])]; - } - - phpbb::$template->assign_block_vars('reports', array( - 'REPORT_ID' => $row['report_id'], - 'REASON_TITLE' => $row['reason_title'], - 'REASON_DESC' => $row['reason_description'], - 'REPORTER' => ($row['user_id'] != ANONYMOUS) ? $row['username'] : phpbb::$user->lang['GUEST'], - 'U_REPORTER' => ($row['user_id'] != ANONYMOUS) ? append_sid('memberlist', 'mode=viewprofile&u=' . $row['user_id']) : '', - 'USER_NOTIFY' => ($row['user_notify']) ? true : false, - 'REPORT_TIME' => phpbb::$user->format_date($row['report_time']), - 'REPORT_TEXT' => bbcode_nl2br(trim($row['report_text'])), - )); - } - while ($row = phpbb::$db->sql_fetchrow($result)); - } - phpbb::$db->sql_freeresult($result); - } - - // Get IP - if (phpbb::$acl->acl_get('m_info', $post_info['forum_id'])) - { - $rdns_ip_num = request_var('rdns', ''); - - if ($rdns_ip_num != 'all') - { - phpbb::$template->assign_vars(array( - 'U_LOOKUP_ALL' => "$url&i=main&mode=post_details&rdns=all", - )); - } - - // Get other users who've posted under this IP - $sql = 'SELECT poster_id, COUNT(poster_id) as postings - FROM ' . POSTS_TABLE . " - WHERE poster_ip = '" . phpbb::$db->sql_escape($post_info['poster_ip']) . "' - GROUP BY poster_id - ORDER BY postings DESC"; - $result = phpbb::$db->sql_query($sql); - - while ($row = phpbb::$db->sql_fetchrow($result)) - { - // Fill the user select list with users who have posted under this IP - if ($row['poster_id'] != $post_info['poster_id']) - { - $users_ary[$row['poster_id']] = $row; - } - } - phpbb::$db->sql_freeresult($result); - - if (sizeof($users_ary)) - { - // Get the usernames - $sql = 'SELECT user_id, username - FROM ' . USERS_TABLE . ' - WHERE ' . phpbb::$db->sql_in_set('user_id', array_keys($users_ary)); - $result = phpbb::$db->sql_query($sql); - - while ($row = phpbb::$db->sql_fetchrow($result)) - { - $users_ary[$row['user_id']]['username'] = $row['username']; - $usernames_ary[utf8_clean_string($row['username'])] = $users_ary[$row['user_id']]; - } - phpbb::$db->sql_freeresult($result); - - foreach ($users_ary as $user_id => $user_row) - { - phpbb::$template->assign_block_vars('userrow', array( - 'USERNAME' => ($user_id == ANONYMOUS) ? phpbb::$user->lang['GUEST'] : $user_row['username'], - 'NUM_POSTS' => $user_row['postings'], - 'L_POST_S' => ($user_row['postings'] == 1) ? phpbb::$user->lang['POST'] : phpbb::$user->lang['POSTS'], - - 'U_PROFILE' => ($user_id == ANONYMOUS) ? '' : append_sid('memberlist', 'mode=viewprofile&u=' . $user_id), - 'U_SEARCHPOSTS' => append_sid('search', 'author_id=' . $user_id . '&sr=topics'), - )); - } - } - - // Get other IP's this user has posted under - - // A compound index on poster_id, poster_ip (posts table) would help speed up this query a lot, - // but the extra size is only valuable if there are persons having more than a thousands posts. - // This is better left to the really really big forums. - - $sql = 'SELECT poster_ip, COUNT(poster_ip) AS postings - FROM ' . POSTS_TABLE . ' - WHERE poster_id = ' . $post_info['poster_id'] . " - GROUP BY poster_ip - ORDER BY postings DESC"; - $result = phpbb::$db->sql_query($sql); - - while ($row = phpbb::$db->sql_fetchrow($result)) - { - $hostname = (($rdns_ip_num == $row['poster_ip'] || $rdns_ip_num == 'all') && $row['poster_ip']) ? @gethostbyaddr($row['poster_ip']) : ''; - - phpbb::$template->assign_block_vars('iprow', array( - 'IP' => $row['poster_ip'], - 'HOSTNAME' => $hostname, - 'NUM_POSTS' => $row['postings'], - 'L_POST_S' => ($row['postings'] == 1) ? phpbb::$user->lang['POST'] : phpbb::$user->lang['POSTS'], - - 'U_LOOKUP_IP' => ($rdns_ip_num == $row['poster_ip'] || $rdns_ip_num == 'all') ? '' : "$url&i=$id&mode=post_details&rdns={$row['poster_ip']}#ip", - 'U_WHOIS' => append_sid('mcp', "i=$id&mode=$mode&action=whois&p=$post_id&ip={$row['poster_ip']}"), - )); - } - phpbb::$db->sql_freeresult($result); - - $user_select = ''; - - if (sizeof($usernames_ary)) - { - ksort($usernames_ary); - - foreach ($usernames_ary as $row) - { - $user_select .= '<option value="' . $row['poster_id'] . '">' . $row['username'] . "</option>\n"; - } - } - - phpbb::$template->assign_var('S_USER_SELECT', $user_select); - } - -} - -/** -* Change a post's poster -*/ -function change_poster(&$post_info, $userdata) -{ - if (empty($userdata) || $userdata['user_id'] == $post_info['user_id']) - { - return; - } - - $post_id = $post_info['post_id']; - - $sql = 'UPDATE ' . POSTS_TABLE . " - SET poster_id = {$userdata['user_id']} - WHERE post_id = $post_id"; - phpbb::$db->sql_query($sql); - - // Resync topic/forum if needed - if ($post_info['topic_last_post_id'] == $post_id || $post_info['forum_last_post_id'] == $post_id || $post_info['topic_first_post_id'] == $post_id) - { - sync('topic', 'topic_id', $post_info['topic_id'], false, false); - sync('forum', 'forum_id', $post_info['forum_id'], false, false); - } - - // Adjust post counts... only if the post is approved (else, it was not added the users post count anyway) - if ($post_info['post_postcount'] && $post_info['post_approved']) - { - $sql = 'UPDATE ' . USERS_TABLE . ' - SET user_posts = user_posts - 1 - WHERE user_id = ' . $post_info['user_id'] .' - AND user_posts > 0'; - phpbb::$db->sql_query($sql); - - $sql = 'UPDATE ' . USERS_TABLE . ' - SET user_posts = user_posts + 1 - WHERE user_id = ' . $userdata['user_id']; - phpbb::$db->sql_query($sql); - } - - // Add posted to information for this topic for the new user - markread('post', $post_info['forum_id'], $post_info['topic_id'], time(), $userdata['user_id']); - - // Remove the dotted topic option if the old user has no more posts within this topic - if (phpbb::$config['load_db_track'] && $post_info['user_id'] != ANONYMOUS) - { - $sql = 'SELECT topic_id - FROM ' . POSTS_TABLE . ' - WHERE topic_id = ' . $post_info['topic_id'] . ' - AND poster_id = ' . $post_info['user_id']; - $result = phpbb::$db->sql_query_limit($sql, 1); - $topic_id = (int) phpbb::$db->sql_fetchfield('topic_id'); - phpbb::$db->sql_freeresult($result); - - if (!$topic_id) - { - $sql = 'DELETE FROM ' . TOPICS_POSTED_TABLE . ' - WHERE user_id = ' . $post_info['user_id'] . ' - AND topic_id = ' . $post_info['topic_id']; - phpbb::$db->sql_query($sql); - } - } - - // change the poster_id within the attachments table, else the data becomes out of sync and errors displayed because of wrong ownership - if ($post_info['post_attachment']) - { - $sql = 'UPDATE ' . ATTACHMENTS_TABLE . ' - SET poster_id = ' . $userdata['user_id'] . ' - WHERE poster_id = ' . $post_info['user_id'] . ' - AND post_msg_id = ' . $post_info['post_id'] . ' - AND topic_id = ' . $post_info['topic_id']; - phpbb::$db->sql_query($sql); - } - - // refresh search cache of this post - $search_type = basename(phpbb::$config['search_type']); - - if (file_exists(PHPBB_ROOT_PATH . 'includes/search/' . $search_type . '.' . PHP_EXT)) - { - require(PHPBB_ROOT_PATH . "includes/search/$search_type." . PHP_EXT); - - // We do some additional checks in the module to ensure it can actually be utilised - $error = false; - $search = new $search_type($error); - - if (!$error && method_exists($search, 'destroy_cache')) - { - $search->destroy_cache(array(), array($post_info['user_id'], $userdata['user_id'])); - } - } - - $from_username = $post_info['username']; - $to_username = $userdata['username']; - - // Renew post info - $post_info = get_post_data(array($post_id), false, true); - - if (!sizeof($post_info)) - { - trigger_error('POST_NOT_EXIST'); - } - - $post_info = $post_info[$post_id]; - - // Now add log entry - add_log('mod', $post_info['forum_id'], $post_info['topic_id'], 'LOG_MCP_CHANGE_POSTER', $post_info['topic_title'], $from_username, $to_username); -} - -?>
\ No newline at end of file |