[bryan09]

Originally Posted by Paul M

Try this;
[sql]$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET open = 0
WHERE forumid IN (1,2,3) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30))
);
[/sql]
Where (1,2,3) is the list of forum id's you want it to work for, and 30 is the number of days

I got this problem when I inserted the above code ..

ERROR: Unknown Punctuation String @ 9
STR: ->
SQL: $DB_site->query("
	UPDATE " . TABLE_PREFIX . "thread
	SET open = 0
	WHERE forumid IN (36) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30))
)

SQL-query: 

$DB_site->query(" UPDATE " . TABLE_PREFIX . "thread SET open = 0 WHERE forumid IN (36) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30)) ) 
MySQL said:  

#1064 - You have an error in your SQL syntax near '$DB_site->query("
    UPDATE " . TABLE_PREFIX . "thread
    SET open = 0
    WHERE for' at line 1