Create a Query to change Default View Age

[SnappedAgain]

I would like to know if someone could write me a query that would allow me to run it and change the Default View Age on all my forums rather than having to go into the forum manager and change it for every single forum I have.

Any Ideas? Thank in Advance :up:

[Logikos]

Go into the admincp->Maintenance->Execute SQL Query->Automatic Query->Drop Down Menu (Show all threads)->press continue. :)

[SnappedAgain]

Awesome thanks man. I ended up using the query

UPDATE forum SET daysprune = 60

also for anyone else who reads this and needs to do the same thing. After I ran the query I had to rebuild the forum and thread info before the new settings would take effect.

Thanks again LiveWire :up:

[Logikos]

No problem :)