Post Merging Install

Post Merging v1.0.0
This modification allows you to merge selected posts from a topic: Create a new topic with selected posts Merge selected posts into another existing topic Merge selected posts into a single post
[ Top ]

Step 1 - Database Changes
This modification does not require any database changes.
[ Top ]

Step 2 - File Uploads
No files required to upload There are pre-modded files located in /Pre-Made Files/ if you are installing this on an un-modded forum. If you have a customized forum, the file edits are below.
[ Top ]

Step 3 - File Edits
There are multiple file edits required to make to your UseBB installation in order for this modification to work correctly. Please do the following edits below. // topic.php -> edit_topic.php -> lang_English.php -> various.tpl.php -> topic.tpl.php
Open File topic.php
FIND around line 365
$post_links[] = '<a href="'.$functions->make_url('post.php', array('topic' => $requested_topic, 'quotepost' => $postsdata['id'])).'" rel="nofollow">'.$lang['Quote'].'</a>';
BELOW add
if ( $functions->auth($topicdata['auth'], 'move', $topicdata['forum_id']) ) $post_links[] = '<input type="checkbox" name="postid[]" value="'.$postsdata['id'].'" />';
FIND around line 479
$action_links[] = '<a href="'.$functions->make_url('edit.php', array('topic' => $requested_topic, 'act' => 'sticky')).'">'.$lang['MakeSticky'].'</a>'; }
BELOW add
if ( $functions->auth($topicdata['auth'], 'move', $topicdata['forum_id']) && intval($functions->get_stats('viewable_forums')) > 1 ) $action_links[] = '<a href="javascript:document.sel_posts.submit();">Move posts</a>';
FIND around line 237
'page_links' => $page_links
ABOVE add
'form_begin' => '<form action="'.$functions->make_url('edit.php', array('topic' => $requested_topic,'act' => 'posts')).'" name="sel_posts" method="post">',
FIND around line 494
'action_links' => $action_links
ABOVE add
'form_end' => '</form>',
Open File sources/edit_topic.php
FIND around line 588
} elseif ( $_GET['act'] == 'move' ) {
ABOVE add
} elseif ( $_GET['act'] == 'posts' ) { // // Move posts // $session->update($_GET['act'].'topic:'.$_GET['topic']); // // Include the page header // require(ROOT_PATH.'sources/page_head.php'); // // Get topic information // $result = $db->query("SELECT t.id, t.topic_title, t.forum_id, t.count_replies, p.post_time, f.name AS forum_name, f.auth, f.last_topic_id FROM ".TABLE_PREFIX."topics t, ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."forums f WHERE t.forum_id = f.id AND p.id = t.last_post_id AND t.id = ".$_GET['topic']); $topicdata = $db->fetch_result($result); if ( !$topicdata['id'] ) { // // I didn't see that topic!? // header($_SERVER['SERVER_PROTOCOL'].' 404 Not Found'); $template->set_page_title($lang['Error']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Error'], 'content' => sprintf($lang['NoSuchTopic'], 'ID '.$_GET['topic']) )); } else { // // If the user is granted to move topics, they can move posts too // if ( $functions->auth($topicdata['auth'], 'move', $topicdata['forum_id']) ) { if ( isset($_POST['postid']) \|\| !empty($_POST['postid']) ) { $total_posts = count($_POST['postid']); $posts = implode(",",$_POST['postid']); } else { $total_posts = 0; $posts = ''; } // // Start some main form error catching. Before anything is submitted. // $merge_all_info = ''; $merge_all_disabled = ''; $new_topic_info = ''; $new_topic_disabled = ''; $existing_topic_disabled = ''; $no_posts_info = ''; if ( $total_posts <= 1 ) { $merge_all_info = $lang['MergeAllInfo']; $merge_all_disabled = 'disabled="disabled"'; } else { $merge_all_info = $lang['MergeAllInfo2'].$total_posts.$lang['MergeAllInfo3']; } if ( $total_posts-1 == $topicdata['count_replies'] ) { $new_topic_info = '<tr><td colspan="2" class="count">'.$lang['NewTopicInfo'].'</td></tr>'; $new_topic_disabled = 'disabled="disabled"'; } if ( $total_posts == 0 ) { $no_posts_info = '<tr><td colspan="2" class="count">'.$lang['NoPostInfo'].'</td></tr>'; $merge_all_disabled = 'disabled="disabled"'; $new_topic_disabled = 'disabled="disabled"'; $existing_topic_disabled = 'disabled="disabled"'; } // // Create a new topic from selected posts // if ( isset($_POST['new']) ) { $tmp = $_POST['total_posts']; // // Get new information // if ( !empty($_POST['new_forum_id']) && valid_int($_POST['new_forum_id']) && !empty($_POST['new_topic_name']) ) { if ( $topicdata['count_replies'] == $tmp-1 ) { // // dont allow any further, waste of resources, just move the whole topic // $template->set_page_title($lang['Error']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Error'], 'content' => $lang['NewTopicInfo'] )); } else { // // Update the old thread with the new post count & latest post id // $new_reply_count = ($topicdata['count_replies'] - $_POST['total_posts']); $result = $db->query("SELECT p.topic_id,p.id FROM ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."topics t WHERE p.topic_id = t.id AND t.forum_id = ".$topicdata['forum_id']." ORDER BY p.post_time ASC LIMIT 1"); $lasttopicdata = $db->fetch_result($result); $db->query("UPDATE ".TABLE_PREFIX."topics SET count_replies = $new_reply_count, last_post_id = ".$lasttopicdata['id']." WHERE id = ".$lasttopicdata['topic_id'].""); // // Create the new topic // $postid = explode(",",$_POST['new_posts']); $topic_first_post = $postid[0]; $topic_last_post = $postid[$_POST['total_posts']-1]; $new_forum_id = $_POST['new_forum_id']; $new_topic_title = $_POST['new_topic_name']; $new_replies = $_POST['total_posts']-1; $db->query("INSERT INTO ".TABLE_PREFIX."topics VALUES(NULL, ".$new_forum_id.", '".$new_topic_title."', $topic_first_post, $topic_last_post, $new_replies, 0, 0, 0)"); $inserted_topic_id = $db->last_id(); // // Update each of the posts to reflect the new topic id // $nposts = $_POST['new_posts']; $db->query("UPDATE ".TABLE_PREFIX."posts SET topic_id = $inserted_topic_id WHERE id IN ($nposts)"); // // Update old forum to put the posts down. Only if it's a different forum. // if ( $topicdata['forum_id'] != $new_forum_id ) { $addon = $_POST['total_posts']; $addonq = 'posts = posts+'.$addon.','; $db->query("UPDATE ".TABLE_PREFIX."forums SET posts = posts-$addon WHERE id = ".$topicdata['forum_id'].""); } else { $addon = ''; $addonq = ''; } $result = $db->query("UPDATE ".TABLE_PREFIX."forums SET topics = topics+1,$addonq last_topic_id = $inserted_topic_id WHERE id = $new_forum_id"); // // Update the global stats // $result = $db->query("UPDATE ".TABLE_PREFIX."stats SET content = content+1 WHERE name = 'topics'"); $template->set_page_title($lang['Note']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Note'], 'content' => $lang['SucessMsg1'].' <a href="'.$functions->make_url('topic.php', array('id' => $inserted_topic_id)).'">'.unhtml(stripslashes($new_topic_title)).'</a>' )); } } // // Merge selected posts into an existing topic // } elseif ( isset($_POST['merge']) ) { if ( !empty($_POST['existing_topic_id']) && valid_int($_POST['existing_topic_id']) && $topicdata['id'] != $_POST['existing_topic_id'] ) { $nposts = $_POST['new_posts']; $new_topic_id = $_POST['existing_topic_id']; // // Get info from the new topic ID // $result = $db->query("SELECT id,topic_title,forum_id,count_replies FROM ".TABLE_PREFIX."topics WHERE id = $new_topic_id"); $new_topicdata = $db->fetch_result($result); $new_forum_id = $new_topicdata['forum_id']; if ( !$new_topicdata['id'] ) { header($_SERVER['SERVER_PROTOCOL'].' 404 Not Found'); $template->set_page_title($lang['Error']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Error'], 'content' => sprintf($lang['NoSuchTopic'], 'ID '.$new_topic_id) )); } else { // // Update each of the posts to reflect the new topic id // $db->query("UPDATE ".TABLE_PREFIX."posts SET topic_id = $new_topic_id WHERE id IN ($nposts)"); // // Update the forum replies in both old and new forums. Only if it's a different forum. // if ( $topicdata['forum_id'] != $new_topicdata['forum_id'] ) { $addon = $_POST['total_posts']; $db->query("UPDATE ".TABLE_PREFIX."forums SET posts = posts-$addon WHERE id = ".$topicdata['forum_id'].""); $db->query("UPDATE ".TABLE_PREFIX."forums SET posts = posts+$addon WHERE id = ".$new_topicdata['forum_id'].""); } // // Only update the old topic if all posts weren't selected. Also update topic count correctly // if ( $topicdata['count_replies'] != $_POST['total_posts']-1 ) { $new_reply_count = $_POST['total_posts']; $forum = $topicdata['forum_id']; $db->query("UPDATE ".TABLE_PREFIX."topics SET count_replies = count_replies-$new_reply_count WHERE id = ".$topicdata['id'].""); } else { $forum = $new_topicdata['forum_id']; $db->query("UPDATE ".TABLE_PREFIX."forums SET topics = topics-1 WHERE id = ".$topicdata['forum_id'].""); $db->query("UPDATE ".TABLE_PREFIX."stats SET content = content-1 WHERE name = 'topics'"); $db->query("DELETE FROM ".TABLE_PREFIX."topics WHERE id = ".$topicdata['id'].""); // // Get the new last topic id if the topic was deleted // $result = $db->query("SELECT id FROM ".TABLE_PREFIX."topics WHERE forum_id = ".$topicdata['forum_id']." ORDER BY id DESC LIMIT 1"); $lasttopicdata = $db->fetch_result($result); if ( $lasttopicdata['id'] != null ) { $db->query("UPDATE ".TABLE_PREFIX."forums SET last_topic_id = ".$lasttopicdata['id']." WHERE id = ".$topicdata['forum_id'].""); } } // // Update old/new topic id with new last post info // $result = $db->query("SELECT p.topic_id,p.id FROM ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."topics t WHERE p.topic_id = t.id AND t.forum_id = $forum ORDER BY p.post_time DESC LIMIT 1"); $lasttopicdata = $db->fetch_result($result); $db->query("UPDATE ".TABLE_PREFIX."topics SET count_replies = count_replies+".$_POST['total_posts'].", last_post_id = ".$lasttopicdata['id']." WHERE id = ".$new_topicdata['id'].""); $template->set_page_title($lang['Note']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Note'], 'content' => $lang['SuccessMsg2'].' <a href="'.$functions->make_url('topic.php', array('id' => $new_topicdata['id'])).'">'.unhtml(stripslashes($new_topicdata['topic_title'])).'</a><br />'.$lang['SuccessMsgInfo'] )); } } else { $template->set_page_title($lang['Error']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Error'], 'content' => $lang['ErrorMsg1'] )); } // // Merge seletected posts into a single post // } elseif ( isset($_POST['merge_all']) ) { $nposts = $_POST['new_posts']; $total_posts = $_POST['total_posts']; $tmp = 1; $postsa = explode(",",$_POST['new_posts']); $destination_post = $postsa[0]; $new_content = ''; // // Get all the selected posts and save the post content // $result = $db->query("SELECT content FROM ".TABLE_PREFIX."posts WHERE id IN ($nposts) ORDER BY id ASC"); while ( $post_content = $db->fetch_result($result) ) { $new_content .= $post_content['content'].'\n\n'; } $db->query("UPDATE ".TABLE_PREFIX."posts SET content = '$new_content' WHERE id = $destination_post"); // // Remove each of the posts that were merged // $remove_posts = array(); array_shift($postsa); $remove_posts = implode(",", $postsa); $db->query("DELETE FROM ".TABLE_PREFIX."posts WHERE id IN ($remove_posts)"); // // Update the last post ID and new reply count // $drop_count = $total_posts-1; $db->query("UPDATE ".TABLE_PREFIX."topics SET count_replies = count_replies-$drop_count, last_post_id = $destination_post WHERE id = ".$topicdata['id'].""); // // Update the forum count // $db->query("UPDATE ".TABLE_PREFIX."forums SET posts = posts-$drop_count WHERE id = ".$topicdata['forum_id'].""); // // Update global stats // $new_count = $total_posts-1; $db->query("UPDATE ".TABLE_PREFIX."stats SET content = content-$new_count WHERE name = 'posts'"); $template->set_page_title($lang['Note']); $template->parse('msgbox', 'global', array( 'box_title' => $lang['Note'], 'content' => $lang['SuccessMsg3'].' <a href="'.$functions->make_url('topic.php', array('id' => $topicdata['id'])).'">'.unhtml(stripslashes($topicdata['topic_title'])).'</a>' )); } else { $template->set_page_title($lang['MovePosts']); $result = $db->query("SELECT c.id AS cat_id, c.name AS cat_name, f.id, f.name, f.auth FROM ".TABLE_PREFIX."cats c, ".TABLE_PREFIX."forums f WHERE c.id = f.cat_id ORDER BY c.sort_id ASC, c.name ASC, f.sort_id ASC, f.name ASC"); $forums = array(); while ( $forumdata = $db->fetch_result($result) ) { if ( $functions->auth($forumdata['auth'], 'view', $forumdata['id']) ) $forums[] = $forumdata; } if ( !count($forums) ) { $functions->redirect('topic.php', array('id' => $_GET['topic'])); } elseif ( count($forums) === 1 ) { $forumdata = $forums[0]; $new_forum_input = '<a href="'.$functions->make_url('forum.php', array('id' => $forumdata['id'])).'">'.unhtml(stripslashes($forumdata['name'])).'</a><input type="hidden" name="new_forum_id" value="'.$forumdata['id'].'" />'; } else { // // Get a list of available forums to move to // $new_forum_input = '<select name="new_forum_id" '.$new_topic_disabled.'>'; $seen_cats = array(); foreach ( $forums as $forumdata ) { if ( !in_array($forumdata['cat_id'], $seen_cats) ) { $new_forum_input .= ( !count($seen_cats) ) ? '' : '</optgroup>'; $new_forum_input .= '<optgroup label="'.unhtml(stripslashes($forumdata['cat_name'])).'">'; $seen_cats[] = $forumdata['cat_id']; } $new_forum_input .= '<option value="'.$forumdata['id'].'">'.unhtml(stripslashes($forumdata['name'])).'</option>'; } $new_forum_input .= '</optgroup></select>'; } $template->parse('move_selected_posts_main', 'various', array( 'form_begin' => '<form action="'.$functions->make_url('edit.php', array('topic' => $_GET['topic'], 'act' => 'posts')).'" method="post">', 'topic_v' => '<a href="'.$functions->make_url('topic.php', array('id' => $_GET['topic'])).'">'.unhtml(stripslashes($topicdata['topic_title'])).'</a>', 'old_forum_v' => '<a href="'.$functions->make_url('forum.php', array('id' => $topicdata['forum_id'])).'">'.unhtml(stripslashes($topicdata['forum_name'])).'</a>', 'new_forum_input' => $new_forum_input, 'total_posts' => $total_posts, 'hidden_inputs' => '<input type="hidden" value="'.$total_posts.'" name="total_posts" /><input type="hidden" value="'.$posts.'" name="new_posts" />', 'existing_topic_id' => '<input type="text" name="existing_topic_id" value="" size="5" '.$existing_topic_disabled.' />', 'board_url' => $functions->get_config('board_url'), 'new_topic_input' => '<input type="text" name="new_topic_name" '.$new_topic_disabled.' value="RE: '.unhtml(stripslashes($topicdata['topic_title'])).'" />', 'merge_all_info' => $merge_all_info, 'new_topic_info' => $new_topic_info, 'no_posts_info' => $no_posts_info, 'submit_button_new' => '<input type="submit" name="new" value="'.$lang['NewTopicButton'].'" '.$new_topic_disabled.' />', 'submit_button_merge' => '<input type="submit" name="merge" value="'.$lang['MergeExistingButton'].'" '.$existing_topic_disabled.' />', 'submit_button_merge_all' => '<input type="submit" name="merge_all" value="'.$lang['MergeAllButton'].'" '.$merge_all_disabled.' />', 'cancel_button' => '<input type="submit" value="'.$lang['Cancel'].'" />', 'form_end' => '</form>' )); } } } // // Include the page footer // require(ROOT_PATH.'sources/page_foot.php');
Open File languages/lang_English.php
FIND END of FILE
?>
ABOVE add
//Post Merging $lang['MovePosts'] = 'Move Posts'; $lang['MergeAllInfo'] = 'You need one or more selected posts inorder to continue with the post merge.'; $lang['MergeAllInfo2'] = 'You will be merging <strong>'; $lang['MergeAllInfo3'] = '</strong> posts together into a single post.'; $lang['NewTopicInfo'] = 'You cannot move all posts from a single topic. You must leave atleast one post.'; $lang['NoPostInfo'] = 'You have not selected any posts.'; $lang['SuccessMsg1'] = 'The selected posts have been merged into a new topic:'; $lang['SuccessMsg2'] = 'The selected posts have been merged into an existing topic:'; $lang['SuccessMsg3'] = 'Posts have been successfully merged:'; $lang['SuccessMsgInfo'] = 'If you merged all posts from the old topic, it has also been removed.'; $lang['ErrorMsg1'] = 'Either you did not choose a valid topic ID, or you tried to merge the same topics.'; $lang['NewTopicButton'] = 'Create New Topic'; $lang['MergeExistingButton'] = 'Merge To Existing Topic'; $lang['MergeAllButton'] = 'Merge Seletected Posts'; $lang['TotalPosts'] = 'Total Posts:'; $lang['CreateNewTopicHeading'] = 'Create a new topic using selected posts'; $lang['OldTopicTitle'] = 'Old topic'; $lang['NewTopicTitle'] = 'New topic title'; $lang['MergeExistingHeading'] = 'Merge selected posts into an existing topic'; $lang['ExistingTopicID'] = 'Existing topic ID'; $lang['MergeToOneHeading'] = 'Merge selected posts into one post';
Open File templates/*/various.tpl.php
FIND END of FILE
?>
ABOVE add
$templates['move_selected_posts_main'] = ' {form_begin} <table class="maintable"> <tr> <td class="forumcat" colspan="2">{l_TotalPosts} {total_posts}</td> </tr> {no_posts_info} <tr> <th colspan="2">{l_CreateNewTopicHeading}</th> </tr> <tr> <td class="fieldtitle">{l_OldTopicTitle}</td><td>{topic_v}</td> </tr> <tr> <td class="fieldtitle">{l_OldForum}</td><td>{old_forum_v}</td> </tr> <tr> <td class="fieldtitle">{l_NewForum}</td><td>{new_forum_input}</td> </tr> <tr> <td class="fieldtitle">{l_NewTopicTitle}</td><td>{new_topic_input}</td> </tr> {new_topic_info} <tr> <td colspan="2" class="formcontrols">{submit_button_new} {cancel_button}</td> </tr> <tr> <th colspan="2">{l_MergeExistingHeading}</th> </tr> <tr> <td class="fieldtitle">{l_OldTopicTitle}</td><td>{topic_v}</td> </tr> <tr> <td class="fieldtitle">{l_ExistingTopicID}</td><td>{existing_topic_id}<div class="moreinfo">{board_url}topic.php?id=<em><strong>##</strong></em></div></td> </tr> <tr> <td colspan="2" class="formcontrols">{submit_button_merge} {cancel_button}</td> </tr> <tr> <th colspan="2">{l_MergeToOneHeading}</th> </tr> <tr> <td class="fieldtitle">{l_Topic}</td><td>{topic_v}</td> </tr> <tr> <td colspan="2">{merge_all_info}{hidden_inputs}</td> </tr> <tr> <td colspan="2" class="formcontrols">{submit_button_merge_all} {cancel_button}</td> </tr> </table> {form_end}';
Open File templates/topic.tpl.php
FIND around line 40
<p id="pagelinkstop">{page_links}</p>
BELOW add
{form_begin}
FIND around line 74
$templates['footer'] = ' </table>
BELOW add
{form_end}
[ Top ]

Modification Support
Support for this modification can be found @ UseBB Zone in the appropriate modification support thread.
[ Top ]

Copyright & Credits
Modification & install © Gaia of UseBB Zone
[ Top ]