query('SELECT f.id AS fid, f.forum_name, f.moderators, f.redirect_url, fp.post_replies, fp.post_topics, t.id AS tid, t.subject, t.posted, t.first_post_id, t.sticky, t.closed, p.poster, p.poster_id, p.message, p.hide_smilies FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.id='.$id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); if (!$db->num_rows($result)) message($lang_common['Bad request']); $cur_post = $db->fetch_assoc($result); // Sort out who the moderators are and if we are currently a moderator (or an admin) $mods_array = ($cur_post['moderators'] != '') ? unserialize($cur_post['moderators']) : array(); $is_admmod = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_moderator'] == '1' && array_key_exists($pun_user['username'], $mods_array))) ? true : false; $can_edit_subject = $id == $cur_post['first_post_id']; if ($pun_config['o_censoring'] == '1') { $cur_post['subject'] = censor_words($cur_post['subject']); $cur_post['message'] = censor_words($cur_post['message']); } // Do we have permission to edit this post? if (($pun_user['g_edit_posts'] == '0' || $cur_post['poster_id'] != $pun_user['id'] || $cur_post['closed'] == '1') && !$is_admmod) message($lang_common['No permission']); // Load the post.php/edit.php language file require PUN_ROOT.'lang/'.$pun_user['language'].'/post.php'; // Start with a clean slate $errors = array(); if (isset($_POST['form_sent'])) { if ($is_admmod) confirm_referrer('edit.php'); // If it's a topic it must contain a subject if ($can_edit_subject) { $subject = pun_trim($_POST['req_subject']); if ($pun_config['o_censoring'] == '1') $censored_subject = pun_trim(censor_words($subject)); if ($subject == '') $errors[] = $lang_post['No subject']; else if ($pun_config['o_censoring'] == '1' && $censored_subject == '') $errors[] = $lang_post['No subject after censoring']; else if (pun_strlen($subject) > 70) $errors[] = $lang_post['Too long subject']; else if ($pun_config['p_subject_all_caps'] == '0' && is_all_uppercase($subject) && !$pun_user['is_admmod']) $errors[] = $lang_post['All caps subject']; } // Clean up message from POST $message = pun_linebreaks(pun_trim($_POST['req_message'])); // Here we use strlen() not pun_strlen() as we want to limit the post to PUN_MAX_POSTSIZE bytes, not characters if (strlen($message) > PUN_MAX_POSTSIZE) $errors[] = sprintf($lang_post['Too long message'], forum_number_format(PUN_MAX_POSTSIZE)); else if ($pun_config['p_message_all_caps'] == '0' && is_all_uppercase($message) && !$pun_user['is_admmod']) $errors[] = $lang_post['All caps message']; // Validate BBCode syntax if ($pun_config['p_message_bbcode'] == '1') { require PUN_ROOT.'include/parser.php'; $message = preparse_bbcode($message, $errors); } if (empty($errors)) { if ($message == '') $errors[] = $lang_post['No message']; else if ($pun_config['o_censoring'] == '1') { // Censor message to see if that causes problems $censored_message = pun_trim(censor_words($message)); if ($censored_message == '') $errors[] = $lang_post['No message after censoring']; } } $hide_smilies = isset($_POST['hide_smilies']) ? '1' : '0'; $stick_topic = isset($_POST['stick_topic']) ? '1' : '0'; if (!$is_admmod) $stick_topic = $cur_post['sticky']; // Did everything go according to plan? if (empty($errors) && !isset($_POST['preview'])) { $edited_sql = (!isset($_POST['silent']) || !$is_admmod) ? ', edited='.time().', edited_by=\''.$db->escape($pun_user['username']).'\'' : ''; require PUN_ROOT.'include/search_idx.php'; if ($can_edit_subject) { // Update the topic and any redirect topics $db->query('UPDATE '.$db->prefix.'topics SET subject=\''.$db->escape($subject).'\', sticky='.$stick_topic.' WHERE id='.$cur_post['tid'].' OR moved_to='.$cur_post['tid']) or error('Unable to update topic', __FILE__, __LINE__, $db->error()); // We changed the subject, so we need to take that into account when we update the search words update_search_index('edit', $id, $message, $subject); } else update_search_index('edit', $id, $message); // Update the post $db->query('UPDATE '.$db->prefix.'posts SET message=\''.$db->escape($message).'\', hide_smilies='.$hide_smilies.$edited_sql.' WHERE id='.$id) or error('Unable to update post', __FILE__, __LINE__, $db->error()); redirect('viewtopic.php?pid='.$id.'#p'.$id, $lang_post['Edit redirect']); } } $page_title = array(pun_htmlspecialchars($pun_config['o_board_title']), $lang_post['Edit post']); $required_fields = array('req_subject' => $lang_common['Subject'], 'req_message' => $lang_common['Message']); $focus_element = array('edit', 'req_message'); define('PUN_ACTIVE_PAGE', 'index'); require PUN_ROOT.'header.php'; $cur_index = 1; ?>