Thread Maintenance v1.0

Well here goes nothing, my first hack at vb.org in sometime now.

Based on an idea by rooshine in this thread -
https://vborg.vbsupport.ru/showthread.php?t=59179

I built on the idea somewhat and in my opinion made a fairly nice system

This hack will close threads if they're not replied to within X amount of days as set per the Administrator. Also if you use a forum to archive your threads you can use that featrue and it will automatically move the thread to the specified forum. You can disable or enable this system whenever you want and can set the amount of time to check for updates so that you're not running the database down.

Screenshot and zip below. Easy Installation just run the installer in the admin directory then upload a file and one file mod and you're done.

Tested on vb2.3.3 but should work for all vb2.x.x.

If you install please click install and thanks.

Any questions, comments, etc are welcomed.

If this hack becomes somewhat popular I already have some ideas for v2.0 including automatic forum updating and bypassing sticky threads etc, but this is just a start, please do enjoy.

Thread Maintenance v1.1

Thanks to Brolly I have updated this hack. It contains the following fixes for the following bugs.

[Bug 1]Maintenance Update even though settings set for minutes updated in seconds instead. Fix Applied.

[Bug 2]Even once Thread Maintenance was ran it updated the setting, but did not updated in the special templates. Fix Applied with the reformattingsettings function.

[Bug 3]Thanks to Brolly with the existing query it selected posts but not those older then X amount of time so that is why there was the issue with closing threads that were created x amount of days ago. Anyways fix applied.

To Update to Thread Maintenance v1.1 (TM) Simply Download updated zip and upload the new threadmaintenance.php to the main directory and thats all. Enjoy.

Regards,
g-force2k2

[Capt PPRuNe]

Originally Posted by g-force2k2

open threadmaintenace.php

find:

PHP Code:

        WHERE post.dateline <= $timenow - ( $TMClosed * 86400 ) AND open=1 


replace with:

PHP Code:

        WHERE post.dateline <= $timenow - ( $TMClosed * 86400 ) AND open=1 AND thread.forumid NOT IN ( 0 ) 


Just replace the 0 in the parethesis with the staff forumids and seperate each one with a comma

ie:

PHP Code:

NOT IN ( 3,25,42 ) 


regards,
g-force2k2

The above code has obviously changed in v1.1 so what is needed to be able to prevent threads in spcific forums from being closed?

[g-force2k2]

Originally Posted by Capt PPRuNe

The above code has obviously changed in v1.1 so what is needed to be able to prevent threads in spcific forums from being closed?

If you open threadmaintenance.php and find:

PHP Code:

        WHERE open=1 


replace with:

PHP Code:

        WHERE open=1 AND thread.forumid NOT IN ( 0 ) 


And then just replace the 0 with forumids. Hope that does the trick, let me know if any problems arise.

Cheers,
g-force2k2

[tiedyetoga]

Thanks, I have been looking for a hack like this for sometime..