vb3 - prune forums/rebuild search index with cron job?

[allan grossman]

Folks -

Is it possible to prune forums and empty and rebuild the search index as a cron job? If so, how?

I've got a couple of kinda high-traffic Usenet forums I'd like to keep under control.

thanks!

[AN-net]

im not sure but i think you could set up when it prunes

[Dean C]

It's perfectly possible - but I wouldn't reccomend it as rebuilding the search index takes a long time on big boards and even small boards. Hence if you have a user post in the middle of it's going to take a long while. You could however write a script to turn the board off, do your stuff and then turn it back on :)

[allan grossman]

Thanks, Dean -

Anybody have an idea how to prune forums as a real (non-vb) cron job?

[Andreas]

lock tables post, thread, forum write;
delete from post, thread where post.threadid=thread.threadid and thread.forumid=1234 and dateline < unix_timestamp(date_add(now(), interval -1 month));
delete from thread,forumid where thread.forumid=1234 and dateline < unix_timestamp(date_add(now(), interval -1 month));
unlock tables;


This should prune all posts & threads from forum 1234 that are older then 1 month.

[allan grossman]

Thanks, Kirby -

I was thinking more along the lines of which switches to add to thread.php so I could run it as a standalone or through lynx - because I'm looking to maintain threads where the last post is <90 days old in a single forum and then recurse into its child forums.

I'm pretty sure thread.php?do=prune will do what I need but I haven't figured out exactly how to spell it out on a command line.

I appreciate you taking the time with the sql query, though - thank you.