vb.org Archive - Automatic Zero-Reply Pruning

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Automatic Zero-Reply Pruning (https://vborg.vbsupport.ru/showthread.php?t=79120)

try adding this right above the $prunedthreads query start:

PHP Code:


		
			
require_once('./includes/functions_databuild.php');

Quote:

Originally Posted by Revan

try adding this right above the $prunedthreads query start:

PHP Code:


		
			
require_once('./includes/functions_databuild.php');

ok thanks,before I do will this change my forums post counts..

as per "Rebuilds forum counters after thread deletion. Clean!"

Ideally I would want the users to have the same postcount,there an awful moany bunch lol

Worked a treat https://vborg.vbsupport.ru/external/2005/04/3.gif

thank you for a great hack, just a little Question

If I change the WHERE `replycount` = '0' to "1" will it work in the same way ?

1. Im not sure if it changes the USERs postcounts, but it changes the FORUMs.
2. If you do that change, it will prune all threads where replies is EXACTLY 1. IE not 0 or 2, but 1.
If you want it to prune threads where reply count is 1 or less, then do WHERE `replycount`<= '1'

Quote:

Originally Posted by Revan

Brilliant stuff Revan,well done,works great,changes post count and forum stats,

Not to worry thou i'm happy with it...

Thanks again :up:

Minor snag...

Some fourms have news areas and articles. where no one posts.
Could this have a tiny mod to ignore these forum id's?

Add a variable like so:

PHP Code:


		
			
$ignoreids = '4, 5, 6, 7, 8'; // or whatever your ignore ids is

change the SQL

Code:

WHERE `replycount` = '0' AND `forumid` NOT IN($ignoreids)

That should work OK. It is important that the variable has comma seperated values tho, else the SQL will complain.
You might want to try running the script right after applying the changes to test it, instead of not seeing the errors and thinking it runs OK ;)

Quote:

Originally Posted by Revan

Add a variable like so:

PHP Code:


		
			
$ignoreids = '4, 5, 6, 7, 8'; // or whatever your ignore ids is

change the SQL

Code:

WHERE `replycount` = '0' AND `forumid` NOT IN($ignoreids)

Thaaan-Q!

I must be pretty stupid, but I made a modification of this cron job to prune closed threads (not sticky) and I just can't get them to delete :'(

Any help would be appreciated!

PHP Code:


		
			
<?php

/*======================================================================*\

|| #################################################################### ||

|| # vBulletin 3.0.7 - Licence Number

|| # ---------------------------------------------------------------- # ||

|| # Copyright ?2000?2005 Jelsoft Enterprises Ltd. All Rights Reserved. ||

|| # This file may not be redistributed in whole or significant part. # ||

|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||

|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||

|| #################################################################### ||

\*======================================================================*/



// ####################### SET PHP ENVIRONMENT ###########################

error_reporting(E_ALL & ~E_NOTICE);



if (!is_object($DB_site))

{

    exit;

}



// ##########

// # Config #

// ##########

// Enter the forum id's of the forums to prune here

$forumpruneids = '27,28,29';



// Set this to 1 if you want to remove the threads physically, 0 to soft delete

$deletetype = 0;



// The deletion info, for DB inserts

$delinfo = array('userid' => $bbuserinfo['userid'], 'username' => $bbuserinfo['username'], 'reason' => 'Auto-Pruned Thread');

// ##############

// # End Config #

// ##############



require_once('./includes/functions_databuild.php');



$prunedthreads = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "thread WHERE open = 0 AND sticky != 1 AND forumid IN ($forumpruneids)");

while ($threads = $DB_site->fetch_array($prunedthreads))

{

    delete_thread($threads['threadid'], 1, $deletetype, $delinfo);

    build_forum_counters($threads['forumid']);

    echo "Pruned Thread: $threads[threadid]<br />";

}



log_cron_action('Threads Pruned.', $nextitem);

/*======================================================================*\

|| ####################################################################

|| # Created: 4:15, Fri May 6th 2005

|| # CVS: $RCSfile: deleteclosed.php,v $ - $Revision: 1.00 $

|| ####################################################################

\*======================================================================*/

?>

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 (2)bbcode_code_printable (5)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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 pagenav_page pagenav_complete 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.01874 seconds Memory Usage 1,760KB 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 (2)bbcode_code_printable (5)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: