vb.org Archive - better pruning options?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - better pruning options? (https://vborg.vbsupport.ru/showthread.php?t=33846)

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?

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.

PHP Code:


		
			


  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?

I wonder if bumping my own thread is illegal

Hmmmm, no reply.

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

replace

PHP Code:


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

with

PHP Code:


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

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.

sorry my fault

replace also

PHP Code:


		
			
$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:

PHP Code:


		
			
$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");

=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.

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01074 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: