Replace the whole huge block of PHP you added last post with this block:
PHP Code:
// ###################### Start by Move 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) with an average rate of at least $minrate and at least $numvotes votes.";
doformheader("thread","moverate");
maketableheader("Move All Threads Automatically");
makehiddencode("forumid", "$forumid");
makehiddencode("numvotes", "$numvotes");
makehiddencode("minrate", "$minrate");
makehiddencode("daysmove", "$daysmove");
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("daysmove", "$daysmove");
makehiddencode("destforumid", "$destforumid");
doformfooter("Click Here to Move Threads Selectively","",2);
exit;
}
$forumcheck=iif($forumid!=-1,"forumid=$forumid AND ","");
if ($daysmove) {
$datecut=time()-($daysmove*86400);
$datecheck="AND lastpost<=$datecut";
}
$DB_site->query("UPDATE thread SET forumid=$destforumid WHERE $forumcheck votenum>=$numvotes AND votetotal/votenum>=$minrate $datecheck");
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 ","");
if ($daysmove) {
$datecut=time()-($daysmove*86400);
$datecheck="AND lastpost<=$datecut";
}
$threads=$DB_site->query("SELECT threadid,title,votenum,votetotal,replycount,postusername,postuserid,lastpost FROM thread WHERE $forumcheck votenum>=$numvotes AND votetotal/votenum>=$minrate $datecheck ORDER BY votetotal/votenum DESC, votenum DESC, lastpost");
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>";
}
And now add
PHP Code:
makeinputcode("Move threads with last post older than x days:","daysmove","0");
right after
PHP Code:
makeinputcode("Move threads with average rate of over x:","minrate");
(everything in thread.php)
That should do what you want.
More Information