better pruning options?

[Justice]

I've been using vBulletin for a while (imported from UBB last summer), and I'm finally reaching the point where I'd like to prune some forums. But I noticed in the Control Panel, the Mass Prune feature doesn't show the number of posts in each thread, only the title. I used to determine which threads to delete by how few posts the it had. I can barely recognize the quality of the thread by it's title alone.

Is there any quick and dirty way to add the total post number next the title in the Mass Prune section?

[G-Cifix]

*Bump

[Justice]

no one has any ideas?? My board could really use a good pruning...

also, is there a way to make the default radio on "No" instead of "Yes"? If I'm pruning a forum with 20k threads and I wanna delete 500, I'd have to click "No" 19,500 times. Not fun :noid:

I tried looking in admin/thread.php but didn't find much to work with.



echo "<tr class='tblhead'><td><font size='1'><b><span class='tblhead'>Thread Title</span></b></font></td><td><font size='1'><b><span class='tblhead'>Delete?</span></b></font></td></tr>\n";

$datecut=time()-($daysdelete*86400);
$threads=$DB_site->query("SELECT threadid,thread.title FROM thread LEFT JOIN forum USING (forumid) WHERE $forumcheck thread.lastpost<=$datecut ORDER BY thread.lastpost DESC");
while ($thread=$DB_site->fetch_array($threads)) {
makeyesnocode("<a href=\"../showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]\" target=_blank>$thread[title]</a>","delete[$thread[threadid]]",1);
}

doformfooter("Submit - only click here if you are ABSOLUTELY certain");
}

:confused: where is the html for the radio input?

[Justice]

I wonder if bumping my own thread is illegal

[Justice]

Hmmmm, no reply.

How do you guys with really large forums deal with pruning ambiguously titled threads?

[Xenon]

replace
makeyesnocode("<a href=\"../showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]\" target=_blank>$thread[title]</a>","delete[$thread[threadid]]",1);

with
makeyesnocode("<a href=\"../showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]\" target=_blank>$thread[title]($thread[replycount])</a>","delete[$thread[threadid]]",0);

[Justice]

unfortunately, that doesn't work Xenon.. but thanks for trying.

All it does is add a () after the thread title. the $thread[replycount] isn't showing a value.

[Xenon]

sorry my fault

replace also
$threads=$DB_site->query("SELECT threadid,thread.title FROM thread LEFT JOIN forum USING (forumid) WHERE $forumcheck thread.lastpost<=$datecut ORDER BY thread.lastpost DESC");


with this:
$threads=$DB_site->query("SELECT threadid,thread.title,thread.replycount FROM thread LEFT JOIN forum USING (forumid) WHERE $forumcheck thread.lastpost<=$datecut ORDER BY thread.lastpost DESC");

[Justice]

=O OMG, you're the greatest human being in the world for these few seconds I'm posting right now!! You've created the best admin hack of 2002 and saved my forum from growing to 80,000,000 posts!! THANK YOU, AND THANK YOUR PARENTS!!

... i mean... yes, that works fine.

[Xenon]

*ggg*
thanks thanks, too much of honor :)