Open thread.php under your admin folder.
Add this code
PHP Code:
// ###################### Start Move by Rate #######################
if ($HTTP_POST_VARS['action']=="moverate") {
if ($numvotes=="" or $minrate=="") {
echo "<p>Please enter number of votes and average rate</p>";
exit;
}
if ($confirm!=1) {
if ($forumid==-1) {
$forumtitle="all";
} else {
$forum=$DB_site->query_first("SELECT title FROM forum WHERE forumid=$forumid");
$forumtitle=$forum[title];
}
echo "<p>You are about to move all threads from the $forumtitle forum older than $daysmove day(s).";
doformheader("thread","moverate");
maketableheader("Move All Threads Automatically");
makehiddencode("forumid", "$forumid");
makehiddencode("numvotes", "$numvotes");
makehiddencode("minrate", "$minrate");
makehiddencode("destforumid", "$destforumid");
makehiddencode("confirm", "1");
doformfooter("Click Here to Move All Threads Automatically","",2);
doformheader("thread","moveratesel");
maketableheader("Move Threads Selectively");
makehiddencode("forumid", "$forumid");
makehiddencode("numvotes", "$numvotes");
makehiddencode("minrate", "$minrate");
makehiddencode("destforumid", "$destforumid");
doformfooter("Click Here to Move Threads Selectively","",2);
exit;
}
$forumcheck=iif($forumid!=-1,"forumid=$forumid AND ","");
$DB_site->query("UPDATE thread SET forumid=$destforumid WHERE $forumcheck votenum>=$numvotes AND votetotal/votenum>=$minrate");
echo "<p>Posts moved successfully! It is recommend that you <a href=\"misc.php?s=$session[sessionhash]\">update counters</a> now.</p>";
}
// ###################### Start Move by rate selector #######################
if ($action=="moveratesel") {
doformheader("thread","domoverate");
makehiddencode("destforumid",$destforumid);
maketableheader("Move Threads Selectively");
$forumcheck=iif($forumid!=-1,"forumid=$forumid AND ","");
$threads=$DB_site->query("SELECT threadid,title,votenum,votetotal,replycount,postusername,postuserid FROM thread WHERE $forumcheck votenum>=$numvotes AND votetotal/votenum>=$minrate ORDER BY lastpost DESC");
while ($thread=$DB_site->fetch_array($threads)) {
$threadavg = $thread[votetotal]/$thread[votenum];
makeyesnocode("<a href=\"../showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]\" target=\"_blank\">$thread[title]</a><br> With <b>$thread[votenum]</b> and an average of <b>$threadavg</b><br> Started by <a href=\"../member.php?s=$session[sessionhash]&action=getinfo&userid=$thread[postuserid]\" target=\"_blank\">$thread[postusername]</a><br> $thread[replycount] replies","move[$thread[threadid]]",1);
}
doformfooter("Submit - only click here if you are ABSOLUTELY certain");
}
// ###################### Start Move by rate selected #######################
if ($HTTP_POST_VARS['action']=="domoverate") {
echo "<p>Moving...</p>";
while (list($key,$val)=each($move)) {
if ($val==1) {
$DB_site->query("UPDATE thread SET forumid=$destforumid WHERE threadid=$key");
}
}
echo "<p>Posts moved successfully! It is recommend that you <a href=\"misc.php?s=$session[sessionhash]\">update counters</a> now.</p>";
}
right before
PHP Code:
// ###################### Start by Move Date #######################
Now add
PHP Code:
doformheader("thread","moverate");
maketableheader("Move by rate");
makeinputcode("Move threads with at least x votes:","numvotes");
makeinputcode("Move threads with average rate of at least x:","minrate");
makeforumchoosercode("Source Forum","forumid",-1,"All forums");
makeforumchoosercode("Destination Forum","destforumid");
makelabelcode("Note: this will not move posts from sub forums!");
doformfooter("Move");
right before
PHP Code:
doformheader("thread","movedate");
maketableheader("Move by date");
makeinputcode("Move threads with last post older than x days:","daysmove","0");
makeforumchoosercode("Source Forum","forumid",-1,"All forums");
makeforumchoosercode("Destination Forum","destforumid");
makelabelcode("Note: this will not move posts from sub forums!");
doformfooter("Move");
And that's it.