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!

[voclain]

I got the SCHEDULED TASK situation fixed.....I read in post number: 10 the following:

could you make it with inactive threads, because its kinda useless moving a thread that is still active. It should be handy that when a thread is inactive and X days old is moved to an archive forum...

to do that you should change the /cron/cronautodelete.php file in line 31 :
find:

AND `replycount` = '0'

just delete it and it will delete/move the threads that created before X days ago.

==========

I did this and it only deleted threads that had ZERO posts in them.

What I want this to do is this.....

I have a forum where my members SELL stuff....and usually after 30 days...the stuff they are selling is OLD, SOLD, or they are not going to sell it.

So...I want all threads...and all posts....that are more than 30 days old to just be deleted...every night.....is that want this will do for me?

I have done what you suggested above...but it again....only deleted threads that had ZERO posts.

HELP!!!

Kirk

[AzzidReign]

How did you get the cron to work? I'm still having problems with it.

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

But....I seriously, seriously, SERIOUSLY need to get this working so that it DELETES ALL threads....older than 35 days....even the ones that have posts to them....JUST like you do in the "PRUNE" section manually.

Kirk

[AzzidReign]

I think you put back what you deleted.

AND `replycount` = '0'

That seemed to work for me. I was testing it with moving the threads and it moved the threads with replies in it...but I didn't check to see if the reply date was x days old.

[voclain]

Originally Posted by AzzidReign

I think you put back what you deleted.

AND `replycount` = '0'

That seemed to work for me. I was testing it with moving the threads and it moved the threads with replies in it...but I didn't check to see if the reply date was x days old.

Azz:

I did not TEST to see if it work on MOVING THEM??? HUM??? That could be the answer??? All I did was test to see if it would work on me DELETING them...

I'm off to test that.

Kirk

[voclain]

Originally Posted by AzzidReign

I think you put back what you deleted.

AND `replycount` = '0'

That seemed to work for me. I was testing it with moving the threads and it moved the threads with replies in it...but I didn't check to see if the reply date was x days old.

Azz!!!!!!!

Thank you, THANK YOU!!!!

That did it...I had the "AUTO MOVE" feature OFF....and when I removed the "AND 'replycount' = '0' command....it did not apply to "DELETING"...only MOVING.

Which I can make work. I just set up a dummy forum....made it so nobody can see in it...and I'll just DELETE from it every now and then....EASY!!!!

Thank you, thank you thank you!!!!!

I vote that this be the best HaCK ever!

Kirk

[AzzidReign]

Your welcome!

That's what I've done...I've set up a "recycle bin" that I'll manually prune. I just got done pruning over 10k THREADS! It's almost like giving lipo to someone who weighed 300 lbs and now weighs 100 lol j/p But the site is loading much quicker now

[paulo_b]

After install I ran the Task manager and get this error message...
Invalid SQL:
SELECT * FROM `vbthread` Where forumid IN(11,40,25,29,12,17,27,15,22,18,30,26,19,44,24,23 ,28,20,) AND `replycount` = '0' AND `postuserid` NOT IN (1,2) AND `dateline` <= '1190175911';

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 `replycount` = '0' AND `postuserid` NOT IN (1,2) AND `da
Error Number : 1064

I have no idea what this means, please help

[paulo_b]

Anyone home??

[paulo_b]

I removed te trailing comma, 20,), that was the problem, seems to work now.