Auto move threads to archive forum after x days

Requested by Floris

This is another simple script based on the Close thread after 30 days .... BUT ...

This one will auto move all threads to an archive forum where the last post is 365 days or older

There is 2 variables for you to edit
1)
Defult is set to "1"
$newforum = the forum number that these threads are to be moved to

2)
Defult is set to 365
this means that threads that havnt been replied to in the last 365 days will be moved to the nominated archive forum
you can change 365 to whatever days you like

Trafix

Please click Install

Update
Found an error in the code please download new zip and replace the file on your forum

Added file ...

This file will move threads from a specific forum to another spacific forum, edit as instructed

[trafix]

thats where you are going wrong ..... your phpmyadmin wont understand $DB_site

if you put the script in the cron folder you can use the task manager to "run now"

[The Realist]

Lost on this one M8.

[Bison]

Originally Posted by The Realist

Same error.

Im using phpmyadmin to run the query.

Sorry for intruding, but this query is a PHP code dependant query and you cannot run it in phpMyadmin, or in the admin cp query. That's why you are getting errors. MySQL doesn't know what a "$db_site->(query" is! LOL!

If you want to test the query (the MySQL way), just type this (and fill in the blanks):

PHP Code:

UPDATE thread
SET forumid = [forumid number where all the threads will be moved ]
Where lastpost <= [what move date value]
AND forumid != [forumid number where all the threads will be moved]
OR sticky != 1 


BTW, this won't be a test on your forums ... it going to do the deed!

[trafix]

Originally Posted by Bison

Sorry for intruding, but this query is a PHP code dependant query and you cannot run it in phpMyadmin, or in the admin cp query. That's why you are getting errors. MySQL doesn't know what a "$db_site->(query" is! LOL!

If you want to test the query (the MySQL way), just type this (and fill in the blanks):

PHP Code:

UPDATE thread
SET forumid = [forumid number where all the threads will be moved ]
Where lastpost <= [what move date value]
AND forumid != [forumid number where all the threads will be moved]
OR sticky != 1 


BTW, this won't be a test on your forums ... it going to do the deed!

Tnanks for explaining that Bison

[catocom2]

This is the closest hack to what I'm looking for that I've found.
Except...
Instead of moving, closing, or what not, I'd just like it to add a little
clock icon in the left column if the thread is older than xx, when someone
replies to it.
Is there an easy way to mod this mod to do that?

Thanks. This cron stuff is just a little beyond my programming skills ATM.
This is a great looking hack.

[trafix]

Originally Posted by catocom2

This is the closest hack to what I'm looking for that I've found.
Except...
Instead of moving, closing, or what not, I'd just like it to add a little
clock icon in the left column if the thread is older than xx, when someone
replies to it.
Is there an easy way to mod this mod to do that?

Thanks. This cron stuff is just a little beyond my programming skills ATM.
This is a great looking hack.

so ... the clock replaces the original icon selected? ... or appears under it?

[catocom2]

Originally Posted by trafix

so ... the clock replaces the original icon selected? ... or appears under it?

exactly

I'm not really sure it's a cron job thing though..?
Maybe just a conditional.

[trafix]

Originally Posted by catocom2

exactly

I'm not really sure it's a cron job thing though..?
Maybe just a conditional.

yep ist php/template coding i can look at it

[catocom2]

Thanks man, but I got it now. :smoke:
fury@otcentral replied and told me how he did it.

http://otcentral.com/forum/showthread.php?t=17762

[catocom2]

here's the code I did:

place it the "threadbit" template where you want it...

PHP Code:

<!-- ---------------------- clock ------------------------------- -->
<if condition="$thread['dateline'] <(TIMENOW-86400*180)"><img src="http://catocom.com/forum/images/smilies/clock.gif" alt="This thread was started more than 6 months ago"></if>
<!-- ---------------------- /clock ------------------------------- --> 


and an icon I altered