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:
Code:
<?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:
Can I just duplicate the a$ query above to prune each of those variables? That is:
Code:
<?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");
?>