Auto Prune Threads

<font size="3">Auto Prune Threads</font>

Description
This hack gives you the ability to specify if you want to have
threads pruned from a forum after x days.
The amount of days can be set separately for each forum in forum manager.

Details
1 Product XML (3 Plugins, 1 Phrase)

Compatibility Note vBulletin 3.7
As of vBulletin 3.7 Beta 4, the hook used for this Mod does not exist any longer.
After installting this Mod, please change the Hook location to cron_script_cleanup_hourly

[Trevor Hannant]

Once installed using the XML file above, edit the hook location in:

AdminCP > Plugins & Products > Plugin Manager > Auto-Prune Threads

to use the cron_script_cleanup_hourly hook.

Works fine in my 4.0.6 install.

Edit - error caused by a space at the start of the above hook name in the XML - revised file attached.

[Acido]

Originally Posted by Trevor Hannant

Works fine in my 4.0.6 install.

I confirm that.

Thank you very much trevor :up:

[atcspaul]

thanks trevor. works great with 4.0.7 also

[POL_ED]

Thanks.
Works great with 4.0.8 also

[AusPhotography]

I've got a slightly modified version working in v4.1.0pl2 .
Based on Trevor's version https://vborg.vbsupport.ru/showpost....6&postcount=81

My mod is to NOT prune sticky threads

[TheGorf]

How are you avoiding stickies? I was looking at the simple code in this mod and I see:

PHP Code:

      while ($thread = $vbulletin->db->fetch_array($threads))
    {
            delete_thread($thread['threadid'], false, true, NULL, false, $thread);
      } 


That easily can be added with a IF block to evaluate if the thread is sticky. Is that all you did? Something like this:

PHP Code:

while ($forum = $vbulletin->db->fetch_array($forums))
{
    $threads = $vbulletin->db->query_read("SELECT threadid, forumid, visible, open, pollid, title, sticky FROM " . TABLE_PREFIX . "thread WHERE forumid=$forum[forumid] AND visible IN (0,1,2) AND sticky IN (0,1) AND lastpost <= " . (TIMENOW - ($forum['pruneafter'] * 86400)));
      while ($thread = $vbulletin->db->fetch_array($threads))
    {
                if ( $thread['sticky'] == 0 )
                {
                    delete_thread($thread['threadid'], false, true, NULL, false, $thread);
                }
      }
      build_forum_counters($forum['forumid']);
} 


which adds "sticky" to the thread query, and then ignores the delete_thread call if the thread is sticky. Hmmmm I bet it would be trivial to make this a checkbox option in the forum edit/setup page.

[enbro]

I've installed this on my board which is 4.1.1 and it seems to be working, thanks so much!

[Boofo]

Originally Posted by snoopytas

I've got a slightly modified version working in v4.1.0pl2 .
Based on Trevor's version https://vborg.vbsupport.ru/showpost....6&postcount=81

My mod is to NOT prune sticky threads

Well, let's see it.

[AusPhotography]

Works on 4.1.3

We also add this line

  AND sticky = 0

to the SQL to not remove sticky threads

http://www.ausphotography.net.au/for...te_maintenance

[Infopro]

Would anyone have an idea on how I could make this check for deleted threads only and move them to a specific forum? After you've soft deleted many spam threads you might like to move them out of view to a specific forum for archiving instead of deleting.

Thanks!