phpBB/modules/ucp/ucp_pm_viewmessage.php

   1 <?php
   2 /**
   3 *
   4 * @package ucp
   5 * @version $Id$
   6 * @copyright (c) 2005 phpBB Group
   7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
   8 *
   9 */
  10
  11 /**
  12 * @ignore
  13 */
  14 if (!defined('IN_PHPBB'))
  15 {
  16         exit;
  17 }
  18
  19 /**
  20 * View private message
  21 */
  22 function view_message($id, $mode, $folder_id, $msg_id, $folder, $message_row)
  23 {
  24         global $user, $template, $auth, $db;
  25
  26         $user->add_lang(array('viewtopic', 'memberlist'));
  27
  28         $msg_id         = (int) $msg_id;
  29         $folder_id      = (int) $folder_id;
  30         $author_id      = (int) $message_row['author_id'];
  31
  32         // Not able to view message, it was deleted by the sender
  33         if ($message_row['pm_deleted'])
  34         {
  35                 $meta_info = append_sid('ucp', "i=pm&amp;folder=$folder_id");
  36                 $message = $user->lang['NO_AUTH_READ_REMOVED_MESSAGE'];
  37
  38                 $message .= '<br /><br />' . sprintf($user->lang['RETURN_FOLDER'], '<a href="' . $meta_info . '">', '</a>');
  39                 trigger_error($message);
  40         }
  41
  42         // Do not allow hold messages to be seen
  43         if ($folder_id == PRIVMSGS_HOLD_BOX)
  44         {
  45                 trigger_error('NO_AUTH_READ_HOLD_MESSAGE');
  46         }
  47
  48         // Grab icons
  49         $icons = phpbb_cache::obtain_icons();
  50
  51         $bbcode = false;
  52
  53         // Instantiate BBCode if need be
  54         if ($message_row['bbcode_bitfield'])
  55         {
  56                 include(PHPBB_ROOT_PATH . 'includes/bbcode.' . PHP_EXT);
  57                 $bbcode = new bbcode($message_row['bbcode_bitfield']);
  58         }
  59
  60         // Assign TO/BCC Addresses to template
  61         write_pm_addresses(array('to' => $message_row['to_address'], 'bcc' => $message_row['bcc_address']), $author_id);
  62
  63         $user_info = get_user_information($author_id, $message_row);
  64
  65         // Parse the message and subject
  66         $message = censor_text($message_row['message_text']);
  67
  68         // Second parse bbcode here
  69         if ($message_row['bbcode_bitfield'])
  70         {
  71                 $bbcode->bbcode_second_pass($message, $message_row['bbcode_uid'], $message_row['bbcode_bitfield']);
  72         }
  73
  74         // Always process smilies after parsing bbcodes
  75         $message = bbcode_nl2br($message);
  76         $message = smiley_text($message);
  77
  78         // Replace naughty words such as farty pants
  79         $message_row['message_subject'] = censor_text($message_row['message_subject']);
  80
  81         // Editing information
  82         if ($message_row['message_edit_count'] && phpbb::$config['display_last_edited'])
  83         {
  84                 $l_edit_time_total = ($message_row['message_edit_count'] == 1) ? $user->lang['EDITED_TIME_TOTAL'] : $user->lang['EDITED_TIMES_TOTAL'];
  85                 $l_edited_by = '<br /><br />' . sprintf($l_edit_time_total, (!$message_row['message_edit_user']) ? $message_row['username'] : $message_row['message_edit_user'], $user->format_date($message_row['message_edit_time'], false, true), $message_row['message_edit_count']);
  86         }
  87         else
  88         {
  89                 $l_edited_by = '';
  90         }
  91
  92         // Pull attachment data
  93         $display_notice = false;
  94         $attachments = array();
  95
  96         if ($message_row['message_attachment'] && phpbb::$config['allow_pm_attach'])
  97         {
  98                 if ($auth->acl_get('u_pm_download'))
  99                 {
 100                         $sql = 'SELECT *
 101                                 FROM ' . ATTACHMENTS_TABLE . "
 102                                 WHERE post_msg_id = $msg_id
 103                                         AND in_message = 1
 104                                 ORDER BY filetime DESC, post_msg_id ASC";
 105                         $result = $db->sql_query($sql);
 106
 107                         while ($row = $db->sql_fetchrow($result))
 108                         {
 109                                 $attachments[] = $row;
 110                         }
 111                         $db->sql_freeresult($result);
 112
 113                         // No attachments exist, but message table thinks they do so go ahead and reset attach flags
 114                         if (!sizeof($attachments))
 115                         {
 116                                 $sql = 'UPDATE ' . PRIVMSGS_TABLE . "
 117                                         SET message_attachment = 0
 118                                         WHERE msg_id = $msg_id";
 119                                 $db->sql_query($sql);
 120                         }
 121                 }
 122                 else
 123                 {
 124                         $display_notice = true;
 125                 }
 126         }
 127
 128         // Assign inline attachments
 129         if (!empty($attachments))
 130         {
 131                 $update_count = array();
 132                 parse_attachments(false, $message, $attachments, $update_count);
 133
 134                 // Update the attachment download counts
 135                 if (sizeof($update_count))
 136                 {
 137                         $sql = 'UPDATE ' . ATTACHMENTS_TABLE . '
 138                                 SET download_count = download_count + 1
 139                                 WHERE ' . $db->sql_in_set('attach_id', array_unique($update_count));
 140                         $db->sql_query($sql);
 141                 }
 142         }
 143
 144         $user_info['sig'] = '';
 145
 146         $signature = ($message_row['enable_sig'] && phpbb::$config['allow_sig'] && $auth->acl_get('u_sig') && $user->optionget('viewsigs')) ? $user_info['user_sig'] : '';
 147
 148         // End signature parsing, only if needed
 149         if ($signature)
 150         {
 151                 $signature = censor_text($signature);
 152
 153                 if ($user_info['user_sig_bbcode_bitfield'])
 154                 {
 155                         if ($bbcode === false)
 156                         {
 157                                 include(PHPBB_ROOT_PATH . 'includes/bbcode.' . PHP_EXT);
 158                                 $bbcode = new bbcode($user_info['user_sig_bbcode_bitfield']);
 159                         }
 160
 161                         $bbcode->bbcode_second_pass($signature, $user_info['user_sig_bbcode_uid'], $user_info['user_sig_bbcode_bitfield']);
 162                 }
 163
 164                 $signature = bbcode_nl2br($signature);
 165                 $signature = smiley_text($signature);
 166         }
 167
 168         $url = append_sid('ucp', 'i=pm');
 169
 170         $template->assign_vars(array(
 171                 'MESSAGE_AUTHOR_FULL'           => get_username_string('full', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),
 172                 'MESSAGE_AUTHOR_COLOUR'         => get_username_string('colour', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),
 173                 'MESSAGE_AUTHOR'                        => get_username_string('username', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),
 174                 'U_MESSAGE_AUTHOR'                      => get_username_string('profile', $author_id, $user_info['username'], $user_info['user_colour'], $user_info['username']),
 175
 176                 'RANK_TITLE'            => $user_info['rank_title'],
 177                 'RANK_IMG'                      => $user_info['rank_image'],
 178                 'AUTHOR_AVATAR'         => (isset($user_info['avatar'])) ? $user_info['avatar'] : '',
 179                 'AUTHOR_JOINED'         => $user->format_date($user_info['user_regdate']),
 180                 'AUTHOR_POSTS'          => (!empty($user_info['user_posts'])) ? $user_info['user_posts'] : '',
 181                 'AUTHOR_FROM'           => (!empty($user_info['user_from'])) ? $user_info['user_from'] : '',
 182
 183                 'ONLINE_IMG'            => (!phpbb::$config['load_onlinetrack']) ? '' : ((isset($user_info['online']) && $user_info['online']) ? $user->img('icon_user_online', $user->lang['ONLINE']) : $user->img('icon_user_offline', $user->lang['OFFLINE'])),
 184                 'S_ONLINE'                      => (!phpbb::$config['load_onlinetrack']) ? false : ((isset($user_info['online']) && $user_info['online']) ? true : false),
 185                 'DELETE_IMG'            => $user->img('icon_post_delete', $user->lang['DELETE_MESSAGE']),
 186                 'INFO_IMG'                      => $user->img('icon_post_info', $user->lang['VIEW_PM_INFO']),
 187                 'PROFILE_IMG'           => $user->img('icon_user_profile', $user->lang['READ_PROFILE']),
 188                 'EMAIL_IMG'                     => $user->img('icon_contact_email', $user->lang['SEND_EMAIL']),
 189                 'QUOTE_IMG'                     => $user->img('icon_post_quote', $user->lang['POST_QUOTE_PM']),
 190                 'REPLY_IMG'                     => $user->img('button_pm_reply', $user->lang['POST_REPLY_PM']),
 191                 'EDIT_IMG'                      => $user->img('icon_post_edit', $user->lang['POST_EDIT_PM']),
 192                 'MINI_POST_IMG'         => $user->img('icon_post_target', $user->lang['PM']),
 193
 194                 'SENT_DATE'                     => $user->format_date($message_row['message_time']),
 195                 'SUBJECT'                       => $message_row['message_subject'],
 196                 'MESSAGE'                       => $message,
 197                 'SIGNATURE'                     => ($message_row['enable_sig']) ? $signature : '',
 198                 'EDITED_MESSAGE'        => $l_edited_by,
 199                 'MESSAGE_ID'            => $message_row['msg_id'],
 200
 201                 'U_PM'                  => (phpbb::$config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_info['user_allow_pm'] || $auth->acl_gets('a_', 'm_') || $auth->acl_getf_global('m_'))) ? append_sid('ucp', 'i=pm&amp;mode=compose&amp;u=' . $author_id) : '',
 202                 'U_WWW'                 => (!empty($user_info['user_website'])) ? $user_info['user_website'] : '',
 203                 'U_ICQ'                 => ($user_info['user_icq']) ? 'http://www.icq.com/people/webmsg.php?to=' . urlencode($user_info['user_icq']) : '',
 204                 'U_AIM'                 => ($user_info['user_aim'] && $auth->acl_get('u_sendim')) ? append_sid('memberlist', 'mode=contact&amp;action=aim&amp;u=' . $author_id) : '',
 205                 'U_YIM'                 => ($user_info['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($user_info['user_yim']) . '&amp;.src=pg' : '',
 206                 'U_MSN'                 => ($user_info['user_msnm'] && $auth->acl_get('u_sendim')) ? append_sid('memberlist', 'mode=contact&amp;action=msnm&amp;u=' . $author_id) : '',
 207                 'U_JABBER'              => ($user_info['user_jabber'] && $auth->acl_get('u_sendim')) ? append_sid('memberlist', 'mode=contact&amp;action=jabber&amp;u=' . $author_id) : '',
 208
 209                 'U_DELETE'                      => ($auth->acl_get('u_pm_delete')) ? "$url&amp;mode=compose&amp;action=delete&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',
 210                 'U_EMAIL'                       => $user_info['email'],
 211                 'U_QUOTE'                       => ($auth->acl_get('u_sendpm') && $author_id != ANONYMOUS) ? "$url&amp;mode=compose&amp;action=quote&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',
 212                 'U_EDIT'                        => (($message_row['message_time'] > time() - (phpbb::$config['pm_edit_time'] * 60) || !phpbb::$config['pm_edit_time']) && $folder_id == PRIVMSGS_OUTBOX && $auth->acl_get('u_pm_edit')) ? "$url&amp;mode=compose&amp;action=edit&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',
 213                 'U_POST_REPLY_PM'       => ($auth->acl_get('u_sendpm') && $author_id != ANONYMOUS) ? "$url&amp;mode=compose&amp;action=reply&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '',
 214                 'U_PREVIOUS_PM'         => "$url&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] . "&amp;view=previous",
 215                 'U_NEXT_PM'                     => "$url&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] . "&amp;view=next",
 216
 217                 'S_HAS_ATTACHMENTS'     => (sizeof($attachments)) ? true : false,
 218                 'S_DISPLAY_NOTICE'      => $display_notice && $message_row['message_attachment'],
 219                 'S_AUTHOR_DELETED'      => ($author_id == ANONYMOUS) ? true : false,
 220                 'S_SPECIAL_FOLDER'      => in_array($folder_id, array(PRIVMSGS_NO_BOX, PRIVMSGS_OUTBOX)),
 221
 222                 'U_PRINT_PM'            => (phpbb::$config['print_pm'] && $auth->acl_get('u_pm_printpm')) ? "$url&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] . "&amp;view=print" : '',
 223                 'U_FORWARD_PM'          => (phpbb::$config['forward_pm'] && $auth->acl_get('u_sendpm') && $auth->acl_get('u_pm_forward')) ? "$url&amp;mode=compose&amp;action=forward&amp;f=$folder_id&amp;p=" . $message_row['msg_id'] : '')
 224         );
 225
 226         // Display not already displayed Attachments for this post, we already parsed them. ;)
 227         if (isset($attachments) && sizeof($attachments))
 228         {
 229                 foreach ($attachments as $attachment)
 230                 {
 231                         $template->assign_block_vars('attachment', array(
 232                                 'DISPLAY_ATTACHMENT'    => $attachment)
 233                         );
 234                 }
 235         }
 236
 237         if (request_var('view', '') != 'print')
 238         {
 239                 // Message History
 240                 if (message_history($msg_id, $user->data['user_id'], $message_row, $folder))
 241                 {
 242                         $template->assign_var('S_DISPLAY_HISTORY', true);
 243                 }
 244         }
 245 }
 246
 247 /**
 248 * Get user information (only for message display)
 249 */
 250 function get_user_information($user_id, $user_row)
 251 {
 252         global $db, $auth, $user;
 253
 254         if (!$user_id)
 255         {
 256                 return array();
 257         }
 258
 259         if (empty($user_row))
 260         {
 261                 $sql = 'SELECT *
 262                         FROM ' . USERS_TABLE . '
 263                         WHERE user_id = ' . (int) $user_id;
 264                 $result = $db->sql_query($sql);
 265                 $user_row = $db->sql_fetchrow($result);
 266                 $db->sql_freeresult($result);
 267         }
 268
 269         // Some standard values
 270         $user_row['online'] = false;
 271         $user_row['rank_title'] = $user_row['rank_image'] = $user_row['rank_image_src'] = $user_row['email'] = '';
 272
 273         // Generate online information for user
 274         if (phpbb::$config['load_onlinetrack'])
 275         {
 276                 $sql = 'SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline
 277                         FROM ' . SESSIONS_TABLE . "
 278                         WHERE session_user_id = $user_id
 279                         GROUP BY session_user_id";
 280                 $result = $db->sql_query_limit($sql, 1);
 281                 $row = $db->sql_fetchrow($result);
 282                 $db->sql_freeresult($result);
 283
 284                 $update_time = phpbb::$config['load_online_time'] * 60;
 285                 if ($row)
 286                 {
 287                         $user_row['online'] = (time() - $update_time < $row['online_time'] && ($row['viewonline'])) ? true : false;
 288                 }
 289         }
 290
 291         if (!function_exists('get_user_avatar'))
 292         {
 293                 include(PHPBB_ROOT_PATH . 'includes/functions_display.' . PHP_EXT);
 294         }
 295
 296         $user_row['avatar'] = ($user->optionget('viewavatars')) ? get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']) : '';
 297
 298         get_user_rank($user_id, $user_row['user_rank'], $user_row['user_posts'], $user_row['rank_title'], $user_row['rank_image'], $user_row['rank_image_src']);
 299
 300         if (!empty($user_row['user_allow_viewemail']) || $auth->acl_get('a_email'))
 301         {
 302                 $user_row['email'] = (phpbb::$config['board_email_form'] && phpbb::$config['email_enable']) ? append_sid('memberlist', "mode=email&amp;u=$user_id") : (((phpbb::$config['board_hide_emails'] && !$auth->acl_get('a_email')) || empty($user_row['user_email'])) ? '' : 'mailto:' . $user_row['user_email']);
 303         }
 304
 305         return $user_row;
 306 }
 307
 308 ?>