Move Posts from One Thread to Another

This was requested on vbulletin.com and it's a very simple hack,
which essentially combines the split and the merge admin options

Open postings.php and find (Around lines 756-757):

  	$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,views,iconid,notes,visible) VALUES (NULL,'".addslashes($title)."','".addslashes($threadinfo[lastpost])."','".addslashes($threadinfo[forumid])."','".addslashes($threadinfo[open])."','".addslashes($threadinfo[replycount])."','".addslashes($threadinfo[postusername])."','".addslashes($threadinfo[postuserid])."','".addslashes($threadinfo[lastposter])."','".addslashes($threadinfo[dateline])."','".addslashes($threadinfo[views])."','".addslashes($threadinfo[iconid])."','Thread split from threadid $threadid by ".addslashes($bbuserinfo['username'])." on ".vbdate($dateformat." ".$timeformat,time()).". ".addslashes($threadinfo[notes])."','".addslashes($threadinfo[visible])."')");
  	$newthreadid=$DB_site->insert_id();

Replace it with:

[high]  // move posts from one thread to another
  if(trim($movetothread)=="") {[/high]

  	$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,views,iconid,notes,visible) VALUES (NULL,'".addslashes($title)."','".addslashes($threadinfo[lastpost])."','".addslashes($threadinfo[forumid])."','".addslashes($threadinfo[open])."','".addslashes($threadinfo[replycount])."','".addslashes($threadinfo[postusername])."','".addslashes($threadinfo[postuserid])."','".addslashes($threadinfo[lastposter])."','".addslashes($threadinfo[dateline])."','".addslashes($threadinfo[views])."','".addslashes($threadinfo[iconid])."','Thread split from threadid $threadid by ".addslashes($bbuserinfo['username'])." on ".vbdate($dateformat." ".$timeformat,time()).". ".addslashes($threadinfo[notes])."','".addslashes($threadinfo[visible])."')");
  	$newthreadid=$DB_site->insert_id();

[high]  } else {
	// get other threadid
	$getthreadid=intval(substr($movetothread,strpos($movetothread,"threadid=")+9));
	if ($getthreadid==0) {
	  $getpostid=intval(substr($movetothread,strpos($movetothread,"postid=")+7));
	  if ($getpostid==0) {
	    // do invalid url
	    eval("standarderror(\"".gettemplate("error_mergebadurl")."\");");
	    exit;
	  }
	  $getpostid=verifyid("post",$getpostid,0);
	  if ($getpostid==0) {
	    // do invalid url
	    eval("standarderror(\"".gettemplate("error_mergebadurl")."\");");
	    exit;
	  }
	
	  $postinfo=getpostinfo($getpostid);
	  $newthreadid=$postinfo[threadid];
	} else {
	  $getthreadid=verifyid("thread",$getthreadid,0);
	  if ($getthreadid==0) {
	    // do invalid url
	    eval("standarderror(\"".gettemplate("error_mergebadurl")."\");");
	    exit;
	  }
	  $newthreadid=$getthreadid;
	}
	
  }
  // / move posts from one thread to another[/high]

Save and upload.

Open template threads_splitthread and find:

$postbits

Right BEFORE it add:

<tr>
	<td bgcolor="{ secondaltcolor }"><normalfont><b>OR Merge Posts into Thread:</b></normalfont></td>
	<td bgcolor="{ secondaltcolor }"><normalfont><input type="text" class="bginput" name="movetothread" size="55"></normalfont></td>
</tr>

(remove the space after and before [high]{ }[/high] in the above code)
That's it

Cheers,

Bira



<< edit: you don't have to put spaces in between the {replacementvars} if you have checked 'disable smilies in this post >>

<< edit 2: ok apparently i lied...chen did you remove that here? >>

[venomx]

I see two of these in 2.2.5... Which do I change?

$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,views,iconid,notes,visible) VALUES (NULL,'".addslashes($title)."','".addslashes($threadinfo[lastpost])."','".addslashes($threadinfo[forumid])."','".addslashes($threadinfo[open])."','".addslashes($threadinfo[replycount])."','".addslashes($threadinfo[postusername])."','".addslashes($threadinfo[postuserid])."','".addslashes($threadinfo[lastposter])."','".addslashes($threadinfo[dateline])."','".addslashes($threadinfo[views])."','".addslashes($threadinfo[iconid])."','Thread split from threadid $threadid by ".addslashes($bbuserinfo['username'])." on ".vbdate($dateformat." ".$timeformat,time()).". ".addslashes($threadinfo[notes])."','".addslashes($threadinfo[visible])."')");

[venomx]

hmm Why when I move a post to a new thread it makes it the top post in the thread?

[Smoothie]

Can an option be added to copy a post to a new thread, instead of move it?

[MarkyBuzz]

Thanks Bira,

Works like a charm, and although its yummy too, I`ll stick to Shish Kebabs

WELL DONE!

[Jawelin]

Could this hack be ported to vb230, where the two rows are innested into an if-clause ?
Thanks, Bira.

[opsman]

Hi this hack is just what I need but am running 29 so dont have the lines of code to change

any chance of updating

[Boofo]

I'm running it on 2.2.9 and it works great here.

I do have a small problem though. Whenever I move any posts, it makes the thread I moved the posts from a sticky thread. Does anyone have any ideas what might be happening?

[crackers8199]

Two questions...

1) Does this work on 2.3.0?

2) Is there a way to create a new thread for the posts you want to move using this hack, or do you need to do that manually?

[VAN]

Has anyone got this to work on 2.3.3?

Mine is creating a new thread instead of placing the selected post(s) in the specified thread.