We’ve found that our users like to add new comments on very old topics, often only tangentially related to their problem. I would like to set all categories to auto-close topics some time after the last post (7 days – just for the sake of argument!).
I have found this thread on how to apply a new auto-close configuration to existing topics, but I can’t find any way to adjust the auto-close configuration for all categories. I don’t especially want to do this by hand for two dozen (sub-)categories or so.
Perhaps it’d be safe to
UPDATE categories SET auto_close_hours = 168, auto_close_based_on_last_post = true; if I had access to the database?