Close posts after x amount of days

[Brian Cruz]

I don't know if this needs to be a hack or if there is a simple MySQL query that can do this, but I want to close all posts that haven't been replied to since an x amount of days. Some people on my forum are bringing back year-old posts and it's getting on my nerves. I don't want to make an archive and move the posts there, I want want them to stay in their present board but be closed. Thanks.

[RDX1]

i would love this hack also

[Brian Cruz]

Anyone?

[Logician]

I may be wrong but the hack may already exist. Have you searched for it?

[Xenon]

UPDATE thread SET open=0 WHERE lastpost<xxxxxxx

just enter a special dateline you want, and all those threads become closed.