default view

[indie]

My forum is set to view threads 30 days and under...

Is there a way to setthat globally to change it .. instead of changing each forum setting,,, and if i set it to 60 days, or "view all", would that affect the queries, or performance... speed, etc..

thanks

[Jake Bunce]

Run this query on your database:

UPDATE forum SET daysprune = X

Where X is the number of days. Use -1 to show all threads. If you use table prefixes then you need to change forum to include the prefix.

You can run this query in your:

Admin CP -> Import & Maintenance -> Execute SQL Query

Make sure your userid is entered into your includes/config.php file so you have permission to run queries:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '';

After running this query you need to update this counter:

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

[indie]

I'm not talking about pruning, just viewing.

Same query?

And will viewing more threads increase the server qeuries or server load?
thx

[Jake Bunce]

I'm not talking about pruning, just viewing.

Same query?

Yes. This is the query for the "view age" of a forum. It doesn't prune in the sense of deleting.

And will viewing more threads increase the server qeuries or server load?
thx

Sorry, I forgot about that question. No, this shouldn't affect load.

[indie]

Is there a setting in the admin cp somewhere, so when i create a new forum, the coice for thread vire is "all", not "last 30 days".. thanks

[Matthew Gordon]

It requires a file edit. This edit is so simple, I don't think I will get killed for posting it here.

admincp/forum.php
Find this:

            'daysprune' => 30, 

Replace with:

            'daysprune' => -1, 

Should work.