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

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

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

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

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

I think you put back what you deleted.
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

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

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 :)

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

Anyone home??

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