Locking old threads in the forum

[Update:]

As  you may know we had some spam problems lately in webdigity. One of the things I had to do was to lock old threads as many of the spammers were posting in threads that were last updated years ago.

So if you want to automatically lock all threads that are for instance 6 months old (in fact this is for threads that their last reply is 6 months old), open phpMyAdmin (or any other query tool you are using) and execute this SQL command:

Code:

UPDATE `topics` INNER JOIN `messages`
   ON ( `topics`.`ID_LAST_MSG` = `messages`.`ID_MSG` ) 
   SET `topics`.`locked` =1
   WHERE `messages`.`posterTime` + ( 6 *31 *24 *60 *60 ) < UNIX_TIMESTAMP( ) 

If you need to lock threads that are more or less than 6 months old, just change the 6 in the (6*31*24.... statement

Update: If you are using a table prefix just replace `topics` and `messages` with `PREtopics` and `PREmessages` where PRE is your actual prefix

sometimes the simplest things are the best! thanks for sharing this code...

EDIT you forget to add the smf table prefix, my structure for example is "smf_topics" (I guess that is the default)

So people should check this...

[Join us @ facebook]

Yeah if you don't stop and think a little you would write a 20 lines php snippet to do the same thing

yes right, if you like phpmyadmin can do so many things...(check my edit above)

[Join us @ facebook]

Thanks. Prefix added (almost)

do you run this script every day?

[Guest]

[62.885]

Googlebot