Mass Delete Old Private messages

Here is a simple script that I just hacked up that will delete all private messages older than 60 days old. Just copy the code to a new file, put in your forum root directory, and run it.

PHP Code:


<?php

require ("global.php");
$time = time() - (60 * 24 * 60 * 60);

$a = $DB_site->query("DELETE FROM privatemessage WHERE dateline < $time");

?>

[Gutspiller]

What do you mean put in "a" file? a php file? Another question, are you saying I would have to run this file everytime I wanted it to delete the messages or do I just have to run it once? If so is there a way to get it to automatically do this instead of needing to be manually ran?

Thanks for any info you can provide. :tu:

[TWTCommish]

It would need to be executed...every time it would delete ALL PMs (for all users) older than 60 days. If you wanted it run regularly without your intervention, you'd need to ask your webhost about setting up a crontab.

[PhotoGenie]

What version is this for?

[TWTCommish]

It's simple enough that I think it'll work for any version that supports the PM system.

[PhotoGenie]

TY!! TWT

[LuBi]

Can we get something like this that does it automatically?

[amykhar]

Lubi, just create a cron job for the script.

Amy

[alexi]

Which numbers would I change if I wanted a figure other than 60 days? Say 6 months? (180 days)

[alexi]

anyone have any idea on which number to change? The last 60?