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");

?>

[Jawelin]

Originally posted by amykhar
$time = time() - (60 * 24 * 60 * 60);

Php time() function is expressed in seconds.
So, 60*60*24 means a day...

Any further problem ?
:bunny:

P.S.: the multiplier operator has the commutative property...

[grace819]

can anyone confirm if this hack does what its suppose to do? Meaning does the above code guarantee to delete PMs longer than 60 days?

[alexi]

works fine for me

[eoc_Jason]

If you don't think it will work (or just want to get a number) you can comment out the delete line and use these to see the total rows that will be deleted:

PHP Code:

$a = $DB_site->query_first("SELECT COUNT(*) AS oldpms FROM privatemessage WHERE dateline < $time");
print "Total PMs To Be Deleted: $a[oldpms]"; 


Works pretty good. Thanks

[Bison]

This would be cool is you can add this into the Admin cp ...

[Night Owl]

Does this work on version 2.3.0?

Does it empty out all the folders?

How can I make it delete the PMs older than one month?

Thank you!

[morey]

Amy,

I took your script and made an option in the Admin CP to run it. It seemed to work, but when I ran it all I got was a blank screen. I was wondering if there is a way to add something to the end of the script so that when it is finished running it would return you to say the PM stats query? I am not that versed in php, to do the coding myself .

Thanks

[chrisvonc]

Originally Posted by DJ5A

Hello:
I would also like to know if it works with version 2.3.0 & which 60 is the 60 days because I would like to change it to 30 Days!

If you are still interested to change the days, I modifed the first 60 and it seemed to work on my v2.3.2 test forum. So your code for 30 day limit would look like this:

PHP Code:

$time = time() - (30 * 24 * 60 * 60); 


[djbaxter]

I'd like to adapt this to work with version 3.60.

The existing version shows:

<?php 

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

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

?>

In 3.60, I see three variables for private messages:

• pm
• pmreceipt
• pmtext

Can I just duplicate the a$ query above to prune each of those variables? Or is that unnecessary or redundant?