Administrative and Maintenance Tools - Auto Delete/Move Thread After X days

What does this hack do ?
This is second version of Auto Delete/Move Hacks, this hack can delete the zero post threads that was created before X days in your specific forums or it can move the zero post threads to specific(Archive) through scheduled task, by defualt delete the zero post every ten days, sure you can change the period as you want,
this is where the Auto Delete After X Days comes in handy!

Features:

• Turn On/Off system "All system".
• Turn On/Off Move system.
• Turn On/Off Delete system.
• Specific forums "this hack will work on this forums only".
• Specific forums " Archive Forums".
• Protected Users.
• Delete Type (soft/hard).
• Created days.
• NO Code Modifications needed!

Install instructions:

1- Upload the file to forum/includes/cron.
2- Import the Product XML file through your Admincp.
3- Enjoy.

NOTE:
Do not forget to review the hacks options in vBulletin options under "Auto Delete/Move After X Days " to set it as you want, the defualt setting are:-
- Soft delete for the threads that have zero replay and created before 30 days ago.
- protected user that have id 1 & 2.
- it will running every ten days.
- check the attachments.


that's all
Any questions, comments, suggestions, pleaes let me know

Enjoy!

[Eagle Creek]

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?

[HaMaDa4eVeR]

1. Does it only work with 0 posts?

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

[tandy]

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

[patrickstar]

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?

[adc-arab]

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

[TigerWare]

Originally Posted by HaMaDa4eVeR

run this query in your forum database :

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.

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

[voclain]

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

[HaMaDa4eVeR]

Originally Posted by adc-arab

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


Originally Posted by tandy

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

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


Originally Posted by patrickstar

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

Originally Posted by voclain

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

he will work on the both
old/new topics

[luckid]

Tnx Good PlugIn

[voclain]

Originally Posted by HaMaDa4eVeR

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:

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