Prevent users from bumping old threads - VB3

[djnoz]

I'd like to see a hack that allows you to place an expiry date on threads.

For example:

Expiry date for a forum is set to one month. The last post in a thread created within this forum was made over 1 month ago.
A user tries to post in this thread and meets an error message telling him that the thread has expired.

This should ideally be implemeted so that it can be switched on or off for different forums. If I have an articles forum, I want to make it so that users can make a comment on that article even if it's past the expiry date.

If nobody makes it I *may* take the challenge and implement this myself.
I think a LOT of people will find this useful.

Forgive me if there's something already like this for VB3.

[cyclical]

I'd like to see a hack that allows you to place an expiry date on threads.

For example:

Expiry date for a forum is set to one month. The last post in a thread created within this forum was made over 1 month ago.
A user tries to post in this thread and meets an error message telling him that the thread has expired.

This should ideally be implemeted so that it can be switched on or off for different forums. If I have an articles forum, I want to make it so that users can make a comment on that article even if it's past the expiry date.

If nobody makes it I *may* take the challenge and implement this myself.
I think a LOT of people will find this useful.

Forgive me if there's something already like this for VB3.
would be useful in general chat sections....

keep spammers from bumping crap thats 2-4 months old... good idea.

[Kentaurus]

I'd like to see a hack that allows you to place an expiry date on threads.

For example:

Expiry date for a forum is set to one month. The last post in a thread created within this forum was made over 1 month ago.
A user tries to post in this thread and meets an error message telling him that the thread has expired.

This should ideally be implemeted so that it can be switched on or off for different forums. If I have an articles forum, I want to make it so that users can make a comment on that article even if it's past the expiry date.

If nobody makes it I *may* take the challenge and implement this myself.
I think a LOT of people will find this useful.

Forgive me if there's something already like this for VB3.
Right now with a cron job you can close threads older than x days.. Then the user would see a "cannot reply because this thread is closed" message

[djnoz]

Nice! But can this be switched off for certain forums? :-/

[freehtml]

Right now with a cron job you can close threads older than x days.. Then the user would see a "cannot reply because this thread is closed" message

How can we do that?

[Cool_Rice]

is there something that just doesnt sort a forum by latest reply, but the original post date? that would work and its what im looking for

[cablemirc]

Right now with a cron job you can close threads older than x days.. Then the user would see a "cannot reply because this thread is closed" message

yes, how can we do that. it's a steady problem on my forums

[MogKnight]

I'd absolutely love this hack...

is there anything out there I'm missing?

[cablemirc]

I'd absolutely love this hack...

is there anything out there I'm missing?

i sure wish someone could tackle this

[Punchak]

I'm also looking for such hack (or SQL query). Not to close each topic older than xxx mounth, but close all topics that haven't been active since xxx mounths ;)

Sorry for my english.

[Andreas]

Close threads which don't have replies newer then x days in forums y and z:

UPDATE thread SET open=0 WHERE lastpost < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -2 MONTH)) AND forumid IN (11, 25)

This will close all threads in forums 11 and 25 where the last reply is older then 2 month.

To do this automatically as a cron-job, use a script like this:


<?php
error_reporting(E_ALL & ~E_NOTICE);

if ($DB_site == NULL)
{
exit;
}

$DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET open=0 WHERE lastpost < UNIX_TIMESTAMP(DATE_ADD(NOW(), INTERVAL -2 MONTH)) AND forumid IN (11,25)");

log_cron_action('Threads expired", $nextitem);

?>


Admin note: SQL highlighting is broken (once again?)

[Punchak]

Wonderful KirbyDE ! Thanks a lot ;)
I'll try it asap ;)