vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Auto move threads to archive forum after x days (https://vborg.vbsupport.ru/showthread.php?t=74772)

trafix 01-31-2005 09:08 AM
nice work :)

catocom2 01-31-2005 08:54 PM
Quote:
Originally Posted by trafix
nice work :)
well not quite. :surprised:
It seems when I search, or goto 'new posts' it shows on all the threads.

Moncha 03-04-2005 09:00 PM
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:
Code:
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 04-15-2005 01:45 PM
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 04-26-2005 04:36 PM
Nobody? :(

KevinL 05-05-2005 05:06 PM
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 05-23-2005 01:31 AM
Quote:
Originally Posted by 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 05-23-2005 10:07 AM
Quote:
Originally Posted by Kruppa
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 05-24-2005 01:40 PM
Quote:
Originally Posted by MarcoH64
This all code you edited?
No it was only a sample. Here's the full file I uploaded:

Marco van Herwaarden 05-24-2005 08:06 PM
PHP Code:
// 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 05-24-2005 08:56 PM
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 05-25-2005 05:34 PM
Quote:
Originally Posted by 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 05-30-2005 02:09 AM
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 06-10-2005 10:26 PM
How do you make this move only threads with no replies?

lifesbattles 06-11-2005 10:59 AM
Quote:
Originally Posted by trafix
ahhh ... ooops

should be
PHP Code:
$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 06-17-2005 06:17 PM
Quote:
Originally Posted by lifesbattles
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 06-24-2005 04:10 PM
OK I am running 3.0.7 The sticky thing dosen't work any suggestions on how to fix it?
Code:
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 11-06-2005 03:42 PM
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 12-16-2005 11:58 AM
Quote:
Originally Posted by 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
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 01-03-2006 05:30 PM
Crap how do you undo this? I want to put the posts back and can't figure out how.

RedWingFan 03-16-2006 11:20 AM
Quote:
Originally Posted by 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 ;)).
I believe the "dateline" field is the date the thread was created. If so, replace "lastpost" with "dateline" as I've done below:

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

DrainBamaged 04-15-2006 04:45 AM
3.5.x?

SCRIPT3R 02-01-2007 05:22 PM
would love a port for this into 3.6.4


All times are GMT. The time now is 06:30 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01234 seconds
  • Memory Usage 1,811KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (3)bbcode_php_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (23)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete