} else { $msg_id = $row['msg_id']; } } $sql = 'SELECT t.*, p.*, u.* FROM ' . FORUMS_PRIVMSGS_TO_TABLE . ' t, ' . FORUMS_PRIVMSGS_TABLE . ' p, ' . CORE_USERS_TABLE . ' u WHERE t.user_id = ' . $_CLASS['core_user']->data['user_id'] . "\n\t\t\t\t\tAND p.author_id = u.user_id\n\t\t\t\t\tAND t.folder_id = {$folder_id}\n\t\t\t\t\tAND t.msg_id = p.msg_id\n\t\t\t\t\tAND p.msg_id = {$msg_id}"; $result = $_CLASS['core_db']->query_limit($sql, 1); $message_row = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$message_row) { trigger_error('NO_MESSAGE'); } // Update unread status if ($message_row['pm_unread']) { set_read_status(true, $message_row['msg_id'], $_CLASS['core_user']->data['user_id'], $folder_id); } } $folder = get_folder($_CLASS['core_user']->data['user_id'], $folder_id); $s_folder_options = $s_to_folder_options = ''; foreach ($folder as $f_id => $folder_ary) { $option = '<option' . (!in_array($f_id, array(PRIVMSGS_INBOX, PRIVMSGS_OUTBOX, PRIVMSGS_SENTBOX)) ? ' class="blue"' : '') . ' value="' . $f_id . '"' . ($f_id == $folder_id ? ' selected="selected"' : '') . '>' . $folder_ary['folder_name'] . ($folder_ary['unread_messages'] ? ' [' . $folder_ary['unread_messages'] . '] ' : '') . '</option>'; $s_to_folder_options .= $f_id != PRIVMSGS_OUTBOX && $f_id != PRIVMSGS_SENTBOX ? $option : ''; $s_folder_options .= $option; } clean_sentbox($folder[PRIVMSGS_SENTBOX]['num_messages']); // Header for message view - folder and so on $folder_status = get_folder_status($folder_id, $folder); $_CLASS['core_template']->assign_array(array('CUR_FOLDER_ID' => $folder_id, 'CUR_FOLDER_NAME' => $folder_status['folder_name'], 'NUM_NOT_MOVED' => $num_not_moved, 'RELEASE_MESSAGE_INFO' => sprintf($_CLASS['core_user']->lang['RELEASE_MESSAGES'], '<a href="' . generate_link($this->link_parent . '&folder=' . $folder_id . '&release=1') . '">', '</a>'), 'NOT_MOVED_MESSAGES' => $num_not_moved == 1 ? $_CLASS['core_user']->lang['NOT_MOVED_MESSAGE'] : sprintf($_CLASS['core_user']->lang['NOT_MOVED_MESSAGES'], $num_not_moved), 'S_FOLDER_OPTIONS' => $s_folder_options, 'S_TO_FOLDER_OPTIONS' => $s_to_folder_options, 'S_FOLDER_ACTION' => generate_link($this->link_parent . '&mode=view&action=view_folder'), 'S_PM_ACTION' => generate_link($this->link_parent . '&mode=$mode&action=' . $action), 'U_INBOX' => generate_link($this->link_parent . '&folder=inbox'), 'U_OUTBOX' => generate_link($this->link_parent . '&folder=outbox'), 'U_SENTBOX' => generate_link($this->link_parent . '&folder=sentbox'), 'U_CREATE_FOLDER' => generate_link($this->link_parent . '&mode=options'), 'S_IN_INBOX' => $folder_id == PRIVMSGS_INBOX, 'S_IN_OUTBOX' => $folder_id == PRIVMSGS_OUTBOX, 'S_IN_SENTBOX' => $folder_id == PRIVMSGS_SENTBOX, 'FOLDER_STATUS' => $folder_status['message'], 'FOLDER_MAX_MESSAGES' => $folder_status['max'], 'FOLDER_CUR_MESSAGES' => $folder_status['cur'], 'FOLDER_REMAINING_MESSAGES' => $folder_status['remaining'], 'FOLDER_PERCENT' => $folder_status['percent'])); $_CLASS['core_template']->assign('S_VIEW_MESSAGE', false); if ($action === 'view_folder') {
function ucp_pm($id, $mode) { global $_CLASS, $config; $action = ''; if ($_CLASS['core_user']->data['user_id'] == ANONYMOUS) { trigger_error('NO_MESSAGE'); } $_CLASS['core_template']->assign_array(array('S_UNREAD' => false, 'TOTAL_MESSAGES' => false, 'S_DISPLAY_HISTORY' => false, 'S_BCC_RECIPIENT' => false)); // This is loaded 2x with drafts $_CLASS['core_user']->add_lang('posting', 'Forums'); $_CLASS['core_template']->assign('S_PRIVMSGS', true); // Folder directly specified? $folder_specified = get_variable('folder', 'REQUEST'); if ($folder_specified) { if (is_numeric($folder_specified)) { $folder_specified = (int) $folder_specified; } else { $folder_specified = $folder_specified === 'sentbox' ? PRIVMSGS_SENTBOX : ($folder_specified === 'outbox' ? PRIVMSGS_OUTBOX : PRIVMSGS_INBOX); } $mode = 'view_messages'; } else { $mode = !$mode ? get_variable('mode', 'REQUEST', 'view_messages') : $mode; } require SITE_FILE_ROOT . 'includes/forums/functions_privmsgs.php'; $_CLASS['core_template']->assign_array(array('L_TITLE' => $_CLASS['core_user']->lang['UCP_PM_' . strtoupper($mode)], 'S_UCP_ACTION' => generate_link("Control_Panel&i={$id}&mode={$mode}" . (isset($action) ? "&action={$action}" : '')))); switch ($mode) { // New private messages popup case 'popup': $indox_link = generate_link('Control_Panel&i=pm&folder=inbox'); if ($_CLASS['core_user']->data['user_new_privmsg']) { $l_new_message = $_CLASS['core_user']->data['user_new_privmsg'] == 1 ? $_CLASS['core_user']->lang['YOU_NEW_PM'] : $_CLASS['core_user']->lang['YOU_NEW_PMS']; } else { $l_new_message = $_CLASS['core_user']->lang['YOU_NO_NEW_PM']; } $_CLASS['core_template']->assign_array(array('MESSAGE' => $l_new_message, 'U_JS_RETURN_INBOX' => $indox_link, 'S_NOT_LOGGED_IN' => $_CLASS['core_user']->data['user_id'] == ANONYMOUS ? true : false, 'CLICK_TO_VIEW' => sprintf($_CLASS['core_user']->lang['CLICK_VIEW_PRIVMSG'], '<a href="' . $indox_link . '" onclick="jump_to_inbox();return false;" target="_new">', '</a>'), 'U_INBOX' => $indox_link)); $_CLASS['core_display']->display(false, 'modules/Control_Panel/ucp_pm_popup.html'); break; // Compose message // Compose message case 'compose': $action = request_var('action', 'post'); get_folder($_CLASS['core_user']->data['user_id'], $folder); if (!$_CLASS['auth']->acl_get('u_sendpm')) { trigger_error('NO_AUTH_SEND_MESSAGE'); } require SITE_FILE_ROOT . 'modules/Control_Panel/ucp/ucp_pm_compose.php'; compose_pm($id, $mode, $action); $_CLASS['core_display']->display(false, 'modules/Control_Panel/ucp_posting_body.html'); break; case 'options': $sql = 'SELECT group_message_limit FROM ' . GROUPS_TABLE . ' WHERE group_id = ' . $_CLASS['core_user']->data['user_group']; $result = $_CLASS['core_db']->query($sql); list($message_limit) = $_CLASS['core_db']->fetch_row_num($result); $_CLASS['core_db']->free_result($result); (int) ($_CLASS['core_user']->data['user_message_limit'] = !$message_limit ? $config['pm_max_msgs'] : $message_limit); get_folder($_CLASS['core_user']->data['user_id'], $folder); require SITE_FILE_ROOT . 'modules/Control_Panel/ucp/ucp_pm_options.php'; message_options($id, $mode, $global_privmsgs_rules, $global_rule_conditions); $_CLASS['core_display']->display(false, 'modules/Control_Panel/ucp_pm_options.html'); break; case 'drafts': get_folder($_CLASS['core_user']->data['user_id'], $folder); require SITE_FILE_ROOT . 'modules/Control_Panel/ucp/ucp_main.php'; $module = new ucp_main($id, $mode); unset($module); exit; break; case 'unread': case 'view_messages': /* if (!$_CLASS['auth']->acl_get('u_readpm')) { trigger_error('NO_AUTH_READ_MESSAGE'); } */ $sql = 'SELECT group_message_limit FROM ' . GROUPS_TABLE . ' WHERE group_id = ' . $_CLASS['core_user']->data['user_group']; $result = $_CLASS['core_db']->query($sql); list($message_limit) = $_CLASS['core_db']->fetch_row_num($result); $_CLASS['core_db']->free_result($result); $_CLASS['core_user']->data['user_message_limit'] = !$message_limit ? $config['pm_max_msgs'] : $message_limit; if ($folder_specified) { $folder_id = $folder_specified; $action = 'view_folder'; } else { $folder_id = get_variable('f', 'REQUEST', PRIVMSGS_INBOX, 'int'); $action = get_variable('action', 'REQUEST', 'view_folder'); } if ($folder_id === PRIVMSGS_NO_BOX) { $folder_id = PRIVMSGS_INBOX; } $msg_id = get_variable('p', 'REQUEST', 0, 'int'); $view = get_variable('view', 'REQUEST'); if ($msg_id && $action === 'view_folder') { $action = 'view_message'; } // First Handle Mark actions and moving messages // Move PM if (isset($_REQUEST['move_pm'])) { $msg_ids = isset($_POST['marked_msg_id']) ? array_unique(array_map('intval', $_POST['marked_msg_id'])) : array(); $cur_folder_id = get_variable('cur_folder_id', 'POST', PRIVMSGS_INBOX, 'int'); $dest_folder = get_variable('dest_folder', 'POST', PRIVMSGS_INBOX, 'int'); if (move_pm($_CLASS['core_user']->data['user_id'], $_CLASS['core_user']->data['user_message_limit'], $msg_ids, $dest_folder, $cur_folder_id)) { // Return to folder view if single message moved if ($action == 'view_message') { $msg_id = 0; $folder_id = $cur_folder_id; $action = 'view_folder'; } } } // Message Mark Options if (isset($_REQUEST['submit_mark'])) { $mark_option = get_variable('mark_option', 'POST'); $msg_ids = isset($_POST['marked_msg_id']) ? array_unique(array_map('intval', $_POST['marked_msg_id'])) : array(); $cur_folder_id = get_variable('cur_folder_id', 'POST', PRIVMSGS_INBOX, 'int'); switch ($mark_option) { case 'mark_read': case 'mark_unread': $read_status = $mark_option === 'mark_read'; set_read_status($read_status, $msg_ids, $_CLASS['core_user']->data['user_id'], $cur_folder_id); break; default: // redo this handle_mark_actions($_CLASS['core_user']->data['user_id'], $mark_option, $msg_ids, $cur_folder_id); break; } } // If new messages arrived, place them into the appropiate folder $num_not_moved = 0; if ($_CLASS['core_user']->data['user_new_privmsg'] && $action == 'view_folder') { place_pm_into_folder($global_privmsgs_rules, get_variable('release', 'POST', false)); $num_not_moved = $_CLASS['core_user']->data['user_new_privmsg']; } $message_row = array(); if ($mode == 'view_messages' && $action == 'view_message' && $msg_id) { // Get Message user want to see if ($view === 'next' || $view === 'previous') { if ($view === 'next') { $sql_condition = '>'; $sql_ordering = 'ASC'; } else { $sql_condition = '<'; $sql_ordering = 'DESC'; } // Redo this for sqlite $sql = 'SELECT t.msg_id FROM ' . FORUMS_PRIVMSGS_TO_TABLE . ' t, ' . FORUMS_PRIVMSGS_TABLE . ' p, ' . FORUMS_PRIVMSGS_TABLE . " p2\n\t\t\t\t\t\t\tWHERE p2.msg_id = {$msg_id}\n\t\t\t\t\t\t\t\tAND t.folder_id = {$folder_id}\n\t\t\t\t\t\t\t\tAND t.user_id = " . $_CLASS['core_user']->data['user_id'] . "\n\t\t\t\t\t\t\t\tAND t.msg_id = p.msg_id\n\t\t\t\t\t\t\t\tAND p.message_time {$sql_condition} p2.message_time\n\t\t\t\t\t\t\tORDER BY p.message_time {$sql_ordering}"; $result = $_CLASS['core_db']->query_limit($sql, 1); if (!($row = $_CLASS['core_db']->fetch_row_assoc($result))) { $message = $view == 'next' ? 'NO_NEWER_PM' : 'NO_OLDER_PM'; trigger_error($message); } else { $msg_id = $row['msg_id']; } $_CLASS['core_db']->free_result($result); } $sql = 'SELECT t.*, p.*, u.* FROM ' . FORUMS_PRIVMSGS_TO_TABLE . ' t, ' . FORUMS_PRIVMSGS_TABLE . ' p, ' . USERS_TABLE . ' u WHERE t.user_id = ' . $_CLASS['core_user']->data['user_id'] . "\n\t\t\t\t\t\t\tAND p.author_id = u.user_id\n\t\t\t\t\t\t\tAND t.folder_id = {$folder_id}\n\t\t\t\t\t\t\tAND t.msg_id = p.msg_id\n\t\t\t\t\t\t\tAND p.msg_id = {$msg_id}"; $result = $_CLASS['core_db']->query_limit($sql, 1); $message_row = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$message_row) { trigger_error('NO_MESSAGE'); } // Update unread status if ($message_row['unread']) { set_read_status(true, $message_row['msg_id'], $_CLASS['core_user']->data['user_id'], $folder_id); } } get_folder($_CLASS['core_user']->data['user_id'], $folder, $folder_id); $s_folder_options = $s_to_folder_options = ''; foreach ($folder as $f_id => $folder_ary) { $option = '<option' . (!in_array($f_id, array(PRIVMSGS_INBOX, PRIVMSGS_OUTBOX, PRIVMSGS_SENTBOX)) ? ' class="blue"' : '') . ' value="' . $f_id . '"' . ($f_id == $folder_id && $mode != 'unread' || $f_id === 'unread' && $mode == 'unread' ? ' selected="selected"' : '') . '>' . $folder_ary['folder_name'] . ($folder_ary['unread_messages'] ? ' [' . $folder_ary['unread_messages'] . '] ' : '') . '</option>'; $s_to_folder_options .= $f_id != PRIVMSGS_OUTBOX && $f_id != PRIVMSGS_SENTBOX ? $option : ''; $s_folder_options .= $option; } clean_sentbox($folder[PRIVMSGS_SENTBOX]['num_messages']); // Header for message view - folder and so on $folder_status = get_folder_status($folder_id, $folder); $url = 'Control_Panel&i=' . $id; $_CLASS['core_template']->assign_array(array('CUR_FOLDER_ID' => $folder_id, 'CUR_FOLDER_NAME' => $folder_status['folder_name'], 'NUM_NOT_MOVED' => $num_not_moved, 'RELEASE_MESSAGE_INFO' => sprintf($_CLASS['core_user']->lang['RELEASE_MESSAGES'], '<a href="' . generate_link($url . '&folder=' . $folder_id . '&release=1') . '">', '</a>'), 'NOT_MOVED_MESSAGES' => $num_not_moved == 1 ? $_CLASS['core_user']->lang['NOT_MOVED_MESSAGE'] : sprintf($_CLASS['core_user']->lang['NOT_MOVED_MESSAGES'], $num_not_moved), 'S_FOLDER_OPTIONS' => $s_folder_options, 'S_TO_FOLDER_OPTIONS' => $s_to_folder_options, 'S_FOLDER_ACTION' => generate_link($url . '&mode=view_messages&action=view_folder'), 'S_PM_ACTION' => generate_link("{$url}&mode={$mode}&action={$action}"), 'U_INBOX' => generate_link($url . '&folder=inbox'), 'U_OUTBOX' => generate_link($url . '&folder=outbox'), 'U_SENTBOX' => generate_link($url . '&folder=sentbox'), 'U_CREATE_FOLDER' => generate_link($url . '&mode=options'), 'S_IN_INBOX' => $folder_id == PRIVMSGS_INBOX ? true : false, 'S_IN_OUTBOX' => $folder_id == PRIVMSGS_OUTBOX ? true : false, 'S_IN_SENTBOX' => $folder_id == PRIVMSGS_SENTBOX ? true : false, 'FOLDER_STATUS' => $folder_status['message'], 'FOLDER_MAX_MESSAGES' => $folder_status['max'], 'FOLDER_CUR_MESSAGES' => $folder_status['cur'], 'FOLDER_REMAINING_MESSAGES' => $folder_status['remaining'], 'FOLDER_PERCENT' => $folder_status['percent'])); $_CLASS['core_template']->assign('S_VIEW_MESSAGE', false); if ($mode == 'unread' || $action == 'view_folder') { require SITE_FILE_ROOT . 'modules/Control_Panel/ucp/ucp_pm_viewfolder.php'; view_folder($id, $mode, $folder_id, $folder, $mode == 'unread' ? 'unread' : 'folder'); $_CLASS['core_display']->display(false, 'modules/Control_Panel/ucp_pm_viewfolder.html'); } elseif ($action == 'view_message') { $_CLASS['core_template']->assign_array(array('S_VIEW_MESSAGE' => true, 'MSG_ID' => $msg_id)); if (!$msg_id) { trigger_error('NO_MESSAGE'); } require SITE_FILE_ROOT . 'modules/Control_Panel/ucp/ucp_pm_viewmessage.php'; view_message($id, $mode, $folder_id, $msg_id, $folder, $message_row); $_CLASS['core_display']->display(false, 'modules/Control_Panel/' . ($view == 'print' ? 'ucp_pm_viewmessage_print.html' : 'ucp_pm_viewmessage.html')); } break; default: trigger_error('NO_ACTION_MODE'); break; } }