The owners of a board I maintain (http://www.stovebolt.com/ubbthreads/ubbthreads.php/) have asked if we could automate topic pruning for a couple of the forums. These are forums where the info gets stale pretty quickly. I looked for a way through the Control Panel but couldn't find it.

It occurred to me that this could be done using sql, but obviously I would not want to screw it up. Is there a way to call prunethreads.php with the right values so the system would do the actual pruning? I'm thinking of something like php prunethreads.php -d day -m month -y year -f forumname. The problem is, the Control Panel prune process involves review and approval (for obvious reasons), and I'm not sure if that can be handled from a script (maybe using expect?)

Any thoughts or ideas would be welcomed. On one forum they want the topics kept at 90 days, and the other at 30 days.

Maybe this is a feature request??? laugh


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB