Automatic Zero-Reply Pruning

This hack was requested by T3MEDIA here.


What this hack does:

• Runs a cronjob every 15 days, deleting threads with zero replies
• Uses vBulletin own thread deletion function. Accept no BS
• Rebuilds forum counters after thread deletion. Clean!

Well thats about it

[Revan]

try adding this right above the $prunedthreads query start:

PHP Code:

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


[Bounce]

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

[Bounce]

Worked a treat



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 ?

[Revan]

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'

[Bounce]

Originally Posted by Revan

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'

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:

[T3MEDIA]

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?

[Revan]

Add a variable like so:

PHP Code:

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


change the SQL

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

[T3MEDIA]

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

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

Thaaan-Q!

[almqdad]

great hack

[djr]

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 $
|| ####################################################################
\*======================================================================*/
?>