Auto move threads to archive forum after x days

[trafix]

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]

Update

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

[Floris]

Way cool!
I asked you less then a few hours ago to give me a birthday present hack. And here it is, exactly what I asked. As always - very pleased with your professional services trafix.

[TCattitude]

This likes me a lot more than the close after X days.

** Install

Thanks trafix ;)

[cinq]

Nice one, sure could use this !

Possible to also do one "Auto Close thread after 100 posts and create a new one with the same title" ( but append a part X to it where X is 2 if the new post created has been branched once, 3 if branched twice and so on .. ) and with the first post of this new thread to have the content : " In continuation of this previous thread here: XX )" where XX is the link to the previous closed thread ?

Have always been meaning to try something like this for my forums but never got round to doing it.

Hope you can release something like this, since you seem to be on a roll with these cron jobs trafix :D

[trafix]

yep ok ill try to do it for you :)

just call me the King of Cron ;)

[trafix]

Nice one, sure could use this !

Possible to also do one "Auto Close thread after 100 posts and create a new one with the same title" ( but append a part X to it where X is 2 if the new post created has been branched once, 3 if branched twice and so on .. ) and with the first post of this new thread to have the content : " In continuation of this previous thread here: XX )" where XX is the link to the previous closed thread ?

Have always been meaning to try something like this for my forums but never got round to doing it.

Hope you can release something like this, since you seem to be on a roll with these cron jobs trafix :D
ive had a think about it ... and ive worked out how to code it ... i will start on it in the morming :)

[cinq]

Fantastic ;)

[trafix]

This likes me a lot more than the close after X days.

** Install

Thanks trafix ;)
Im glad it like you ;)

[trafix]

Way cool!
I asked you less then a few hours ago to give me a birthday present hack. And here it is, exactly what I asked. As always - very pleased with your professional services trafix.
after i went to bed i started thinking about this one ...... careful where you archives are and who has access to it ..... remember that it will move ALL threads to the archive forum .... even from you pvt forums ... eg your mod or admin forums.

The hint here is to keep them bumped before the move time has expired

[funkmeister]

How hard would it be to amend the script to move the messages from a live forum inside a sub-category to an archived forum within a designated "Archives" category?

For example:

LIVE CATEGORY
All The Latest (sub-category)
|---> News (forum)

ARCHIVES CATEGORY
---> News (archived forum)

What I'm trying to achieve is not to place "all" messages from all forums into a single forum....rather....place messages from a single forum into a designated archived forum of the same name but within a category called "Archives".

Hope that makes sense!?!?

Thanks.

[trafix]

How hard would it be to amend the script to move the messages from a live forum inside a sub-category to an archived sub-forum within a designated "Archive" category.

For example:
LIVE CATEGORY
Forum A (sub-category)
|---> News (forum)

ARCHIVES CATEGORY
---> News (archived sub-forum)

Hope that makes sense!?!?

Thanks.
should be quite easy

[funkmeister]

So it's something you would consider to incorporate into this hack or something I would need to request of you off the forum?

[trafix]

i have added the script for this to the first post :)

[funkmeister]

Many thanks trafix - excellent work, thank you.

Just to push the envelope a little further ;) How might I be able to include a start & end time? In other words, let's say I wanted to move all messages from a specific year, so for example....January 1st, 2002 to December 31st, 2002....into an archive sub-forum called 2002 Archives?

That way, at the end of each year, I'd be able to archive it's messages and start over from scratch with a 'clean' set of live forums for the new year.

Just an idea. Thanks.

[trafix]

ill look at it for you ... again it should be easy

[The Realist]

What about a script that follows on from your close posts after 30 days. I need one that automatically moved these closed threads/posts to a section called cemetary IE posts/threads that are no longer active.

Laters

[trafix]

yep run the cron scripts back to back :) ... the otherone closes the thread then this one come in and moves them :)

[funkmeister]

ill look at it for you ... again it should be easy

Many thanks, look forward to it.

[The Realist]

Ahhhh nice one :)

yep run the cron scripts back to back :) ... the otherone closes the thread then this one come in and moves them :)

[The Realist]

One thing I've noticed is this.

It moves the closed stickies as well?

Can it have options in the code so we can specify what sections not to move closed posts from. We dont want staff or stickies moving to an open forum do we.

Laters

[Bison]

One thing I've noticed is this.

It moves the closed stickies as well?

Can it have options in the code so we can specify what sections not to move closed posts from. We dont want staff or stickies moving to an open forum do we.

Laters


$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
AND sticky != 1
");

[The Realist]

This would stop the stickies being moved yes?


$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
AND sticky != 1
");

[trafix]

yep i didnt take stickies into concideration ... good job :)

[The Realist]

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 10
STR: ->
SQL: $DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
AND sticky != 1
")

[trafix]

ahhh ... ooops

should be

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
OR sticky != 1
");

[The Realist]

Still the same M8 :)

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 10
STR: ->
SQL: $DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
OR sticky != 1
")

[trafix]

Ummm i just tested that code on my dev forum and it ran without an error ..... im confused

[The Realist]

I'll run it again.

[The Realist]

Same error.

Im using phpmyadmin to run the query.

[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]

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):


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]

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):


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]

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]

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]

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...

<!-- ---------------------- 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

http://catocom.com/forum/images/smilies/clock.gif

[trafix]

nice work :)

[catocom2]

nice work :)

well not quite. :surprised:
It seems when I search, or goto 'new posts' it shows on all the threads.

[Moncha]

With this cron, it runs without error but nothing get moved. I do have it set for 2 different forums to move into one. Here's a peek:
error_reporting(E_ALL & ~E_NOTICE);

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

global $DB_site;

// you only need to edit the number of days only
$movedate = strtotime("now -365 days");

//##############################################

// edit the forum id number where the threads have to be moved FROM
$fromforuma="10";

// edit the forum id number where the threads have to be moved TO
$toforuma="60";

// do not edit below

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforuma
Where lastpost <= $movedate
AND forumid = $fromforuma
");

// do not edit above

//##############################################
// edit the forum id number where the threads have to be moved FROM
$fromforumb="17";

// edit the forum id number where the threads have to be moved TO
$toforumb="60";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $fromforumb
Where lastpost <= $movedate
AND forumid = $toforumb
");

// do not edit above
Any ideas?

[Kruppa]

I get this error when I try to run it:

Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE thread
SET forumid =
Where lastpost <= 1110979914
AND forumid =

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 'Where lastpost <= 1110979914
AND forumid =' at line 3

mysql error number: 1064

Any ideas?

Here's a sample of the php file I've edited:

// edit the forum id number where the threads have to be moved FROM
$fromforuma="153";

// edit the forum id number where the threads have to be moved TO
$toforuma="63";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforuma
Where lastpost <= $movedate
AND forumid = $fromforuma
");

// edit the forum id number where the threads have to be moved FROM
$fromforumb="4";

// edit the forum id number where the threads have to be moved TO
$toforumb="63";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforumb
Where lastpost <= $movedate
AND forumid = $fromforumb
");
.
.
.
.
.
.

[Kruppa]

Nobody? :(

[KevinL]

This is almost what I have looking for!

Is it possible for this to move a thread once some one posts in it?

Like..a thread is started in one forum (news forum) and once someone replies it then moves to a discussion forum so others can reply?

[Kruppa]

I get this error when I try to run it:


Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE thread
SET forumid =
Where lastpost <= 1110979914
AND forumid =

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 'Where lastpost <= 1110979914
AND forumid =' at line 3

mysql error number: 1064



Any ideas?


Here's a sample of the php file I've edited:


// edit the forum id number where the threads have to be moved FROM
$fromforuma="153";

// edit the forum id number where the threads have to be moved TO
$toforuma="63";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforuma
Where lastpost <= $movedate
AND forumid = $fromforuma
");

// edit the forum id number where the threads have to be moved FROM
$fromforumb="4";

// edit the forum id number where the threads have to be moved TO
$toforumb="63";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforumb
Where lastpost <= $movedate
AND forumid = $fromforumb
");
.
.
.
.
.
.
Imagine a world where my mods would get off my back to make this hack work....please help if you can. I only install hacks that are supposed to be supported, as this one is advertised.

[Marco van Herwaarden]

Imagine a world where my mods would get off my back to make this hack work....please help if you can. I only install hacks that are supposed to be supported, as this one is advertised.This all code you edited?

[Kruppa]

This all code you edited?
No it was only a sample. Here's the full file I uploaded:

[Marco van Herwaarden]

// edit the forum id number where the threads have to be moved TO
$toforumi="161";

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforumai
Where lastpost <= $movedate
AND forumid = $fromforumai
");

$toforumai is not defined.

PS:
OMG This is the worst script i have ever seen. Do you realize you could also have done this in a 6-line loop?

No offence ment, not trying to put you down, but this really brought a smile on my face. (and a headache looking for the wrong spelled var)

[Kruppa]

No problem! :)

I'm not sure how you do this loop thing but if you could show me how to get rid of this monster of a script it might solve all my problems.

Are sure you I can do it in my situation? Each section I'm moving threads from has its own dead threads section. That's why I thought I had to list them all.

Btw, it worked, only there was another mistake like you pointed out a little lower. Works now! :)

[KevinL]

This is almost what I have looking for!

Is it possible for this to move a thread once some one posts in it?

Like..a thread is started in one forum (news forum) and once someone replies it then moves to a discussion forum so others can reply?
Im guessing no one knows how to do this then with this? :disappointed:

[Rukas]

Is there a way to make this work so that after 24 hours of a thread being posted it is moved, regardless of when the last post in the thread was. So basically it only works off when the thread was started, not replied to, and moves aver 24 hours (I assume setting days to 1 would work ;)).

[HeloHi]

How do you make this move only threads with no replies?

[lifesbattles]

ahhh ... ooops

should be

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
OR sticky != 1
");


ugh o, every post went to my garbage folder

[Kruppa]

ugh o, every post went to my garbage folder
Yeah that happened to me as well. Thank goodness I had a backup from about a week ago because I was in for some serious thread moving.

This hack was a good idea, but it's very annoying to have to move back the stickies every day this script runs. It works great without the stickies bit.

[Sinistra]

OK I am running 3.0.7 The sticky thing dosen't work any suggestions on how to fix it?

error_reporting(E_ALL & ~E_NOTICE);

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

global $DB_site;

// edit the forum id number
$newforum="25";

// you only need to edit the number of days only
$movedate = strtotime("now -14 days");


// do not edit below

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $newforum
Where lastpost <= $movedate
AND forumid != $newforum
OR sticky != 1
");

log_cron_action('Auto Move Threads To Archive', $nextitem);

[debear]

Great! This looks like what I need to archive my 2004 posts to a 2004 Archive forum. I want it to maintain the forum structure and be readable, but not postable. I want them to also be searchable.

This looks like the 2 version is for annual moves which is what I need. But it looks like it is for older versions.

Has anyone tried this on version 3.5 yet? And did it leave the stickies?

Thanks for your work on this guys. :)

[Julie]

Nice one, sure could use this !

Possible to also do one "Auto Close thread after 100 posts and create a new one with the same title" ( but append a part X to it where X is 2 if the new post created has been branched once, 3 if branched twice and so on .. ) and with the first post of this new thread to have the content : " In continuation of this previous thread here: XX )" where XX is the link to the previous closed thread ?

Have always been meaning to try something like this for my forums but never got round to doing it.

Hope you can release something like this, since you seem to be on a roll with these cron jobs trafix :D

I too would like something like that. As I have this "Band/Movie/Song/Etc Games".... And those topics should stop at 250 replies, and then a person starts a new one with the last band/movie/song/etc posted... The above request would be wicked :D Hehe...

I know it's a long while since this was posted, but... *poke* You alive?

[Dactyld]

Crap how do you undo this? I want to put the posts back and can't figure out how.

[RedWingFan]

Is there a way to make this work so that after 24 hours of a thread being posted it is moved, regardless of when the last post in the thread was. So basically it only works off when the thread was started, not replied to, and moves aver 24 hours (I assume setting days to 1 would work ;)).
I believe the "dateline" field is the date the thread was created. If so, replace "lastpost" with "dateline" as I've done below:

$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforuma
Where dateline <= $movedate
AND forumid = $fromforuma
");

[DrainBamaged]

3.5.x?

[SCRIPT3R]

would love a port for this into 3.6.4