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!

[AtoZ]

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.

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]

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:

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

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:

AND `replycount` = '0'

to

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.

[R1D1]

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]

Originally Posted by R1D1

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

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]

fascinating! thx

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

[rammbs]

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

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]

Does this work with 3.6.8 Patch Level 2?

[TigerWare]

Originally Posted by ETDC

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]

I don't have it installed yet.