Default View Age

[truthaddict]

Is there a way to change this for all forums rather than just one forum at a time? For a board we just created we want to change it for all of our (100+) forums so that in the early days we'll show all threads from the beginning and then as the board get busier we'll ratchet that back. There has to be an easier way than going through each forum individually and making the change right?

[Andy Huang]

You can do so through admin cp's execute query option. You can find the query in the licensed members' section of this forum.

Ooops, my bad... I'm tired at this hour and forgot I am already in the licensed section >.<

Here's the query:
UPDATE forum SET daysprune=-1;

Where -1 can be replaced with the following:
1 = Show threads from last day
2 = Show threads from last 2 days
7 = Show threads from last week
10 = Show threads from last 10 days
14 = Show threads from last 2 weeks
30 = Show threads from last month
45 = Show threads from last 45 days
60 = Show threads from last 2 months
75 = Show threads from last 75 days
100 = Show threads from last 100 days
365 = Show threads from last year
-1 = Show all threads

[Jake Bunce]

After running that query, you need to run this counter:

Admin CP -> Import & Maintenance -> Update Counters -> Rebuild Forum Information