Auto Close threads after XX days

[sabret00the]

errrr, kinda what the title says.

i would greatly appreciate it if someone made a hack that would automatically close threads in set forums after XX days

[NTLDR]

All you need is a simple cron script that runs every day (or at whatever interval you choose) to update the threads table.


$DB_site->query("UPDATE ".TABLE_PREFIX."thread SET open = 0 WHERE forumid IN (X,Y,Z) AND dateline < A");

Where X,Y,Z are the forumids and A is the timestamp that the threads must be older than to be closed.

[Gio Takahashi]

I need that, Thanks.

I am confused with the time stamp, but say threads older than 7 days, do I put in just "7"?

[NTLDR]

$DB_site->query("UPDATE ".TABLE_PREFIX."thread SET open = 0 WHERE forumid IN (X,Y,Z) AND dateline < ".TIMENOW - (60 * 60 * 24 * 7));

That should close all threads in forumid X, Y and Z older than 7 days.

[Gio Takahashi]

ran it and got this error:

Invalid SQL: -604800
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-604800' at line 1
mysql error number: 1064

And I used this for script:


$DB_site->query("UPDATE ".TABLE_PREFIX."thread SET open = 0 WHERE forumid IN 6 AND dateline < ".TIMENOW - (60 * 60 * 24 * 7));

[NTLDR]

Try this instead:


$DB_site->query("UPDATE ".TABLE_PREFIX."thread
SET open = 0
WHERE dateline < ".(TIMENOW - (60 * 60 * 24 * 7))."
AND forumid IN (6)
");

[Gio Takahashi]

A friend of mine helped out, and gave me the better coding, it should be:

argh, it only closed all thread regardless of time.

[Gio Takahashi]

the last script you gave DID work....>.>

[sabret00the]

nice one, will this email me to let me know which threads it's closed?

[Gio Takahashi]

It should do the same as all other tasks do in task schedules.....