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

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)

Very cool!
Any chance it will be supported (I ask because of the new vb-versions)?

1. Does it only work with 0 posts?
2. Do I have to make the cron myself?

Quote:

1. Does it only work with 0 posts?

you can custom it :)
as you wish, just edit the attached file forum/includes/cron

INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

Give me

#1064 - Erreur de syntaxe pr賠de '" . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,logle' ࠬa ligne 1

very nice, will it work with 3.6.7?

does the timer start when the thread was created or when the last post was made?

thx alot ^^ but i don'est add any cron job in v 3.6.7 pl1 >.>

how can i add it manually without running sql Query

Quote:

Originally Posted by HaMaDa4eVeR (Post 1232046)

run this query in your forum database :

Code:

INSERT INTO " . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active,varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

make sure that you've uploaded the file cronautodelete.php in ./includes/cron/cronautodelete.php

and It should be working now...

If I may, I'd like to point out that this SQL does not look right though I'm no expert.

Quote:

(weekday,day,hour,minute,filename,loglevel,active, varname, volatile,product)) VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')

There is an additional bracket after the column list.
The number of quoted columns (Ten) does not mach the number of values (Seven).
To me it looks like there are missing values for column active, varname and volatile.

I have no scheduled task in either 3.6.4 (mine) or on a 3.6.7PL1 (which I am co-admin).

Sorry if I'm being thick, but the SQL on the install code just doesn't look correct.

:confused:

Quick questions...I'm just about to install this...I will have it up in a few minutes.

But....what I want to know is once it's installed...and I have applied it to my specific forum that I want to apply it to.

WILL it then do the action to everything that is CURRENTLY in that FORUM??? or will it only do it to NEW THREADS/POST that come in AFTER the Hack is installed???

JUST WONDERING???

Kirk

Quote:

Originally Posted by adc-arab (Post 1290146)

thx alot ^^ but i don'est add any cron job in v 3.6.7 pl1 >.>

how can i add it manually without running sql Query

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');

Quote:

Originally Posted by tandy (Post 1285784)

try this:

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');

Quote:

Originally Posted by patrickstar (Post 1287852)

very nice, will it work with 3.6.7?

does the timer start when the thread was created or when the last post was made?

revire the mod. options, it will do it

Quote:

Originally Posted by voclain (Post 1293327)

he will work on the both :)
old/new topics

Tnx Good PlugIn:cool:

Quote:

Originally Posted by HaMaDa4eVeR (Post 1293580)

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');

try this:

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');

revire the mod. options, it will do it

he will work on the both :)
old/new topics

I did what you said here...and this is the message I got after running it:

Quote:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1136
error desc: Column count doesn't match value count at row 1

Any suggestions????

Kirk

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_php_printable (9)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01314 seconds Memory Usage 1,758KB 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 (1)bbcode_code_printable (4)bbcode_php_printable (9)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: