Automatically closing threads

[hurrican]

Dude, you're the bomb Worked like a charm that time. Funny how TIMENOW and time can cause a problem, lol. I guess the original script that I copied somewhere else on the forum was wrong, but it works great this time! Now to go set it up as a cron job Could I Paypal ya $15 bucks for your help?? I highly appreciate your help, and this board I'm suprised that I couldn't find the answer asked already, with a solution. Again, thanks a lot!! :nervous: :nervous:

Thanks Dean, but I am running 2.3.5 I'm kinda holding off for now on vB 3 until it gets to around 3.1 for bug purposes, then again, my users hate change, lol. I run a football website so can't do any upgrades until around January now anyway! doh :ermm:

[Dean C]

Best of luck with upgrading in January then

[Modin]

Glad it's working
I don't require anything, but I won't object to donations

Sent you a pm with my paypal account in it.

Cheers

[Milktruck]

I want to close all threads older than a week, weekly.

I have vB 3.0.1

This script would work?

[Dean C]

This is the query you want:

[sql]
UPDATE thread SET open = 0 WHERE dateline < ".(time() - (60 * 60 * 24 * 7))."
[/sql]

Modify the script above to suit