'.$lang_common['Required'].'') ?>
'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.closed, p.poster, p.poster_id, p.message, p.hide_smilies', 'FROM' => 'posts AS p', 'JOINS' => array( array( 'INNER JOIN' => 'topics AS t', 'ON' => 't.id=p.topic_id' ), array( 'INNER JOIN' => 'forums AS f', 'ON' => 'f.id=t.forum_id' ), array( 'LEFT JOIN' => '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 ); ($hook = get_hook('ed_qr_get_post_info')) ? eval($hook) : null; $result = $pun_db->query_build($query) or error(__FILE__, __LINE__); if (!$pun_db->num_rows($result)) message($lang_common['Bad request']); $cur_post = $pun_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(); $pun_page['is_admmod'] = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_moderator'] == '1' && array_key_exists($pun_user['username'], $mods_array))) ? true : false; // 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') && !$pun_page['is_admmod']) message($lang_common['No permission']); // Start with a clean slate $errors = array(); $can_edit_subject = ($id == $cur_post['first_post_id'] && (($pun_user['g_edit_subjects_interval'] == '0' || (time() - $cur_post['posted']) < $pun_user['g_edit_subjects_interval']) || $pun_page['is_admmod'])) ? true : false; if (isset($_POST['form_sent'])) { ($hook = get_hook('ed_form_submitted')) ? eval($hook) : null; // If it is a topic it must contain a subject if ($can_edit_subject) { $subject = trim($_POST['req_subject']); if ($subject == '') $errors[] = $lang_post['No subject']; else if (pun_strlen($subject) > 70) $errors[] = $lang_post['Too long subject']; else if ($pun_config['p_subject_all_caps'] == '0' && strtoupper($subject) == $subject && !$pun_page['is_admmod']) $subject = ucwords(strtolower($subject)); } // Clean up message from POST $message = pun_linebreaks(trim($_POST['req_message'])); if ($message == '') $errors[] = $lang_post['No message']; else if (strlen($message) > PUN_MAX_POSTSIZE) $errors[] = $lang_post['Too long message']; else if ($pun_config['p_message_all_caps'] == '0' && strtoupper($message) == $message && !$pun_page['is_admmod']) $message = ucwords(strtolower($message)); // Validate BBCode syntax if ($pun_config['p_message_bbcode'] == '1' && strpos($message, '[') !== false && strpos($message, ']') !== false) { require PUN_ROOT.'include/parser.php'; $message = preparse_bbcode($message, $errors); } $hide_smilies = isset($_POST['hide_smilies']) ? 1 : 0; ($hook = get_hook('ed_end_validation')) ? eval($hook) : null; // Did everything go according to plan? if (empty($errors) && !isset($_POST['preview'])) { ($hook = get_hook('ed_pre_post_edited')) ? eval($hook) : null; if ($db_type != 'mysql' && $db_type != 'mysqli') require PUN_ROOT.'include/search_idx.php'; if ($can_edit_subject) { // Update the topic and any redirect topics $query = array( 'UPDATE' => 'topics', 'SET' => 'subject=\''.$pun_db->escape($subject).'\'', 'WHERE' => 'id='.$cur_post['tid'].' OR moved_to='.$cur_post['tid'] ); ($hook = get_hook('ed_qr_update_subject')) ? eval($hook) : null; $pun_db->query_build($query) or error(__FILE__, __LINE__); // We changed the subject, so we need to take that into account when we update the search words if ($db_type != 'mysql' && $db_type != 'mysqli') update_search_index('edit', $id, $message, $subject); } else if ($db_type != 'mysql' && $db_type != 'mysqli') update_search_index('edit', $id, $message); // Update the post $query = array( 'UPDATE' => 'posts', 'SET' => 'message=\''.$pun_db->escape($message).'\', hide_smilies=\''.$hide_smilies.'\'', 'WHERE' => 'id='.$id ); if (!isset($_POST['silent']) || !$pun_page['is_admmod']) $query['SET'] .= ', edited='.time().', edited_by=\''.$pun_db->escape($pun_user['username']).'\''; ($hook = get_hook('ed_qr_update_post')) ? eval($hook) : null; $pun_db->query_build($query) or error(__FILE__, __LINE__); redirect(pun_link($pun_url['post'], $id), $lang_post['Edit redirect']); } } // Setup error messages if (!empty($errors)) { $pun_page['errors'] = array(); while (list(, $cur_error) = each($errors)) $pun_page['errors'][] = '
'.$lang_common['Required'].'') ?>