vb.org Archive - Administrative and Maintenance Tools - Auto Delete/Move Thread After X days

Page 5 of 9

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Administrative and Maintenance Tools - Auto Delete/Move Thread After X days (https://vborg.vbsupport.ru/showthread.php?t=139646)

AtoZ	10-03-2007 05:38 AM

Quote:

Originally Posted by voclain (Post 1296678)

All I did was make a NEW SCHEDULED TASK and had it point to .php file that I uploaded into the "CRON" folder.

Just like that...it works.

Thank you for pointing this out. I wanted to emphasize it here in case anyone else is having trouble getting this set up. It was easy to overlook this important piece of information that you provided! All of the previous posts with the SQL code has incorrect syntax. :down:

Other than that, I think I am going to LOVE this plugin! I changed the replycount to > 59, so once a thread gets more than 59 posts, it will automatically be moved to my forum for long threads and debates. I am using another plugin that will automatically close those threads to further posting. It's an awesome combo!

Doctor Death

10-03-2007 09:08 AM

Have been looking for something like this for several years. Looking forward to installing it.

Update: It is installed... I want it set up to delete a specific forum (#28) with any posts older than 7 days.

I did NOT see a chron job installed with this, although I might have missed it. Other than putting in the product and the configuration via CP, do I need to do anything else to have it delete threads older than 7 days routinely?

The Options in ADMINCP are not that intuitive...

Have it set currently to:

Quote:

Turn on the (Auto Delete/Move Thread After X days) system "All Systems". NO
Turn on the (Auto Delete Thread After X days) system. YES
Please enter the user id that you don't want to delete there threads, Admins or Mods, comma seperated. 4
Turn on the (Auto Move Thread After X days) system. YES
Please enter the forum id that you want to apply this hack on it , comma seperated. 28
Please enter the forum id that you want set as archive . 28 (Although I dont want an archive)
Choose YES for physical delete and NO for soft delete YES
Thread must have been created earlier than X days. 7

Thanks!

KuJoe

10-08-2007 12:08 PM

I just finished installing this on my test board and I had to manually enter the Scheduled Task (set to run once a day) but as of now it is working perfectly. The only change I had to make was:

Code:

AND `replycount` = '0'

Code:

AND `replycount` > '0'

So it would leave all posts with 0 replies (mainly stickies) and would archive all posts with replies. This is perfect for my "Introduction" forum since after 30 days, a members tends to not be new anymore. :D

R1D1	10-31-2007 04:58 PM

as it seems, the cron-thing doesn't work. so i will drop it on standby the next weeks... perhaps the problem will be solved till then? :) would be wonderful... its a great mod-idea! thx.

AtoZ	10-31-2007 05:03 PM

Quote:

Originally Posted by R1D1 (Post 1372891)

as it seems, the cron-thing doesn't work. so i will drop it on standby the next weeks... perhaps the problem will be solved till then? :) would be wonderful... its a great mod-idea! thx.

This is the solution...

Quote:

Originally Posted by voclain
All I did was make a NEW SCHEDULED TASK and had it point to .php file that I uploaded into the "CRON" folder.

Just like that...it works.

R1D1	11-01-2007 04:50 PM

fascinating! :D thx ;)

perhaps worth enoug to give it a short quote at the thread's startpost? ;)

rammbs

11-05-2007 03:34 PM

need help please. i get the error below when i run the scheduled task..

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM `thread` Where forumid IN(23) AND `replycount` = '0' AND `postuserid` NOT IN () AND `dateline` <= '1194024543';

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 ') AND `dateline` <= '1194024543'' at line 1
Error Number : 1064

i ran the query below too :

PHP Code:


		
			
INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days');

ETDC	11-12-2007 08:06 PM

Does this work with 3.6.8 Patch Level 2?

:)

TigerWare

11-13-2007 05:25 PM

Quote:

Originally Posted by ETDC (Post 1381274)

Does this work with 3.6.8 Patch Level 2?

If you have it running on 3.6.8 already, then yup, PL1/PL2 is fine.

ETDC	11-13-2007 05:39 PM

I don't have it installed yet.

All times are GMT. The time now is 08:14 PM.

Page 5 of 9

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01320 seconds Memory Usage 1,746KB 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 (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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
Messages: