Mass Delete Old Private messages

[djbaxter]

First, my apologies in advance if I'm posting this in the wrong place.

I'd like to adapt Amy's Mass Delete Old Private Messages script for vB 2.x 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.64, I see three variables for private messages:

• pm
• pmreceipt
• pmtext

Can I just duplicate the a$ query above to prune each of those variables? That is:

<?php 

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

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

?>

[Zia]

gez yet not finished..

a wrong place too

[djbaxter]

I'm aware of that - see above. Moderators, please move this to the apropriate forum.

[a1whs.com]

Hi,
I am confused a bit , does vb new vesion not come with the feature of mass delete where you check on box and all messages get checked and you delete them all ? Or are you trying to build cron to delete old messages?

[djbaxter]

Originally Posted by a1whs.com

Or are you trying to build cron to delete old messages?

Yes. I want to delete/prune all messages older than a certain date.

Discussion continuing at https://vborg.vbsupport.ru/showthrea...81#post1191881